blob: 992529283780ab979c45788b2449b422990ef5b6 [file] [log] [blame]
<?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="462pt" height="401pt"
viewBox="0.00 0.00 462.00 401.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 397)">
<title>oneDegreeRelationshipsDiagram</title>
<polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-397 458,-397 458,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_calendar_history -->
<g id="node1" class="node">
<title>m_calendar_history</title>
<g id="a_node1"><a xlink:href="../../tables/m_calendar_history.html" xlink:title="m_calendar_history" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="216,-37 216,-389 446,-389 446,-37 216,-37"/>
<polygon fill="#f5f5f5" stroke="transparent" points="218,-365 218,-387 444,-387 444,-365 218,-365"/>
<polygon fill="none" stroke="black" points="218,-365 218,-387 444,-387 444,-365 218,-365"/>
<text text-anchor="start" x="223" y="-374.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_calendar_history</text>
<text text-anchor="start" x="409" y="-373.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="218,-343 218,-365 377,-365 377,-343 218,-343"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="223" y="-360"/>
<text text-anchor="start" x="238" y="-351.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="none" stroke="black" points="377,-343 377,-365 444,-365 444,-343 377,-343"/>
<text text-anchor="start" x="380" y="-351.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="#ffffff" stroke="transparent" points="218,-321 218,-343 377,-343 377,-321 218,-321"/>
<polygon fill="none" stroke="black" points="218,-321 218,-343 377,-343 377,-321 218,-321"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="223" y="-338"/>
<text text-anchor="start" x="238" y="-329.2" font-family="Helvetica,sans-Serif" font-size="11.00">calendar_id</text>
<polygon fill="none" stroke="black" points="377,-321 377,-343 444,-343 444,-321 377,-321"/>
<text text-anchor="start" x="380" y="-329.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="none" stroke="black" points="218,-299 218,-321 377,-321 377,-299 218,-299"/>
<text text-anchor="start" x="238" y="-307.2" font-family="Helvetica,sans-Serif" font-size="11.00">title</text>
<polygon fill="none" stroke="black" points="377,-299 377,-321 444,-321 444,-299 377,-299"/>
<text text-anchor="start" x="380" y="-307.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[70]</text>
<polygon fill="none" stroke="black" points="218,-277 218,-299 377,-299 377,-277 218,-277"/>
<text text-anchor="start" x="238" y="-285.2" font-family="Helvetica,sans-Serif" font-size="11.00">description</text>
<polygon fill="none" stroke="black" points="377,-277 377,-299 444,-299 444,-277 377,-277"/>
<text text-anchor="start" x="380" y="-285.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[100]</text>
<polygon fill="none" stroke="black" points="218,-255 218,-277 377,-277 377,-255 218,-255"/>
<text text-anchor="start" x="238" y="-263.2" font-family="Helvetica,sans-Serif" font-size="11.00">location</text>
<polygon fill="none" stroke="black" points="377,-255 377,-277 444,-277 444,-255 377,-255"/>
<text text-anchor="start" x="380" y="-263.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[50]</text>
<polygon fill="none" stroke="black" points="218,-233 218,-255 377,-255 377,-233 218,-233"/>
<text text-anchor="start" x="238" y="-241.2" font-family="Helvetica,sans-Serif" font-size="11.00">start_date</text>
<polygon fill="none" stroke="black" points="377,-233 377,-255 444,-255 444,-233 377,-233"/>
<text text-anchor="start" x="380" y="-241.2" font-family="Helvetica,sans-Serif" font-size="11.00">date[10]</text>
<polygon fill="none" stroke="black" points="218,-211 218,-233 377,-233 377,-211 218,-211"/>
<text text-anchor="start" x="238" y="-219.2" font-family="Helvetica,sans-Serif" font-size="11.00">end_date</text>
<polygon fill="none" stroke="black" points="377,-211 377,-233 444,-233 444,-211 377,-211"/>
<text text-anchor="start" x="380" y="-219.2" font-family="Helvetica,sans-Serif" font-size="11.00">date[10]</text>
<polygon fill="none" stroke="black" points="218,-189 218,-211 377,-211 377,-189 218,-189"/>
<text text-anchor="start" x="238" y="-197.2" font-family="Helvetica,sans-Serif" font-size="11.00">duration</text>
<polygon fill="none" stroke="black" points="377,-189 377,-211 444,-211 444,-189 377,-189"/>
<text text-anchor="start" x="380" y="-197.2" font-family="Helvetica,sans-Serif" font-size="11.00">smallint[5]</text>
<polygon fill="none" stroke="black" points="218,-167 218,-189 377,-189 377,-167 218,-167"/>
<text text-anchor="start" x="238" y="-175.2" font-family="Helvetica,sans-Serif" font-size="11.00">calendar_type_enum</text>
<polygon fill="none" stroke="black" points="377,-167 377,-189 444,-189 444,-167 377,-167"/>
<text text-anchor="start" x="380" y="-175.2" font-family="Helvetica,sans-Serif" font-size="11.00">smallint[5]</text>
<polygon fill="none" stroke="black" points="218,-145 218,-167 377,-167 377,-145 218,-145"/>
<text text-anchor="start" x="238" y="-153.2" font-family="Helvetica,sans-Serif" font-size="11.00">repeating</text>
<polygon fill="none" stroke="black" points="377,-145 377,-167 444,-167 444,-145 377,-145"/>
<text text-anchor="start" x="380" y="-153.2" font-family="Helvetica,sans-Serif" font-size="11.00">bit[1]</text>
<polygon fill="none" stroke="black" points="218,-123 218,-145 377,-145 377,-123 218,-123"/>
<text text-anchor="start" x="238" y="-131.2" font-family="Helvetica,sans-Serif" font-size="11.00">recurrence</text>
<polygon fill="none" stroke="black" points="377,-123 377,-145 444,-145 444,-123 377,-123"/>
<text text-anchor="start" x="380" y="-131.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[100]</text>
<polygon fill="none" stroke="black" points="218,-101 218,-123 377,-123 377,-101 218,-101"/>
<text text-anchor="start" x="238" y="-109.2" font-family="Helvetica,sans-Serif" font-size="11.00">remind_by_enum</text>
<polygon fill="none" stroke="black" points="377,-101 377,-123 444,-123 444,-101 377,-101"/>
<text text-anchor="start" x="380" y="-109.2" font-family="Helvetica,sans-Serif" font-size="11.00">smallint[5]</text>
<polygon fill="none" stroke="black" points="218,-79 218,-101 377,-101 377,-79 218,-79"/>
<text text-anchor="start" x="238" y="-87.2" font-family="Helvetica,sans-Serif" font-size="11.00">first_reminder</text>
<polygon fill="none" stroke="black" points="377,-79 377,-101 444,-101 444,-79 377,-79"/>
<text text-anchor="start" x="380" y="-87.2" font-family="Helvetica,sans-Serif" font-size="11.00">smallint[5]</text>
<polygon fill="none" stroke="black" points="218,-57 218,-79 377,-79 377,-57 218,-57"/>
<text text-anchor="start" x="238" y="-65.2" font-family="Helvetica,sans-Serif" font-size="11.00">second_reminder</text>
<polygon fill="none" stroke="black" points="377,-57 377,-79 444,-79 444,-57 377,-57"/>
<text text-anchor="start" x="380" y="-65.2" font-family="Helvetica,sans-Serif" font-size="11.00">smallint[5]</text>
<polygon fill="#ffffff" stroke="transparent" points="218,-39 218,-57 289,-57 289,-39 218,-39"/>
<polygon fill="none" stroke="black" points="218,-39 218,-57 289,-57 289,-39 218,-39"/>
<text text-anchor="start" x="221" y="-45.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 1</text>
<polygon fill="#ffffff" stroke="transparent" points="289,-39 289,-57 377,-57 377,-39 289,-39"/>
<polygon fill="none" stroke="black" points="289,-39 289,-57 377,-57 377,-39 289,-39"/>
<text text-anchor="start" x="341" y="-45.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="377,-39 377,-57 444,-57 444,-39 377,-39"/>
<polygon fill="none" stroke="black" points="377,-39 377,-57 444,-57 444,-39 377,-39"/>
<text text-anchor="start" x="425" y="-45.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 &gt;</text>
<polygon fill="none" stroke="black" stroke-width="2" points="217,-38 217,-388 445,-388 445,-38 217,-38"/>
</a>
</g>
</g>
<!-- m_calendar -->
<g id="node2" class="node">
<title>m_calendar</title>
<g id="a_node2"><a xlink:href="../../tables/m_calendar.html" xlink:title="m_calendar" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="8,-285 8,-365 167,-365 167,-285 8,-285"/>
<polygon fill="#f5f5f5" stroke="transparent" points="8.5,-343 8.5,-365 167.5,-365 167.5,-343 8.5,-343"/>
<polygon fill="none" stroke="black" points="8.5,-343 8.5,-365 167.5,-365 167.5,-343 8.5,-343"/>
<text text-anchor="start" x="13.5" y="-352.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_calendar</text>
<text text-anchor="start" x="132.5" y="-351.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="8.5,-321 8.5,-343 167.5,-343 167.5,-321 8.5,-321"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-338"/>
<text text-anchor="start" x="28.5" y="-329.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="none" stroke="black" points="8.5,-303 8.5,-321 167.5,-321 167.5,-303 8.5,-303"/>
<text text-anchor="start" x="11.5" y="-309.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="8.5,-285 8.5,-303 63.5,-303 63.5,-285 8.5,-285"/>
<polygon fill="none" stroke="black" points="8.5,-285 8.5,-303 63.5,-303 63.5,-285 8.5,-285"/>
<text text-anchor="start" x="11.5" y="-291.2" font-family="Helvetica,sans-Serif" font-size="11.00"> &#160;</text>
<polygon fill="#ffffff" stroke="transparent" points="63.5,-285 63.5,-303 123.5,-303 123.5,-285 63.5,-285"/>
<polygon fill="none" stroke="black" points="63.5,-285 63.5,-303 123.5,-303 123.5,-285 63.5,-285"/>
<text text-anchor="start" x="87.5" y="-291.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="123.5,-285 123.5,-303 167.5,-303 167.5,-285 123.5,-285"/>
<polygon fill="none" stroke="black" points="123.5,-285 123.5,-303 167.5,-303 167.5,-285 123.5,-285"/>
<text text-anchor="start" x="148.5" y="-291.2" font-family="Helvetica,sans-Serif" font-size="11.00">2 &gt;</text>
</a>
</g>
</g>
<!-- m_calendar_history&#45;&gt;m_calendar -->
<g id="edge1" class="edge">
<title>m_calendar_history:w&#45;&gt;m_calendar:e</title>
<path fill="none" stroke="black" d="M202.28,-332C191.29,-332 184.16,-332 168.5,-332"/>
<polygon fill="black" stroke="black" points="209,-332 217,-335.6 213,-332 217,-332 217,-332 217,-332 213,-332 217,-328.4 209,-332 209,-332"/>
<ellipse fill="none" stroke="black" cx="205.8" cy="-332" rx="3.2" ry="3.2"/>
</g>
</g>
</svg>