custom_fields_projects.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_projects Pages: 1 -->
<svg width="2810pt" height="944pt"
 viewBox="0.00 0.00 2810.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_projects</title>
<polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-940 2806,-940 2806,4 -4,4"/>
<!-- custom_fields_projects -->
<g id="node1" class="node">
<title>custom_fields_projects</title>
<polygon fill="#efefef" stroke="transparent" points="1803.5,-844 1803.5,-890 2097.5,-890 2097.5,-844 1803.5,-844"/>
<polygon fill="none" stroke="#000000" points="1803.5,-844 1803.5,-890 2097.5,-890 2097.5,-844 1803.5,-844"/>
<text text-anchor="start" x="1810.3584" y="-867.8" font-family="Arial Bold" font-size="18.00" fill="#000000">custom_fields_projects</text>
<text text-anchor="start" x="1993.3878" y="-867.8" font-family="Arial" font-size="14.00" fill="#000000"> </text>
<text text-anchor="start" x="1997.2784" y="-867.8" font-family="Arial" font-size="14.00" fill="#666666">[BASE TABLE]</text>
<text text-anchor="start" x="1830.3632" y="-853.4" font-family="Arial" font-size="14.00" fill="#333333">カスタムフィールド⇔プロジェクト</text>
<polygon fill="none" stroke="#000000" points="1803.5,-814 1803.5,-844 2097.5,-844 2097.5,-814 1803.5,-814"/>
<text text-anchor="start" x="1810.5" y="-825.4" font-family="Arial" font-size="14.00" fill="#000000">custom_field_id </text>
<text text-anchor="start" x="1911.6304" y="-825.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<polygon fill="none" stroke="#000000" points="1803.5,-784 1803.5,-814 2097.5,-814 2097.5,-784 1803.5,-784"/>
<text text-anchor="start" x="1810.5" y="-795.4" font-family="Arial" font-size="14.00" fill="#000000">project_id </text>
<text text-anchor="start" x="1875.068" y="-795.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<polygon fill="none" stroke="#000000" stroke-width="3" points="1802,-782.5 1802,-891.5 2099,-891.5 2099,-782.5 1802,-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_projects&#45;&gt;custom_fields -->
<g id="edge1" class="edge">
<title>custom_fields_projects:custom_field_id&#45;&gt;custom_fields:id</title>
<path fill="none" stroke="#000000" stroke-dasharray="5,2" d="M1793.4938,-827.4528C1765.5617,-817.7308 1778.3174,-764.632 1803.5,-738 1901.8268,-634.0141 2348.1732,-805.9859 2446.5,-702 2478.2574,-668.4149 2492.7222,-598 2446.5,-598"/>
<polygon fill="#000000" stroke="#000000" points="1793.6174,-827.4718 1802.8123,-833.4471 1798.5587,-828.2359 1803.5,-829 1803.5,-829 1803.5,-829 1798.5587,-828.2359 1804.1877,-824.5529 1793.6174,-827.4718 1793.6174,-827.4718"/>
<text text-anchor="start" x="1713.8245" y="-839" font-family="Arial" font-size="10.00" fill="#000000">Additional Relation</text>
</g>
<!-- projects -->
<g id="node3" class="node">
<title>projects</title>
<polygon fill="#efefef" stroke="transparent" points="2550.5,-568 2550.5,-614 2759.5,-614 2759.5,-568 2550.5,-568"/>
<polygon fill="none" stroke="#000000" points="2550.5,-568 2550.5,-614 2759.5,-614 2759.5,-568 2550.5,-568"/>
<text text-anchor="start" x="2574.8695" y="-591.8" font-family="Arial Bold" font-size="18.00" fill="#000000">projects</text>
<text text-anchor="start" x="2637.8767" y="-591.8" font-family="Arial" font-size="14.00" fill="#000000"> </text>
<text text-anchor="start" x="2641.7673" y="-591.8" font-family="Arial" font-size="14.00" fill="#666666">[BASE TABLE]</text>
<text text-anchor="start" x="2612.6269" y="-577.4" font-family="Arial" font-size="14.00" fill="#333333">プロジェクト</text>
<polygon fill="none" stroke="#000000" points="2550.5,-538 2550.5,-568 2759.5,-568 2759.5,-538 2550.5,-538"/>
<text text-anchor="start" x="2557.5" y="-549.4" font-family="Arial" font-size="14.00" fill="#000000">id </text>
<text text-anchor="start" x="2572.2798" y="-549.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<polygon fill="none" stroke="#000000" points="2550.5,-508 2550.5,-538 2759.5,-538 2759.5,-508 2550.5,-508"/>
<text text-anchor="start" x="2557.5" y="-519.4" font-family="Arial" font-size="14.00" fill="#000000">name </text>
<text text-anchor="start" x="2596.399" y="-519.4" font-family="Arial" font-size="14.00" fill="#666666">[varchar(255)]</text>
<polygon fill="none" stroke="#000000" points="2550.5,-478 2550.5,-508 2759.5,-508 2759.5,-478 2550.5,-478"/>
<text text-anchor="start" x="2557.5" y="-489.4" font-family="Arial" font-size="14.00" fill="#000000">description </text>
<text text-anchor="start" x="2629.068" y="-489.4" font-family="Arial" font-size="14.00" fill="#666666">[text]</text>
<polygon fill="none" stroke="#000000" points="2550.5,-448 2550.5,-478 2759.5,-478 2759.5,-448 2550.5,-448"/>
<text text-anchor="start" x="2557.5" y="-459.4" font-family="Arial" font-size="14.00" fill="#000000">homepage </text>
<text text-anchor="start" x="2627.5294" y="-459.4" font-family="Arial" font-size="14.00" fill="#666666">[varchar(255)]</text>
<polygon fill="none" stroke="#000000" points="2550.5,-418 2550.5,-448 2759.5,-448 2759.5,-418 2550.5,-418"/>
<text text-anchor="start" x="2557.5" y="-429.4" font-family="Arial" font-size="14.00" fill="#000000">is_public </text>
<text text-anchor="start" x="2615.8408" y="-429.4" font-family="Arial" font-size="14.00" fill="#666666">[tinyint(1)]</text>
<polygon fill="none" stroke="#000000" points="2550.5,-388 2550.5,-418 2759.5,-418 2759.5,-388 2550.5,-388"/>
<text text-anchor="start" x="2557.5" y="-399.4" font-family="Arial" font-size="14.00" fill="#000000">parent_id </text>
<text text-anchor="start" x="2619.744" y="-399.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<polygon fill="none" stroke="#000000" points="2550.5,-358 2550.5,-388 2759.5,-388 2759.5,-358 2550.5,-358"/>
<text text-anchor="start" x="2557.5" y="-369.4" font-family="Arial" font-size="14.00" fill="#000000">created_on </text>
<text text-anchor="start" x="2631.42" y="-369.4" font-family="Arial" font-size="14.00" fill="#666666">[timestamp]</text>
<polygon fill="none" stroke="#000000" points="2550.5,-328 2550.5,-358 2759.5,-358 2759.5,-328 2550.5,-328"/>
<text text-anchor="start" x="2557.5" y="-339.4" font-family="Arial" font-size="14.00" fill="#000000">updated_on </text>
<text text-anchor="start" x="2635.3246" y="-339.4" font-family="Arial" font-size="14.00" fill="#666666">[timestamp]</text>
<polygon fill="none" stroke="#000000" points="2550.5,-298 2550.5,-328 2759.5,-328 2759.5,-298 2550.5,-298"/>
<text text-anchor="start" x="2557.5" y="-309.4" font-family="Arial" font-size="14.00" fill="#000000">identifier </text>
<text text-anchor="start" x="2614.2826" y="-309.4" font-family="Arial" font-size="14.00" fill="#666666">[varchar(255)]</text>
<polygon fill="none" stroke="#000000" points="2550.5,-268 2550.5,-298 2759.5,-298 2759.5,-268 2550.5,-268"/>
<text text-anchor="start" x="2557.5" y="-279.4" font-family="Arial" font-size="14.00" fill="#000000">status </text>
<text text-anchor="start" x="2598.737" y="-279.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<polygon fill="none" stroke="#000000" points="2550.5,-238 2550.5,-268 2759.5,-268 2759.5,-238 2550.5,-238"/>
<text text-anchor="start" x="2557.5" y="-249.4" font-family="Arial" font-size="14.00" fill="#000000">lft </text>
<text text-anchor="start" x="2572.2784" y="-249.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<polygon fill="none" stroke="#000000" points="2550.5,-208 2550.5,-238 2759.5,-238 2759.5,-208 2550.5,-208"/>
<text text-anchor="start" x="2557.5" y="-219.4" font-family="Arial" font-size="14.00" fill="#000000">rgt </text>
<text text-anchor="start" x="2577.7244" y="-219.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<polygon fill="none" stroke="#000000" points="2550.5,-178 2550.5,-208 2759.5,-208 2759.5,-178 2550.5,-178"/>
<text text-anchor="start" x="2557.5" y="-189.4" font-family="Arial" font-size="14.00" fill="#000000">inherit_members </text>
<text text-anchor="start" x="2665.615" y="-189.4" font-family="Arial" font-size="14.00" fill="#666666">[tinyint(1)]</text>
<polygon fill="none" stroke="#000000" points="2550.5,-148 2550.5,-178 2759.5,-178 2759.5,-148 2550.5,-148"/>
<text text-anchor="start" x="2557.5" y="-159.4" font-family="Arial" font-size="14.00" fill="#000000">default_version_id </text>
<text text-anchor="start" x="2674.9782" y="-159.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<polygon fill="none" stroke="#000000" points="2550.5,-118 2550.5,-148 2759.5,-148 2759.5,-118 2550.5,-118"/>
<text text-anchor="start" x="2557.357" y="-129.4" font-family="Arial" font-size="14.00" fill="#000000">default_assigned_to_id </text>
<text text-anchor="start" x="2705.1956" y="-129.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<polygon fill="none" stroke="#000000" points="2550.5,-88 2550.5,-118 2759.5,-118 2759.5,-88 2550.5,-88"/>
<text text-anchor="start" x="2557.3633" y="-99.4" font-family="Arial" font-size="14.00" fill="#000000">default_issue_query_id </text>
<text text-anchor="start" x="2705.1893" y="-99.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
</g>
<!-- custom_fields_projects&#45;&gt;projects -->
<g id="edge2" class="edge">
<title>custom_fields_projects:project_id&#45;&gt;projects:id</title>
<path fill="none" stroke="#000000" stroke-dasharray="5,2" d="M2107.7105,-798.869C2205.9388,-796.4759 2432.949,-761.396 2498.5,-702 2550.476,-654.9043 2480.3608,-553 2550.5,-553"/>
<polygon fill="#000000" stroke="#000000" points="2107.4992,-798.8716 2097.4422,-794.5004 2102.4996,-798.9358 2097.5,-799 2097.5,-799 2097.5,-799 2102.4996,-798.9358 2097.5578,-803.4996 2107.4992,-798.8716 2107.4992,-798.8716"/>
<text text-anchor="start" x="2104.8245" y="-809" font-family="Arial" font-size="10.00" fill="#000000">Additional Relation</text>
</g>
</g>
</svg>