time_entries.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: time_entries Pages: 1 -->
<svg width="1295pt" height="1454pt"
 viewBox="0.00 0.00 1295.00 1454.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 1450)">
<title>time_entries</title>
<polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-1450 1291,-1450 1291,4 -4,4"/>
<!-- time_entries -->
<g id="node1" class="node">
<title>time_entries</title>
<polygon fill="#efefef" stroke="transparent" points="492.5,-1354 492.5,-1400 701.5,-1400 701.5,-1354 492.5,-1354"/>
<polygon fill="none" stroke="#000000" points="492.5,-1354 492.5,-1400 701.5,-1400 701.5,-1354 492.5,-1354"/>
<text text-anchor="start" x="499.369" y="-1377.8" font-family="Arial Bold" font-size="18.00" fill="#000000">time_entries</text>
<text text-anchor="start" x="597.3772" y="-1377.8" font-family="Arial" font-size="14.00" fill="#000000"> </text>
<text text-anchor="start" x="601.2678" y="-1377.8" font-family="Arial" font-size="14.00" fill="#666666">[BASE TABLE]</text>
<text text-anchor="start" x="568.2167" y="-1363.4" font-family="Arial" font-size="14.00" fill="#333333">時間管理</text>
<polygon fill="none" stroke="#000000" points="492.5,-1324 492.5,-1354 701.5,-1354 701.5,-1324 492.5,-1324"/>
<text text-anchor="start" x="499.5" y="-1335.4" font-family="Arial" font-size="14.00" fill="#000000">id </text>
<text text-anchor="start" x="514.2798" y="-1335.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<polygon fill="none" stroke="#000000" points="492.5,-1294 492.5,-1324 701.5,-1324 701.5,-1294 492.5,-1294"/>
<text text-anchor="start" x="499.5" y="-1305.4" font-family="Arial" font-size="14.00" fill="#000000">project_id </text>
<text text-anchor="start" x="564.068" y="-1305.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<polygon fill="none" stroke="#000000" points="492.5,-1264 492.5,-1294 701.5,-1294 701.5,-1264 492.5,-1264"/>
<text text-anchor="start" x="499.5" y="-1275.4" font-family="Arial" font-size="14.00" fill="#000000">author_id </text>
<text text-anchor="start" x="561.744" y="-1275.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<polygon fill="none" stroke="#000000" points="492.5,-1234 492.5,-1264 701.5,-1264 701.5,-1234 492.5,-1234"/>
<text text-anchor="start" x="499.5" y="-1245.4" font-family="Arial" font-size="14.00" fill="#000000">user_id </text>
<text text-anchor="start" x="549.2882" y="-1245.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<polygon fill="none" stroke="#000000" points="492.5,-1204 492.5,-1234 701.5,-1234 701.5,-1204 492.5,-1204"/>
<text text-anchor="start" x="499.5" y="-1215.4" font-family="Arial" font-size="14.00" fill="#000000">issue_id </text>
<text text-anchor="start" x="554.7342" y="-1215.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<polygon fill="none" stroke="#000000" points="492.5,-1174 492.5,-1204 701.5,-1204 701.5,-1174 492.5,-1174"/>
<text text-anchor="start" x="499.5" y="-1185.4" font-family="Arial" font-size="14.00" fill="#000000">hours </text>
<text text-anchor="start" x="538.399" y="-1185.4" font-family="Arial" font-size="14.00" fill="#666666">[float]</text>
<polygon fill="none" stroke="#000000" points="492.5,-1144 492.5,-1174 701.5,-1174 701.5,-1144 492.5,-1144"/>
<text text-anchor="start" x="499.5" y="-1155.4" font-family="Arial" font-size="14.00" fill="#000000">comments </text>
<text text-anchor="start" x="567.9502" y="-1155.4" font-family="Arial" font-size="14.00" fill="#666666">[varchar(1024)]</text>
<polygon fill="none" stroke="#000000" points="492.5,-1114 492.5,-1144 701.5,-1144 701.5,-1114 492.5,-1114"/>
<text text-anchor="start" x="499.5" y="-1125.4" font-family="Arial" font-size="14.00" fill="#000000">activity_id </text>
<text text-anchor="start" x="564.8394" y="-1125.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<polygon fill="none" stroke="#000000" points="492.5,-1084 492.5,-1114 701.5,-1114 701.5,-1084 492.5,-1084"/>
<text text-anchor="start" x="499.5" y="-1095.4" font-family="Arial" font-size="14.00" fill="#000000">spent_on </text>
<text text-anchor="start" x="560.9768" y="-1095.4" font-family="Arial" font-size="14.00" fill="#666666">[date]</text>
<polygon fill="none" stroke="#000000" points="492.5,-1054 492.5,-1084 701.5,-1084 701.5,-1054 492.5,-1054"/>
<text text-anchor="start" x="499.5" y="-1065.4" font-family="Arial" font-size="14.00" fill="#000000">tyear </text>
<text text-anchor="start" x="534.507" y="-1065.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<polygon fill="none" stroke="#000000" points="492.5,-1024 492.5,-1054 701.5,-1054 701.5,-1024 492.5,-1024"/>
<text text-anchor="start" x="499.5" y="-1035.4" font-family="Arial" font-size="14.00" fill="#000000">tmonth </text>
<text text-anchor="start" x="546.1802" y="-1035.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<polygon fill="none" stroke="#000000" points="492.5,-994 492.5,-1024 701.5,-1024 701.5,-994 492.5,-994"/>
<text text-anchor="start" x="499.5" y="-1005.4" font-family="Arial" font-size="14.00" fill="#000000">tweek </text>
<text text-anchor="start" x="539.953" y="-1005.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<polygon fill="none" stroke="#000000" points="492.5,-964 492.5,-994 701.5,-994 701.5,-964 492.5,-964"/>
<text text-anchor="start" x="499.5" y="-975.4" font-family="Arial" font-size="14.00" fill="#000000">created_on </text>
<text text-anchor="start" x="573.42" y="-975.4" font-family="Arial" font-size="14.00" fill="#666666">[datetime]</text>
<polygon fill="none" stroke="#000000" points="492.5,-934 492.5,-964 701.5,-964 701.5,-934 492.5,-934"/>
<text text-anchor="start" x="499.5" y="-945.4" font-family="Arial" font-size="14.00" fill="#000000">updated_on </text>
<text text-anchor="start" x="577.3246" y="-945.4" font-family="Arial" font-size="14.00" fill="#666666">[datetime]</text>
<polygon fill="none" stroke="#000000" stroke-width="3" points="490.5,-932.5 490.5,-1401.5 702.5,-1401.5 702.5,-932.5 490.5,-932.5"/>
</g>
<!-- projects -->
<g id="node2" class="node">
<title>projects</title>
<polygon fill="#efefef" stroke="transparent" points="43.5,-643 43.5,-689 252.5,-689 252.5,-643 43.5,-643"/>
<polygon fill="none" stroke="#000000" points="43.5,-643 43.5,-689 252.5,-689 252.5,-643 43.5,-643"/>
<text text-anchor="start" x="67.8695" y="-666.8" font-family="Arial Bold" font-size="18.00" fill="#000000">projects</text>
<text text-anchor="start" x="130.8767" y="-666.8" font-family="Arial" font-size="14.00" fill="#000000"> </text>
<text text-anchor="start" x="134.7673" y="-666.8" font-family="Arial" font-size="14.00" fill="#666666">[BASE TABLE]</text>
<text text-anchor="start" x="105.6269" y="-652.4" font-family="Arial" font-size="14.00" fill="#333333">プロジェクト</text>
<polygon fill="none" stroke="#000000" points="43.5,-613 43.5,-643 252.5,-643 252.5,-613 43.5,-613"/>
<text text-anchor="start" x="50.5" y="-624.4" font-family="Arial" font-size="14.00" fill="#000000">id </text>
<text text-anchor="start" x="65.2798" y="-624.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<polygon fill="none" stroke="#000000" points="43.5,-583 43.5,-613 252.5,-613 252.5,-583 43.5,-583"/>
<text text-anchor="start" x="50.5" y="-594.4" font-family="Arial" font-size="14.00" fill="#000000">name </text>
<text text-anchor="start" x="89.399" y="-594.4" font-family="Arial" font-size="14.00" fill="#666666">[varchar(255)]</text>
<polygon fill="none" stroke="#000000" points="43.5,-553 43.5,-583 252.5,-583 252.5,-553 43.5,-553"/>
<text text-anchor="start" x="50.5" y="-564.4" font-family="Arial" font-size="14.00" fill="#000000">description </text>
<text text-anchor="start" x="122.068" y="-564.4" font-family="Arial" font-size="14.00" fill="#666666">[text]</text>
<polygon fill="none" stroke="#000000" points="43.5,-523 43.5,-553 252.5,-553 252.5,-523 43.5,-523"/>
<text text-anchor="start" x="50.5" y="-534.4" font-family="Arial" font-size="14.00" fill="#000000">homepage </text>
<text text-anchor="start" x="120.5294" y="-534.4" font-family="Arial" font-size="14.00" fill="#666666">[varchar(255)]</text>
<polygon fill="none" stroke="#000000" points="43.5,-493 43.5,-523 252.5,-523 252.5,-493 43.5,-493"/>
<text text-anchor="start" x="50.5" y="-504.4" font-family="Arial" font-size="14.00" fill="#000000">is_public </text>
<text text-anchor="start" x="108.8408" y="-504.4" font-family="Arial" font-size="14.00" fill="#666666">[tinyint(1)]</text>
<polygon fill="none" stroke="#000000" points="43.5,-463 43.5,-493 252.5,-493 252.5,-463 43.5,-463"/>
<text text-anchor="start" x="50.5" y="-474.4" font-family="Arial" font-size="14.00" fill="#000000">parent_id </text>
<text text-anchor="start" x="112.744" y="-474.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<polygon fill="none" stroke="#000000" points="43.5,-433 43.5,-463 252.5,-463 252.5,-433 43.5,-433"/>
<text text-anchor="start" x="50.5" y="-444.4" font-family="Arial" font-size="14.00" fill="#000000">created_on </text>
<text text-anchor="start" x="124.42" y="-444.4" font-family="Arial" font-size="14.00" fill="#666666">[timestamp]</text>
<polygon fill="none" stroke="#000000" points="43.5,-403 43.5,-433 252.5,-433 252.5,-403 43.5,-403"/>
<text text-anchor="start" x="50.5" y="-414.4" font-family="Arial" font-size="14.00" fill="#000000">updated_on </text>
<text text-anchor="start" x="128.3246" y="-414.4" font-family="Arial" font-size="14.00" fill="#666666">[timestamp]</text>
<polygon fill="none" stroke="#000000" points="43.5,-373 43.5,-403 252.5,-403 252.5,-373 43.5,-373"/>
<text text-anchor="start" x="50.5" y="-384.4" font-family="Arial" font-size="14.00" fill="#000000">identifier </text>
<text text-anchor="start" x="107.2826" y="-384.4" font-family="Arial" font-size="14.00" fill="#666666">[varchar(255)]</text>
<polygon fill="none" stroke="#000000" points="43.5,-343 43.5,-373 252.5,-373 252.5,-343 43.5,-343"/>
<text text-anchor="start" x="50.5" y="-354.4" font-family="Arial" font-size="14.00" fill="#000000">status </text>
<text text-anchor="start" x="91.737" y="-354.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<polygon fill="none" stroke="#000000" points="43.5,-313 43.5,-343 252.5,-343 252.5,-313 43.5,-313"/>
<text text-anchor="start" x="50.5" y="-324.4" font-family="Arial" font-size="14.00" fill="#000000">lft </text>
<text text-anchor="start" x="65.2784" y="-324.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<polygon fill="none" stroke="#000000" points="43.5,-283 43.5,-313 252.5,-313 252.5,-283 43.5,-283"/>
<text text-anchor="start" x="50.5" y="-294.4" font-family="Arial" font-size="14.00" fill="#000000">rgt </text>
<text text-anchor="start" x="70.7244" y="-294.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<polygon fill="none" stroke="#000000" points="43.5,-253 43.5,-283 252.5,-283 252.5,-253 43.5,-253"/>
<text text-anchor="start" x="50.5" y="-264.4" font-family="Arial" font-size="14.00" fill="#000000">inherit_members </text>
<text text-anchor="start" x="158.615" y="-264.4" font-family="Arial" font-size="14.00" fill="#666666">[tinyint(1)]</text>
<polygon fill="none" stroke="#000000" points="43.5,-223 43.5,-253 252.5,-253 252.5,-223 43.5,-223"/>
<text text-anchor="start" x="50.5" y="-234.4" font-family="Arial" font-size="14.00" fill="#000000">default_version_id </text>
<text text-anchor="start" x="167.9782" y="-234.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<polygon fill="none" stroke="#000000" points="43.5,-193 43.5,-223 252.5,-223 252.5,-193 43.5,-193"/>
<text text-anchor="start" x="50.357" y="-204.4" font-family="Arial" font-size="14.00" fill="#000000">default_assigned_to_id </text>
<text text-anchor="start" x="198.1956" y="-204.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<polygon fill="none" stroke="#000000" points="43.5,-163 43.5,-193 252.5,-193 252.5,-163 43.5,-163"/>
<text text-anchor="start" x="50.3633" y="-174.4" font-family="Arial" font-size="14.00" fill="#000000">default_issue_query_id </text>
<text text-anchor="start" x="198.1893" y="-174.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
</g>
<!-- time_entries&#45;&gt;projects -->
<g id="edge1" class="edge">
<title>time_entries:project_id&#45;&gt;projects:id</title>
<path fill="none" stroke="#000000" stroke-dasharray="5,2" d="M482.4361,-1308.8196C275.9102,-1301.266 370.2852,-1057.9427 304.5,-852 288.9505,-803.3218 303.6014,-628 252.5,-628"/>
<polygon fill="#000000" stroke="#000000" points="482.5016,-1308.8207 492.4193,-1313.4993 487.5008,-1308.9103 492.5,-1309 492.5,-1309 492.5,-1309 487.5008,-1308.9103 492.5807,-1304.5007 482.5016,-1308.8207 482.5016,-1308.8207"/>
<text text-anchor="start" x="402.8245" y="-1319" font-family="Arial" font-size="10.00" fill="#000000">Additional Relation</text>
</g>
<!-- users -->
<g id="node3" class="node">
<title>users</title>
<polygon fill="#efefef" stroke="transparent" points="356.5,-718 356.5,-764 838.5,-764 838.5,-718 356.5,-718"/>
<polygon fill="none" stroke="#000000" points="356.5,-718 356.5,-764 838.5,-764 838.5,-718 356.5,-718"/>
<text text-anchor="start" x="526.8708" y="-741.8" font-family="Arial Bold" font-size="18.00" fill="#000000">users</text>
<text text-anchor="start" x="570.8754" y="-741.8" font-family="Arial" font-size="14.00" fill="#000000"> </text>
<text text-anchor="start" x="574.766" y="-741.8" font-family="Arial" font-size="14.00" fill="#666666">[BASE TABLE]</text>
<text text-anchor="start" x="518.9558" y="-727.4" font-family="Arial" font-size="14.00" fill="#333333">ユーザー / グループ</text>
<polygon fill="none" stroke="#000000" points="356.5,-688 356.5,-718 838.5,-718 838.5,-688 356.5,-688"/>
<text text-anchor="start" x="363.5" y="-699.4" font-family="Arial" font-size="14.00" fill="#000000">id </text>
<text text-anchor="start" x="378.2798" y="-699.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<polygon fill="none" stroke="#000000" points="356.5,-658 356.5,-688 838.5,-688 838.5,-658 356.5,-658"/>
<text text-anchor="start" x="363.5" y="-669.4" font-family="Arial" font-size="14.00" fill="#000000">login </text>
<text text-anchor="start" x="396.9516" y="-669.4" font-family="Arial" font-size="14.00" fill="#666666">[varchar(255)]</text>
<text text-anchor="start" x="484.0708" y="-669.4" font-family="Arial" font-size="14.00" fill="#000000"> ログインID</text>
<polygon fill="none" stroke="#000000" points="356.5,-628 356.5,-658 838.5,-658 838.5,-628 356.5,-628"/>
<text text-anchor="start" x="363.5" y="-639.4" font-family="Arial" font-size="14.00" fill="#000000">hashed_password </text>
<text text-anchor="start" x="480.9838" y="-639.4" font-family="Arial" font-size="14.00" fill="#666666">[varchar(40)]</text>
<text text-anchor="start" x="560.3204" y="-639.4" font-family="Arial" font-size="14.00" fill="#000000"> パスワード(ハッシュ化済み)</text>
<polygon fill="none" stroke="#000000" points="356.5,-598 356.5,-628 838.5,-628 838.5,-598 356.5,-598"/>
<text text-anchor="start" x="363.5" y="-609.4" font-family="Arial" font-size="14.00" fill="#000000">firstname </text>
<text text-anchor="start" x="424.9474" y="-609.4" font-family="Arial" font-size="14.00" fill="#666666">[varchar(30)]</text>
<text text-anchor="start" x="504.284" y="-609.4" font-family="Arial" font-size="14.00" fill="#000000"> 名</text>
<polygon fill="none" stroke="#000000" points="356.5,-568 356.5,-598 838.5,-598 838.5,-568 356.5,-568"/>
<text text-anchor="start" x="363.5" y="-579.4" font-family="Arial" font-size="14.00" fill="#000000">lastname </text>
<text text-anchor="start" x="424.1788" y="-579.4" font-family="Arial" font-size="14.00" fill="#666666">[varchar(255)]</text>
<text text-anchor="start" x="511.298" y="-579.4" font-family="Arial" font-size="14.00" fill="#000000"> 姓</text>
<polygon fill="none" stroke="#000000" points="356.5,-538 356.5,-568 838.5,-568 838.5,-538 356.5,-538"/>
<text text-anchor="start" x="363.5" y="-549.4" font-family="Arial" font-size="14.00" fill="#000000">admin </text>
<text text-anchor="start" x="405.5056" y="-549.4" font-family="Arial" font-size="14.00" fill="#666666">[tinyint(1)]</text>
<text text-anchor="start" x="466.9502" y="-549.4" font-family="Arial" font-size="14.00" fill="#000000"> システム管理者</text>
<polygon fill="none" stroke="#000000" points="356.5,-508 356.5,-538 838.5,-538 838.5,-508 356.5,-508"/>
<text text-anchor="start" x="363.5" y="-519.4" font-family="Arial" font-size="14.00" fill="#000000">status </text>
<text text-anchor="start" x="404.737" y="-519.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<polygon fill="none" stroke="#000000" points="356.5,-478 356.5,-508 838.5,-508 838.5,-478 356.5,-478"/>
<text text-anchor="start" x="363.5" y="-489.4" font-family="Arial" font-size="14.00" fill="#000000">last_login_on </text>
<text text-anchor="start" x="449.8618" y="-489.4" font-family="Arial" font-size="14.00" fill="#666666">[datetime]</text>
<polygon fill="none" stroke="#000000" points="356.5,-448 356.5,-478 838.5,-478 838.5,-448 356.5,-448"/>
<text text-anchor="start" x="363.5" y="-459.4" font-family="Arial" font-size="14.00" fill="#000000">language </text>
<text text-anchor="start" x="424.9754" y="-459.4" font-family="Arial" font-size="14.00" fill="#666666">[varchar(5)]</text>
<text text-anchor="start" x="496.5294" y="-459.4" font-family="Arial" font-size="14.00" fill="#000000"> 言語</text>
<polygon fill="none" stroke="#000000" points="356.5,-418 356.5,-448 838.5,-448 838.5,-418 356.5,-418"/>
<text text-anchor="start" x="363.5" y="-429.4" font-family="Arial" font-size="14.00" fill="#000000">auth_source_id </text>
<text text-anchor="start" x="463.0918" y="-429.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<polygon fill="none" stroke="#000000" points="356.5,-388 356.5,-418 838.5,-418 838.5,-388 356.5,-388"/>
<text text-anchor="start" x="363.5" y="-399.4" font-family="Arial" font-size="14.00" fill="#000000">created_on </text>
<text text-anchor="start" x="437.42" y="-399.4" font-family="Arial" font-size="14.00" fill="#666666">[timestamp]</text>
<polygon fill="none" stroke="#000000" points="356.5,-358 356.5,-388 838.5,-388 838.5,-358 356.5,-358"/>
<text text-anchor="start" x="363.5" y="-369.4" font-family="Arial" font-size="14.00" fill="#000000">updated_on </text>
<text text-anchor="start" x="441.3246" y="-369.4" font-family="Arial" font-size="14.00" fill="#666666">[timestamp]</text>
<polygon fill="none" stroke="#000000" points="356.5,-328 356.5,-358 838.5,-358 838.5,-328 356.5,-328"/>
<text text-anchor="start" x="363.5" y="-339.4" font-family="Arial" font-size="14.00" fill="#000000">type </text>
<text text-anchor="start" x="393.8464" y="-339.4" font-family="Arial" font-size="14.00" fill="#666666">[varchar(255)]</text>
<text text-anchor="start" x="480.9656" y="-339.4" font-family="Arial" font-size="14.00" fill="#000000"> User:ユーザー Group:グループ </text>
<polygon fill="none" stroke="#000000" points="356.5,-298 356.5,-328 838.5,-328 838.5,-298 356.5,-298"/>
<text text-anchor="start" x="363.5" y="-309.4" font-family="Arial" font-size="14.00" fill="#000000">mail_notification </text>
<text text-anchor="start" x="467.7342" y="-309.4" font-family="Arial" font-size="14.00" fill="#666666">[varchar(255)]</text>
<text text-anchor="start" x="554.8534" y="-309.4" font-family="Arial" font-size="14.00" fill="#000000"> メール通知</text>
<polygon fill="none" stroke="#000000" points="356.5,-268 356.5,-298 838.5,-298 838.5,-268 356.5,-268"/>
<text text-anchor="start" x="363.5" y="-279.4" font-family="Arial" font-size="14.00" fill="#000000">salt </text>
<text text-anchor="start" x="389.1704" y="-279.4" font-family="Arial" font-size="14.00" fill="#666666">[varchar(64)]</text>
<polygon fill="none" stroke="#000000" points="356.5,-238 356.5,-268 838.5,-268 838.5,-238 356.5,-238"/>
<text text-anchor="start" x="363.2646" y="-249.4" font-family="Arial" font-size="14.00" fill="#000000">must_change_passwd </text>
<text text-anchor="start" x="506.4216" y="-249.4" font-family="Arial" font-size="14.00" fill="#666666">[tinyint(1)]</text>
<text text-anchor="start" x="567.8662" y="-249.4" font-family="Arial" font-size="14.00" fill="#000000"> 次回ログイン時にパスワード変更を強制</text>
<polygon fill="none" stroke="#000000" points="356.5,-208 356.5,-238 838.5,-238 838.5,-208 356.5,-208"/>
<text text-anchor="start" x="363.5" y="-219.4" font-family="Arial" font-size="14.00" fill="#000000">passwd_changed_on </text>
<text text-anchor="start" x="499.671" y="-219.4" font-family="Arial" font-size="14.00" fill="#666666">[datetime]</text>
<polygon fill="none" stroke="#000000" points="356.5,-178 356.5,-208 838.5,-208 838.5,-178 356.5,-178"/>
<text text-anchor="start" x="363.5" y="-189.4" font-family="Arial" font-size="14.00" fill="#000000">twofa_scheme </text>
<text text-anchor="start" x="457.6346" y="-189.4" font-family="Arial" font-size="14.00" fill="#666666">[varchar(255)]</text>
<polygon fill="none" stroke="#000000" points="356.5,-148 356.5,-178 838.5,-178 838.5,-148 356.5,-148"/>
<text text-anchor="start" x="363.5" y="-159.4" font-family="Arial" font-size="14.00" fill="#000000">twofa_totp_key </text>
<text text-anchor="start" x="461.5378" y="-159.4" font-family="Arial" font-size="14.00" fill="#666666">[varchar(255)]</text>
<polygon fill="none" stroke="#000000" points="356.5,-118 356.5,-148 838.5,-148 838.5,-118 356.5,-118"/>
<text text-anchor="start" x="363.5" y="-129.4" font-family="Arial" font-size="14.00" fill="#000000">twofa_totp_last_used_at </text>
<text text-anchor="start" x="519.1212" y="-129.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<polygon fill="none" stroke="#000000" points="356.5,-88 356.5,-118 838.5,-118 838.5,-88 356.5,-88"/>
<text text-anchor="start" x="363.5" y="-99.4" font-family="Arial" font-size="14.00" fill="#000000">twofa_required </text>
<text text-anchor="start" x="459.967" y="-99.4" font-family="Arial" font-size="14.00" fill="#666666">[tinyint(1)]</text>
</g>
<!-- time_entries&#45;&gt;users -->
<g id="edge2" class="edge">
<title>time_entries:author_id&#45;&gt;users:id</title>
<path fill="none" stroke="#000000" stroke-dasharray="5,2" d="M711.8908,-1278.6817C872.5592,-1268.5991 807.2132,-1021.4073 701.5,-888 603.6813,-764.5553 454.3187,-930.4447 356.5,-807 327.7932,-770.7728 310.2778,-703 356.5,-703"/>
<polygon fill="#000000" stroke="#000000" points="711.4953,-1278.6938 701.3622,-1274.5021 706.4977,-1278.8469 701.5,-1279 701.5,-1279 701.5,-1279 706.4977,-1278.8469 701.6378,-1283.4979 711.4953,-1278.6938 711.4953,-1278.6938"/>
<text text-anchor="start" x="708.8245" y="-1289" font-family="Arial" font-size="10.00" fill="#000000">Additional Relation</text>
</g>
<!-- time_entries&#45;&gt;users -->
<g id="edge3" class="edge">
<title>time_entries:user_id&#45;&gt;users:id</title>
<path fill="none" stroke="#000000" stroke-dasharray="5,2" d="M711.5366,-1248.6777C859.3141,-1238.9422 799.0049,-1011.0487 701.5,-888 603.6813,-764.5553 454.3187,-930.4447 356.5,-807 327.7932,-770.7728 310.2778,-703 356.5,-703"/>
<polygon fill="#000000" stroke="#000000" points="711.4948,-1248.6789 701.3555,-1244.5023 706.4974,-1248.8395 701.5,-1249 701.5,-1249 701.5,-1249 706.4974,-1248.8395 701.6445,-1253.4977 711.4948,-1248.6789 711.4948,-1248.6789"/>
<text text-anchor="start" x="708.768" y="-1259" font-family="Arial" font-size="10.00" fill="#000000">Detected Relation</text>
</g>
<!-- issues -->
<g id="node4" class="node">
<title>issues</title>
<polygon fill="#efefef" stroke="transparent" points="943.5,-763 943.5,-809 1244.5,-809 1244.5,-763 943.5,-763"/>
<polygon fill="none" stroke="#000000" points="943.5,-763 943.5,-809 1244.5,-809 1244.5,-763 943.5,-763"/>
<text text-anchor="start" x="1019.8698" y="-786.8" font-family="Arial Bold" font-size="18.00" fill="#000000">issues</text>
<text text-anchor="start" x="1070.8764" y="-786.8" font-family="Arial" font-size="14.00" fill="#000000"> </text>
<text text-anchor="start" x="1074.767" y="-786.8" font-family="Arial" font-size="14.00" fill="#666666">[BASE TABLE]</text>
<text text-anchor="start" x="1066.1344" y="-772.4" font-family="Arial" font-size="14.00" fill="#333333">チケット</text>
<polygon fill="none" stroke="#000000" points="943.5,-733 943.5,-763 1244.5,-763 1244.5,-733 943.5,-733"/>
<text text-anchor="start" x="950.5" y="-744.4" font-family="Arial" font-size="14.00" fill="#000000">id </text>
<text text-anchor="start" x="965.2798" y="-744.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<polygon fill="none" stroke="#000000" points="943.5,-703 943.5,-733 1244.5,-733 1244.5,-703 943.5,-703"/>
<text text-anchor="start" x="950.5" y="-714.4" font-family="Arial" font-size="14.00" fill="#000000">tracker_id </text>
<text text-anchor="start" x="1015.8394" y="-714.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<text text-anchor="start" x="1063.2868" y="-714.4" font-family="Arial" font-size="14.00" fill="#000000"> トラッカーID</text>
<polygon fill="none" stroke="#000000" points="943.5,-673 943.5,-703 1244.5,-703 1244.5,-673 943.5,-673"/>
<text text-anchor="start" x="950.5" y="-684.4" font-family="Arial" font-size="14.00" fill="#000000">project_id </text>
<text text-anchor="start" x="1015.068" y="-684.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<text text-anchor="start" x="1062.5154" y="-684.4" font-family="Arial" font-size="14.00" fill="#000000"> プロジェクトID</text>
<polygon fill="none" stroke="#000000" points="943.5,-643 943.5,-673 1244.5,-673 1244.5,-643 943.5,-643"/>
<text text-anchor="start" x="950.5" y="-654.4" font-family="Arial" font-size="14.00" fill="#000000">subject </text>
<text text-anchor="start" x="998.7356" y="-654.4" font-family="Arial" font-size="14.00" fill="#666666">[varchar(255)]</text>
<text text-anchor="start" x="1085.8548" y="-654.4" font-family="Arial" font-size="14.00" fill="#000000"> 題名</text>
<polygon fill="none" stroke="#000000" points="943.5,-613 943.5,-643 1244.5,-643 1244.5,-613 943.5,-613"/>
<text text-anchor="start" x="950.5" y="-624.4" font-family="Arial" font-size="14.00" fill="#000000">description </text>
<text text-anchor="start" x="1022.068" y="-624.4" font-family="Arial" font-size="14.00" fill="#666666">[longtext]</text>
<text text-anchor="start" x="1078.8674" y="-624.4" font-family="Arial" font-size="14.00" fill="#000000"> 説明</text>
<polygon fill="none" stroke="#000000" points="943.5,-583 943.5,-613 1244.5,-613 1244.5,-583 943.5,-583"/>
<text text-anchor="start" x="950.5" y="-594.4" font-family="Arial" font-size="14.00" fill="#000000">due_date </text>
<text text-anchor="start" x="1012.7594" y="-594.4" font-family="Arial" font-size="14.00" fill="#666666">[date]</text>
<text text-anchor="start" x="1047.779" y="-594.4" font-family="Arial" font-size="14.00" fill="#000000"> 期日</text>
<polygon fill="none" stroke="#000000" points="943.5,-553 943.5,-583 1244.5,-583 1244.5,-553 943.5,-553"/>
<text text-anchor="start" x="950.5" y="-564.4" font-family="Arial" font-size="14.00" fill="#000000">category_id </text>
<text text-anchor="start" x="1026.744" y="-564.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<text text-anchor="start" x="1074.1914" y="-564.4" font-family="Arial" font-size="14.00" fill="#000000"> カテゴリーID</text>
<polygon fill="none" stroke="#000000" points="943.5,-523 943.5,-553 1244.5,-553 1244.5,-523 943.5,-523"/>
<text text-anchor="start" x="950.5" y="-534.4" font-family="Arial" font-size="14.00" fill="#000000">status_id </text>
<text text-anchor="start" x="1010.4088" y="-534.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<text text-anchor="start" x="1057.8562" y="-534.4" font-family="Arial" font-size="14.00" fill="#000000"> ステータスID</text>
<polygon fill="none" stroke="#000000" points="943.5,-493 943.5,-523 1244.5,-523 1244.5,-493 943.5,-493"/>
<text text-anchor="start" x="950.5" y="-504.4" font-family="Arial" font-size="14.00" fill="#000000">assigned_to_id </text>
<text text-anchor="start" x="1048.5378" y="-504.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<text text-anchor="start" x="1095.9852" y="-504.4" font-family="Arial" font-size="14.00" fill="#000000"> 担当者ID</text>
<polygon fill="none" stroke="#000000" points="943.5,-463 943.5,-493 1244.5,-493 1244.5,-463 943.5,-463"/>
<text text-anchor="start" x="950.5" y="-474.4" font-family="Arial" font-size="14.00" fill="#000000">priority_id </text>
<text text-anchor="start" x="1015.0526" y="-474.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<text text-anchor="start" x="1062.5" y="-474.4" font-family="Arial" font-size="14.00" fill="#000000"> 優先度ID</text>
<polygon fill="none" stroke="#000000" points="943.5,-433 943.5,-463 1244.5,-463 1244.5,-433 943.5,-433"/>
<text text-anchor="start" x="950.3635" y="-444.4" font-family="Arial" font-size="14.00" fill="#000000">fixed_version_id </text>
<text text-anchor="start" x="1055.3859" y="-444.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<text text-anchor="start" x="1102.8333" y="-444.4" font-family="Arial" font-size="14.00" fill="#000000"> 対象バージョンID</text>
<polygon fill="none" stroke="#000000" points="943.5,-403 943.5,-433 1244.5,-433 1244.5,-403 943.5,-403"/>
<text text-anchor="start" x="950.5" y="-414.4" font-family="Arial" font-size="14.00" fill="#000000">author_id </text>
<text text-anchor="start" x="1012.744" y="-414.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<text text-anchor="start" x="1060.1914" y="-414.4" font-family="Arial" font-size="14.00" fill="#000000"> 登録者ID</text>
<polygon fill="none" stroke="#000000" points="943.5,-373 943.5,-403 1244.5,-403 1244.5,-373 943.5,-373"/>
<text text-anchor="start" x="950.5" y="-384.4" font-family="Arial" font-size="14.00" fill="#000000">lock_version </text>
<text text-anchor="start" x="1032.1774" y="-384.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<text text-anchor="start" x="1079.6248" y="-384.4" font-family="Arial" font-size="14.00" fill="#000000"> ロックバージョン</text>
<polygon fill="none" stroke="#000000" points="943.5,-343 943.5,-373 1244.5,-373 1244.5,-343 943.5,-343"/>
<text text-anchor="start" x="950.5" y="-354.4" font-family="Arial" font-size="14.00" fill="#000000">created_on </text>
<text text-anchor="start" x="1024.42" y="-354.4" font-family="Arial" font-size="14.00" fill="#666666">[timestamp]</text>
<polygon fill="none" stroke="#000000" points="943.5,-313 943.5,-343 1244.5,-343 1244.5,-313 943.5,-313"/>
<text text-anchor="start" x="950.5" y="-324.4" font-family="Arial" font-size="14.00" fill="#000000">updated_on </text>
<text text-anchor="start" x="1028.3246" y="-324.4" font-family="Arial" font-size="14.00" fill="#666666">[timestamp]</text>
<polygon fill="none" stroke="#000000" points="943.5,-283 943.5,-313 1244.5,-313 1244.5,-283 943.5,-283"/>
<text text-anchor="start" x="950.5" y="-294.4" font-family="Arial" font-size="14.00" fill="#000000">start_date </text>
<text text-anchor="start" x="1016.636" y="-294.4" font-family="Arial" font-size="14.00" fill="#666666">[date]</text>
<text text-anchor="start" x="1051.6556" y="-294.4" font-family="Arial" font-size="14.00" fill="#000000"> 開始日</text>
<polygon fill="none" stroke="#000000" points="943.5,-253 943.5,-283 1244.5,-283 1244.5,-253 943.5,-253"/>
<text text-anchor="start" x="950.5" y="-264.4" font-family="Arial" font-size="14.00" fill="#000000">done_ratio </text>
<text text-anchor="start" x="1020.5266" y="-264.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<text text-anchor="start" x="1067.974" y="-264.4" font-family="Arial" font-size="14.00" fill="#000000"> 進捗率</text>
<polygon fill="none" stroke="#000000" points="943.5,-223 943.5,-253 1244.5,-253 1244.5,-223 943.5,-223"/>
<text text-anchor="start" x="950.5" y="-234.4" font-family="Arial" font-size="14.00" fill="#000000">estimated_hours </text>
<text text-anchor="start" x="1057.8604" y="-234.4" font-family="Arial" font-size="14.00" fill="#666666">[float]</text>
<text text-anchor="start" x="1092.0946" y="-234.4" font-family="Arial" font-size="14.00" fill="#000000"> 予定工数</text>
<polygon fill="none" stroke="#000000" points="943.5,-193 943.5,-223 1244.5,-223 1244.5,-193 943.5,-193"/>
<text text-anchor="start" x="950.5" y="-204.4" font-family="Arial" font-size="14.00" fill="#000000">parent_id </text>
<text text-anchor="start" x="1012.744" y="-204.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<text text-anchor="start" x="1060.1914" y="-204.4" font-family="Arial" font-size="14.00" fill="#000000"> 親チケット</text>
<polygon fill="none" stroke="#000000" points="943.5,-163 943.5,-193 1244.5,-193 1244.5,-163 943.5,-163"/>
<text text-anchor="start" x="950.5" y="-174.4" font-family="Arial" font-size="14.00" fill="#000000">root_id </text>
<text text-anchor="start" x="997.1788" y="-174.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<text text-anchor="start" x="1044.6262" y="-174.4" font-family="Arial" font-size="14.00" fill="#000000"> ルートID</text>
<polygon fill="none" stroke="#000000" points="943.5,-133 943.5,-163 1244.5,-163 1244.5,-133 943.5,-133"/>
<text text-anchor="start" x="950.5" y="-144.4" font-family="Arial" font-size="14.00" fill="#000000">lft </text>
<text text-anchor="start" x="965.2784" y="-144.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<text text-anchor="start" x="1012.7258" y="-144.4" font-family="Arial" font-size="14.00" fill="#000000"> 左ノードポインタ</text>
<polygon fill="none" stroke="#000000" points="943.5,-103 943.5,-133 1244.5,-133 1244.5,-103 943.5,-103"/>
<text text-anchor="start" x="950.5" y="-114.4" font-family="Arial" font-size="14.00" fill="#000000">rgt </text>
<text text-anchor="start" x="970.7244" y="-114.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<text text-anchor="start" x="1018.1718" y="-114.4" font-family="Arial" font-size="14.00" fill="#000000"> 右ノードポインタ</text>
<polygon fill="none" stroke="#000000" points="943.5,-73 943.5,-103 1244.5,-103 1244.5,-73 943.5,-73"/>
<text text-anchor="start" x="950.5" y="-84.4" font-family="Arial" font-size="14.00" fill="#000000">is_private </text>
<text text-anchor="start" x="1014.2854" y="-84.4" font-family="Arial" font-size="14.00" fill="#666666">[tinyint(1)]</text>
<text text-anchor="start" x="1075.73" y="-84.4" font-family="Arial" font-size="14.00" fill="#000000"> プライベート</text>
<polygon fill="none" stroke="#000000" points="943.5,-43 943.5,-73 1244.5,-73 1244.5,-43 943.5,-43"/>
<text text-anchor="start" x="950.5" y="-54.4" font-family="Arial" font-size="14.00" fill="#000000">closed_on </text>
<text text-anchor="start" x="1018.1928" y="-54.4" font-family="Arial" font-size="14.00" fill="#666666">[datetime]</text>
<text text-anchor="start" x="1079.6528" y="-54.4" font-family="Arial" font-size="14.00" fill="#000000"> 完了日時</text>
</g>
<!-- time_entries&#45;&gt;issues -->
<g id="edge4" class="edge">
<title>time_entries:issue_id&#45;&gt;issues:id</title>
<path fill="none" stroke="#000000" stroke-dasharray="5,2" d="M711.6998,-1218.7801C882.0533,-1211.2561 808.4402,-1012.1799 890.5,-852 914.1538,-805.828 891.6217,-748 943.5,-748"/>
<polygon fill="#000000" stroke="#000000" points="711.4977,-1218.7843 701.4029,-1214.501 706.4988,-1218.8922 701.5,-1219 701.5,-1219 701.5,-1219 706.4988,-1218.8922 701.5971,-1223.499 711.4977,-1218.7843 711.4977,-1218.7843"/>
<text text-anchor="start" x="708.768" y="-1229" font-family="Arial" font-size="10.00" fill="#000000">Detected Relation</text>
</g>
</g>
</svg>