journals.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: journals Pages: 1 -->
<svg width="625pt" height="1502pt"
 viewBox="0.00 0.00 624.50 1502.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 1498)">
<title>journals</title>
<polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-1498 620.5,-1498 620.5,4 -4,4"/>
<!-- journals -->
<g id="node1" class="node">
<title>journals</title>
<polygon fill="#efefef" stroke="transparent" points="46.5,-1054 46.5,-1100 523.5,-1100 523.5,-1054 46.5,-1054"/>
<polygon fill="none" stroke="#000000" points="46.5,-1054 46.5,-1100 523.5,-1100 523.5,-1054 46.5,-1054"/>
<text text-anchor="start" x="204.8704" y="-1077.8" font-family="Arial Bold" font-size="18.00" fill="#000000">journals</text>
<text text-anchor="start" x="267.8758" y="-1077.8" font-family="Arial" font-size="14.00" fill="#000000"> </text>
<text text-anchor="start" x="271.7664" y="-1077.8" font-family="Arial" font-size="14.00" fill="#666666">[BASE TABLE]</text>
<text text-anchor="start" x="244.0458" y="-1063.4" font-family="Arial" font-size="14.00" fill="#333333">ジャーナル</text>
<polygon fill="none" stroke="#000000" points="46.5,-1024 46.5,-1054 523.5,-1054 523.5,-1024 46.5,-1024"/>
<text text-anchor="start" x="53.5" y="-1035.4" font-family="Arial" font-size="14.00" fill="#000000">id </text>
<text text-anchor="start" x="68.2798" y="-1035.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<polygon fill="none" stroke="#000000" points="46.5,-994 46.5,-1024 523.5,-1024 523.5,-994 46.5,-994"/>
<text text-anchor="start" x="53.5" y="-1005.4" font-family="Arial" font-size="14.00" fill="#000000">journalized_id </text>
<text text-anchor="start" x="143.7384" y="-1005.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<polygon fill="none" stroke="#000000" points="46.5,-964 46.5,-994 523.5,-994 523.5,-964 46.5,-964"/>
<text text-anchor="start" x="53.4575" y="-975.4" font-family="Arial" font-size="14.00" fill="#000000">journalized_type </text>
<text text-anchor="start" x="159.2625" y="-975.4" font-family="Arial" font-size="14.00" fill="#666666">[varchar(30)]</text>
<text text-anchor="start" x="238.5991" y="-975.4" font-family="Arial" font-size="14.00" fill="#000000"> Issue:チケット Changeset:チェンジセット </text>
<polygon fill="none" stroke="#000000" points="46.5,-934 46.5,-964 523.5,-964 523.5,-934 46.5,-934"/>
<text text-anchor="start" x="53.5" y="-945.4" font-family="Arial" font-size="14.00" fill="#000000">user_id </text>
<text text-anchor="start" x="103.2882" y="-945.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<polygon fill="none" stroke="#000000" points="46.5,-904 46.5,-934 523.5,-934 523.5,-904 46.5,-904"/>
<text text-anchor="start" x="53.5" y="-915.4" font-family="Arial" font-size="14.00" fill="#000000">notes </text>
<text text-anchor="start" x="91.629" y="-915.4" font-family="Arial" font-size="14.00" fill="#666666">[longtext]</text>
<polygon fill="none" stroke="#000000" points="46.5,-874 46.5,-904 523.5,-904 523.5,-874 46.5,-874"/>
<text text-anchor="start" x="53.5" y="-885.4" font-family="Arial" font-size="14.00" fill="#000000">created_on </text>
<text text-anchor="start" x="127.42" y="-885.4" font-family="Arial" font-size="14.00" fill="#666666">[datetime]</text>
<polygon fill="none" stroke="#000000" points="46.5,-844 46.5,-874 523.5,-874 523.5,-844 46.5,-844"/>
<text text-anchor="start" x="53.5" y="-855.4" font-family="Arial" font-size="14.00" fill="#000000">private_notes </text>
<text text-anchor="start" x="141.4172" y="-855.4" font-family="Arial" font-size="14.00" fill="#666666">[tinyint(1)]</text>
<polygon fill="none" stroke="#000000" stroke-width="3" points="44.5,-842.5 44.5,-1101.5 524.5,-1101.5 524.5,-842.5 44.5,-842.5"/>
</g>
<!-- users -->
<g id="node3" class="node">
<title>users</title>
<polygon fill="#efefef" stroke="transparent" points="44.5,-673 44.5,-719 526.5,-719 526.5,-673 44.5,-673"/>
<polygon fill="none" stroke="#000000" points="44.5,-673 44.5,-719 526.5,-719 526.5,-673 44.5,-673"/>
<text text-anchor="start" x="214.8708" y="-696.8" font-family="Arial Bold" font-size="18.00" fill="#000000">users</text>
<text text-anchor="start" x="258.8754" y="-696.8" font-family="Arial" font-size="14.00" fill="#000000"> </text>
<text text-anchor="start" x="262.766" y="-696.8" font-family="Arial" font-size="14.00" fill="#666666">[BASE TABLE]</text>
<text text-anchor="start" x="206.9558" y="-682.4" font-family="Arial" font-size="14.00" fill="#333333">ユーザー / グループ</text>
<polygon fill="none" stroke="#000000" points="44.5,-643 44.5,-673 526.5,-673 526.5,-643 44.5,-643"/>
<text text-anchor="start" x="51.5" y="-654.4" font-family="Arial" font-size="14.00" fill="#000000">id </text>
<text text-anchor="start" x="66.2798" y="-654.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<polygon fill="none" stroke="#000000" points="44.5,-613 44.5,-643 526.5,-643 526.5,-613 44.5,-613"/>
<text text-anchor="start" x="51.5" y="-624.4" font-family="Arial" font-size="14.00" fill="#000000">login </text>
<text text-anchor="start" x="84.9516" y="-624.4" font-family="Arial" font-size="14.00" fill="#666666">[varchar(255)]</text>
<text text-anchor="start" x="172.0708" y="-624.4" font-family="Arial" font-size="14.00" fill="#000000"> ログインID</text>
<polygon fill="none" stroke="#000000" points="44.5,-583 44.5,-613 526.5,-613 526.5,-583 44.5,-583"/>
<text text-anchor="start" x="51.5" y="-594.4" font-family="Arial" font-size="14.00" fill="#000000">hashed_password </text>
<text text-anchor="start" x="168.9838" y="-594.4" font-family="Arial" font-size="14.00" fill="#666666">[varchar(40)]</text>
<text text-anchor="start" x="248.3204" y="-594.4" font-family="Arial" font-size="14.00" fill="#000000"> パスワード(ハッシュ化済み)</text>
<polygon fill="none" stroke="#000000" points="44.5,-553 44.5,-583 526.5,-583 526.5,-553 44.5,-553"/>
<text text-anchor="start" x="51.5" y="-564.4" font-family="Arial" font-size="14.00" fill="#000000">firstname </text>
<text text-anchor="start" x="112.9474" y="-564.4" font-family="Arial" font-size="14.00" fill="#666666">[varchar(30)]</text>
<text text-anchor="start" x="192.284" y="-564.4" font-family="Arial" font-size="14.00" fill="#000000"> 名</text>
<polygon fill="none" stroke="#000000" points="44.5,-523 44.5,-553 526.5,-553 526.5,-523 44.5,-523"/>
<text text-anchor="start" x="51.5" y="-534.4" font-family="Arial" font-size="14.00" fill="#000000">lastname </text>
<text text-anchor="start" x="112.1788" y="-534.4" font-family="Arial" font-size="14.00" fill="#666666">[varchar(255)]</text>
<text text-anchor="start" x="199.298" y="-534.4" font-family="Arial" font-size="14.00" fill="#000000"> 姓</text>
<polygon fill="none" stroke="#000000" points="44.5,-493 44.5,-523 526.5,-523 526.5,-493 44.5,-493"/>
<text text-anchor="start" x="51.5" y="-504.4" font-family="Arial" font-size="14.00" fill="#000000">admin </text>
<text text-anchor="start" x="93.5056" y="-504.4" font-family="Arial" font-size="14.00" fill="#666666">[tinyint(1)]</text>
<text text-anchor="start" x="154.9502" y="-504.4" font-family="Arial" font-size="14.00" fill="#000000"> システム管理者</text>
<polygon fill="none" stroke="#000000" points="44.5,-463 44.5,-493 526.5,-493 526.5,-463 44.5,-463"/>
<text text-anchor="start" x="51.5" y="-474.4" font-family="Arial" font-size="14.00" fill="#000000">status </text>
<text text-anchor="start" x="92.737" y="-474.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<polygon fill="none" stroke="#000000" points="44.5,-433 44.5,-463 526.5,-463 526.5,-433 44.5,-433"/>
<text text-anchor="start" x="51.5" y="-444.4" font-family="Arial" font-size="14.00" fill="#000000">last_login_on </text>
<text text-anchor="start" x="137.8618" y="-444.4" font-family="Arial" font-size="14.00" fill="#666666">[datetime]</text>
<polygon fill="none" stroke="#000000" points="44.5,-403 44.5,-433 526.5,-433 526.5,-403 44.5,-403"/>
<text text-anchor="start" x="51.5" y="-414.4" font-family="Arial" font-size="14.00" fill="#000000">language </text>
<text text-anchor="start" x="112.9754" y="-414.4" font-family="Arial" font-size="14.00" fill="#666666">[varchar(5)]</text>
<text text-anchor="start" x="184.5294" y="-414.4" font-family="Arial" font-size="14.00" fill="#000000"> 言語</text>
<polygon fill="none" stroke="#000000" points="44.5,-373 44.5,-403 526.5,-403 526.5,-373 44.5,-373"/>
<text text-anchor="start" x="51.5" y="-384.4" font-family="Arial" font-size="14.00" fill="#000000">auth_source_id </text>
<text text-anchor="start" x="151.0918" y="-384.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<polygon fill="none" stroke="#000000" points="44.5,-343 44.5,-373 526.5,-373 526.5,-343 44.5,-343"/>
<text text-anchor="start" x="51.5" y="-354.4" font-family="Arial" font-size="14.00" fill="#000000">created_on </text>
<text text-anchor="start" x="125.42" y="-354.4" font-family="Arial" font-size="14.00" fill="#666666">[timestamp]</text>
<polygon fill="none" stroke="#000000" points="44.5,-313 44.5,-343 526.5,-343 526.5,-313 44.5,-313"/>
<text text-anchor="start" x="51.5" y="-324.4" font-family="Arial" font-size="14.00" fill="#000000">updated_on </text>
<text text-anchor="start" x="129.3246" y="-324.4" font-family="Arial" font-size="14.00" fill="#666666">[timestamp]</text>
<polygon fill="none" stroke="#000000" points="44.5,-283 44.5,-313 526.5,-313 526.5,-283 44.5,-283"/>
<text text-anchor="start" x="51.5" y="-294.4" font-family="Arial" font-size="14.00" fill="#000000">type </text>
<text text-anchor="start" x="81.8464" y="-294.4" font-family="Arial" font-size="14.00" fill="#666666">[varchar(255)]</text>
<text text-anchor="start" x="168.9656" y="-294.4" font-family="Arial" font-size="14.00" fill="#000000"> User:ユーザー Group:グループ </text>
<polygon fill="none" stroke="#000000" points="44.5,-253 44.5,-283 526.5,-283 526.5,-253 44.5,-253"/>
<text text-anchor="start" x="51.5" y="-264.4" font-family="Arial" font-size="14.00" fill="#000000">mail_notification </text>
<text text-anchor="start" x="155.7342" y="-264.4" font-family="Arial" font-size="14.00" fill="#666666">[varchar(255)]</text>
<text text-anchor="start" x="242.8534" y="-264.4" font-family="Arial" font-size="14.00" fill="#000000"> メール通知</text>
<polygon fill="none" stroke="#000000" points="44.5,-223 44.5,-253 526.5,-253 526.5,-223 44.5,-223"/>
<text text-anchor="start" x="51.5" y="-234.4" font-family="Arial" font-size="14.00" fill="#000000">salt </text>
<text text-anchor="start" x="77.1704" y="-234.4" font-family="Arial" font-size="14.00" fill="#666666">[varchar(64)]</text>
<polygon fill="none" stroke="#000000" points="44.5,-193 44.5,-223 526.5,-223 526.5,-193 44.5,-193"/>
<text text-anchor="start" x="51.2646" y="-204.4" font-family="Arial" font-size="14.00" fill="#000000">must_change_passwd </text>
<text text-anchor="start" x="194.4216" y="-204.4" font-family="Arial" font-size="14.00" fill="#666666">[tinyint(1)]</text>
<text text-anchor="start" x="255.8662" y="-204.4" font-family="Arial" font-size="14.00" fill="#000000"> 次回ログイン時にパスワード変更を強制</text>
<polygon fill="none" stroke="#000000" points="44.5,-163 44.5,-193 526.5,-193 526.5,-163 44.5,-163"/>
<text text-anchor="start" x="51.5" y="-174.4" font-family="Arial" font-size="14.00" fill="#000000">passwd_changed_on </text>
<text text-anchor="start" x="187.671" y="-174.4" font-family="Arial" font-size="14.00" fill="#666666">[datetime]</text>
<polygon fill="none" stroke="#000000" points="44.5,-133 44.5,-163 526.5,-163 526.5,-133 44.5,-133"/>
<text text-anchor="start" x="51.5" y="-144.4" font-family="Arial" font-size="14.00" fill="#000000">twofa_scheme </text>
<text text-anchor="start" x="145.6346" y="-144.4" font-family="Arial" font-size="14.00" fill="#666666">[varchar(255)]</text>
<polygon fill="none" stroke="#000000" points="44.5,-103 44.5,-133 526.5,-133 526.5,-103 44.5,-103"/>
<text text-anchor="start" x="51.5" y="-114.4" font-family="Arial" font-size="14.00" fill="#000000">twofa_totp_key </text>
<text text-anchor="start" x="149.5378" y="-114.4" font-family="Arial" font-size="14.00" fill="#666666">[varchar(255)]</text>
<polygon fill="none" stroke="#000000" points="44.5,-73 44.5,-103 526.5,-103 526.5,-73 44.5,-73"/>
<text text-anchor="start" x="51.5" y="-84.4" font-family="Arial" font-size="14.00" fill="#000000">twofa_totp_last_used_at </text>
<text text-anchor="start" x="207.1212" y="-84.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<polygon fill="none" stroke="#000000" points="44.5,-43 44.5,-73 526.5,-73 526.5,-43 44.5,-43"/>
<text text-anchor="start" x="51.5" y="-54.4" font-family="Arial" font-size="14.00" fill="#000000">twofa_required </text>
<text text-anchor="start" x="147.967" y="-54.4" font-family="Arial" font-size="14.00" fill="#666666">[tinyint(1)]</text>
</g>
<!-- journals&#45;&gt;users -->
<g id="edge2" class="edge">
<title>journals:user_id&#45;&gt;users:id</title>
<path fill="none" stroke="#000000" stroke-dasharray="5,2" d="M533.7262,-948.1119C588.1906,-938.023 566.6458,-844.5102 523.5,-798 450.9036,-719.7428 117.0964,-840.2572 44.5,-762 13.0646,-728.1133 -1.7222,-658 44.5,-658"/>
<polygon fill="#000000" stroke="#000000" points="533.4625,-948.1347 523.1106,-944.5169 528.4813,-948.5674 523.5,-949 523.5,-949 523.5,-949 528.4813,-948.5674 523.8894,-953.4831 533.4625,-948.1347 533.4625,-948.1347"/>
<text text-anchor="start" x="530.768" y="-959" font-family="Arial" font-size="10.00" fill="#000000">Detected Relation</text>
</g>
<!-- journal_details -->
<g id="node2" class="node">
<title>journal_details</title>
<polygon fill="#efefef" stroke="transparent" points="98.5,-1405 98.5,-1451 472.5,-1451 472.5,-1405 98.5,-1405"/>
<polygon fill="none" stroke="#000000" points="98.5,-1405 98.5,-1451 472.5,-1451 472.5,-1405 98.5,-1405"/>
<text text-anchor="start" x="178.8627" y="-1428.8" font-family="Arial Bold" font-size="18.00" fill="#000000">journal_details</text>
<text text-anchor="start" x="294.8835" y="-1428.8" font-family="Arial" font-size="14.00" fill="#000000"> </text>
<text text-anchor="start" x="298.7741" y="-1428.8" font-family="Arial" font-size="14.00" fill="#666666">[BASE TABLE]</text>
<text text-anchor="start" x="229.591" y="-1414.4" font-family="Arial" font-size="14.00" fill="#333333">ジャーナル詳細</text>
<polygon fill="none" stroke="#000000" points="98.5,-1375 98.5,-1405 472.5,-1405 472.5,-1375 98.5,-1375"/>
<text text-anchor="start" x="105.5" y="-1386.4" font-family="Arial" font-size="14.00" fill="#000000">id </text>
<text text-anchor="start" x="120.2798" y="-1386.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<polygon fill="none" stroke="#000000" points="98.5,-1345 98.5,-1375 472.5,-1375 472.5,-1345 98.5,-1345"/>
<text text-anchor="start" x="105.5" y="-1356.4" font-family="Arial" font-size="14.00" fill="#000000">journal_id </text>
<text text-anchor="start" x="170.0666" y="-1356.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<text text-anchor="start" x="217.514" y="-1356.4" font-family="Arial" font-size="14.00" fill="#000000"> ジャーナルID</text>
<polygon fill="none" stroke="#000000" points="98.5,-1315 98.5,-1345 472.5,-1345 472.5,-1315 98.5,-1315"/>
<text text-anchor="start" x="105.4397" y="-1326.4" font-family="Arial" font-size="14.00" fill="#000000">property </text>
<text text-anchor="start" x="160.6725" y="-1326.4" font-family="Arial" font-size="14.00" fill="#666666">[varchar(30)]</text>
<text text-anchor="start" x="240.0091" y="-1326.4" font-family="Arial" font-size="14.00" fill="#000000"> attr:属性 cf:カスタムフィールド </text>
<polygon fill="none" stroke="#000000" points="98.5,-1285 98.5,-1315 472.5,-1315 472.5,-1285 98.5,-1285"/>
<text text-anchor="start" x="105.5" y="-1296.4" font-family="Arial" font-size="14.00" fill="#000000">prop_key </text>
<text text-anchor="start" x="166.9642" y="-1296.4" font-family="Arial" font-size="14.00" fill="#666666">[varchar(30)]</text>
<text text-anchor="start" x="246.3008" y="-1296.4" font-family="Arial" font-size="14.00" fill="#000000"> 項目</text>
<polygon fill="none" stroke="#000000" points="98.5,-1255 98.5,-1285 472.5,-1285 472.5,-1255 98.5,-1255"/>
<text text-anchor="start" x="105.5" y="-1266.4" font-family="Arial" font-size="14.00" fill="#000000">old_value </text>
<text text-anchor="start" x="169.2994" y="-1266.4" font-family="Arial" font-size="14.00" fill="#666666">[longtext]</text>
<text text-anchor="start" x="226.0988" y="-1266.4" font-family="Arial" font-size="14.00" fill="#000000"> 変更前の値</text>
<polygon fill="none" stroke="#000000" points="98.5,-1225 98.5,-1255 472.5,-1255 472.5,-1225 98.5,-1225"/>
<text text-anchor="start" x="105.5" y="-1236.4" font-family="Arial" font-size="14.00" fill="#000000">value </text>
<text text-anchor="start" x="142.845" y="-1236.4" font-family="Arial" font-size="14.00" fill="#666666">[longtext]</text>
<text text-anchor="start" x="199.6444" y="-1236.4" font-family="Arial" font-size="14.00" fill="#000000"> 変更後の値</text>
</g>
<!-- journal_details&#45;&gt;journals -->
<g id="edge1" class="edge">
<title>journal_details:journal_id&#45;&gt;journals:id</title>
<path fill="none" stroke="#000000" stroke-dasharray="5,2" d="M88.4654,-1359.2915C21.7438,-1349.3656 47.3773,-1237.6361 98.5,-1182 162.6307,-1112.2074 459.3693,-1215.7926 523.5,-1146 555.6765,-1110.9828 571.0556,-1039 523.5,-1039"/>
<polygon fill="#000000" stroke="#000000" points="88.5248,-1359.2956 98.183,-1364.4888 93.5124,-1359.6478 98.5,-1360 98.5,-1360 98.5,-1360 93.5124,-1359.6478 98.817,-1355.5112 88.5248,-1359.2956 88.5248,-1359.2956"/>
<text text-anchor="start" x="12.768" y="-1370" font-family="Arial" font-size="10.00" fill="#000000">Detected Relation</text>
</g>
</g>
</svg>