docs/database/diagrams/tables/m_holiday_office.1degree.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.43.0 (0)
 -->
<!-- Title: oneDegreeRelationshipsDiagram Pages: 1 -->
<svg width="470pt" height="340pt"
 viewBox="0.00 0.00 470.00 340.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 336)">
<title>oneDegreeRelationshipsDiagram</title>
<polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-336 466,-336 466,4 -4,4"/>
<text text-anchor="middle" x="71.5" y="-7.2" font-family="Helvetica,sans-Serif" font-size="11.00">Generated by SchemaSpy</text>
<!-- m_holiday_office -->
<g id="node1" class="node">
<title>m_holiday_office</title>
<g id="a_node1"><a xlink:href="../../tables/m_holiday_office.html" xlink:title="m_holiday_office" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="267,-180 267,-268 454,-268 454,-180 267,-180"/>
<polygon fill="#f5f5f5" stroke="transparent" points="269.5,-244 269.5,-266 452.5,-266 452.5,-244 269.5,-244"/>
<polygon fill="none" stroke="black" points="269.5,-244 269.5,-266 452.5,-266 452.5,-244 269.5,-244"/>
<text text-anchor="start" x="274.5" y="-253.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_holiday_office</text>
<text text-anchor="start" x="417.5" y="-252.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="269.5,-222 269.5,-244 402.5,-244 402.5,-222 269.5,-222"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="274.5" y="-239"/>
<text text-anchor="start" x="289.5" y="-230.2" font-family="Helvetica,sans-Serif" font-size="11.00">holiday_id</text>
<polygon fill="none" stroke="black" points="402.5,-222 402.5,-244 452.5,-244 452.5,-222 402.5,-222"/>
<text text-anchor="start" x="405.5" y="-230.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="none" stroke="black" points="269.5,-200 269.5,-222 402.5,-222 402.5,-200 269.5,-200"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="274.5" y="-217"/>
<text text-anchor="start" x="289.5" y="-208.2" font-family="Helvetica,sans-Serif" font-size="11.00">office_id</text>
<polygon fill="none" stroke="black" points="402.5,-200 402.5,-222 452.5,-222 452.5,-200 402.5,-200"/>
<text text-anchor="start" x="405.5" y="-208.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="#ffffff" stroke="transparent" points="269.5,-182 269.5,-200 327.5,-200 327.5,-182 269.5,-182"/>
<polygon fill="none" stroke="black" points="269.5,-182 269.5,-200 327.5,-200 327.5,-182 269.5,-182"/>
<text text-anchor="start" x="272.5" y="-188.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 2</text>
<polygon fill="#ffffff" stroke="transparent" points="327.5,-182 327.5,-200 402.5,-200 402.5,-182 327.5,-182"/>
<polygon fill="none" stroke="black" points="327.5,-182 327.5,-200 402.5,-200 402.5,-182 327.5,-182"/>
<text text-anchor="start" x="366.5" y="-188.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="402.5,-182 402.5,-200 452.5,-200 452.5,-182 402.5,-182"/>
<polygon fill="none" stroke="black" points="402.5,-182 402.5,-200 452.5,-200 452.5,-182 402.5,-182"/>
<text text-anchor="start" x="433.5" y="-188.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 &gt;</text>
<polygon fill="none" stroke="black" stroke-width="2" points="268,-181 268,-267 453,-267 453,-181 268,-181"/>
</a>
</g>
</g>
<!-- m_holiday -->
<g id="node2" class="node">
<title>m_holiday</title>
<g id="a_node2"><a xlink:href="../../tables/m_holiday.html" xlink:title="m_holiday" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="8,-204 8,-328 218,-328 218,-204 8,-204"/>
<polygon fill="#f5f5f5" stroke="transparent" points="8,-306 8,-328 218,-328 218,-306 8,-306"/>
<polygon fill="none" stroke="black" points="8,-306 8,-328 218,-328 218,-306 8,-306"/>
<text text-anchor="start" x="13" y="-315.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_holiday</text>
<text text-anchor="start" x="183" y="-314.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="8,-284 8,-306 218,-306 218,-284 8,-284"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-301"/>
<text text-anchor="start" x="28" y="-292.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-262 8,-284 218,-284 218,-262 8,-262"/>
<polygon fill="none" stroke="black" points="8,-262 8,-284 218,-284 218,-262 8,-262"/>
<text text-anchor="start" x="28" y="-270.2" font-family="Helvetica,sans-Serif" font-size="11.00">name</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-240 8,-262 218,-262 218,-240 8,-240"/>
<polygon fill="none" stroke="black" points="8,-240 8,-262 218,-262 218,-240 8,-240"/>
<text text-anchor="start" x="28" y="-248.2" font-family="Helvetica,sans-Serif" font-size="11.00">from_date</text>
<polygon fill="none" stroke="black" points="8,-222 8,-240 218,-240 218,-222 8,-222"/>
<text text-anchor="start" x="11" y="-228.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-204 8,-222 89,-222 89,-204 8,-204"/>
<polygon fill="none" stroke="black" points="8,-204 8,-222 89,-222 89,-204 8,-204"/>
<text text-anchor="start" x="11" y="-210.2" font-family="Helvetica,sans-Serif" font-size="11.00"> &#160;</text>
<polygon fill="#ffffff" stroke="transparent" points="89,-204 89,-222 162,-222 162,-204 89,-204"/>
<polygon fill="none" stroke="black" points="89,-204 89,-222 162,-222 162,-204 89,-204"/>
<text text-anchor="start" x="126" y="-210.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="162,-204 162,-222 218,-222 218,-204 162,-204"/>
<polygon fill="none" stroke="black" points="162,-204 162,-222 218,-222 218,-204 162,-204"/>
<text text-anchor="start" x="199" y="-210.2" font-family="Helvetica,sans-Serif" font-size="11.00">1 &gt;</text>
</a>
</g>
</g>
<!-- m_holiday_office&#45;&gt;m_holiday -->
<g id="edge1" class="edge">
<title>m_holiday_office:w&#45;&gt;m_holiday:e</title>
<path fill="none" stroke="black" d="M254.74,-237.87C238.8,-252.48 248.2,-295 219,-295"/>
<polygon fill="black" stroke="black" points="260.96,-235.67 269.7,-236.39 264.73,-234.33 268.5,-233 268.5,-233 268.5,-233 264.73,-234.33 267.3,-229.61 260.96,-235.67 260.96,-235.67"/>
<ellipse fill="none" stroke="black" cx="257.94" cy="-236.73" rx="3.2" ry="3.2"/>
</g>
<!-- m_office -->
<g id="node3" class="node">
<title>m_office</title>
<g id="a_node3"><a xlink:href="../../tables/m_office.html" xlink:title="m_office" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="57,-37 57,-183 169,-183 169,-37 57,-37"/>
<polygon fill="#f5f5f5" stroke="transparent" points="57,-161 57,-183 169,-183 169,-161 57,-161"/>
<polygon fill="none" stroke="black" points="57,-161 57,-183 169,-183 169,-161 57,-161"/>
<text text-anchor="start" x="62" y="-170.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_office</text>
<text text-anchor="start" x="134" y="-169.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="57,-139 57,-161 169,-161 169,-139 57,-139"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="62" y="-156"/>
<text text-anchor="start" x="77" y="-147.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="#ffffff" stroke="transparent" points="57,-117 57,-139 169,-139 169,-117 57,-117"/>
<polygon fill="none" stroke="black" points="57,-117 57,-139 169,-139 169,-117 57,-117"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="62" y="-134"/>
<text text-anchor="start" x="77" y="-125.2" font-family="Helvetica,sans-Serif" font-size="11.00">parent_id</text>
<polygon fill="#ffffff" stroke="transparent" points="57,-95 57,-117 169,-117 169,-95 57,-95"/>
<polygon fill="none" stroke="black" points="57,-95 57,-117 169,-117 169,-95 57,-95"/>
<text text-anchor="start" x="77" y="-103.2" font-family="Helvetica,sans-Serif" font-size="11.00">external_id</text>
<polygon fill="#ffffff" stroke="transparent" points="57,-73 57,-95 169,-95 169,-73 57,-73"/>
<polygon fill="none" stroke="black" points="57,-73 57,-95 169,-95 169,-73 57,-73"/>
<text text-anchor="start" x="77" y="-81.2" font-family="Helvetica,sans-Serif" font-size="11.00">name</text>
<polygon fill="none" stroke="black" points="57,-55 57,-73 169,-73 169,-55 57,-55"/>
<text text-anchor="start" x="60" y="-61.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="57,-37 57,-55 90,-55 90,-37 57,-37"/>
<polygon fill="none" stroke="black" points="57,-37 57,-55 90,-55 90,-37 57,-37"/>
<text text-anchor="start" x="60" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 1</text>
<polygon fill="#ffffff" stroke="transparent" points="90,-37 90,-55 135,-55 135,-37 90,-37"/>
<polygon fill="none" stroke="black" points="90,-37 90,-55 135,-55 135,-37 90,-37"/>
<text text-anchor="start" x="99" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="135,-37 135,-55 169,-55 169,-37 135,-37"/>
<polygon fill="none" stroke="black" points="135,-37 135,-55 169,-55 169,-37 135,-37"/>
<text text-anchor="start" x="144" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">20 &gt;</text>
</a>
</g>
</g>
<!-- m_holiday_office&#45;&gt;m_office -->
<g id="edge2" class="edge">
<title>m_holiday_office:w&#45;&gt;m_office:e</title>
<path fill="none" stroke="black" d="M253.94,-209.11C217.33,-198.81 216.06,-150 170,-150"/>
<polygon fill="black" stroke="black" points="260.57,-209.97 268.04,-214.57 264.53,-210.48 268.5,-211 268.5,-211 268.5,-211 264.53,-210.48 268.96,-207.43 260.57,-209.97 260.57,-209.97"/>
<ellipse fill="none" stroke="black" cx="257.39" cy="-209.56" rx="3.2" ry="3.2"/>
</g>
</g>
</svg>