| <?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="829pt" height="254pt" |
| viewBox="0.00 0.00 829.00 254.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 250)"> |
| <title>twoDegreesRelationshipsDiagram</title> |
| <polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-250 825,-250 825,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_instance --> |
| <g id="node1" class="node"> |
| <title>m_calendar_instance</title> |
| <g id="a_node1"><a xlink:href="../../tables/m_calendar_instance.html" xlink:title="m_calendar_instance" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="162,-37 162,-139 323,-139 323,-37 162,-37"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="162.5,-117 162.5,-139 323.5,-139 323.5,-117 162.5,-117"/> |
| <polygon fill="none" stroke="black" points="162.5,-117 162.5,-139 323.5,-139 323.5,-117 162.5,-117"/> |
| <text text-anchor="start" x="167.5" y="-126.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_calendar_instance</text> |
| <text text-anchor="start" x="288.5" y="-125.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="162.5,-95 162.5,-117 323.5,-117 323.5,-95 162.5,-95"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="167.5" y="-112"/> |
| <text text-anchor="start" x="182.5" y="-103.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="162.5,-73 162.5,-95 323.5,-95 323.5,-73 162.5,-73"/> |
| <polygon fill="none" stroke="black" points="162.5,-73 162.5,-95 323.5,-95 323.5,-73 162.5,-73"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="167.5" y="-90"/> |
| <text text-anchor="start" x="182.5" y="-81.2" font-family="Helvetica,sans-Serif" font-size="11.00">calendar_id</text> |
| <polygon fill="none" stroke="black" points="162.5,-55 162.5,-73 323.5,-73 323.5,-55 162.5,-55"/> |
| <text text-anchor="start" x="165.5" y="-61.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="162.5,-37 162.5,-55 223.5,-55 223.5,-37 162.5,-37"/> |
| <polygon fill="none" stroke="black" points="162.5,-37 162.5,-55 223.5,-55 223.5,-37 162.5,-37"/> |
| <text text-anchor="start" x="165.5" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 1</text> |
| <polygon fill="#ffffff" stroke="transparent" points="223.5,-37 223.5,-55 281.5,-55 281.5,-37 223.5,-37"/> |
| <polygon fill="none" stroke="black" points="223.5,-37 223.5,-55 281.5,-55 281.5,-37 223.5,-37"/> |
| <text text-anchor="start" x="245.5" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="281.5,-37 281.5,-55 323.5,-55 323.5,-37 281.5,-37"/> |
| <polygon fill="none" stroke="black" points="281.5,-37 281.5,-55 323.5,-55 323.5,-37 281.5,-37"/> |
| <text text-anchor="start" x="304.5" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">1 ></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,-57 8,-115 113,-115 113,-57 8,-57"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="8.5,-93 8.5,-115 113.5,-115 113.5,-93 8.5,-93"/> |
| <polygon fill="none" stroke="black" points="8.5,-93 8.5,-115 113.5,-115 113.5,-93 8.5,-93"/> |
| <text text-anchor="start" x="13.5" y="-102.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_calendar</text> |
| <text text-anchor="start" x="78.5" y="-101.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="8.5,-75 8.5,-93 113.5,-93 113.5,-75 8.5,-75"/> |
| <text text-anchor="start" x="11.5" y="-81.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-57 8.5,-75 36.5,-75 36.5,-57 8.5,-57"/> |
| <polygon fill="none" stroke="black" points="8.5,-57 8.5,-75 36.5,-75 36.5,-57 8.5,-57"/> |
| <text text-anchor="start" x="11.5" y="-63.2" font-family="Helvetica,sans-Serif" font-size="11.00">  </text> |
| <polygon fill="#ffffff" stroke="transparent" points="36.5,-57 36.5,-75 83.5,-75 83.5,-57 36.5,-57"/> |
| <polygon fill="none" stroke="black" points="36.5,-57 36.5,-75 83.5,-75 83.5,-57 36.5,-57"/> |
| <text text-anchor="start" x="47.5" y="-63.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="83.5,-57 83.5,-75 113.5,-75 113.5,-57 83.5,-57"/> |
| <polygon fill="none" stroke="black" points="83.5,-57 83.5,-75 113.5,-75 113.5,-57 83.5,-57"/> |
| <text text-anchor="start" x="94.5" y="-63.2" font-family="Helvetica,sans-Serif" font-size="11.00">2 ></text> |
| </a> |
| </g> |
| </g> |
| <!-- m_calendar_instance->m_calendar --> |
| <g id="edge1" class="edge"> |
| <title>m_calendar_instance:w->m_calendar:e</title> |
| <path fill="none" stroke="black" d="M146.9,-84C136.43,-84 129.51,-84 114.5,-84"/> |
| <polygon fill="black" stroke="black" points="153.5,-84 161.5,-87.6 157.5,-84 161.5,-84 161.5,-84 161.5,-84 157.5,-84 161.5,-80.4 153.5,-84 153.5,-84"/> |
| <ellipse fill="none" stroke="black" cx="150.3" cy="-84" rx="3.2" ry="3.2"/> |
| </g> |
| <!-- m_client_attendance --> |
| <g id="node3" class="node"> |
| <title>m_client_attendance</title> |
| <g id="a_node3"><a xlink:href="../../tables/m_client_attendance.html" xlink:title="m_client_attendance" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="636,-111 636,-235 813,-235 813,-111 636,-111"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="636.5,-213 636.5,-235 813.5,-235 813.5,-213 636.5,-213"/> |
| <polygon fill="none" stroke="black" points="636.5,-213 636.5,-235 813.5,-235 813.5,-213 636.5,-213"/> |
| <text text-anchor="start" x="641.5" y="-222.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_client_attendance</text> |
| <text text-anchor="start" x="778.5" y="-221.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="636.5,-191 636.5,-213 813.5,-213 813.5,-191 636.5,-191"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="641.5" y="-208"/> |
| <text text-anchor="start" x="656.5" y="-199.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="636.5,-169 636.5,-191 813.5,-191 813.5,-169 636.5,-169"/> |
| <polygon fill="none" stroke="black" points="636.5,-169 636.5,-191 813.5,-191 813.5,-169 636.5,-169"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="641.5" y="-186"/> |
| <text text-anchor="start" x="656.5" y="-177.2" font-family="Helvetica,sans-Serif" font-size="11.00">client_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="636.5,-147 636.5,-169 813.5,-169 813.5,-147 636.5,-147"/> |
| <polygon fill="none" stroke="black" points="636.5,-147 636.5,-169 813.5,-169 813.5,-147 636.5,-147"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="641.5" y="-164"/> |
| <text text-anchor="start" x="656.5" y="-155.2" font-family="Helvetica,sans-Serif" font-size="11.00">meeting_id</text> |
| <polygon fill="none" stroke="black" points="636.5,-129 636.5,-147 813.5,-147 813.5,-129 636.5,-129"/> |
| <text text-anchor="start" x="639.5" y="-135.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="636.5,-111 636.5,-129 709.5,-129 709.5,-111 636.5,-111"/> |
| <polygon fill="none" stroke="black" points="636.5,-111 636.5,-129 709.5,-129 709.5,-111 636.5,-111"/> |
| <text text-anchor="start" x="639.5" y="-117.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 2</text> |
| <polygon fill="#ffffff" stroke="transparent" points="709.5,-111 709.5,-129 774.5,-129 774.5,-111 709.5,-111"/> |
| <polygon fill="none" stroke="black" points="709.5,-111 709.5,-129 774.5,-129 774.5,-111 709.5,-111"/> |
| <text text-anchor="start" x="738.5" y="-117.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="774.5,-111 774.5,-129 813.5,-129 813.5,-111 774.5,-111"/> |
| <polygon fill="none" stroke="black" points="774.5,-111 774.5,-129 813.5,-129 813.5,-111 774.5,-111"/> |
| <text text-anchor="start" x="803.5" y="-117.2" font-family="Helvetica,sans-Serif" font-size="11.00">  </text> |
| </a> |
| </g> |
| </g> |
| <!-- m_client --> |
| <g id="node4" class="node"> |
| <title>m_client</title> |
| <g id="a_node4"><a xlink:href="../../tables/m_client.html" xlink:title="m_client" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="432,-184 432,-242 527,-242 527,-184 432,-184"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="432.5,-220 432.5,-242 527.5,-242 527.5,-220 432.5,-220"/> |
| <polygon fill="none" stroke="black" points="432.5,-220 432.5,-242 527.5,-242 527.5,-220 432.5,-220"/> |
| <text text-anchor="start" x="437.5" y="-229.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_client</text> |
| <text text-anchor="start" x="492.5" y="-228.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="432.5,-202 432.5,-220 527.5,-220 527.5,-202 432.5,-202"/> |
| <text text-anchor="start" x="435.5" y="-208.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="432.5,-184 432.5,-202 460.5,-202 460.5,-184 432.5,-184"/> |
| <polygon fill="none" stroke="black" points="432.5,-184 432.5,-202 460.5,-202 460.5,-184 432.5,-184"/> |
| <text text-anchor="start" x="435.5" y="-190.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 13</text> |
| <polygon fill="#ffffff" stroke="transparent" points="460.5,-184 460.5,-202 499.5,-202 499.5,-184 460.5,-184"/> |
| <polygon fill="none" stroke="black" points="460.5,-184 460.5,-202 499.5,-202 499.5,-184 460.5,-184"/> |
| <text text-anchor="start" x="463.5" y="-190.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="499.5,-184 499.5,-202 527.5,-202 527.5,-184 499.5,-184"/> |
| <polygon fill="none" stroke="black" points="499.5,-184 499.5,-202 527.5,-202 527.5,-184 499.5,-184"/> |
| <text text-anchor="start" x="502.5" y="-190.2" font-family="Helvetica,sans-Serif" font-size="11.00">23 ></text> |
| </a> |
| </g> |
| </g> |
| <!-- m_client_attendance->m_client --> |
| <g id="edge2" class="edge"> |
| <title>m_client_attendance:w->m_client:e</title> |
| <path fill="none" stroke="black" d="M621.12,-180.96C583.84,-186.19 572.79,-211 528.5,-211"/> |
| <polygon fill="black" stroke="black" points="627.52,-180.53 635.74,-183.59 631.51,-180.27 635.5,-180 635.5,-180 635.5,-180 631.51,-180.27 635.26,-176.41 627.52,-180.53 627.52,-180.53"/> |
| <ellipse fill="none" stroke="black" cx="624.32" cy="-180.75" rx="3.2" ry="3.2"/> |
| </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="372,-53 372,-163 587,-163 587,-53 372,-53"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="374.5,-139 374.5,-161 585.5,-161 585.5,-139 374.5,-139"/> |
| <polygon fill="none" stroke="black" points="374.5,-139 374.5,-161 585.5,-161 585.5,-139 374.5,-139"/> |
| <text text-anchor="start" x="379.5" y="-148.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_meeting</text> |
| <text text-anchor="start" x="550.5" y="-147.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="374.5,-117 374.5,-139 535.5,-139 535.5,-117 374.5,-117"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="379.5" y="-134"/> |
| <text text-anchor="start" x="394.5" y="-125.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="none" stroke="black" points="535.5,-117 535.5,-139 585.5,-139 585.5,-117 535.5,-117"/> |
| <text text-anchor="start" x="538.5" y="-125.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="374.5,-95 374.5,-117 535.5,-117 535.5,-95 374.5,-95"/> |
| <polygon fill="none" stroke="black" points="374.5,-95 374.5,-117 535.5,-117 535.5,-95 374.5,-95"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="379.5" y="-112"/> |
| <text text-anchor="start" x="394.5" y="-103.2" font-family="Helvetica,sans-Serif" font-size="11.00">calendar_instance_id</text> |
| <polygon fill="none" stroke="black" points="535.5,-95 535.5,-117 585.5,-117 585.5,-95 535.5,-95"/> |
| <text text-anchor="start" x="538.5" y="-103.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="374.5,-73 374.5,-95 535.5,-95 535.5,-73 374.5,-73"/> |
| <polygon fill="none" stroke="black" points="374.5,-73 374.5,-95 535.5,-95 535.5,-73 374.5,-73"/> |
| <text text-anchor="start" x="394.5" y="-81.2" font-family="Helvetica,sans-Serif" font-size="11.00">meeting_date</text> |
| <polygon fill="none" stroke="black" points="535.5,-73 535.5,-95 585.5,-95 585.5,-73 535.5,-73"/> |
| <text text-anchor="start" x="538.5" y="-81.2" font-family="Helvetica,sans-Serif" font-size="11.00">date[10]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="374.5,-55 374.5,-73 446.5,-73 446.5,-55 374.5,-55"/> |
| <polygon fill="none" stroke="black" points="374.5,-55 374.5,-73 446.5,-73 446.5,-55 374.5,-55"/> |
| <text text-anchor="start" x="377.5" y="-61.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 1</text> |
| <polygon fill="#ffffff" stroke="transparent" points="446.5,-55 446.5,-73 535.5,-73 535.5,-55 446.5,-55"/> |
| <polygon fill="none" stroke="black" points="446.5,-55 446.5,-73 535.5,-73 535.5,-55 446.5,-55"/> |
| <text text-anchor="start" x="499.5" y="-61.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="535.5,-55 535.5,-73 585.5,-73 585.5,-55 535.5,-55"/> |
| <polygon fill="none" stroke="black" points="535.5,-55 535.5,-73 585.5,-73 585.5,-55 535.5,-55"/> |
| <text text-anchor="start" x="566.5" y="-61.2" font-family="Helvetica,sans-Serif" font-size="11.00">1 ></text> |
| <polygon fill="none" stroke="black" stroke-width="2" points="373,-54 373,-162 586,-162 586,-54 373,-54"/> |
| </a> |
| </g> |
| </g> |
| <!-- m_client_attendance->m_meeting --> |
| <g id="edge3" class="edge"> |
| <title>m_client_attendance:w->m_meeting:e</title> |
| <path fill="none" stroke="black" d="M621.38,-153.83C609.42,-145.59 606.05,-128 586.5,-128"/> |
| <polygon fill="black" stroke="black" points="627.83,-155.73 634.48,-161.45 631.66,-156.87 635.5,-158 635.5,-158 635.5,-158 631.66,-156.87 636.52,-154.55 627.83,-155.73 627.83,-155.73"/> |
| <ellipse fill="none" stroke="black" cx="624.76" cy="-154.83" rx="3.2" ry="3.2"/> |
| </g> |
| <!-- m_meeting->m_calendar_instance --> |
| <g id="edge4" class="edge"> |
| <title>m_meeting:w->m_calendar_instance:e</title> |
| <path fill="none" stroke="black" d="M358.99,-106C347.68,-106 340.49,-106 324.5,-106"/> |
| <polygon fill="black" stroke="black" points="365.5,-106 373.5,-109.6 369.5,-106 373.5,-106 373.5,-106 373.5,-106 369.5,-106 373.5,-102.4 365.5,-106 365.5,-106"/> |
| <ellipse fill="none" stroke="black" cx="362.3" cy="-106" rx="3.2" ry="3.2"/> |
| </g> |
| </g> |
| </svg> |