boards.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: boards Pages: 1 -->
<svg width="380pt" height="1592pt"
 viewBox="0.00 0.00 380.00 1592.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 1588)">
<title>boards</title>
<polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-1588 376,-1588 376,4 -4,4"/>
<!-- boards -->
<g id="node1" class="node">
<title>boards</title>
<polygon fill="#efefef" stroke="transparent" points="97,-964 97,-1010 269,-1010 269,-964 97,-964"/>
<polygon fill="none" stroke="#000000" points="97,-964 97,-1010 269,-1010 269,-964 97,-964"/>
<text text-anchor="start" x="106.8646" y="-987.8" font-family="Arial Bold" font-size="18.00" fill="#000000">boards</text>
<text text-anchor="start" x="161.8816" y="-987.8" font-family="Arial" font-size="14.00" fill="#000000"> </text>
<text text-anchor="start" x="165.7722" y="-987.8" font-family="Arial" font-size="14.00" fill="#666666">[BASE TABLE]</text>
<text text-anchor="start" x="146.7638" y="-973.4" font-family="Arial" font-size="14.00" fill="#333333">フォーラム</text>
<polygon fill="none" stroke="#000000" points="97,-934 97,-964 269,-964 269,-934 97,-934"/>
<text text-anchor="start" x="104" y="-945.4" font-family="Arial" font-size="14.00" fill="#000000">id </text>
<text text-anchor="start" x="118.7798" y="-945.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<polygon fill="none" stroke="#000000" points="97,-904 97,-934 269,-934 269,-904 97,-904"/>
<text text-anchor="start" x="104" y="-915.4" font-family="Arial" font-size="14.00" fill="#000000">project_id </text>
<text text-anchor="start" x="168.568" y="-915.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<polygon fill="none" stroke="#000000" points="97,-874 97,-904 269,-904 269,-874 97,-874"/>
<text text-anchor="start" x="104" y="-885.4" font-family="Arial" font-size="14.00" fill="#000000">name </text>
<text text-anchor="start" x="142.899" y="-885.4" font-family="Arial" font-size="14.00" fill="#666666">[varchar(255)]</text>
<polygon fill="none" stroke="#000000" points="97,-844 97,-874 269,-874 269,-844 97,-844"/>
<text text-anchor="start" x="103.6564" y="-855.4" font-family="Arial" font-size="14.00" fill="#000000">description </text>
<text text-anchor="start" x="175.2244" y="-855.4" font-family="Arial" font-size="14.00" fill="#666666">[varchar(255)]</text>
<polygon fill="none" stroke="#000000" points="97,-814 97,-844 269,-844 269,-814 97,-814"/>
<text text-anchor="start" x="104" y="-825.4" font-family="Arial" font-size="14.00" fill="#000000">position </text>
<text text-anchor="start" x="156.1248" y="-825.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<polygon fill="none" stroke="#000000" points="97,-784 97,-814 269,-814 269,-784 97,-784"/>
<text text-anchor="start" x="104" y="-795.4" font-family="Arial" font-size="14.00" fill="#000000">topics_count </text>
<text text-anchor="start" x="186.474" y="-795.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<polygon fill="none" stroke="#000000" points="97,-754 97,-784 269,-784 269,-754 97,-754"/>
<text text-anchor="start" x="104" y="-765.4" font-family="Arial" font-size="14.00" fill="#000000">messages_count </text>
<text text-anchor="start" x="213.7026" y="-765.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<polygon fill="none" stroke="#000000" points="97,-724 97,-754 269,-754 269,-724 97,-724"/>
<text text-anchor="start" x="104" y="-735.4" font-family="Arial" font-size="14.00" fill="#000000">last_message_id </text>
<text text-anchor="start" x="212.9158" y="-735.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<polygon fill="none" stroke="#000000" points="97,-694 97,-724 269,-724 269,-694 97,-694"/>
<text text-anchor="start" x="104" y="-705.4" font-family="Arial" font-size="14.00" fill="#000000">parent_id </text>
<text text-anchor="start" x="166.244" y="-705.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<polygon fill="none" stroke="#000000" stroke-width="3" points="95.5,-692.5 95.5,-1011.5 270.5,-1011.5 270.5,-692.5 95.5,-692.5"/>
</g>
<!-- projects -->
<g id="node3" class="node">
<title>projects</title>
<polygon fill="#efefef" stroke="transparent" points="78,-523 78,-569 287,-569 287,-523 78,-523"/>
<polygon fill="none" stroke="#000000" points="78,-523 78,-569 287,-569 287,-523 78,-523"/>
<text text-anchor="start" x="102.3695" y="-546.8" font-family="Arial Bold" font-size="18.00" fill="#000000">projects</text>
<text text-anchor="start" x="165.3767" y="-546.8" font-family="Arial" font-size="14.00" fill="#000000"> </text>
<text text-anchor="start" x="169.2673" y="-546.8" font-family="Arial" font-size="14.00" fill="#666666">[BASE TABLE]</text>
<text text-anchor="start" x="140.1269" y="-532.4" font-family="Arial" font-size="14.00" fill="#333333">プロジェクト</text>
<polygon fill="none" stroke="#000000" points="78,-493 78,-523 287,-523 287,-493 78,-493"/>
<text text-anchor="start" x="85" y="-504.4" font-family="Arial" font-size="14.00" fill="#000000">id </text>
<text text-anchor="start" x="99.7798" y="-504.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<polygon fill="none" stroke="#000000" points="78,-463 78,-493 287,-493 287,-463 78,-463"/>
<text text-anchor="start" x="85" y="-474.4" font-family="Arial" font-size="14.00" fill="#000000">name </text>
<text text-anchor="start" x="123.899" y="-474.4" font-family="Arial" font-size="14.00" fill="#666666">[varchar(255)]</text>
<polygon fill="none" stroke="#000000" points="78,-433 78,-463 287,-463 287,-433 78,-433"/>
<text text-anchor="start" x="85" y="-444.4" font-family="Arial" font-size="14.00" fill="#000000">description </text>
<text text-anchor="start" x="156.568" y="-444.4" font-family="Arial" font-size="14.00" fill="#666666">[text]</text>
<polygon fill="none" stroke="#000000" points="78,-403 78,-433 287,-433 287,-403 78,-403"/>
<text text-anchor="start" x="85" y="-414.4" font-family="Arial" font-size="14.00" fill="#000000">homepage </text>
<text text-anchor="start" x="155.0294" y="-414.4" font-family="Arial" font-size="14.00" fill="#666666">[varchar(255)]</text>
<polygon fill="none" stroke="#000000" points="78,-373 78,-403 287,-403 287,-373 78,-373"/>
<text text-anchor="start" x="85" y="-384.4" font-family="Arial" font-size="14.00" fill="#000000">is_public </text>
<text text-anchor="start" x="143.3408" y="-384.4" font-family="Arial" font-size="14.00" fill="#666666">[tinyint(1)]</text>
<polygon fill="none" stroke="#000000" points="78,-343 78,-373 287,-373 287,-343 78,-343"/>
<text text-anchor="start" x="85" y="-354.4" font-family="Arial" font-size="14.00" fill="#000000">parent_id </text>
<text text-anchor="start" x="147.244" y="-354.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<polygon fill="none" stroke="#000000" points="78,-313 78,-343 287,-343 287,-313 78,-313"/>
<text text-anchor="start" x="85" y="-324.4" font-family="Arial" font-size="14.00" fill="#000000">created_on </text>
<text text-anchor="start" x="158.92" y="-324.4" font-family="Arial" font-size="14.00" fill="#666666">[timestamp]</text>
<polygon fill="none" stroke="#000000" points="78,-283 78,-313 287,-313 287,-283 78,-283"/>
<text text-anchor="start" x="85" y="-294.4" font-family="Arial" font-size="14.00" fill="#000000">updated_on </text>
<text text-anchor="start" x="162.8246" y="-294.4" font-family="Arial" font-size="14.00" fill="#666666">[timestamp]</text>
<polygon fill="none" stroke="#000000" points="78,-253 78,-283 287,-283 287,-253 78,-253"/>
<text text-anchor="start" x="85" y="-264.4" font-family="Arial" font-size="14.00" fill="#000000">identifier </text>
<text text-anchor="start" x="141.7826" y="-264.4" font-family="Arial" font-size="14.00" fill="#666666">[varchar(255)]</text>
<polygon fill="none" stroke="#000000" points="78,-223 78,-253 287,-253 287,-223 78,-223"/>
<text text-anchor="start" x="85" y="-234.4" font-family="Arial" font-size="14.00" fill="#000000">status </text>
<text text-anchor="start" x="126.237" y="-234.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<polygon fill="none" stroke="#000000" points="78,-193 78,-223 287,-223 287,-193 78,-193"/>
<text text-anchor="start" x="85" y="-204.4" font-family="Arial" font-size="14.00" fill="#000000">lft </text>
<text text-anchor="start" x="99.7784" y="-204.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<polygon fill="none" stroke="#000000" points="78,-163 78,-193 287,-193 287,-163 78,-163"/>
<text text-anchor="start" x="85" y="-174.4" font-family="Arial" font-size="14.00" fill="#000000">rgt </text>
<text text-anchor="start" x="105.2244" y="-174.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<polygon fill="none" stroke="#000000" points="78,-133 78,-163 287,-163 287,-133 78,-133"/>
<text text-anchor="start" x="85" y="-144.4" font-family="Arial" font-size="14.00" fill="#000000">inherit_members </text>
<text text-anchor="start" x="193.115" y="-144.4" font-family="Arial" font-size="14.00" fill="#666666">[tinyint(1)]</text>
<polygon fill="none" stroke="#000000" points="78,-103 78,-133 287,-133 287,-103 78,-103"/>
<text text-anchor="start" x="85" y="-114.4" font-family="Arial" font-size="14.00" fill="#000000">default_version_id </text>
<text text-anchor="start" x="202.4782" y="-114.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<polygon fill="none" stroke="#000000" points="78,-73 78,-103 287,-103 287,-73 78,-73"/>
<text text-anchor="start" x="84.857" y="-84.4" font-family="Arial" font-size="14.00" fill="#000000">default_assigned_to_id </text>
<text text-anchor="start" x="232.6956" y="-84.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<polygon fill="none" stroke="#000000" points="78,-43 78,-73 287,-73 287,-43 78,-43"/>
<text text-anchor="start" x="84.8633" y="-54.4" font-family="Arial" font-size="14.00" fill="#000000">default_issue_query_id </text>
<text text-anchor="start" x="232.6893" y="-54.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
</g>
<!-- boards&#45;&gt;projects -->
<g id="edge2" class="edge">
<title>boards:project_id&#45;&gt;projects:id</title>
<path fill="none" stroke="#000000" stroke-dasharray="5,2" d="M86.8332,-918.5477C-20.8605,-908.6294 22.4192,-738.0389 97,-648 151.8257,-581.8108 232.1743,-678.1892 287,-612 316.4853,-576.4035 333.2222,-508 287,-508"/>
<polygon fill="#000000" stroke="#000000" points="87.0099,-918.5554 96.7999,-923.4956 92.0049,-918.7777 97,-919 97,-919 97,-919 92.0049,-918.7777 97.2001,-914.5044 87.0099,-918.5554 87.0099,-918.5554"/>
<text text-anchor="start" x="7.3245" y="-929" font-family="Arial" font-size="10.00" fill="#000000">Additional Relation</text>
</g>
<!-- messages -->
<g id="node2" class="node">
<title>messages</title>
<polygon fill="#efefef" stroke="transparent" points="86,-1495 86,-1541 279,-1541 279,-1495 86,-1495"/>
<polygon fill="none" stroke="#000000" points="86,-1495 86,-1541 279,-1541 279,-1495 86,-1495"/>
<text text-anchor="start" x="92.8646" y="-1518.8" font-family="Arial Bold" font-size="18.00" fill="#000000">messages</text>
<text text-anchor="start" x="174.8816" y="-1518.8" font-family="Arial" font-size="14.00" fill="#000000"> </text>
<text text-anchor="start" x="178.7722" y="-1518.8" font-family="Arial" font-size="14.00" fill="#666666">[BASE TABLE]</text>
<text text-anchor="start" x="106.8706" y="-1504.4" font-family="Arial" font-size="14.00" fill="#333333">フォーラムメッセージ</text>
<polygon fill="none" stroke="#000000" points="86,-1465 86,-1495 279,-1495 279,-1465 86,-1465"/>
<text text-anchor="start" x="93" y="-1476.4" font-family="Arial" font-size="14.00" fill="#000000">id </text>
<text text-anchor="start" x="107.7798" y="-1476.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<polygon fill="none" stroke="#000000" points="86,-1435 86,-1465 279,-1465 279,-1435 86,-1435"/>
<text text-anchor="start" x="93" y="-1446.4" font-family="Arial" font-size="14.00" fill="#000000">board_id </text>
<text text-anchor="start" x="151.3534" y="-1446.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<polygon fill="none" stroke="#000000" points="86,-1405 86,-1435 279,-1435 279,-1405 86,-1405"/>
<text text-anchor="start" x="93" y="-1416.4" font-family="Arial" font-size="14.00" fill="#000000">parent_id </text>
<text text-anchor="start" x="155.244" y="-1416.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<polygon fill="none" stroke="#000000" points="86,-1375 86,-1405 279,-1405 279,-1375 86,-1375"/>
<text text-anchor="start" x="93" y="-1386.4" font-family="Arial" font-size="14.00" fill="#000000">subject </text>
<text text-anchor="start" x="141.2356" y="-1386.4" font-family="Arial" font-size="14.00" fill="#666666">[varchar(255)]</text>
<polygon fill="none" stroke="#000000" points="86,-1345 86,-1375 279,-1375 279,-1345 86,-1345"/>
<text text-anchor="start" x="93" y="-1356.4" font-family="Arial" font-size="14.00" fill="#000000">content </text>
<text text-anchor="start" x="142.8022" y="-1356.4" font-family="Arial" font-size="14.00" fill="#666666">[text]</text>
<polygon fill="none" stroke="#000000" points="86,-1315 86,-1345 279,-1345 279,-1315 86,-1315"/>
<text text-anchor="start" x="93" y="-1326.4" font-family="Arial" font-size="14.00" fill="#000000">author_id </text>
<text text-anchor="start" x="155.244" y="-1326.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<polygon fill="none" stroke="#000000" points="86,-1285 86,-1315 279,-1315 279,-1285 86,-1285"/>
<text text-anchor="start" x="93" y="-1296.4" font-family="Arial" font-size="14.00" fill="#000000">replies_count </text>
<text text-anchor="start" x="180.1332" y="-1296.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<polygon fill="none" stroke="#000000" points="86,-1255 86,-1285 279,-1285 279,-1255 86,-1255"/>
<text text-anchor="start" x="93" y="-1266.4" font-family="Arial" font-size="14.00" fill="#000000">last_reply_id </text>
<text text-anchor="start" x="175.4572" y="-1266.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<polygon fill="none" stroke="#000000" points="86,-1225 86,-1255 279,-1255 279,-1225 86,-1225"/>
<text text-anchor="start" x="93" y="-1236.4" font-family="Arial" font-size="14.00" fill="#000000">created_on </text>
<text text-anchor="start" x="166.92" y="-1236.4" font-family="Arial" font-size="14.00" fill="#666666">[datetime]</text>
<polygon fill="none" stroke="#000000" points="86,-1195 86,-1225 279,-1225 279,-1195 86,-1195"/>
<text text-anchor="start" x="93" y="-1206.4" font-family="Arial" font-size="14.00" fill="#000000">updated_on </text>
<text text-anchor="start" x="170.8246" y="-1206.4" font-family="Arial" font-size="14.00" fill="#666666">[datetime]</text>
<polygon fill="none" stroke="#000000" points="86,-1165 86,-1195 279,-1195 279,-1165 86,-1165"/>
<text text-anchor="start" x="93" y="-1176.4" font-family="Arial" font-size="14.00" fill="#000000">locked </text>
<text text-anchor="start" x="137.345" y="-1176.4" font-family="Arial" font-size="14.00" fill="#666666">[tinyint(1)]</text>
<polygon fill="none" stroke="#000000" points="86,-1135 86,-1165 279,-1165 279,-1135 86,-1135"/>
<text text-anchor="start" x="93" y="-1146.4" font-family="Arial" font-size="14.00" fill="#000000">sticky </text>
<text text-anchor="start" x="131.8878" y="-1146.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
</g>
<!-- messages&#45;&gt;boards -->
<g id="edge1" class="edge">
<title>messages:board_id&#45;&gt;boards:id</title>
<path fill="none" stroke="#000000" stroke-dasharray="5,2" d="M289.0717,-1448.253C355.902,-1423.833 327.2337,-1150.709 279,-1092 226.6564,-1028.2885 149.3436,-1119.7115 97,-1056 66.8114,-1019.2552 49.4444,-949 97,-949"/>
<polygon fill="#000000" stroke="#000000" points="288.8529,-1448.2909 278.2309,-1445.5662 283.9264,-1449.1455 279,-1450 279,-1450 279,-1450 283.9264,-1449.1455 279.7691,-1454.4338 288.8529,-1448.2909 288.8529,-1448.2909"/>
<text text-anchor="start" x="286.268" y="-1460" font-family="Arial" font-size="10.00" fill="#000000">Detected Relation</text>
</g>
</g>
</svg>