tokens.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: tokens Pages: 1 -->
<svg width="747pt" height="1124pt"
 viewBox="0.00 0.00 746.50 1124.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 1120)">
<title>tokens</title>
<polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-1120 742.5,-1120 742.5,4 -4,4"/>
<!-- tokens -->
<g id="node1" class="node">
<title>tokens</title>
<polygon fill="#efefef" stroke="transparent" points="46.5,-1024 46.5,-1070 641.5,-1070 641.5,-1024 46.5,-1024"/>
<polygon fill="none" stroke="#000000" points="46.5,-1024 46.5,-1070 641.5,-1070 641.5,-1024 46.5,-1024"/>
<text text-anchor="start" x="268.8627" y="-1047.8" font-family="Arial Bold" font-size="18.00" fill="#000000">tokens</text>
<text text-anchor="start" x="321.8835" y="-1047.8" font-family="Arial" font-size="14.00" fill="#000000"> </text>
<text text-anchor="start" x="325.7741" y="-1047.8" font-family="Arial" font-size="14.00" fill="#666666">[BASE TABLE]</text>
<text text-anchor="start" x="294.3525" y="-1033.4" font-family="Arial" font-size="14.00" fill="#333333">各種トークン</text>
<polygon fill="none" stroke="#000000" points="46.5,-994 46.5,-1024 641.5,-1024 641.5,-994 46.5,-994"/>
<text text-anchor="start" x="53.5" y="-1005.4" font-family="Arial" font-size="14.00" fill="#000000">id </text>
<text text-anchor="start" x="68.2798" 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 641.5,-994 641.5,-964 46.5,-964"/>
<text text-anchor="start" x="53.5" y="-975.4" font-family="Arial" font-size="14.00" fill="#000000">user_id </text>
<text text-anchor="start" x="103.2882" y="-975.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<polygon fill="none" stroke="#000000" points="46.5,-934 46.5,-964 641.5,-964 641.5,-934 46.5,-934"/>
<text text-anchor="start" x="53.2543" y="-945.4" font-family="Arial" font-size="14.00" fill="#000000">action </text>
<text text-anchor="start" x="94.4899" y="-945.4" font-family="Arial" font-size="14.00" fill="#666666">[varchar(30)]</text>
<text text-anchor="start" x="173.8265" y="-945.4" font-family="Arial" font-size="14.00" fill="#000000"> session:セッション api:APIアクセスキー feeds:Atomアクセスキー </text>
<polygon fill="none" stroke="#000000" points="46.5,-904 46.5,-934 641.5,-934 641.5,-904 46.5,-904"/>
<text text-anchor="start" x="53.5" y="-915.4" font-family="Arial" font-size="14.00" fill="#000000">value </text>
<text text-anchor="start" x="90.845" y="-915.4" font-family="Arial" font-size="14.00" fill="#666666">[varchar(40)]</text>
<text text-anchor="start" x="170.1816" y="-915.4" font-family="Arial" font-size="14.00" fill="#000000"> トークン</text>
<polygon fill="none" stroke="#000000" points="46.5,-874 46.5,-904 641.5,-904 641.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 641.5,-874 641.5,-844 46.5,-844"/>
<text text-anchor="start" x="53.5" y="-855.4" font-family="Arial" font-size="14.00" fill="#000000">updated_on </text>
<text text-anchor="start" x="131.3246" y="-855.4" font-family="Arial" font-size="14.00" fill="#666666">[timestamp]</text>
<polygon fill="none" stroke="#000000" stroke-width="3" points="44.5,-842.5 44.5,-1071.5 642.5,-1071.5 642.5,-842.5 44.5,-842.5"/>
</g>
<!-- users -->
<g id="node2" class="node">
<title>users</title>
<polygon fill="#efefef" stroke="transparent" points="103.5,-673 103.5,-719 585.5,-719 585.5,-673 103.5,-673"/>
<polygon fill="none" stroke="#000000" points="103.5,-673 103.5,-719 585.5,-719 585.5,-673 103.5,-673"/>
<text text-anchor="start" x="273.8708" y="-696.8" font-family="Arial Bold" font-size="18.00" fill="#000000">users</text>
<text text-anchor="start" x="317.8754" y="-696.8" font-family="Arial" font-size="14.00" fill="#000000"> </text>
<text text-anchor="start" x="321.766" y="-696.8" font-family="Arial" font-size="14.00" fill="#666666">[BASE TABLE]</text>
<text text-anchor="start" x="265.9558" y="-682.4" font-family="Arial" font-size="14.00" fill="#333333">ユーザー / グループ</text>
<polygon fill="none" stroke="#000000" points="103.5,-643 103.5,-673 585.5,-673 585.5,-643 103.5,-643"/>
<text text-anchor="start" x="110.5" y="-654.4" font-family="Arial" font-size="14.00" fill="#000000">id </text>
<text text-anchor="start" x="125.2798" y="-654.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<polygon fill="none" stroke="#000000" points="103.5,-613 103.5,-643 585.5,-643 585.5,-613 103.5,-613"/>
<text text-anchor="start" x="110.5" y="-624.4" font-family="Arial" font-size="14.00" fill="#000000">login </text>
<text text-anchor="start" x="143.9516" y="-624.4" font-family="Arial" font-size="14.00" fill="#666666">[varchar(255)]</text>
<text text-anchor="start" x="231.0708" y="-624.4" font-family="Arial" font-size="14.00" fill="#000000"> ログインID</text>
<polygon fill="none" stroke="#000000" points="103.5,-583 103.5,-613 585.5,-613 585.5,-583 103.5,-583"/>
<text text-anchor="start" x="110.5" y="-594.4" font-family="Arial" font-size="14.00" fill="#000000">hashed_password </text>
<text text-anchor="start" x="227.9838" y="-594.4" font-family="Arial" font-size="14.00" fill="#666666">[varchar(40)]</text>
<text text-anchor="start" x="307.3204" y="-594.4" font-family="Arial" font-size="14.00" fill="#000000"> パスワード(ハッシュ化済み)</text>
<polygon fill="none" stroke="#000000" points="103.5,-553 103.5,-583 585.5,-583 585.5,-553 103.5,-553"/>
<text text-anchor="start" x="110.5" y="-564.4" font-family="Arial" font-size="14.00" fill="#000000">firstname </text>
<text text-anchor="start" x="171.9474" y="-564.4" font-family="Arial" font-size="14.00" fill="#666666">[varchar(30)]</text>
<text text-anchor="start" x="251.284" y="-564.4" font-family="Arial" font-size="14.00" fill="#000000"> 名</text>
<polygon fill="none" stroke="#000000" points="103.5,-523 103.5,-553 585.5,-553 585.5,-523 103.5,-523"/>
<text text-anchor="start" x="110.5" y="-534.4" font-family="Arial" font-size="14.00" fill="#000000">lastname </text>
<text text-anchor="start" x="171.1788" y="-534.4" font-family="Arial" font-size="14.00" fill="#666666">[varchar(255)]</text>
<text text-anchor="start" x="258.298" y="-534.4" font-family="Arial" font-size="14.00" fill="#000000"> 姓</text>
<polygon fill="none" stroke="#000000" points="103.5,-493 103.5,-523 585.5,-523 585.5,-493 103.5,-493"/>
<text text-anchor="start" x="110.5" y="-504.4" font-family="Arial" font-size="14.00" fill="#000000">admin </text>
<text text-anchor="start" x="152.5056" y="-504.4" font-family="Arial" font-size="14.00" fill="#666666">[tinyint(1)]</text>
<text text-anchor="start" x="213.9502" y="-504.4" font-family="Arial" font-size="14.00" fill="#000000"> システム管理者</text>
<polygon fill="none" stroke="#000000" points="103.5,-463 103.5,-493 585.5,-493 585.5,-463 103.5,-463"/>
<text text-anchor="start" x="110.5" y="-474.4" font-family="Arial" font-size="14.00" fill="#000000">status </text>
<text text-anchor="start" x="151.737" y="-474.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<polygon fill="none" stroke="#000000" points="103.5,-433 103.5,-463 585.5,-463 585.5,-433 103.5,-433"/>
<text text-anchor="start" x="110.5" y="-444.4" font-family="Arial" font-size="14.00" fill="#000000">last_login_on </text>
<text text-anchor="start" x="196.8618" y="-444.4" font-family="Arial" font-size="14.00" fill="#666666">[datetime]</text>
<polygon fill="none" stroke="#000000" points="103.5,-403 103.5,-433 585.5,-433 585.5,-403 103.5,-403"/>
<text text-anchor="start" x="110.5" y="-414.4" font-family="Arial" font-size="14.00" fill="#000000">language </text>
<text text-anchor="start" x="171.9754" y="-414.4" font-family="Arial" font-size="14.00" fill="#666666">[varchar(5)]</text>
<text text-anchor="start" x="243.5294" y="-414.4" font-family="Arial" font-size="14.00" fill="#000000"> 言語</text>
<polygon fill="none" stroke="#000000" points="103.5,-373 103.5,-403 585.5,-403 585.5,-373 103.5,-373"/>
<text text-anchor="start" x="110.5" y="-384.4" font-family="Arial" font-size="14.00" fill="#000000">auth_source_id </text>
<text text-anchor="start" x="210.0918" y="-384.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<polygon fill="none" stroke="#000000" points="103.5,-343 103.5,-373 585.5,-373 585.5,-343 103.5,-343"/>
<text text-anchor="start" x="110.5" y="-354.4" font-family="Arial" font-size="14.00" fill="#000000">created_on </text>
<text text-anchor="start" x="184.42" y="-354.4" font-family="Arial" font-size="14.00" fill="#666666">[timestamp]</text>
<polygon fill="none" stroke="#000000" points="103.5,-313 103.5,-343 585.5,-343 585.5,-313 103.5,-313"/>
<text text-anchor="start" x="110.5" y="-324.4" font-family="Arial" font-size="14.00" fill="#000000">updated_on </text>
<text text-anchor="start" x="188.3246" y="-324.4" font-family="Arial" font-size="14.00" fill="#666666">[timestamp]</text>
<polygon fill="none" stroke="#000000" points="103.5,-283 103.5,-313 585.5,-313 585.5,-283 103.5,-283"/>
<text text-anchor="start" x="110.5" y="-294.4" font-family="Arial" font-size="14.00" fill="#000000">type </text>
<text text-anchor="start" x="140.8464" y="-294.4" font-family="Arial" font-size="14.00" fill="#666666">[varchar(255)]</text>
<text text-anchor="start" x="227.9656" y="-294.4" font-family="Arial" font-size="14.00" fill="#000000"> User:ユーザー Group:グループ </text>
<polygon fill="none" stroke="#000000" points="103.5,-253 103.5,-283 585.5,-283 585.5,-253 103.5,-253"/>
<text text-anchor="start" x="110.5" y="-264.4" font-family="Arial" font-size="14.00" fill="#000000">mail_notification </text>
<text text-anchor="start" x="214.7342" y="-264.4" font-family="Arial" font-size="14.00" fill="#666666">[varchar(255)]</text>
<text text-anchor="start" x="301.8534" y="-264.4" font-family="Arial" font-size="14.00" fill="#000000"> メール通知</text>
<polygon fill="none" stroke="#000000" points="103.5,-223 103.5,-253 585.5,-253 585.5,-223 103.5,-223"/>
<text text-anchor="start" x="110.5" y="-234.4" font-family="Arial" font-size="14.00" fill="#000000">salt </text>
<text text-anchor="start" x="136.1704" y="-234.4" font-family="Arial" font-size="14.00" fill="#666666">[varchar(64)]</text>
<polygon fill="none" stroke="#000000" points="103.5,-193 103.5,-223 585.5,-223 585.5,-193 103.5,-193"/>
<text text-anchor="start" x="110.2646" y="-204.4" font-family="Arial" font-size="14.00" fill="#000000">must_change_passwd </text>
<text text-anchor="start" x="253.4216" y="-204.4" font-family="Arial" font-size="14.00" fill="#666666">[tinyint(1)]</text>
<text text-anchor="start" x="314.8662" y="-204.4" font-family="Arial" font-size="14.00" fill="#000000"> 次回ログイン時にパスワード変更を強制</text>
<polygon fill="none" stroke="#000000" points="103.5,-163 103.5,-193 585.5,-193 585.5,-163 103.5,-163"/>
<text text-anchor="start" x="110.5" y="-174.4" font-family="Arial" font-size="14.00" fill="#000000">passwd_changed_on </text>
<text text-anchor="start" x="246.671" y="-174.4" font-family="Arial" font-size="14.00" fill="#666666">[datetime]</text>
<polygon fill="none" stroke="#000000" points="103.5,-133 103.5,-163 585.5,-163 585.5,-133 103.5,-133"/>
<text text-anchor="start" x="110.5" y="-144.4" font-family="Arial" font-size="14.00" fill="#000000">twofa_scheme </text>
<text text-anchor="start" x="204.6346" y="-144.4" font-family="Arial" font-size="14.00" fill="#666666">[varchar(255)]</text>
<polygon fill="none" stroke="#000000" points="103.5,-103 103.5,-133 585.5,-133 585.5,-103 103.5,-103"/>
<text text-anchor="start" x="110.5" y="-114.4" font-family="Arial" font-size="14.00" fill="#000000">twofa_totp_key </text>
<text text-anchor="start" x="208.5378" y="-114.4" font-family="Arial" font-size="14.00" fill="#666666">[varchar(255)]</text>
<polygon fill="none" stroke="#000000" points="103.5,-73 103.5,-103 585.5,-103 585.5,-73 103.5,-73"/>
<text text-anchor="start" x="110.5" y="-84.4" font-family="Arial" font-size="14.00" fill="#000000">twofa_totp_last_used_at </text>
<text text-anchor="start" x="266.1212" y="-84.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<polygon fill="none" stroke="#000000" points="103.5,-43 103.5,-73 585.5,-73 585.5,-43 103.5,-43"/>
<text text-anchor="start" x="110.5" y="-54.4" font-family="Arial" font-size="14.00" fill="#000000">twofa_required </text>
<text text-anchor="start" x="206.967" y="-54.4" font-family="Arial" font-size="14.00" fill="#666666">[tinyint(1)]</text>
</g>
<!-- tokens&#45;&gt;users -->
<g id="edge1" class="edge">
<title>tokens:user_id&#45;&gt;users:id</title>
<path fill="none" stroke="#000000" stroke-dasharray="5,2" d="M651.7067,-978.2768C719.5946,-968.1448 693.9826,-854.1118 641.5,-798 559.6497,-710.4897 185.3503,-849.5103 103.5,-762 71.9259,-728.2425 57.2778,-658 103.5,-658"/>
<polygon fill="#000000" stroke="#000000" points="651.475,-978.2931 641.1819,-974.5113 646.4875,-978.6465 641.5,-979 641.5,-979 641.5,-979 646.4875,-978.6465 641.8181,-983.4887 651.475,-978.2931 651.475,-978.2931"/>
<text text-anchor="start" x="648.8245" y="-989" font-family="Arial" font-size="10.00" fill="#000000">Additional Relation</text>
</g>
</g>
</svg>