blob: 3124032788d4be17228e0fe3361e33e0e2f6fd56 [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="864pt" height="260pt"
viewBox="0.00 0.00 864.00 260.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 256)">
<title>twoDegreesRelationshipsDiagram</title>
<polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-256 860,-256 860,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="252,-190 252,-248 400,-248 400,-190 252,-190"/>
<polygon fill="#f5f5f5" stroke="transparent" points="252,-226 252,-248 400,-248 400,-226 252,-226"/>
<polygon fill="none" stroke="black" points="252,-226 252,-248 400,-248 400,-226 252,-226"/>
<text text-anchor="start" x="257" y="-235.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_calendar_history</text>
<text text-anchor="start" x="365" y="-234.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="252,-208 252,-226 400,-226 400,-208 252,-208"/>
<text text-anchor="start" x="255" y="-214.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="252,-190 252,-208 311,-208 311,-190 252,-190"/>
<polygon fill="none" stroke="black" points="252,-190 252,-208 311,-208 311,-190 252,-190"/>
<text text-anchor="start" x="255" y="-196.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 1</text>
<polygon fill="#ffffff" stroke="transparent" points="311,-190 311,-208 368,-208 368,-190 311,-190"/>
<polygon fill="none" stroke="black" points="311,-190 311,-208 368,-208 368,-190 311,-190"/>
<text text-anchor="start" x="332" y="-196.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="368,-190 368,-208 400,-208 400,-190 368,-190"/>
<polygon fill="none" stroke="black" points="368,-190 368,-208 400,-208 400,-190 368,-190"/>
<text text-anchor="start" x="390" y="-196.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,-117 8,-197 167,-197 167,-117 8,-117"/>
<polygon fill="#f5f5f5" stroke="transparent" points="8.5,-175 8.5,-197 167.5,-197 167.5,-175 8.5,-175"/>
<polygon fill="none" stroke="black" points="8.5,-175 8.5,-197 167.5,-197 167.5,-175 8.5,-175"/>
<text text-anchor="start" x="13.5" y="-184.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_calendar</text>
<text text-anchor="start" x="132.5" y="-183.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="8.5,-153 8.5,-175 167.5,-175 167.5,-153 8.5,-153"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-170"/>
<text text-anchor="start" x="28.5" y="-161.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="none" stroke="black" points="8.5,-135 8.5,-153 167.5,-153 167.5,-135 8.5,-135"/>
<text text-anchor="start" x="11.5" y="-141.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="8.5,-117 8.5,-135 63.5,-135 63.5,-117 8.5,-117"/>
<polygon fill="none" stroke="black" points="8.5,-117 8.5,-135 63.5,-135 63.5,-117 8.5,-117"/>
<text text-anchor="start" x="11.5" y="-123.2" font-family="Helvetica,sans-Serif" font-size="11.00"> &#160;</text>
<polygon fill="#ffffff" stroke="transparent" points="63.5,-117 63.5,-135 123.5,-135 123.5,-117 63.5,-117"/>
<polygon fill="none" stroke="black" points="63.5,-117 63.5,-135 123.5,-135 123.5,-117 63.5,-117"/>
<text text-anchor="start" x="87.5" y="-123.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="123.5,-117 123.5,-135 167.5,-135 167.5,-117 123.5,-117"/>
<polygon fill="none" stroke="black" points="123.5,-117 123.5,-135 167.5,-135 167.5,-117 123.5,-117"/>
<text text-anchor="start" x="148.5" y="-123.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="M236.73,-214.72C207.83,-204.58 206.63,-164 168.5,-164"/>
<polygon fill="black" stroke="black" points="243.1,-215.74 250.43,-220.56 247.05,-216.37 251,-217 251,-217 251,-217 247.05,-216.37 251.57,-213.44 243.1,-215.74 243.1,-215.74"/>
<ellipse fill="none" stroke="black" cx="239.94" cy="-215.23" 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="216,-37 216,-169 436,-169 436,-37 216,-37"/>
<polygon fill="#f5f5f5" stroke="transparent" points="218,-145 218,-167 434,-167 434,-145 218,-145"/>
<polygon fill="none" stroke="black" points="218,-145 218,-167 434,-167 434,-145 218,-145"/>
<text text-anchor="start" x="223" y="-154.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_calendar_instance</text>
<text text-anchor="start" x="399" y="-153.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="218,-123 218,-145 379,-145 379,-123 218,-123"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="223" y="-140"/>
<text text-anchor="start" x="238" y="-131.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="none" stroke="black" points="379,-123 379,-145 434,-145 434,-123 379,-123"/>
<text text-anchor="start" x="382" y="-131.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="#ffffff" stroke="transparent" points="218,-101 218,-123 379,-123 379,-101 218,-101"/>
<polygon fill="none" stroke="black" points="218,-101 218,-123 379,-123 379,-101 218,-101"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="223" y="-118"/>
<text text-anchor="start" x="238" y="-109.2" font-family="Helvetica,sans-Serif" font-size="11.00">calendar_id</text>
<polygon fill="none" stroke="black" points="379,-101 379,-123 434,-123 434,-101 379,-101"/>
<text text-anchor="start" x="382" y="-109.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="none" stroke="black" points="218,-79 218,-101 379,-101 379,-79 218,-79"/>
<text text-anchor="start" x="238" y="-87.2" font-family="Helvetica,sans-Serif" font-size="11.00">entity_id</text>
<polygon fill="none" stroke="black" points="379,-79 379,-101 434,-101 434,-79 379,-79"/>
<text text-anchor="start" x="382" y="-87.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="none" stroke="black" points="218,-57 218,-79 379,-79 379,-57 218,-57"/>
<text text-anchor="start" x="238" y="-65.2" font-family="Helvetica,sans-Serif" font-size="11.00">entity_type_enum</text>
<polygon fill="none" stroke="black" points="379,-57 379,-79 434,-79 434,-57 379,-57"/>
<text text-anchor="start" x="382" 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 290,-57 290,-39 218,-39"/>
<polygon fill="none" stroke="black" points="218,-39 218,-57 290,-57 290,-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="290,-39 290,-57 379,-57 379,-39 290,-39"/>
<polygon fill="none" stroke="black" points="290,-39 290,-57 379,-57 379,-39 290,-39"/>
<text text-anchor="start" x="343" y="-45.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="379,-39 379,-57 434,-57 434,-39 379,-39"/>
<polygon fill="none" stroke="black" points="379,-39 379,-57 434,-57 434,-39 379,-39"/>
<text text-anchor="start" x="415" y="-45.2" font-family="Helvetica,sans-Serif" font-size="11.00">1 &gt;</text>
<polygon fill="none" stroke="black" stroke-width="2" points="217,-38 217,-168 435,-168 435,-38 217,-38"/>
</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="M203.09,-117.18C189.37,-130.33 193.93,-164 168.5,-164"/>
<polygon fill="black" stroke="black" points="209.5,-114.79 218.26,-115.37 213.25,-113.4 217,-112 217,-112 217,-112 213.25,-113.4 215.74,-108.63 209.5,-114.79 209.5,-114.79"/>
<ellipse fill="none" stroke="black" cx="206.5" cy="-115.91" rx="3.2" ry="3.2"/>
</g>
<!-- m_client_attendance -->
<g id="node4" class="node">
<title>m_client_attendance</title>
<g id="a_node4"><a xlink:href="../../tables/m_client_attendance.html" xlink:title="m_client_attendance" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="695,-129 695,-187 848,-187 848,-129 695,-129"/>
<polygon fill="#f5f5f5" stroke="transparent" points="695.5,-165 695.5,-187 848.5,-187 848.5,-165 695.5,-165"/>
<polygon fill="none" stroke="black" points="695.5,-165 695.5,-187 848.5,-187 848.5,-165 695.5,-165"/>
<text text-anchor="start" x="700.5" y="-174.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_client_attendance</text>
<text text-anchor="start" x="813.5" y="-173.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="695.5,-147 695.5,-165 848.5,-165 848.5,-147 695.5,-147"/>
<text text-anchor="start" x="698.5" y="-153.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="695.5,-129 695.5,-147 756.5,-147 756.5,-129 695.5,-129"/>
<polygon fill="none" stroke="black" points="695.5,-129 695.5,-147 756.5,-147 756.5,-129 695.5,-129"/>
<text text-anchor="start" x="698.5" y="-135.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 2</text>
<polygon fill="#ffffff" stroke="transparent" points="756.5,-129 756.5,-147 815.5,-147 815.5,-129 756.5,-129"/>
<polygon fill="none" stroke="black" points="756.5,-129 756.5,-147 815.5,-147 815.5,-129 756.5,-129"/>
<text text-anchor="start" x="779.5" y="-135.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="815.5,-129 815.5,-147 848.5,-147 848.5,-129 815.5,-129"/>
<polygon fill="none" stroke="black" points="815.5,-129 815.5,-147 848.5,-147 848.5,-129 815.5,-129"/>
<text text-anchor="start" x="838.5" y="-135.2" font-family="Helvetica,sans-Serif" font-size="11.00"> &#160;</text>
</a>
</g>
</g>
<!-- m_meeting -->
<g id="node5" class="node">
<title>m_meeting</title>
<g id="a_node5"><a xlink:href="../../tables/m_meeting.html" xlink:title="m_meeting" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="485,-83 485,-189 646,-189 646,-83 485,-83"/>
<polygon fill="#f5f5f5" stroke="transparent" points="485.5,-167 485.5,-189 646.5,-189 646.5,-167 485.5,-167"/>
<polygon fill="none" stroke="black" points="485.5,-167 485.5,-189 646.5,-189 646.5,-167 485.5,-167"/>
<text text-anchor="start" x="490.5" y="-176.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_meeting</text>
<text text-anchor="start" x="611.5" y="-175.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="485.5,-145 485.5,-167 646.5,-167 646.5,-145 485.5,-145"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="490.5" y="-162"/>
<text text-anchor="start" x="505.5" y="-153.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="#ffffff" stroke="transparent" points="485.5,-123 485.5,-145 646.5,-145 646.5,-123 485.5,-123"/>
<polygon fill="none" stroke="black" points="485.5,-123 485.5,-145 646.5,-145 646.5,-123 485.5,-123"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="490.5" y="-140"/>
<text text-anchor="start" x="505.5" y="-131.2" font-family="Helvetica,sans-Serif" font-size="11.00">calendar_instance_id</text>
<polygon fill="#ffffff" stroke="transparent" points="485.5,-101 485.5,-123 646.5,-123 646.5,-101 485.5,-101"/>
<polygon fill="none" stroke="black" points="485.5,-101 485.5,-123 646.5,-123 646.5,-101 485.5,-101"/>
<text text-anchor="start" x="505.5" y="-109.2" font-family="Helvetica,sans-Serif" font-size="11.00">meeting_date</text>
<polygon fill="#ffffff" stroke="transparent" points="485.5,-83 485.5,-101 546.5,-101 546.5,-83 485.5,-83"/>
<polygon fill="none" stroke="black" points="485.5,-83 485.5,-101 546.5,-101 546.5,-83 485.5,-83"/>
<text text-anchor="start" x="488.5" y="-89.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 1</text>
<polygon fill="#ffffff" stroke="transparent" points="546.5,-83 546.5,-101 604.5,-101 604.5,-83 546.5,-83"/>
<polygon fill="none" stroke="black" points="546.5,-83 546.5,-101 604.5,-101 604.5,-83 546.5,-83"/>
<text text-anchor="start" x="568.5" y="-89.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="604.5,-83 604.5,-101 646.5,-101 646.5,-83 604.5,-83"/>
<polygon fill="none" stroke="black" points="604.5,-83 604.5,-101 646.5,-101 646.5,-83 604.5,-83"/>
<text text-anchor="start" x="627.5" y="-89.2" font-family="Helvetica,sans-Serif" font-size="11.00">1 &gt;</text>
</a>
</g>
</g>
<!-- m_client_attendance&#45;&gt;m_meeting -->
<g id="edge3" class="edge">
<title>m_client_attendance:w&#45;&gt;m_meeting:e</title>
<path fill="none" stroke="black" d="M679.9,-156C669.43,-156 662.51,-156 647.5,-156"/>
<polygon fill="black" stroke="black" points="686.5,-156 694.5,-159.6 690.5,-156 694.5,-156 694.5,-156 694.5,-156 690.5,-156 694.5,-152.4 686.5,-156 686.5,-156"/>
<ellipse fill="none" stroke="black" cx="683.3" cy="-156" rx="3.2" ry="3.2"/>
</g>
<!-- m_meeting&#45;&gt;m_calendar_instance -->
<g id="edge4" class="edge">
<title>m_meeting:w&#45;&gt;m_calendar_instance:e</title>
<path fill="none" stroke="black" d="M469.84,-134C458.41,-134 451.16,-134 435,-134"/>
<polygon fill="black" stroke="black" points="476.5,-134 484.5,-137.6 480.5,-134 484.5,-134 484.5,-134 484.5,-134 480.5,-134 484.5,-130.4 476.5,-134 476.5,-134"/>
<ellipse fill="none" stroke="black" cx="473.3" cy="-134" rx="3.2" ry="3.2"/>
</g>
</g>
</svg>