erd.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: RailsXcars Pages: 1 -->
<svg width="270pt" height="711pt"
 viewBox="0.00 0.00 269.60 710.60" 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(28.8 681.8)">
<title>RailsXcars</title>
<polygon fill="#ffffff" stroke="transparent" points="-28.8,28.8 -28.8,-681.8 240.8,-681.8 240.8,28.8 -28.8,28.8"/>
<text text-anchor="middle" x="106" y="-638.6" font-family="Arial BoldMT" font-size="13.00" fill="#000000">RailsXcars domain model</text>
<!-- m_Booking -->
<g id="node1" class="node">
<title>m_Booking</title>
<path fill="none" stroke="#000000" d="M22,-.5C22,-.5 142,-.5 142,-.5 148,-.5 154,-6.5 154,-12.5 154,-12.5 154,-69.5 154,-69.5 154,-75.5 148,-81.5 142,-81.5 142,-81.5 22,-81.5 22,-81.5 16,-81.5 10,-75.5 10,-69.5 10,-69.5 10,-12.5 10,-12.5 10,-6.5 16,-.5 22,-.5"/>
<text text-anchor="start" x="60.1243" y="-68.2" font-family="Arial BoldMT" font-size="11.00" fill="#000000">Booking</text>
<polyline fill="none" stroke="#000000" points="10,-62.5 154,-62.5 "/>
<text text-anchor="start" x="17" y="-49.5" font-family="ArialMT" font-size="10.00" fill="#000000">car_id </text>
<text text-anchor="start" x="47.0146" y="-49.5" font-family="Arial ItalicMT" font-size="10.00" fill="#999999">integer ∗ FK</text>
<text text-anchor="start" x="17" y="-36.5" font-family="ArialMT" font-size="10.00" fill="#000000">end_date </text>
<text text-anchor="start" x="61.4873" y="-36.5" font-family="Arial ItalicMT" font-size="10.00" fill="#999999">date ∗</text>
<text text-anchor="start" x="17" y="-23.5" font-family="ArialMT" font-size="10.00" fill="#000000">start_date </text>
<text text-anchor="start" x="64.251" y="-23.5" font-family="Arial ItalicMT" font-size="10.00" fill="#999999">date ∗</text>
<text text-anchor="start" x="17" y="-10.5" font-family="ArialMT" font-size="10.00" fill="#000000">user_id </text>
<text text-anchor="start" x="52.5762" y="-10.5" font-family="Arial ItalicMT" font-size="10.00" fill="#999999">integer ∗ FK</text>
</g>
<!-- m_Car -->
<g id="node2" class="node">
<title>m_Car</title>
<path fill="none" stroke="#000000" d="M80,-118.5C80,-118.5 200,-118.5 200,-118.5 206,-118.5 212,-124.5 212,-130.5 212,-130.5 212,-304.5 212,-304.5 212,-310.5 206,-316.5 200,-316.5 200,-316.5 80,-316.5 80,-316.5 74,-316.5 68,-310.5 68,-304.5 68,-304.5 68,-130.5 68,-130.5 68,-124.5 74,-118.5 80,-118.5"/>
<text text-anchor="start" x="129.1377" y="-303.2" font-family="Arial BoldMT" font-size="11.00" fill="#000000">Car</text>
<polyline fill="none" stroke="#000000" points="68,-297.5 212,-297.5 "/>
<text text-anchor="start" x="75" y="-284" font-family="ArialMT" font-size="10.00" fill="#000000">color </text>
<text text-anchor="start" x="99.4531" y="-284" font-family="Arial ItalicMT" font-size="10.00" fill="#999999">string</text>
<text text-anchor="start" x="75" y="-271" font-family="ArialMT" font-size="10.00" fill="#000000">latitude </text>
<text text-anchor="start" x="110.0244" y="-271" font-family="Arial ItalicMT" font-size="10.00" fill="#999999">float</text>
<text text-anchor="start" x="75" y="-258" font-family="ArialMT" font-size="10.00" fill="#000000">location </text>
<text text-anchor="start" x="112.2461" y="-258" font-family="Arial ItalicMT" font-size="10.00" fill="#999999">string</text>
<text text-anchor="start" x="75" y="-245" font-family="ArialMT" font-size="10.00" fill="#000000">longitude </text>
<text text-anchor="start" x="118.3691" y="-245" font-family="Arial ItalicMT" font-size="10.00" fill="#999999">float</text>
<text text-anchor="start" x="75" y="-232" font-family="ArialMT" font-size="10.00" fill="#000000">make </text>
<text text-anchor="start" x="102.2314" y="-232" font-family="Arial ItalicMT" font-size="10.00" fill="#999999">string</text>
<text text-anchor="start" x="75" y="-219" font-family="ArialMT" font-size="10.00" fill="#000000">model </text>
<text text-anchor="start" x="105.0146" y="-219" font-family="Arial ItalicMT" font-size="10.00" fill="#999999">string</text>
<text text-anchor="start" x="75" y="-206" font-family="ArialMT" font-size="10.00" fill="#000000">name </text>
<text text-anchor="start" x="102.793" y="-206" font-family="Arial ItalicMT" font-size="10.00" fill="#999999">string</text>
<text text-anchor="start" x="75" y="-193" font-family="ArialMT" font-size="10.00" fill="#000000">photo </text>
<text text-anchor="start" x="102.8027" y="-193" font-family="Arial ItalicMT" font-size="10.00" fill="#999999">string</text>
<text text-anchor="start" x="75" y="-180" font-family="ArialMT" font-size="10.00" fill="#000000">price </text>
<text text-anchor="start" x="99.4531" y="-180" font-family="Arial ItalicMT" font-size="10.00" fill="#999999">float</text>
<text text-anchor="start" x="75" y="-167" font-family="ArialMT" font-size="10.00" fill="#000000">seats </text>
<text text-anchor="start" x="101.6797" y="-167" font-family="Arial ItalicMT" font-size="10.00" fill="#999999">integer</text>
<text text-anchor="start" x="75" y="-154" font-family="ArialMT" font-size="10.00" fill="#000000">transmission </text>
<text text-anchor="start" x="133.9063" y="-154" font-family="Arial ItalicMT" font-size="10.00" fill="#999999">string</text>
<text text-anchor="start" x="75" y="-141" font-family="ArialMT" font-size="10.00" fill="#000000">user_id </text>
<text text-anchor="start" x="110.5762" y="-141" font-family="Arial ItalicMT" font-size="10.00" fill="#999999">integer FK</text>
<text text-anchor="start" x="75" y="-128" font-family="ArialMT" font-size="10.00" fill="#000000">year </text>
<text text-anchor="start" x="97.2314" y="-128" font-family="Arial ItalicMT" font-size="10.00" fill="#999999">integer</text>
</g>
<!-- m_Car&#45;&gt;m_Booking -->
<g id="edge4" class="edge">
<title>m_Car&#45;&gt;m_Booking</title>
<path fill="none" stroke="#000000" d="M105.8571,-113.5997C103.4435,-106.2547 101.0789,-99.0591 98.8332,-92.2253"/>
<ellipse fill="none" stroke="#000000" cx="106.6904" cy="-116.1354" rx="2.4" ry="2.4"/>
<ellipse fill="#000000" stroke="#000000" cx="96.1615" cy="-84.0949" rx="2.4" ry="2.4"/>
<polygon fill="#000000" stroke="#000000" points="100.779,-91.4194 96.9108,-86.3749 96.7889,-92.7307 100.779,-91.4194"/>
</g>
<!-- m_User -->
<g id="node3" class="node">
<title>m_User</title>
<path fill="none" stroke="#000000" d="M12,-353.5C12,-353.5 152,-353.5 152,-353.5 158,-353.5 164,-359.5 164,-365.5 164,-365.5 164,-604.5 164,-604.5 164,-610.5 158,-616.5 152,-616.5 152,-616.5 12,-616.5 12,-616.5 6,-616.5 0,-610.5 0,-604.5 0,-604.5 0,-365.5 0,-365.5 0,-359.5 6,-353.5 12,-353.5"/>
<text text-anchor="start" x="68.3877" y="-603.2" font-family="Arial BoldMT" font-size="11.00" fill="#000000">User</text>
<polyline fill="none" stroke="#000000" points="0,-597.5 164,-597.5 "/>
<text text-anchor="start" x="7" y="-584.5" font-family="ArialMT" font-size="10.00" fill="#000000">address </text>
<text text-anchor="start" x="45.3545" y="-584.5" font-family="Arial ItalicMT" font-size="10.00" fill="#999999">string</text>
<text text-anchor="start" x="7" y="-571.5" font-family="ArialMT" font-size="10.00" fill="#000000">current_sign_in_at </text>
<text text-anchor="start" x="92.0537" y="-571.5" font-family="Arial ItalicMT" font-size="10.00" fill="#999999">datetime</text>
<text text-anchor="start" x="7" y="-558.5" font-family="ArialMT" font-size="10.00" fill="#000000">current_sign_in_ip </text>
<text text-anchor="start" x="91.4971" y="-558.5" font-family="Arial ItalicMT" font-size="10.00" fill="#999999">inet</text>
<text text-anchor="start" x="7" y="-545.5" font-family="ArialMT" font-size="10.00" fill="#000000">email </text>
<text text-anchor="start" x="33.6748" y="-545.5" font-family="Arial ItalicMT" font-size="10.00" fill="#999999">string ∗ U</text>
<text text-anchor="start" x="7" y="-532.5" font-family="ArialMT" font-size="10.00" fill="#000000">encrypted_password </text>
<text text-anchor="start" x="102.0537" y="-532.5" font-family="Arial ItalicMT" font-size="10.00" fill="#999999">string ∗</text>
<text text-anchor="start" x="7" y="-519.5" font-family="ArialMT" font-size="10.00" fill="#000000">facebook_picture_url </text>
<text text-anchor="start" x="102.6152" y="-519.5" font-family="Arial ItalicMT" font-size="10.00" fill="#999999">string</text>
<text text-anchor="start" x="7" y="-506.5" font-family="ArialMT" font-size="10.00" fill="#000000">first_name </text>
<text text-anchor="start" x="56.4629" y="-506.5" font-family="Arial ItalicMT" font-size="10.00" fill="#999999">string</text>
<text text-anchor="start" x="7" y="-493.5" font-family="ArialMT" font-size="10.00" fill="#000000">last_name </text>
<text text-anchor="start" x="55.916" y="-493.5" font-family="Arial ItalicMT" font-size="10.00" fill="#999999">string</text>
<text text-anchor="start" x="7" y="-480.5" font-family="ArialMT" font-size="10.00" fill="#000000">last_sign_in_at </text>
<text text-anchor="start" x="76.4922" y="-480.5" font-family="Arial ItalicMT" font-size="10.00" fill="#999999">datetime</text>
<text text-anchor="start" x="7" y="-467.5" font-family="ArialMT" font-size="10.00" fill="#000000">last_sign_in_ip </text>
<text text-anchor="start" x="75.9355" y="-467.5" font-family="Arial ItalicMT" font-size="10.00" fill="#999999">inet</text>
<text text-anchor="start" x="7" y="-454.5" font-family="ArialMT" font-size="10.00" fill="#000000">provider </text>
<text text-anchor="start" x="45.9063" y="-454.5" font-family="Arial ItalicMT" font-size="10.00" fill="#999999">string</text>
<text text-anchor="start" x="7" y="-441.5" font-family="ArialMT" font-size="10.00" fill="#000000">remember_created_at </text>
<text text-anchor="start" x="108.1621" y="-441.5" font-family="Arial ItalicMT" font-size="10.00" fill="#999999">datetime</text>
<text text-anchor="start" x="6.9561" y="-428.5" font-family="ArialMT" font-size="10.00" fill="#000000">reset_password_sent_at </text>
<text text-anchor="start" x="118.6895" y="-428.5" font-family="Arial ItalicMT" font-size="10.00" fill="#999999">datetime</text>
<text text-anchor="start" x="7" y="-415.5" font-family="ArialMT" font-size="10.00" fill="#000000">reset_password_token </text>
<text text-anchor="start" x="110.3936" y="-415.5" font-family="Arial ItalicMT" font-size="10.00" fill="#999999">string</text>
<text text-anchor="start" x="7" y="-402.5" font-family="ArialMT" font-size="10.00" fill="#000000">sign_in_count </text>
<text text-anchor="start" x="71.4922" y="-402.5" font-family="Arial ItalicMT" font-size="10.00" fill="#999999">integer ∗</text>
<text text-anchor="start" x="7" y="-389.5" font-family="ArialMT" font-size="10.00" fill="#000000">token </text>
<text text-anchor="start" x="34.2412" y="-389.5" font-family="Arial ItalicMT" font-size="10.00" fill="#999999">string</text>
<text text-anchor="start" x="7" y="-376.5" font-family="ArialMT" font-size="10.00" fill="#000000">token_expiry </text>
<text text-anchor="start" x="66.4775" y="-376.5" font-family="Arial ItalicMT" font-size="10.00" fill="#999999">datetime</text>
<text text-anchor="start" x="7" y="-363.5" font-family="ArialMT" font-size="10.00" fill="#000000">uid </text>
<text text-anchor="start" x="23.123" y="-363.5" font-family="Arial ItalicMT" font-size="10.00" fill="#999999">string</text>
</g>
<!-- m_User&#45;&gt;m_Booking -->
<g id="edge1" class="edge">
<title>m_User&#45;&gt;m_Booking</title>
<path fill="none" stroke="#000000" d="M55.4523,-348.4617C46.0269,-279.0438 40.6827,-193.5913 54,-118 55.4924,-109.5291 57.8419,-100.7639 60.5605,-92.316"/>
<ellipse fill="none" stroke="#000000" cx="55.8098" cy="-351.0542" rx="2.4" ry="2.4"/>
<ellipse fill="#000000" stroke="#000000" cx="63.3844" cy="-84.1007" rx="2.4" ry="2.4"/>
<polygon fill="#000000" stroke="#000000" points="62.6397,-92.7272 62.6042,-86.3704 58.6678,-91.3619 62.6397,-92.7272"/>
</g>
<!-- m_User&#45;&gt;m_Car -->
<g id="edge2" class="edge">
<title>m_User&#45;&gt;m_Car</title>
<path fill="none" stroke="#000000" d="M111.6348,-348.3223C113.148,-341.3434 114.6589,-334.3751 116.1509,-327.4935"/>
<ellipse fill="none" stroke="#000000" cx="111.0838" cy="-350.8637" rx="2.4" ry="2.4"/>
<ellipse fill="#000000" stroke="#000000" cx="117.9692" cy="-319.1074" rx="2.4" ry="2.4"/>
<polygon fill="#000000" stroke="#000000" points="118.2415,-327.7616 117.4607,-321.4529 114.1369,-326.8716 118.2415,-327.7616"/>
</g>
</g>
</svg>