groups_users.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: groups_users Pages: 1 -->
<svg width="580pt" height="1004pt"
 viewBox="0.00 0.00 579.52 1004.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 1000)">
<title>groups_users</title>
<polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-1000 575.518,-1000 575.518,4 -4,4"/>
<!-- groups_users -->
<g id="node1" class="node">
<title>groups_users</title>
<polygon fill="#efefef" stroke="transparent" points="174,-904 174,-950 394,-950 394,-904 174,-904"/>
<polygon fill="none" stroke="#000000" points="174,-904 174,-950 394,-950 394,-904 174,-904"/>
<text text-anchor="start" x="180.8592" y="-927.8" font-family="Arial Bold" font-size="18.00" fill="#000000">groups_users</text>
<text text-anchor="start" x="289.887" y="-927.8" font-family="Arial" font-size="14.00" fill="#000000"> </text>
<text text-anchor="start" x="293.7776" y="-927.8" font-family="Arial" font-size="14.00" fill="#666666">[BASE TABLE]</text>
<text text-anchor="start" x="205.4558" y="-913.4" font-family="Arial" font-size="14.00" fill="#333333">グループ⇔ユーザー</text>
<polygon fill="none" stroke="#000000" points="174,-874 174,-904 394,-904 394,-874 174,-874"/>
<text text-anchor="start" x="181" y="-885.4" font-family="Arial" font-size="14.00" fill="#000000">group_id </text>
<text text-anchor="start" x="239.3534" y="-885.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<polygon fill="none" stroke="#000000" points="174,-844 174,-874 394,-874 394,-844 174,-844"/>
<text text-anchor="start" x="181" y="-855.4" font-family="Arial" font-size="14.00" fill="#000000">user_id </text>
<text text-anchor="start" x="230.7882" y="-855.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<polygon fill="none" stroke="#000000" stroke-width="3" points="172.5,-842.5 172.5,-951.5 395.5,-951.5 395.5,-842.5 172.5,-842.5"/>
</g>
<!-- users -->
<g id="node2" class="node">
<title>users</title>
<polygon fill="#efefef" stroke="transparent" points="43,-673 43,-719 525,-719 525,-673 43,-673"/>
<polygon fill="none" stroke="#000000" points="43,-673 43,-719 525,-719 525,-673 43,-673"/>
<text text-anchor="start" x="213.3708" y="-696.8" font-family="Arial Bold" font-size="18.00" fill="#000000">users</text>
<text text-anchor="start" x="257.3754" y="-696.8" font-family="Arial" font-size="14.00" fill="#000000"> </text>
<text text-anchor="start" x="261.266" y="-696.8" font-family="Arial" font-size="14.00" fill="#666666">[BASE TABLE]</text>
<text text-anchor="start" x="205.4558" y="-682.4" font-family="Arial" font-size="14.00" fill="#333333">ユーザー / グループ</text>
<polygon fill="none" stroke="#000000" points="43,-643 43,-673 525,-673 525,-643 43,-643"/>
<text text-anchor="start" x="50" y="-654.4" font-family="Arial" font-size="14.00" fill="#000000">id </text>
<text text-anchor="start" x="64.7798" y="-654.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<polygon fill="none" stroke="#000000" points="43,-613 43,-643 525,-643 525,-613 43,-613"/>
<text text-anchor="start" x="50" y="-624.4" font-family="Arial" font-size="14.00" fill="#000000">login </text>
<text text-anchor="start" x="83.4516" y="-624.4" font-family="Arial" font-size="14.00" fill="#666666">[varchar(255)]</text>
<text text-anchor="start" x="170.5708" y="-624.4" font-family="Arial" font-size="14.00" fill="#000000"> ログインID</text>
<polygon fill="none" stroke="#000000" points="43,-583 43,-613 525,-613 525,-583 43,-583"/>
<text text-anchor="start" x="50" y="-594.4" font-family="Arial" font-size="14.00" fill="#000000">hashed_password </text>
<text text-anchor="start" x="167.4838" y="-594.4" font-family="Arial" font-size="14.00" fill="#666666">[varchar(40)]</text>
<text text-anchor="start" x="246.8204" y="-594.4" font-family="Arial" font-size="14.00" fill="#000000"> パスワード(ハッシュ化済み)</text>
<polygon fill="none" stroke="#000000" points="43,-553 43,-583 525,-583 525,-553 43,-553"/>
<text text-anchor="start" x="50" y="-564.4" font-family="Arial" font-size="14.00" fill="#000000">firstname </text>
<text text-anchor="start" x="111.4474" y="-564.4" font-family="Arial" font-size="14.00" fill="#666666">[varchar(30)]</text>
<text text-anchor="start" x="190.784" y="-564.4" font-family="Arial" font-size="14.00" fill="#000000"> 名</text>
<polygon fill="none" stroke="#000000" points="43,-523 43,-553 525,-553 525,-523 43,-523"/>
<text text-anchor="start" x="50" y="-534.4" font-family="Arial" font-size="14.00" fill="#000000">lastname </text>
<text text-anchor="start" x="110.6788" y="-534.4" font-family="Arial" font-size="14.00" fill="#666666">[varchar(255)]</text>
<text text-anchor="start" x="197.798" y="-534.4" font-family="Arial" font-size="14.00" fill="#000000"> 姓</text>
<polygon fill="none" stroke="#000000" points="43,-493 43,-523 525,-523 525,-493 43,-493"/>
<text text-anchor="start" x="50" y="-504.4" font-family="Arial" font-size="14.00" fill="#000000">admin </text>
<text text-anchor="start" x="92.0056" y="-504.4" font-family="Arial" font-size="14.00" fill="#666666">[tinyint(1)]</text>
<text text-anchor="start" x="153.4502" y="-504.4" font-family="Arial" font-size="14.00" fill="#000000"> システム管理者</text>
<polygon fill="none" stroke="#000000" points="43,-463 43,-493 525,-493 525,-463 43,-463"/>
<text text-anchor="start" x="50" y="-474.4" font-family="Arial" font-size="14.00" fill="#000000">status </text>
<text text-anchor="start" x="91.237" y="-474.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<polygon fill="none" stroke="#000000" points="43,-433 43,-463 525,-463 525,-433 43,-433"/>
<text text-anchor="start" x="50" y="-444.4" font-family="Arial" font-size="14.00" fill="#000000">last_login_on </text>
<text text-anchor="start" x="136.3618" y="-444.4" font-family="Arial" font-size="14.00" fill="#666666">[datetime]</text>
<polygon fill="none" stroke="#000000" points="43,-403 43,-433 525,-433 525,-403 43,-403"/>
<text text-anchor="start" x="50" y="-414.4" font-family="Arial" font-size="14.00" fill="#000000">language </text>
<text text-anchor="start" x="111.4754" y="-414.4" font-family="Arial" font-size="14.00" fill="#666666">[varchar(5)]</text>
<text text-anchor="start" x="183.0294" y="-414.4" font-family="Arial" font-size="14.00" fill="#000000"> 言語</text>
<polygon fill="none" stroke="#000000" points="43,-373 43,-403 525,-403 525,-373 43,-373"/>
<text text-anchor="start" x="50" y="-384.4" font-family="Arial" font-size="14.00" fill="#000000">auth_source_id </text>
<text text-anchor="start" x="149.5918" y="-384.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<polygon fill="none" stroke="#000000" points="43,-343 43,-373 525,-373 525,-343 43,-343"/>
<text text-anchor="start" x="50" y="-354.4" font-family="Arial" font-size="14.00" fill="#000000">created_on </text>
<text text-anchor="start" x="123.92" y="-354.4" font-family="Arial" font-size="14.00" fill="#666666">[timestamp]</text>
<polygon fill="none" stroke="#000000" points="43,-313 43,-343 525,-343 525,-313 43,-313"/>
<text text-anchor="start" x="50" y="-324.4" font-family="Arial" font-size="14.00" fill="#000000">updated_on </text>
<text text-anchor="start" x="127.8246" y="-324.4" font-family="Arial" font-size="14.00" fill="#666666">[timestamp]</text>
<polygon fill="none" stroke="#000000" points="43,-283 43,-313 525,-313 525,-283 43,-283"/>
<text text-anchor="start" x="50" y="-294.4" font-family="Arial" font-size="14.00" fill="#000000">type </text>
<text text-anchor="start" x="80.3464" y="-294.4" font-family="Arial" font-size="14.00" fill="#666666">[varchar(255)]</text>
<text text-anchor="start" x="167.4656" y="-294.4" font-family="Arial" font-size="14.00" fill="#000000"> User:ユーザー Group:グループ </text>
<polygon fill="none" stroke="#000000" points="43,-253 43,-283 525,-283 525,-253 43,-253"/>
<text text-anchor="start" x="50" y="-264.4" font-family="Arial" font-size="14.00" fill="#000000">mail_notification </text>
<text text-anchor="start" x="154.2342" y="-264.4" font-family="Arial" font-size="14.00" fill="#666666">[varchar(255)]</text>
<text text-anchor="start" x="241.3534" y="-264.4" font-family="Arial" font-size="14.00" fill="#000000"> メール通知</text>
<polygon fill="none" stroke="#000000" points="43,-223 43,-253 525,-253 525,-223 43,-223"/>
<text text-anchor="start" x="50" y="-234.4" font-family="Arial" font-size="14.00" fill="#000000">salt </text>
<text text-anchor="start" x="75.6704" y="-234.4" font-family="Arial" font-size="14.00" fill="#666666">[varchar(64)]</text>
<polygon fill="none" stroke="#000000" points="43,-193 43,-223 525,-223 525,-193 43,-193"/>
<text text-anchor="start" x="49.7646" y="-204.4" font-family="Arial" font-size="14.00" fill="#000000">must_change_passwd </text>
<text text-anchor="start" x="192.9216" y="-204.4" font-family="Arial" font-size="14.00" fill="#666666">[tinyint(1)]</text>
<text text-anchor="start" x="254.3662" y="-204.4" font-family="Arial" font-size="14.00" fill="#000000"> 次回ログイン時にパスワード変更を強制</text>
<polygon fill="none" stroke="#000000" points="43,-163 43,-193 525,-193 525,-163 43,-163"/>
<text text-anchor="start" x="50" y="-174.4" font-family="Arial" font-size="14.00" fill="#000000">passwd_changed_on </text>
<text text-anchor="start" x="186.171" y="-174.4" font-family="Arial" font-size="14.00" fill="#666666">[datetime]</text>
<polygon fill="none" stroke="#000000" points="43,-133 43,-163 525,-163 525,-133 43,-133"/>
<text text-anchor="start" x="50" y="-144.4" font-family="Arial" font-size="14.00" fill="#000000">twofa_scheme </text>
<text text-anchor="start" x="144.1346" y="-144.4" font-family="Arial" font-size="14.00" fill="#666666">[varchar(255)]</text>
<polygon fill="none" stroke="#000000" points="43,-103 43,-133 525,-133 525,-103 43,-103"/>
<text text-anchor="start" x="50" y="-114.4" font-family="Arial" font-size="14.00" fill="#000000">twofa_totp_key </text>
<text text-anchor="start" x="148.0378" y="-114.4" font-family="Arial" font-size="14.00" fill="#666666">[varchar(255)]</text>
<polygon fill="none" stroke="#000000" points="43,-73 43,-103 525,-103 525,-73 43,-73"/>
<text text-anchor="start" x="50" y="-84.4" font-family="Arial" font-size="14.00" fill="#000000">twofa_totp_last_used_at </text>
<text text-anchor="start" x="205.6212" y="-84.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<polygon fill="none" stroke="#000000" points="43,-43 43,-73 525,-73 525,-43 43,-43"/>
<text text-anchor="start" x="50" y="-54.4" font-family="Arial" font-size="14.00" fill="#000000">twofa_required </text>
<text text-anchor="start" x="146.467" y="-54.4" font-family="Arial" font-size="14.00" fill="#666666">[tinyint(1)]</text>
</g>
<!-- groups_users&#45;&gt;users -->
<g id="edge1" class="edge">
<title>groups_users:group_id&#45;&gt;users:id</title>
<path fill="none" stroke="#000000" stroke-dasharray="5,2" d="M404.0529,-888.4547C519.2468,-876.1013 639.684,-658 525,-658"/>
<polygon fill="#000000" stroke="#000000" points="403.9853,-888.4583 393.7562,-884.5066 398.9927,-888.7291 394,-889 394,-889 394,-889 398.9927,-888.7291 394.2438,-893.4934 403.9853,-888.4583 403.9853,-888.4583"/>
<text text-anchor="start" x="401.3245" y="-899" font-family="Arial" font-size="10.00" fill="#000000">Additional Relation</text>
</g>
<!-- groups_users&#45;&gt;users -->
<g id="edge2" class="edge">
<title>groups_users:user_id&#45;&gt;users:id</title>
<path fill="none" stroke="#000000" stroke-dasharray="5,2" d="M284.5361,-833.7826C295.1742,-738.5713 461.2531,-851.0256 525,-762 551.91,-724.4188 571.2222,-658 525,-658"/>
<polygon fill="#000000" stroke="#000000" points="284.5241,-834.0137 279.5062,-843.7642 284.262,-839.0069 284,-844 284,-844 284,-844 284.262,-839.0069 288.4938,-844.2358 284.5241,-834.0137 284.5241,-834.0137"/>
<text text-anchor="start" x="267.0745" y="-828" font-family="Arial" font-size="10.00" fill="#000000">Additional Relation</text>
</g>
</g>
</svg>