docs/sk_custom_reserve_items.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: sk_custom_reserve_items Pages: 1 -->
<svg width="659pt" height="1402pt"
 viewBox="0.00 0.00 659.00 1402.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 1398)">
<title>sk_custom_reserve_items</title>
<polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-1398 655,-1398 655,4 -4,4"/>
<!-- sk_custom_reserve_items -->
<g id="node1" class="node">
<title>sk_custom_reserve_items</title>
<polygon fill="#efefef" stroke="transparent" points="255,-1312.5 255,-1347.5 605,-1347.5 605,-1312.5 255,-1312.5"/>
<polygon fill="none" stroke="#000000" points="255,-1312.5 255,-1347.5 605,-1347.5 605,-1312.5 255,-1312.5"/>
<text text-anchor="start" x="261.7044" y="-1325.3" font-family="Arial Bold" font-size="18.00" fill="#000000">sk_custom_reserve_items</text>
<text text-anchor="start" x="470.7276" y="-1325.3" font-family="Arial" font-size="14.00" fill="#000000">    </text>
<text text-anchor="start" x="504.9324" y="-1325.3" font-family="Arial" font-size="14.00" fill="#666666">[BASE TABLE]</text>
<polygon fill="none" stroke="#000000" points="255,-1282.5 255,-1312.5 605,-1312.5 605,-1282.5 255,-1282.5"/>
<text text-anchor="start" x="262" y="-1293.9" font-family="Arial" font-size="14.00" fill="#000000">id </text>
<text text-anchor="start" x="276.7798" y="-1293.9" font-family="Arial" font-size="14.00" fill="#666666">[int(10) unsigned]</text>
<polygon fill="none" stroke="#000000" points="255,-1252.5 255,-1282.5 605,-1282.5 605,-1252.5 255,-1252.5"/>
<text text-anchor="start" x="262" y="-1263.9" font-family="Arial" font-size="14.00" fill="#000000">user_id </text>
<text text-anchor="start" x="311.7882" y="-1263.9" font-family="Arial" font-size="14.00" fill="#666666">[int(11) unsigned]</text>
<polygon fill="none" stroke="#000000" points="255,-1222.5 255,-1252.5 605,-1252.5 605,-1222.5 255,-1222.5"/>
<text text-anchor="start" x="262" y="-1233.9" font-family="Arial" font-size="14.00" fill="#000000">is_enabled </text>
<text text-anchor="start" x="333.582" y="-1233.9" font-family="Arial" font-size="14.00" fill="#666666">[tinyint(1)]</text>
<polygon fill="none" stroke="#000000" points="255,-1192.5 255,-1222.5 605,-1222.5 605,-1192.5 255,-1192.5"/>
<text text-anchor="start" x="262" y="-1203.9" font-family="Arial" font-size="14.00" fill="#000000">name </text>
<text text-anchor="start" x="300.899" y="-1203.9" font-family="Arial" font-size="14.00" fill="#666666">[varchar(50)]</text>
<polygon fill="none" stroke="#000000" points="255,-1162.5 255,-1192.5 605,-1192.5 605,-1162.5 255,-1162.5"/>
<text text-anchor="start" x="262" y="-1173.9" font-family="Arial" font-size="14.00" fill="#000000">form_type </text>
<text text-anchor="start" x="328.1234" y="-1173.9" font-family="Arial" font-size="14.00" fill="#666666">[tinyint(4)]</text>
<polygon fill="none" stroke="#000000" points="255,-1132.5 255,-1162.5 605,-1162.5 605,-1132.5 255,-1132.5"/>
<text text-anchor="start" x="262" y="-1143.9" font-family="Arial" font-size="14.00" fill="#000000">created_datetime </text>
<text text-anchor="start" x="374.0336" y="-1143.9" font-family="Arial" font-size="14.00" fill="#666666">[timestamp]</text>
<polygon fill="none" stroke="#000000" points="255,-1102.5 255,-1132.5 605,-1132.5 605,-1102.5 255,-1102.5"/>
<text text-anchor="start" x="262" y="-1113.9" font-family="Arial" font-size="14.00" fill="#000000">updated_datetime </text>
<text text-anchor="start" x="377.9382" y="-1113.9" font-family="Arial" font-size="14.00" fill="#666666">[timestamp]</text>
<polygon fill="none" stroke="#000000" stroke-width="3" points="253.5,-1101.5 253.5,-1349.5 606.5,-1349.5 606.5,-1101.5 253.5,-1101.5"/>
</g>
<!-- sk_users -->
<g id="node2" class="node">
<title>sk_users</title>
<polygon fill="#efefef" stroke="transparent" points="279,-942.5 279,-977.5 580,-977.5 580,-942.5 279,-942.5"/>
<polygon fill="none" stroke="#000000" points="279,-942.5 279,-977.5 580,-977.5 580,-942.5 279,-942.5"/>
<text text-anchor="start" x="329.7106" y="-955.3" font-family="Arial Bold" font-size="18.00" fill="#000000">sk_users</text>
<text text-anchor="start" x="401.7214" y="-955.3" font-family="Arial" font-size="14.00" fill="#000000">    </text>
<text text-anchor="start" x="435.9262" y="-955.3" font-family="Arial" font-size="14.00" fill="#666666">[BASE TABLE]</text>
<polygon fill="none" stroke="#000000" points="279,-912.5 279,-942.5 580,-942.5 580,-912.5 279,-912.5"/>
<text text-anchor="start" x="286" y="-923.9" font-family="Arial" font-size="14.00" fill="#000000">id    </text>
<text text-anchor="start" x="331.094" y="-923.9" font-family="Arial" font-size="14.00" fill="#666666">[int(11) unsigned]</text>
<polygon fill="none" stroke="#000000" points="279,-882.5 279,-912.5 580,-912.5 580,-882.5 279,-882.5"/>
<text text-anchor="start" x="286" y="-893.9" font-family="Arial" font-size="14.00" fill="#000000">is_deleted    </text>
<text text-anchor="start" x="384.0042" y="-893.9" font-family="Arial" font-size="14.00" fill="#666666">[tinyint(1)]</text>
<polygon fill="none" stroke="#000000" points="279,-852.5 279,-882.5 580,-882.5 580,-852.5 279,-852.5"/>
<text text-anchor="start" x="286" y="-863.9" font-family="Arial" font-size="14.00" fill="#000000">email    </text>
<text text-anchor="start" x="353.6438" y="-863.9" font-family="Arial" font-size="14.00" fill="#666666">[varchar(255)]</text>
<polygon fill="none" stroke="#000000" points="279,-822.5 279,-852.5 580,-852.5 580,-822.5 279,-822.5"/>
<text text-anchor="start" x="286" y="-833.9" font-family="Arial" font-size="14.00" fill="#000000">password    </text>
<text text-anchor="start" x="380.1024" y="-833.9" font-family="Arial" font-size="14.00" fill="#666666">[varchar(255)]</text>
<polygon fill="none" stroke="#000000" points="279,-792.5 279,-822.5 580,-822.5 580,-792.5 279,-792.5"/>
<text text-anchor="start" x="286" y="-803.9" font-family="Arial" font-size="14.00" fill="#000000">role    </text>
<text text-anchor="start" x="343.5372" y="-803.9" font-family="Arial" font-size="14.00" fill="#666666">[smallint(6)]</text>
<polygon fill="none" stroke="#000000" points="279,-762.5 279,-792.5 580,-792.5 580,-762.5 279,-762.5"/>
<text text-anchor="start" x="286" y="-773.9" font-family="Arial" font-size="14.00" fill="#000000">last_name    </text>
<text text-anchor="start" x="384.7756" y="-773.9" font-family="Arial" font-size="14.00" fill="#666666">[varchar(40)]</text>
<polygon fill="none" stroke="#000000" points="279,-732.5 279,-762.5 580,-762.5 580,-732.5 279,-732.5"/>
<text text-anchor="start" x="286" y="-743.9" font-family="Arial" font-size="14.00" fill="#000000">last_name_kana    </text>
<text text-anchor="start" x="422.906" y="-743.9" font-family="Arial" font-size="14.00" fill="#666666">[varchar(40)]</text>
<polygon fill="none" stroke="#000000" points="279,-702.5 279,-732.5 580,-732.5 580,-702.5 279,-702.5"/>
<text text-anchor="start" x="286" y="-713.9" font-family="Arial" font-size="14.00" fill="#000000">first_name    </text>
<text text-anchor="start" x="385.5442" y="-713.9" font-family="Arial" font-size="14.00" fill="#666666">[varchar(40)]</text>
<polygon fill="none" stroke="#000000" points="279,-672.5 279,-702.5 580,-702.5 580,-672.5 279,-672.5"/>
<text text-anchor="start" x="286" y="-683.9" font-family="Arial" font-size="14.00" fill="#000000">first_name_kana    </text>
<text text-anchor="start" x="423.6746" y="-683.9" font-family="Arial" font-size="14.00" fill="#666666">[varchar(40)]</text>
<polygon fill="none" stroke="#000000" points="279,-642.5 279,-672.5 580,-672.5 580,-642.5 279,-642.5"/>
<text text-anchor="start" x="286" y="-653.9" font-family="Arial" font-size="14.00" fill="#000000">postal    </text>
<text text-anchor="start" x="357.5498" y="-653.9" font-family="Arial" font-size="14.00" fill="#666666">[varchar(8)]</text>
<polygon fill="none" stroke="#000000" points="279,-612.5 279,-642.5 580,-642.5 580,-612.5 279,-612.5"/>
<text text-anchor="start" x="286" y="-623.9" font-family="Arial" font-size="14.00" fill="#000000">mynavi_employee_id    </text>
<text text-anchor="start" x="451.6718" y="-623.9" font-family="Arial" font-size="14.00" fill="#666666">[varchar(255)]</text>
<polygon fill="none" stroke="#000000" points="279,-582.5 279,-612.5 580,-612.5 580,-582.5 279,-582.5"/>
<text text-anchor="start" x="286" y="-593.9" font-family="Arial" font-size="14.00" fill="#000000">prefecture    </text>
<text text-anchor="start" x="383.2202" y="-593.9" font-family="Arial" font-size="14.00" fill="#666666">[varchar(20)]</text>
<polygon fill="none" stroke="#000000" points="279,-552.5 279,-582.5 580,-582.5 580,-552.5 279,-552.5"/>
<text text-anchor="start" x="286" y="-563.9" font-family="Arial" font-size="14.00" fill="#000000">address    </text>
<text text-anchor="start" x="369.9958" y="-563.9" font-family="Arial" font-size="14.00" fill="#666666">[varchar(500)]</text>
<polygon fill="none" stroke="#000000" points="279,-522.5 279,-552.5 580,-552.5 580,-522.5 279,-522.5"/>
<text text-anchor="start" x="286" y="-533.9" font-family="Arial" font-size="14.00" fill="#000000">tel    </text>
<text text-anchor="start" x="334.9846" y="-533.9" font-family="Arial" font-size="14.00" fill="#666666">[varchar(13)]</text>
<polygon fill="none" stroke="#000000" points="279,-492.5 279,-522.5 580,-522.5 580,-492.5 279,-492.5"/>
<text text-anchor="start" x="286" y="-503.9" font-family="Arial" font-size="14.00" fill="#000000">is_registerd    </text>
<text text-anchor="start" x="392.5428" y="-503.9" font-family="Arial" font-size="14.00" fill="#666666">[tinyint(1) unsigned]</text>
<polygon fill="none" stroke="#000000" points="279,-462.5 279,-492.5 580,-492.5 580,-462.5 279,-462.5"/>
<text text-anchor="start" x="286" y="-473.9" font-family="Arial" font-size="14.00" fill="#000000">register_token    </text>
<text text-anchor="start" x="408.892" y="-473.9" font-family="Arial" font-size="14.00" fill="#666666">[varchar(64)]</text>
<polygon fill="none" stroke="#000000" points="279,-432.5 279,-462.5 580,-462.5 580,-432.5 279,-432.5"/>
<text text-anchor="start" x="286" y="-443.9" font-family="Arial" font-size="14.00" fill="#000000">register_created    </text>
<text text-anchor="start" x="421.3352" y="-443.9" font-family="Arial" font-size="14.00" fill="#666666">[datetime]</text>
<polygon fill="none" stroke="#000000" points="279,-402.5 279,-432.5 580,-432.5 580,-402.5 279,-402.5"/>
<text text-anchor="start" x="286" y="-413.9" font-family="Arial" font-size="14.00" fill="#000000">registerd_redirect_url    </text>
<text text-anchor="start" x="452.4348" y="-413.9" font-family="Arial" font-size="14.00" fill="#666666">[varchar(1000)]</text>
<polygon fill="none" stroke="#000000" points="279,-372.5 279,-402.5 580,-402.5 580,-372.5 279,-372.5"/>
<text text-anchor="start" x="285.9923" y="-383.9" font-family="Arial" font-size="14.00" fill="#000000">password_remember_token    </text>
<text text-anchor="start" x="493.6711" y="-383.9" font-family="Arial" font-size="14.00" fill="#666666">[varchar(64)]</text>
<polygon fill="none" stroke="#000000" points="279,-342.5 279,-372.5 580,-372.5 580,-342.5 279,-342.5"/>
<text text-anchor="start" x="286" y="-353.9" font-family="Arial" font-size="14.00" fill="#000000">password_remember_created    </text>
<text text-anchor="start" x="506.122" y="-353.9" font-family="Arial" font-size="14.00" fill="#666666">[datetime]</text>
<polygon fill="none" stroke="#000000" points="279,-312.5 279,-342.5 580,-342.5 580,-312.5 279,-312.5"/>
<text text-anchor="start" x="286" y="-323.9" font-family="Arial" font-size="14.00" fill="#000000">update_email    </text>
<text text-anchor="start" x="404.23" y="-323.9" font-family="Arial" font-size="14.00" fill="#666666">[varchar(255)]</text>
<polygon fill="none" stroke="#000000" points="279,-282.5 279,-312.5 580,-312.5 580,-282.5 279,-282.5"/>
<text text-anchor="start" x="286" y="-293.9" font-family="Arial" font-size="14.00" fill="#000000">update_email_token    </text>
<text text-anchor="start" x="446.251" y="-293.9" font-family="Arial" font-size="14.00" fill="#666666">[varchar(64)]</text>
<polygon fill="none" stroke="#000000" points="279,-252.5 279,-282.5 580,-282.5 580,-252.5 279,-252.5"/>
<text text-anchor="start" x="286" y="-263.9" font-family="Arial" font-size="14.00" fill="#000000">update_email_created    </text>
<text text-anchor="start" x="458.6942" y="-263.9" font-family="Arial" font-size="14.00" fill="#666666">[datetime]</text>
<polygon fill="none" stroke="#000000" points="279,-222.5 279,-252.5 580,-252.5 580,-222.5 279,-222.5"/>
<text text-anchor="start" x="286" y="-233.9" font-family="Arial" font-size="14.00" fill="#000000">user_image_id    </text>
<text text-anchor="start" x="412" y="-233.9" font-family="Arial" font-size="14.00" fill="#666666">[bigint(21) unsigned]</text>
<polygon fill="none" stroke="#000000" points="279,-192.5 279,-222.5 580,-222.5 580,-192.5 279,-192.5"/>
<text text-anchor="start" x="286" y="-203.9" font-family="Arial" font-size="14.00" fill="#000000">birthday    </text>
<text text-anchor="start" x="369.993" y="-203.9" font-family="Arial" font-size="14.00" fill="#666666">[date]</text>
<polygon fill="none" stroke="#000000" points="279,-162.5 279,-192.5 580,-192.5 580,-162.5 279,-162.5"/>
<text text-anchor="start" x="286" y="-173.9" font-family="Arial" font-size="14.00" fill="#000000">where_to_know    </text>
<text text-anchor="start" x="418.23" y="-173.9" font-family="Arial" font-size="14.00" fill="#666666">[smallint(6)]</text>
<polygon fill="none" stroke="#000000" points="279,-132.5 279,-162.5 580,-162.5 580,-132.5 279,-132.5"/>
<text text-anchor="start" x="286" y="-143.9" font-family="Arial" font-size="14.00" fill="#000000">apply_lessor_parent_ids    </text>
<text text-anchor="start" x="471.9102" y="-143.9" font-family="Arial" font-size="14.00" fill="#666666">[varchar(100)]</text>
<polygon fill="none" stroke="#000000" points="279,-102.5 279,-132.5 580,-132.5 580,-102.5 279,-102.5"/>
<text text-anchor="start" x="286" y="-113.9" font-family="Arial" font-size="14.00" fill="#000000">check_terms_date    </text>
<text text-anchor="start" x="434.568" y="-113.9" font-family="Arial" font-size="14.00" fill="#666666">[datetime]</text>
<polygon fill="none" stroke="#000000" points="279,-72.5 279,-102.5 580,-102.5 580,-72.5 279,-72.5"/>
<text text-anchor="start" x="286" y="-83.9" font-family="Arial" font-size="14.00" fill="#000000">created    </text>
<text text-anchor="start" x="366.8864" y="-83.9" font-family="Arial" font-size="14.00" fill="#666666">[datetime]</text>
<polygon fill="none" stroke="#000000" points="279,-42.5 279,-72.5 580,-72.5 580,-42.5 279,-42.5"/>
<text text-anchor="start" x="286" y="-53.9" font-family="Arial" font-size="14.00" fill="#000000">modified    </text>
<text text-anchor="start" x="373.0996" y="-53.9" font-family="Arial" font-size="14.00" fill="#666666">[datetime]</text>
</g>
<!-- sk_custom_reserve_items&#45;&gt;sk_users -->
<g id="edge1" class="edge">
<title>sk_custom_reserve_items:user_id&#45;&gt;sk_users:id</title>
<path fill="none" stroke="#000000" d="M244.6017,-1266.8681C163.9257,-1256.6085 195.0318,-1123.9777 255,-1057 303.4703,-1002.8642 531.5297,-1075.1358 580,-1021 607.7195,-990.0405 621.5556,-927.5 580,-927.5"/>
<polygon fill="#000000" stroke="#000000" points="245.0184,-1266.8933 254.727,-1271.9917 250.0092,-1267.1967 255,-1267.5 255,-1267.5 255,-1267.5 250.0092,-1267.1967 255.273,-1263.0083 245.0184,-1266.8933 245.0184,-1266.8933"/>
<text text-anchor="start" x="7.1655" y="-1277.5" font-family="Arial" font-size="10.00" fill="#000000">FOREIGN KEY (user_id) REFERENCES sk_users (id)</text>
</g>
</g>
</svg>