blob: cdff61889913feb29c725d2c21e2b172c793a55c [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: twoDegreesRelationshipsDiagram Pages: 1 -->
<svg width="615pt" height="570pt"
viewBox="0.00 0.00 615.00 570.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 566)">
<title>twoDegreesRelationshipsDiagram</title>
<polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-566 611,-566 611,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="288,-456 288,-558 447,-558 447,-456 288,-456"/>
<polygon fill="#f5f5f5" stroke="transparent" points="288.5,-536 288.5,-558 447.5,-558 447.5,-536 288.5,-536"/>
<polygon fill="none" stroke="black" points="288.5,-536 288.5,-558 447.5,-558 447.5,-536 288.5,-536"/>
<text text-anchor="start" x="293.5" y="-545.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_calendar_history</text>
<text text-anchor="start" x="412.5" y="-544.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="288.5,-514 288.5,-536 447.5,-536 447.5,-514 288.5,-514"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="293.5" y="-531"/>
<text text-anchor="start" x="308.5" y="-522.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="#ffffff" stroke="transparent" points="288.5,-492 288.5,-514 447.5,-514 447.5,-492 288.5,-492"/>
<polygon fill="none" stroke="black" points="288.5,-492 288.5,-514 447.5,-514 447.5,-492 288.5,-492"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="293.5" y="-509"/>
<text text-anchor="start" x="308.5" y="-500.2" font-family="Helvetica,sans-Serif" font-size="11.00">calendar_id</text>
<polygon fill="none" stroke="black" points="288.5,-474 288.5,-492 447.5,-492 447.5,-474 288.5,-474"/>
<text text-anchor="start" x="291.5" y="-480.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="288.5,-456 288.5,-474 352.5,-474 352.5,-456 288.5,-456"/>
<polygon fill="none" stroke="black" points="288.5,-456 288.5,-474 352.5,-474 352.5,-456 288.5,-456"/>
<text text-anchor="start" x="291.5" y="-462.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 1</text>
<polygon fill="#ffffff" stroke="transparent" points="352.5,-456 352.5,-474 412.5,-474 412.5,-456 352.5,-456"/>
<polygon fill="none" stroke="black" points="352.5,-456 352.5,-474 412.5,-474 412.5,-456 352.5,-456"/>
<text text-anchor="start" x="376.5" y="-462.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="412.5,-456 412.5,-474 447.5,-474 447.5,-456 412.5,-456"/>
<polygon fill="none" stroke="black" points="412.5,-456 412.5,-474 447.5,-474 447.5,-456 412.5,-456"/>
<text text-anchor="start" x="437.5" y="-462.2" font-family="Helvetica,sans-Serif" font-size="11.00"> &#160;</text>
</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,-37 8,-477 238,-477 238,-37 8,-37"/>
<polygon fill="#f5f5f5" stroke="transparent" points="10,-453 10,-475 236,-475 236,-453 10,-453"/>
<polygon fill="none" stroke="black" points="10,-453 10,-475 236,-475 236,-453 10,-453"/>
<text text-anchor="start" x="15" y="-462.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_calendar</text>
<text text-anchor="start" x="201" y="-461.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="10,-431 10,-453 169,-453 169,-431 10,-431"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="15" y="-448"/>
<text text-anchor="start" x="30" y="-439.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="none" stroke="black" points="169,-431 169,-453 236,-453 236,-431 169,-431"/>
<text text-anchor="start" x="172" y="-439.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="none" stroke="black" points="10,-409 10,-431 169,-431 169,-409 10,-409"/>
<text text-anchor="start" x="30" y="-417.2" font-family="Helvetica,sans-Serif" font-size="11.00">title</text>
<polygon fill="none" stroke="black" points="169,-409 169,-431 236,-431 236,-409 169,-409"/>
<text text-anchor="start" x="172" y="-417.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[70]</text>
<polygon fill="none" stroke="black" points="10,-387 10,-409 169,-409 169,-387 10,-387"/>
<text text-anchor="start" x="30" y="-395.2" font-family="Helvetica,sans-Serif" font-size="11.00">description</text>
<polygon fill="none" stroke="black" points="169,-387 169,-409 236,-409 236,-387 169,-387"/>
<text text-anchor="start" x="172" y="-395.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[100]</text>
<polygon fill="none" stroke="black" points="10,-365 10,-387 169,-387 169,-365 10,-365"/>
<text text-anchor="start" x="30" y="-373.2" font-family="Helvetica,sans-Serif" font-size="11.00">location</text>
<polygon fill="none" stroke="black" points="169,-365 169,-387 236,-387 236,-365 169,-365"/>
<text text-anchor="start" x="172" y="-373.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[50]</text>
<polygon fill="none" stroke="black" points="10,-343 10,-365 169,-365 169,-343 10,-343"/>
<text text-anchor="start" x="30" y="-351.2" font-family="Helvetica,sans-Serif" font-size="11.00">start_date</text>
<polygon fill="none" stroke="black" points="169,-343 169,-365 236,-365 236,-343 169,-343"/>
<text text-anchor="start" x="172" y="-351.2" font-family="Helvetica,sans-Serif" font-size="11.00">date[10]</text>
<polygon fill="none" stroke="black" points="10,-321 10,-343 169,-343 169,-321 10,-321"/>
<text text-anchor="start" x="30" y="-329.2" font-family="Helvetica,sans-Serif" font-size="11.00">end_date</text>
<polygon fill="none" stroke="black" points="169,-321 169,-343 236,-343 236,-321 169,-321"/>
<text text-anchor="start" x="172" y="-329.2" font-family="Helvetica,sans-Serif" font-size="11.00">date[10]</text>
<polygon fill="none" stroke="black" points="10,-299 10,-321 169,-321 169,-299 10,-299"/>
<text text-anchor="start" x="30" y="-307.2" font-family="Helvetica,sans-Serif" font-size="11.00">duration</text>
<polygon fill="none" stroke="black" points="169,-299 169,-321 236,-321 236,-299 169,-299"/>
<text text-anchor="start" x="172" y="-307.2" font-family="Helvetica,sans-Serif" font-size="11.00">smallint[5]</text>
<polygon fill="none" stroke="black" points="10,-277 10,-299 169,-299 169,-277 10,-277"/>
<text text-anchor="start" x="30" y="-285.2" font-family="Helvetica,sans-Serif" font-size="11.00">calendar_type_enum</text>
<polygon fill="none" stroke="black" points="169,-277 169,-299 236,-299 236,-277 169,-277"/>
<text text-anchor="start" x="172" y="-285.2" font-family="Helvetica,sans-Serif" font-size="11.00">smallint[5]</text>
<polygon fill="none" stroke="black" points="10,-255 10,-277 169,-277 169,-255 10,-255"/>
<text text-anchor="start" x="30" y="-263.2" font-family="Helvetica,sans-Serif" font-size="11.00">repeating</text>
<polygon fill="none" stroke="black" points="169,-255 169,-277 236,-277 236,-255 169,-255"/>
<text text-anchor="start" x="172" y="-263.2" font-family="Helvetica,sans-Serif" font-size="11.00">bit[1]</text>
<polygon fill="none" stroke="black" points="10,-233 10,-255 169,-255 169,-233 10,-233"/>
<text text-anchor="start" x="30" y="-241.2" font-family="Helvetica,sans-Serif" font-size="11.00">recurrence</text>
<polygon fill="none" stroke="black" points="169,-233 169,-255 236,-255 236,-233 169,-233"/>
<text text-anchor="start" x="172" y="-241.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[100]</text>
<polygon fill="none" stroke="black" points="10,-211 10,-233 169,-233 169,-211 10,-211"/>
<text text-anchor="start" x="30" y="-219.2" font-family="Helvetica,sans-Serif" font-size="11.00">remind_by_enum</text>
<polygon fill="none" stroke="black" points="169,-211 169,-233 236,-233 236,-211 169,-211"/>
<text text-anchor="start" x="172" y="-219.2" font-family="Helvetica,sans-Serif" font-size="11.00">smallint[5]</text>
<polygon fill="none" stroke="black" points="10,-189 10,-211 169,-211 169,-189 10,-189"/>
<text text-anchor="start" x="30" y="-197.2" font-family="Helvetica,sans-Serif" font-size="11.00">first_reminder</text>
<polygon fill="none" stroke="black" points="169,-189 169,-211 236,-211 236,-189 169,-189"/>
<text text-anchor="start" x="172" y="-197.2" font-family="Helvetica,sans-Serif" font-size="11.00">smallint[5]</text>
<polygon fill="none" stroke="black" points="10,-167 10,-189 169,-189 169,-167 10,-167"/>
<text text-anchor="start" x="30" y="-175.2" font-family="Helvetica,sans-Serif" font-size="11.00">second_reminder</text>
<polygon fill="none" stroke="black" points="169,-167 169,-189 236,-189 236,-167 169,-167"/>
<text text-anchor="start" x="172" y="-175.2" font-family="Helvetica,sans-Serif" font-size="11.00">smallint[5]</text>
<polygon fill="none" stroke="black" points="10,-145 10,-167 169,-167 169,-145 10,-145"/>
<text text-anchor="start" x="30" y="-153.2" font-family="Helvetica,sans-Serif" font-size="11.00">createdby_id</text>
<polygon fill="none" stroke="black" points="169,-145 169,-167 236,-167 236,-145 169,-145"/>
<text text-anchor="start" x="172" y="-153.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="none" stroke="black" points="10,-123 10,-145 169,-145 169,-123 10,-123"/>
<text text-anchor="start" x="30" y="-131.2" font-family="Helvetica,sans-Serif" font-size="11.00">lastmodifiedby_id</text>
<polygon fill="none" stroke="black" points="169,-123 169,-145 236,-145 236,-123 169,-123"/>
<text text-anchor="start" x="172" y="-131.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="none" stroke="black" points="10,-101 10,-123 169,-123 169,-101 10,-101"/>
<text text-anchor="start" x="30" y="-109.2" font-family="Helvetica,sans-Serif" font-size="11.00">created_date</text>
<polygon fill="none" stroke="black" points="169,-101 169,-123 236,-123 236,-101 169,-101"/>
<text text-anchor="start" x="172" y="-109.2" font-family="Helvetica,sans-Serif" font-size="11.00">datetime[19]</text>
<polygon fill="none" stroke="black" points="10,-79 10,-101 169,-101 169,-79 10,-79"/>
<text text-anchor="start" x="30" y="-87.2" font-family="Helvetica,sans-Serif" font-size="11.00">lastmodified_date</text>
<polygon fill="none" stroke="black" points="169,-79 169,-101 236,-101 236,-79 169,-79"/>
<text text-anchor="start" x="172" y="-87.2" font-family="Helvetica,sans-Serif" font-size="11.00">datetime[19]</text>
<polygon fill="none" stroke="black" points="10,-57 10,-79 169,-79 169,-57 10,-57"/>
<text text-anchor="start" x="30" y="-65.2" font-family="Helvetica,sans-Serif" font-size="11.00">meeting_time</text>
<polygon fill="none" stroke="black" points="169,-57 169,-79 236,-79 236,-57 169,-57"/>
<text text-anchor="start" x="172" y="-65.2" font-family="Helvetica,sans-Serif" font-size="11.00">time[10]</text>
<polygon fill="#ffffff" stroke="transparent" points="10,-39 10,-57 81,-57 81,-39 10,-39"/>
<polygon fill="none" stroke="black" points="10,-39 10,-57 81,-57 81,-39 10,-39"/>
<text text-anchor="start" x="13" y="-45.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 0</text>
<polygon fill="#ffffff" stroke="transparent" points="81,-39 81,-57 169,-57 169,-39 81,-39"/>
<polygon fill="none" stroke="black" points="81,-39 81,-57 169,-57 169,-39 81,-39"/>
<text text-anchor="start" x="133" y="-45.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="169,-39 169,-57 236,-57 236,-39 169,-39"/>
<polygon fill="none" stroke="black" points="169,-39 169,-57 236,-57 236,-39 169,-39"/>
<text text-anchor="start" x="217" y="-45.2" font-family="Helvetica,sans-Serif" font-size="11.00">2 &gt;</text>
<polygon fill="none" stroke="black" stroke-width="2" points="9,-38 9,-476 237,-476 237,-38 9,-38"/>
</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="M273.67,-498.21C257.51,-483.83 266.15,-442 237,-442"/>
<polygon fill="black" stroke="black" points="279.94,-500.38 286.32,-506.4 283.72,-501.69 287.5,-503 287.5,-503 287.5,-503 283.72,-501.69 288.68,-499.6 279.94,-500.38 279.94,-500.38"/>
<ellipse fill="none" stroke="black" cx="276.92" cy="-499.34" rx="3.2" ry="3.2"/>
</g>
<!-- m_calendar_instance -->
<g id="node3" class="node">
<title>m_calendar_instance</title>
<g id="a_node3"><a xlink:href="../../tables/m_calendar_instance.html" xlink:title="m_calendar_instance" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="287,-333 287,-435 448,-435 448,-333 287,-333"/>
<polygon fill="#f5f5f5" stroke="transparent" points="287.5,-413 287.5,-435 448.5,-435 448.5,-413 287.5,-413"/>
<polygon fill="none" stroke="black" points="287.5,-413 287.5,-435 448.5,-435 448.5,-413 287.5,-413"/>
<text text-anchor="start" x="292.5" y="-422.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_calendar_instance</text>
<text text-anchor="start" x="413.5" y="-421.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="287.5,-391 287.5,-413 448.5,-413 448.5,-391 287.5,-391"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="292.5" y="-408"/>
<text text-anchor="start" x="307.5" y="-399.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="#ffffff" stroke="transparent" points="287.5,-369 287.5,-391 448.5,-391 448.5,-369 287.5,-369"/>
<polygon fill="none" stroke="black" points="287.5,-369 287.5,-391 448.5,-391 448.5,-369 287.5,-369"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="292.5" y="-386"/>
<text text-anchor="start" x="307.5" y="-377.2" font-family="Helvetica,sans-Serif" font-size="11.00">calendar_id</text>
<polygon fill="none" stroke="black" points="287.5,-351 287.5,-369 448.5,-369 448.5,-351 287.5,-351"/>
<text text-anchor="start" x="290.5" y="-357.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="287.5,-333 287.5,-351 348.5,-351 348.5,-333 287.5,-333"/>
<polygon fill="none" stroke="black" points="287.5,-333 287.5,-351 348.5,-351 348.5,-333 287.5,-333"/>
<text text-anchor="start" x="290.5" y="-339.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 1</text>
<polygon fill="#ffffff" stroke="transparent" points="348.5,-333 348.5,-351 406.5,-351 406.5,-333 348.5,-333"/>
<polygon fill="none" stroke="black" points="348.5,-333 348.5,-351 406.5,-351 406.5,-333 348.5,-333"/>
<text text-anchor="start" x="370.5" y="-339.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="406.5,-333 406.5,-351 448.5,-351 448.5,-333 406.5,-333"/>
<polygon fill="none" stroke="black" points="406.5,-333 406.5,-351 448.5,-351 448.5,-333 406.5,-333"/>
<text text-anchor="start" x="429.5" y="-339.2" font-family="Helvetica,sans-Serif" font-size="11.00">1 &gt;</text>
</a>
</g>
</g>
<!-- m_calendar_instance&#45;&gt;m_calendar -->
<g id="edge2" class="edge">
<title>m_calendar_instance:w&#45;&gt;m_calendar:e</title>
<path fill="none" stroke="black" d="M272.74,-384.87C256.8,-399.48 266.2,-442 237,-442"/>
<polygon fill="black" stroke="black" points="278.96,-382.67 287.7,-383.39 282.73,-381.33 286.5,-380 286.5,-380 286.5,-380 282.73,-381.33 285.3,-376.61 278.96,-382.67 278.96,-382.67"/>
<ellipse fill="none" stroke="black" cx="275.94" cy="-383.73" rx="3.2" ry="3.2"/>
</g>
<!-- m_meeting -->
<g id="node4" class="node">
<title>m_meeting</title>
<g id="a_node4"><a xlink:href="../../tables/m_meeting.html" xlink:title="m_meeting" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="497,-375 497,-433 599,-433 599,-375 497,-375"/>
<polygon fill="#f5f5f5" stroke="transparent" points="497,-411 497,-433 599,-433 599,-411 497,-411"/>
<polygon fill="none" stroke="black" points="497,-411 497,-433 599,-433 599,-411 497,-411"/>
<text text-anchor="start" x="502" y="-420.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_meeting</text>
<text text-anchor="start" x="564" y="-419.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="497,-393 497,-411 599,-411 599,-393 497,-393"/>
<text text-anchor="start" x="500" y="-399.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="497,-375 497,-393 528,-393 528,-375 497,-375"/>
<polygon fill="none" stroke="black" points="497,-375 497,-393 528,-393 528,-375 497,-375"/>
<text text-anchor="start" x="500" y="-381.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 1</text>
<polygon fill="#ffffff" stroke="transparent" points="528,-375 528,-393 572,-393 572,-375 528,-375"/>
<polygon fill="none" stroke="black" points="528,-375 528,-393 572,-393 572,-375 528,-375"/>
<text text-anchor="start" x="536" y="-381.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="572,-375 572,-393 599,-393 599,-375 572,-375"/>
<polygon fill="none" stroke="black" points="572,-375 572,-393 599,-393 599,-375 572,-375"/>
<text text-anchor="start" x="580" y="-381.2" font-family="Helvetica,sans-Serif" font-size="11.00">1 &gt;</text>
</a>
</g>
</g>
<!-- m_meeting&#45;&gt;m_calendar_instance -->
<g id="edge3" class="edge">
<title>m_meeting:w&#45;&gt;m_calendar_instance:e</title>
<path fill="none" stroke="black" d="M481.55,-402C471.2,-402 464.35,-402 449.5,-402"/>
<polygon fill="black" stroke="black" points="488,-402 496,-405.6 492,-402 496,-402 496,-402 496,-402 492,-402 496,-398.4 488,-402 488,-402"/>
<ellipse fill="none" stroke="black" cx="484.8" cy="-402" rx="3.2" ry="3.2"/>
</g>
</g>
</svg>