custom_fields_trackers.svg

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<!DOCTYPE svg PUBLIC "-//W3C//DTD SVG 1.1//EN"
 "http://www.w3.org/Graphics/SVG/1.1/DTD/svg11.dtd">
<!-- Generated by graphviz version 2.40.1 (20161225.0304)
 -->
<!-- Title: custom_fields_trackers Pages: 1 -->
<svg width="2776pt" height="944pt"
 viewBox="0.00 0.00 2776.00 944.00" xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink">
<g id="graph0" class="graph" transform="scale(1 1) rotate(0) translate(4 940)">
<title>custom_fields_trackers</title>
<polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-940 2772,-940 2772,4 -4,4"/>
<!-- custom_fields_trackers -->
<g id="node1" class="node">
<title>custom_fields_trackers</title>
<polygon fill="#efefef" stroke="transparent" points="1793.5,-844 1793.5,-890 2088.5,-890 2088.5,-844 1793.5,-844"/>
<polygon fill="none" stroke="#000000" points="1793.5,-844 1793.5,-890 2088.5,-890 2088.5,-844 1793.5,-844"/>
<text text-anchor="start" x="1800.3625" y="-867.8" font-family="Arial Bold" font-size="18.00" fill="#000000">custom_fields_trackers</text>
<text text-anchor="start" x="1984.3837" y="-867.8" font-family="Arial" font-size="14.00" fill="#000000"> </text>
<text text-anchor="start" x="1988.2743" y="-867.8" font-family="Arial" font-size="14.00" fill="#666666">[BASE TABLE]</text>
<text text-anchor="start" x="1824.4451" y="-853.4" font-family="Arial" font-size="14.00" fill="#333333">カスタムフィールド⇔トラッカー</text>
<polygon fill="none" stroke="#000000" points="1793.5,-814 1793.5,-844 2088.5,-844 2088.5,-814 1793.5,-814"/>
<text text-anchor="start" x="1800.5" y="-825.4" font-family="Arial" font-size="14.00" fill="#000000">custom_field_id </text>
<text text-anchor="start" x="1901.6304" y="-825.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<polygon fill="none" stroke="#000000" points="1793.5,-784 1793.5,-814 2088.5,-814 2088.5,-784 1793.5,-784"/>
<text text-anchor="start" x="1800.5" y="-795.4" font-family="Arial" font-size="14.00" fill="#000000">tracker_id </text>
<text text-anchor="start" x="1865.8394" y="-795.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<polygon fill="none" stroke="#000000" stroke-width="3" points="1791.5,-782.5 1791.5,-891.5 2089.5,-891.5 2089.5,-782.5 1791.5,-782.5"/>
</g>
<!-- custom_fields -->
<g id="node2" class="node">
<title>custom_fields</title>
<polygon fill="#efefef" stroke="transparent" points="43.5,-613 43.5,-659 2446.5,-659 2446.5,-613 43.5,-613"/>
<polygon fill="none" stroke="#000000" points="43.5,-613 43.5,-659 2446.5,-659 2446.5,-613 43.5,-613"/>
<text text-anchor="start" x="1141.3651" y="-636.8" font-family="Arial Bold" font-size="18.00" fill="#000000">custom_fields</text>
<text text-anchor="start" x="1251.3811" y="-636.8" font-family="Arial" font-size="14.00" fill="#000000"> </text>
<text text-anchor="start" x="1255.2717" y="-636.8" font-family="Arial" font-size="14.00" fill="#666666">[BASE TABLE]</text>
<text text-anchor="start" x="1173.0722" y="-622.4" font-family="Arial" font-size="14.00" fill="#333333">カスタムフィールド</text>
<polygon fill="none" stroke="#000000" points="43.5,-583 43.5,-613 2446.5,-613 2446.5,-583 43.5,-583"/>
<text text-anchor="start" x="50.5" y="-594.4" font-family="Arial" font-size="14.00" fill="#000000">id </text>
<text text-anchor="start" x="65.2798" y="-594.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<polygon fill="none" stroke="#000000" points="43.5,-553 43.5,-583 2446.5,-583 2446.5,-553 43.5,-553"/>
<text text-anchor="start" x="50.3359" y="-564.4" font-family="Arial" font-size="14.00" fill="#000000">type </text>
<text text-anchor="start" x="80.6823" y="-564.4" font-family="Arial" font-size="14.00" fill="#666666">[varchar(30)]</text>
<text text-anchor="start" x="160.0189" y="-564.4" font-family="Arial" font-size="14.00" fill="#000000"> IssueCustomField:チケット TimeEntryCustomField:作業時間 ProjectCustomField:プロジェクト VersionCustomField:バージョン DocumentCustomField:文書 UserCustomField:ユーザー GroupCustomField:グループ TimeEntryActivityCustomField:作業分類(時間管理) IssuePriorityCustomField:チケットの優先度 DocumentCategoryCustomField:文書カテゴリ </text>
<polygon fill="none" stroke="#000000" points="43.5,-523 43.5,-553 2446.5,-553 2446.5,-523 43.5,-523"/>
<text text-anchor="start" x="50.5" y="-534.4" font-family="Arial" font-size="14.00" fill="#000000">name </text>
<text text-anchor="start" x="89.399" y="-534.4" font-family="Arial" font-size="14.00" fill="#666666">[varchar(30)]</text>
<polygon fill="none" stroke="#000000" points="43.5,-493 43.5,-523 2446.5,-523 2446.5,-493 43.5,-493"/>
<text text-anchor="start" x="50.5" y="-504.4" font-family="Arial" font-size="14.00" fill="#000000">field_format </text>
<text text-anchor="start" x="127.5098" y="-504.4" font-family="Arial" font-size="14.00" fill="#666666">[varchar(30)]</text>
<text text-anchor="start" x="206.8464" y="-504.4" font-family="Arial" font-size="14.00" fill="#000000"> string:テキスト version:バージョン attachment:ファイル user:ユーザー list:リスト link:リンク float:小数 int:整数 整数:日付 bool:真偽値 text:長いテキスト </text>
<polygon fill="none" stroke="#000000" points="43.5,-463 43.5,-493 2446.5,-493 2446.5,-463 43.5,-463"/>
<text text-anchor="start" x="50.5" y="-474.4" font-family="Arial" font-size="14.00" fill="#000000">possible_values </text>
<text text-anchor="start" x="153.9712" y="-474.4" font-family="Arial" font-size="14.00" fill="#666666">[text]</text>
<polygon fill="none" stroke="#000000" points="43.5,-433 43.5,-463 2446.5,-463 2446.5,-433 43.5,-433"/>
<text text-anchor="start" x="50.5" y="-444.4" font-family="Arial" font-size="14.00" fill="#000000">regexp </text>
<text text-anchor="start" x="97.1816" y="-444.4" font-family="Arial" font-size="14.00" fill="#666666">[varchar(255)]</text>
<polygon fill="none" stroke="#000000" points="43.5,-403 43.5,-433 2446.5,-433 2446.5,-403 43.5,-403"/>
<text text-anchor="start" x="50.5" y="-414.4" font-family="Arial" font-size="14.00" fill="#000000">min_length </text>
<text text-anchor="start" x="122.8506" y="-414.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<polygon fill="none" stroke="#000000" points="43.5,-373 43.5,-403 2446.5,-403 2446.5,-373 43.5,-373"/>
<text text-anchor="start" x="50.5" y="-384.4" font-family="Arial" font-size="14.00" fill="#000000">max_length </text>
<text text-anchor="start" x="126.744" y="-384.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<polygon fill="none" stroke="#000000" points="43.5,-343 43.5,-373 2446.5,-373 2446.5,-343 43.5,-343"/>
<text text-anchor="start" x="50.5" y="-354.4" font-family="Arial" font-size="14.00" fill="#000000">is_required </text>
<text text-anchor="start" x="123.6206" y="-354.4" font-family="Arial" font-size="14.00" fill="#666666">[tinyint(1)]</text>
<polygon fill="none" stroke="#000000" points="43.5,-313 43.5,-343 2446.5,-343 2446.5,-313 43.5,-313"/>
<text text-anchor="start" x="50.5" y="-324.4" font-family="Arial" font-size="14.00" fill="#000000">is_for_all </text>
<text text-anchor="start" x="110.392" y="-324.4" font-family="Arial" font-size="14.00" fill="#666666">[tinyint(1)]</text>
<polygon fill="none" stroke="#000000" points="43.5,-283 43.5,-313 2446.5,-313 2446.5,-283 43.5,-283"/>
<text text-anchor="start" x="50.5" y="-294.4" font-family="Arial" font-size="14.00" fill="#000000">is_filter </text>
<text text-anchor="start" x="98.7174" y="-294.4" font-family="Arial" font-size="14.00" fill="#666666">[tinyint(1)]</text>
<polygon fill="none" stroke="#000000" points="43.5,-253 43.5,-283 2446.5,-283 2446.5,-253 43.5,-253"/>
<text text-anchor="start" x="50.5" y="-264.4" font-family="Arial" font-size="14.00" fill="#000000">position </text>
<text text-anchor="start" x="102.6248" y="-264.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<polygon fill="none" stroke="#000000" points="43.5,-223 43.5,-253 2446.5,-253 2446.5,-223 43.5,-223"/>
<text text-anchor="start" x="50.5" y="-234.4" font-family="Arial" font-size="14.00" fill="#000000">searchable </text>
<text text-anchor="start" x="122.8534" y="-234.4" font-family="Arial" font-size="14.00" fill="#666666">[tinyint(1)]</text>
<polygon fill="none" stroke="#000000" points="43.5,-193 43.5,-223 2446.5,-223 2446.5,-193 43.5,-193"/>
<text text-anchor="start" x="50.5" y="-204.4" font-family="Arial" font-size="14.00" fill="#000000">default_value </text>
<text text-anchor="start" x="137.6458" y="-204.4" font-family="Arial" font-size="14.00" fill="#666666">[text]</text>
<polygon fill="none" stroke="#000000" points="43.5,-163 43.5,-193 2446.5,-193 2446.5,-163 43.5,-163"/>
<text text-anchor="start" x="50.5" y="-174.4" font-family="Arial" font-size="14.00" fill="#000000">editable </text>
<text text-anchor="start" x="103.4074" y="-174.4" font-family="Arial" font-size="14.00" fill="#666666">[tinyint(1)]</text>
<polygon fill="none" stroke="#000000" points="43.5,-133 43.5,-163 2446.5,-163 2446.5,-133 43.5,-133"/>
<text text-anchor="start" x="50.5" y="-144.4" font-family="Arial" font-size="14.00" fill="#000000">visible </text>
<text text-anchor="start" x="93.2756" y="-144.4" font-family="Arial" font-size="14.00" fill="#666666">[tinyint(1)]</text>
<polygon fill="none" stroke="#000000" points="43.5,-103 43.5,-133 2446.5,-133 2446.5,-103 43.5,-103"/>
<text text-anchor="start" x="50.5" y="-114.4" font-family="Arial" font-size="14.00" fill="#000000">multiple </text>
<text text-anchor="start" x="102.6094" y="-114.4" font-family="Arial" font-size="14.00" fill="#666666">[tinyint(1)]</text>
<polygon fill="none" stroke="#000000" points="43.5,-73 43.5,-103 2446.5,-103 2446.5,-73 43.5,-73"/>
<text text-anchor="start" x="50.5" y="-84.4" font-family="Arial" font-size="14.00" fill="#000000">format_store </text>
<text text-anchor="start" x="132.9572" y="-84.4" font-family="Arial" font-size="14.00" fill="#666666">[text]</text>
<polygon fill="none" stroke="#000000" points="43.5,-43 43.5,-73 2446.5,-73 2446.5,-43 43.5,-43"/>
<text text-anchor="start" x="50.5" y="-54.4" font-family="Arial" font-size="14.00" fill="#000000">description </text>
<text text-anchor="start" x="122.068" y="-54.4" font-family="Arial" font-size="14.00" fill="#666666">[text]</text>
</g>
<!-- custom_fields_trackers&#45;&gt;custom_fields -->
<g id="edge1" class="edge">
<title>custom_fields_trackers:custom_field_id&#45;&gt;custom_fields:id</title>
<path fill="none" stroke="#000000" stroke-dasharray="5,2" d="M1783.4935,-827.4525C1755.5595,-817.7288 1768.306,-764.6212 1793.5,-738 1893.3964,-632.4446 2346.6036,-807.5554 2446.5,-702 2478.2717,-668.4284 2492.7222,-598 2446.5,-598"/>
<polygon fill="#000000" stroke="#000000" points="1783.6175,-827.4716 1792.8122,-833.4471 1788.5587,-828.2358 1793.5,-829 1793.5,-829 1793.5,-829 1788.5587,-828.2358 1794.1878,-824.5529 1783.6175,-827.4716 1783.6175,-827.4716"/>
<text text-anchor="start" x="1703.8245" y="-839" font-family="Arial" font-size="10.00" fill="#000000">Additional Relation</text>
</g>
<!-- trackers -->
<g id="node3" class="node">
<title>trackers</title>
<polygon fill="#efefef" stroke="transparent" points="2550.5,-433 2550.5,-479 2725.5,-479 2725.5,-433 2550.5,-433"/>
<polygon fill="none" stroke="#000000" points="2550.5,-433 2550.5,-479 2725.5,-479 2725.5,-433 2550.5,-433"/>
<text text-anchor="start" x="2557.3736" y="-456.8" font-family="Arial Bold" font-size="18.00" fill="#000000">trackers</text>
<text text-anchor="start" x="2621.3726" y="-456.8" font-family="Arial" font-size="14.00" fill="#000000"> </text>
<text text-anchor="start" x="2625.2632" y="-456.8" font-family="Arial" font-size="14.00" fill="#666666">[BASE TABLE]</text>
<text text-anchor="start" x="2599.2088" y="-442.4" font-family="Arial" font-size="14.00" fill="#333333">トラッカー</text>
<polygon fill="none" stroke="#000000" points="2550.5,-403 2550.5,-433 2725.5,-433 2725.5,-403 2550.5,-403"/>
<text text-anchor="start" x="2557.5" y="-414.4" font-family="Arial" font-size="14.00" fill="#000000">id </text>
<text text-anchor="start" x="2572.2798" y="-414.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<polygon fill="none" stroke="#000000" points="2550.5,-373 2550.5,-403 2725.5,-403 2725.5,-373 2550.5,-373"/>
<text text-anchor="start" x="2557.5" y="-384.4" font-family="Arial" font-size="14.00" fill="#000000">name </text>
<text text-anchor="start" x="2596.399" y="-384.4" font-family="Arial" font-size="14.00" fill="#666666">[varchar(30)]</text>
<polygon fill="none" stroke="#000000" points="2550.5,-343 2550.5,-373 2725.5,-373 2725.5,-343 2550.5,-343"/>
<text text-anchor="start" x="2557.5" y="-354.4" font-family="Arial" font-size="14.00" fill="#000000">description </text>
<text text-anchor="start" x="2629.068" y="-354.4" font-family="Arial" font-size="14.00" fill="#666666">[varchar(255)]</text>
<polygon fill="none" stroke="#000000" points="2550.5,-313 2550.5,-343 2725.5,-343 2725.5,-313 2550.5,-313"/>
<text text-anchor="start" x="2557.5" y="-324.4" font-family="Arial" font-size="14.00" fill="#000000">position </text>
<text text-anchor="start" x="2609.6248" y="-324.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<polygon fill="none" stroke="#000000" points="2550.5,-283 2550.5,-313 2725.5,-313 2725.5,-283 2550.5,-283"/>
<text text-anchor="start" x="2557.5" y="-294.4" font-family="Arial" font-size="14.00" fill="#000000">is_in_roadmap </text>
<text text-anchor="start" x="2653.1858" y="-294.4" font-family="Arial" font-size="14.00" fill="#666666">[tinyint(1)]</text>
<polygon fill="none" stroke="#000000" points="2550.5,-253 2550.5,-283 2725.5,-283 2725.5,-253 2550.5,-253"/>
<text text-anchor="start" x="2557.5" y="-264.4" font-family="Arial" font-size="14.00" fill="#000000">fields_bits </text>
<text text-anchor="start" x="2623.622" y="-264.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<polygon fill="none" stroke="#000000" points="2550.5,-223 2550.5,-253 2725.5,-253 2725.5,-223 2550.5,-223"/>
<text text-anchor="start" x="2557.5" y="-234.4" font-family="Arial" font-size="14.00" fill="#000000">default_status_id </text>
<text text-anchor="start" x="2667.2096" y="-234.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
</g>
<!-- custom_fields_trackers&#45;&gt;trackers -->
<g id="edge2" class="edge">
<title>custom_fields_trackers:tracker_id&#45;&gt;trackers:id</title>
<path fill="none" stroke="#000000" stroke-dasharray="5,2" d="M2098.6412,-798.8975C2199.1262,-796.9639 2436.2174,-767.5574 2498.5,-702 2586.883,-608.9698 2422.1794,-418 2550.5,-418"/>
<polygon fill="#000000" stroke="#000000" points="2098.4995,-798.8989 2088.4545,-794.5002 2093.4997,-798.9494 2088.5,-799 2088.5,-799 2088.5,-799 2093.4997,-798.9494 2088.5455,-803.4998 2098.4995,-798.8989 2098.4995,-798.8989"/>
<text text-anchor="start" x="2095.8245" y="-809" font-family="Arial" font-size="10.00" fill="#000000">Additional Relation</text>
</g>
</g>
</svg>