roles_managed_roles.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: roles_managed_roles Pages: 1 -->
<svg width="621pt" height="704pt"
 viewBox="0.00 0.00 620.64 704.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 700)">
<title>roles_managed_roles</title>
<polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-700 616.642,-700 616.642,4 -4,4"/>
<!-- roles_managed_roles -->
<g id="node1" class="node">
<title>roles_managed_roles</title>
<polygon fill="#efefef" stroke="transparent" points="148.142,-604 148.142,-650 471.142,-650 471.142,-604 148.142,-604"/>
<polygon fill="none" stroke="#000000" points="148.142,-604 148.142,-650 471.142,-650 471.142,-604 148.142,-604"/>
<text text-anchor="start" x="174.4954" y="-627.8" font-family="Arial Bold" font-size="18.00" fill="#000000">roles_managed_roles</text>
<text text-anchor="start" x="347.5348" y="-627.8" font-family="Arial" font-size="14.00" fill="#000000"> </text>
<text text-anchor="start" x="351.4254" y="-627.8" font-family="Arial" font-size="14.00" fill="#666666">[BASE TABLE]</text>
<text text-anchor="start" x="184.055" y="-613.4" font-family="Arial" font-size="14.00" fill="#333333">メンバーの管理(管理対象のロール)</text>
<polygon fill="none" stroke="#000000" points="148.142,-574 148.142,-604 471.142,-604 471.142,-574 148.142,-574"/>
<text text-anchor="start" x="155.142" y="-585.4" font-family="Arial" font-size="14.00" fill="#000000">role_id </text>
<text text-anchor="start" x="201.0368" y="-585.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<text text-anchor="start" x="248.4842" y="-585.4" font-family="Arial" font-size="14.00" fill="#000000"> ロールID</text>
<polygon fill="none" stroke="#000000" points="148.142,-544 148.142,-574 471.142,-574 471.142,-544 148.142,-544"/>
<text text-anchor="start" x="154.9826" y="-555.4" font-family="Arial" font-size="14.00" fill="#000000">managed_role_id </text>
<text text-anchor="start" x="267.0162" y="-555.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<text text-anchor="start" x="314.4636" y="-555.4" font-family="Arial" font-size="14.00" fill="#000000"> 管理対象のロールID</text>
<polygon fill="none" stroke="#000000" stroke-width="3" points="146.142,-542.5 146.142,-651.5 472.142,-651.5 472.142,-542.5 146.142,-542.5"/>
</g>
<!-- roles -->
<g id="node2" class="node">
<title>roles</title>
<polygon fill="#efefef" stroke="transparent" points="49.142,-373 49.142,-419 570.142,-419 570.142,-373 49.142,-373"/>
<polygon fill="none" stroke="#000000" points="49.142,-373 49.142,-419 570.142,-419 570.142,-373 49.142,-373"/>
<text text-anchor="start" x="241.5157" y="-396.8" font-family="Arial Bold" font-size="18.00" fill="#000000">roles</text>
<text text-anchor="start" x="280.5145" y="-396.8" font-family="Arial" font-size="14.00" fill="#000000"> </text>
<text text-anchor="start" x="284.4051" y="-396.8" font-family="Arial" font-size="14.00" fill="#666666">[BASE TABLE]</text>
<text text-anchor="start" x="282.8166" y="-382.4" font-family="Arial" font-size="14.00" fill="#333333">ロール</text>
<polygon fill="none" stroke="#000000" points="49.142,-343 49.142,-373 570.142,-373 570.142,-343 49.142,-343"/>
<text text-anchor="start" x="56.142" y="-354.4" font-family="Arial" font-size="14.00" fill="#000000">id </text>
<text text-anchor="start" x="70.9218" y="-354.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<polygon fill="none" stroke="#000000" points="49.142,-313 49.142,-343 570.142,-343 570.142,-313 49.142,-313"/>
<text text-anchor="start" x="56.142" y="-324.4" font-family="Arial" font-size="14.00" fill="#000000">name </text>
<text text-anchor="start" x="95.041" y="-324.4" font-family="Arial" font-size="14.00" fill="#666666">[varchar(255)]</text>
<text text-anchor="start" x="182.1602" y="-324.4" font-family="Arial" font-size="14.00" fill="#000000"> 名称</text>
<polygon fill="none" stroke="#000000" points="49.142,-283 49.142,-313 570.142,-313 570.142,-283 49.142,-283"/>
<text text-anchor="start" x="56.142" y="-294.4" font-family="Arial" font-size="14.00" fill="#000000">position </text>
<text text-anchor="start" x="108.2668" y="-294.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<text text-anchor="start" x="155.7142" y="-294.4" font-family="Arial" font-size="14.00" fill="#000000"> 並び順</text>
<polygon fill="none" stroke="#000000" points="49.142,-253 49.142,-283 570.142,-283 570.142,-253 49.142,-253"/>
<text text-anchor="start" x="55.8353" y="-264.4" font-family="Arial" font-size="14.00" fill="#000000">assignable </text>
<text text-anchor="start" x="126.6347" y="-264.4" font-family="Arial" font-size="14.00" fill="#666666">[tinyint(1)]</text>
<text text-anchor="start" x="188.0793" y="-264.4" font-family="Arial" font-size="14.00" fill="#000000"> このロールのユーザーにチケットを割り当て可能</text>
<polygon fill="none" stroke="#000000" points="49.142,-223 49.142,-253 570.142,-253 570.142,-223 49.142,-223"/>
<text text-anchor="start" x="56.142" y="-234.4" font-family="Arial" font-size="14.00" fill="#000000">builtin </text>
<text text-anchor="start" x="96.5908" y="-234.4" font-family="Arial" font-size="14.00" fill="#666666">[int(11)]</text>
<text text-anchor="start" x="144.0382" y="-234.4" font-family="Arial" font-size="14.00" fill="#000000"> 1:非メンバー 2:匿名ユーザー 0:それ以外 </text>
<polygon fill="none" stroke="#000000" points="49.142,-193 49.142,-223 570.142,-223 570.142,-193 49.142,-193"/>
<text text-anchor="start" x="56.142" y="-204.4" font-family="Arial" font-size="14.00" fill="#000000">permissions </text>
<text text-anchor="start" x="134.6974" y="-204.4" font-family="Arial" font-size="14.00" fill="#666666">[text]</text>
<text text-anchor="start" x="165.0424" y="-204.4" font-family="Arial" font-size="14.00" fill="#000000"> 権限</text>
<polygon fill="none" stroke="#000000" points="49.142,-163 49.142,-193 570.142,-193 570.142,-163 49.142,-163"/>
<text text-anchor="start" x="56.142" y="-174.4" font-family="Arial" font-size="14.00" fill="#000000">issues_visibility </text>
<text text-anchor="start" x="155.6932" y="-174.4" font-family="Arial" font-size="14.00" fill="#666666">[varchar(30)]</text>
<text text-anchor="start" x="235.0298" y="-174.4" font-family="Arial" font-size="14.00" fill="#000000"> 表示できるチケット</text>
<polygon fill="none" stroke="#000000" points="49.142,-133 49.142,-163 570.142,-163 570.142,-133 49.142,-133"/>
<text text-anchor="start" x="56.142" y="-144.4" font-family="Arial" font-size="14.00" fill="#000000">users_visibility </text>
<text text-anchor="start" x="150.2472" y="-144.4" font-family="Arial" font-size="14.00" fill="#666666">[varchar(30)]</text>
<text text-anchor="start" x="229.5838" y="-144.4" font-family="Arial" font-size="14.00" fill="#000000"> 表示できるユーザー</text>
<polygon fill="none" stroke="#000000" points="49.142,-103 49.142,-133 570.142,-133 570.142,-103 49.142,-103"/>
<text text-anchor="start" x="56.142" y="-114.4" font-family="Arial" font-size="14.00" fill="#000000">time_entries_visibility </text>
<text text-anchor="start" x="192.25" y="-114.4" font-family="Arial" font-size="14.00" fill="#666666">[varchar(30)]</text>
<text text-anchor="start" x="271.5866" y="-114.4" font-family="Arial" font-size="14.00" fill="#000000"> 表示できる作業時間</text>
<polygon fill="none" stroke="#000000" points="49.142,-73 49.142,-103 570.142,-103 570.142,-73 49.142,-73"/>
<text text-anchor="start" x="56.142" y="-84.4" font-family="Arial" font-size="14.00" fill="#000000">all_roles_managed </text>
<text text-anchor="start" x="178.2822" y="-84.4" font-family="Arial" font-size="14.00" fill="#666666">[tinyint(1)]</text>
<text text-anchor="start" x="239.7268" y="-84.4" font-family="Arial" font-size="14.00" fill="#000000"> メンバーの管理(すべてのロール)</text>
<polygon fill="none" stroke="#000000" points="49.142,-43 49.142,-73 570.142,-73 570.142,-43 49.142,-43"/>
<text text-anchor="start" x="56.142" y="-54.4" font-family="Arial" font-size="14.00" fill="#000000">settings </text>
<text text-anchor="start" x="108.2682" y="-54.4" font-family="Arial" font-size="14.00" fill="#666666">[text]</text>
</g>
<!-- roles_managed_roles&#45;&gt;roles -->
<g id="edge1" class="edge">
<title>roles_managed_roles:role_id&#45;&gt;roles:id</title>
<path fill="none" stroke="#000000" stroke-dasharray="5,2" d="M138.038,-588.3777C30.643,-575.2254 -59.1745,-358 49.142,-358"/>
<polygon fill="#000000" stroke="#000000" points="138.1609,-588.3852 147.8653,-593.4915 143.1515,-588.6926 148.142,-589 148.142,-589 148.142,-589 143.1515,-588.6926 148.4187,-584.5085 138.1609,-588.3852 138.1609,-588.3852"/>
<text text-anchor="start" x="58.4665" y="-599" font-family="Arial" font-size="10.00" fill="#000000">Additional Relation</text>
</g>
<!-- roles_managed_roles&#45;&gt;roles -->
<g id="edge2" class="edge">
<title>roles_managed_roles:managed_role_id&#45;&gt;roles:id</title>
<path fill="none" stroke="#000000" stroke-dasharray="5,2" d="M309.6629,-533.9683C299.1652,-430.2705 118.9818,-557.1474 49.142,-462 21.7913,-424.7383 2.9198,-358 49.142,-358"/>
<polygon fill="#000000" stroke="#000000" points="309.6649,-534.0114 305.6471,-544.2147 309.9035,-539.0057 310.142,-544 310.142,-544 310.142,-544 309.9035,-539.0057 314.6369,-543.7853 309.6649,-534.0114 309.6649,-534.0114"/>
<text text-anchor="start" x="293.2165" y="-528" font-family="Arial" font-size="10.00" fill="#000000">Additional Relation</text>
</g>
</g>
</svg>