| <?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="462pt" height="480pt" |
| viewBox="0.00 0.00 462.00 480.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 476)"> |
| <title>twoDegreesRelationshipsDiagram</title> |
| <polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-476 458,-476 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,-116 216,-468 446,-468 446,-116 216,-116"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="218,-444 218,-466 444,-466 444,-444 218,-444"/> |
| <polygon fill="none" stroke="black" points="218,-444 218,-466 444,-466 444,-444 218,-444"/> |
| <text text-anchor="start" x="223" y="-453.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_calendar_history</text> |
| <text text-anchor="start" x="409" y="-452.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="218,-422 218,-444 377,-444 377,-422 218,-422"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="223" y="-439"/> |
| <text text-anchor="start" x="238" y="-430.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="none" stroke="black" points="377,-422 377,-444 444,-444 444,-422 377,-422"/> |
| <text text-anchor="start" x="380" y="-430.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="218,-400 218,-422 377,-422 377,-400 218,-400"/> |
| <polygon fill="none" stroke="black" points="218,-400 218,-422 377,-422 377,-400 218,-400"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="223" y="-417"/> |
| <text text-anchor="start" x="238" y="-408.2" font-family="Helvetica,sans-Serif" font-size="11.00">calendar_id</text> |
| <polygon fill="none" stroke="black" points="377,-400 377,-422 444,-422 444,-400 377,-400"/> |
| <text text-anchor="start" x="380" y="-408.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="none" stroke="black" points="218,-378 218,-400 377,-400 377,-378 218,-378"/> |
| <text text-anchor="start" x="238" y="-386.2" font-family="Helvetica,sans-Serif" font-size="11.00">title</text> |
| <polygon fill="none" stroke="black" points="377,-378 377,-400 444,-400 444,-378 377,-378"/> |
| <text text-anchor="start" x="380" y="-386.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[70]</text> |
| <polygon fill="none" stroke="black" points="218,-356 218,-378 377,-378 377,-356 218,-356"/> |
| <text text-anchor="start" x="238" y="-364.2" font-family="Helvetica,sans-Serif" font-size="11.00">description</text> |
| <polygon fill="none" stroke="black" points="377,-356 377,-378 444,-378 444,-356 377,-356"/> |
| <text text-anchor="start" x="380" y="-364.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[100]</text> |
| <polygon fill="none" stroke="black" points="218,-334 218,-356 377,-356 377,-334 218,-334"/> |
| <text text-anchor="start" x="238" y="-342.2" font-family="Helvetica,sans-Serif" font-size="11.00">location</text> |
| <polygon fill="none" stroke="black" points="377,-334 377,-356 444,-356 444,-334 377,-334"/> |
| <text text-anchor="start" x="380" y="-342.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[50]</text> |
| <polygon fill="none" stroke="black" points="218,-312 218,-334 377,-334 377,-312 218,-312"/> |
| <text text-anchor="start" x="238" y="-320.2" font-family="Helvetica,sans-Serif" font-size="11.00">start_date</text> |
| <polygon fill="none" stroke="black" points="377,-312 377,-334 444,-334 444,-312 377,-312"/> |
| <text text-anchor="start" x="380" y="-320.2" font-family="Helvetica,sans-Serif" font-size="11.00">date[10]</text> |
| <polygon fill="none" stroke="black" points="218,-290 218,-312 377,-312 377,-290 218,-290"/> |
| <text text-anchor="start" x="238" y="-298.2" font-family="Helvetica,sans-Serif" font-size="11.00">end_date</text> |
| <polygon fill="none" stroke="black" points="377,-290 377,-312 444,-312 444,-290 377,-290"/> |
| <text text-anchor="start" x="380" y="-298.2" font-family="Helvetica,sans-Serif" font-size="11.00">date[10]</text> |
| <polygon fill="none" stroke="black" points="218,-268 218,-290 377,-290 377,-268 218,-268"/> |
| <text text-anchor="start" x="238" y="-276.2" font-family="Helvetica,sans-Serif" font-size="11.00">duration</text> |
| <polygon fill="none" stroke="black" points="377,-268 377,-290 444,-290 444,-268 377,-268"/> |
| <text text-anchor="start" x="380" y="-276.2" font-family="Helvetica,sans-Serif" font-size="11.00">smallint[5]</text> |
| <polygon fill="none" stroke="black" points="218,-246 218,-268 377,-268 377,-246 218,-246"/> |
| <text text-anchor="start" x="238" y="-254.2" font-family="Helvetica,sans-Serif" font-size="11.00">calendar_type_enum</text> |
| <polygon fill="none" stroke="black" points="377,-246 377,-268 444,-268 444,-246 377,-246"/> |
| <text text-anchor="start" x="380" y="-254.2" font-family="Helvetica,sans-Serif" font-size="11.00">smallint[5]</text> |
| <polygon fill="none" stroke="black" points="218,-224 218,-246 377,-246 377,-224 218,-224"/> |
| <text text-anchor="start" x="238" y="-232.2" font-family="Helvetica,sans-Serif" font-size="11.00">repeating</text> |
| <polygon fill="none" stroke="black" points="377,-224 377,-246 444,-246 444,-224 377,-224"/> |
| <text text-anchor="start" x="380" y="-232.2" font-family="Helvetica,sans-Serif" font-size="11.00">bit[1]</text> |
| <polygon fill="none" stroke="black" points="218,-202 218,-224 377,-224 377,-202 218,-202"/> |
| <text text-anchor="start" x="238" y="-210.2" font-family="Helvetica,sans-Serif" font-size="11.00">recurrence</text> |
| <polygon fill="none" stroke="black" points="377,-202 377,-224 444,-224 444,-202 377,-202"/> |
| <text text-anchor="start" x="380" y="-210.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[100]</text> |
| <polygon fill="none" stroke="black" points="218,-180 218,-202 377,-202 377,-180 218,-180"/> |
| <text text-anchor="start" x="238" y="-188.2" font-family="Helvetica,sans-Serif" font-size="11.00">remind_by_enum</text> |
| <polygon fill="none" stroke="black" points="377,-180 377,-202 444,-202 444,-180 377,-180"/> |
| <text text-anchor="start" x="380" y="-188.2" font-family="Helvetica,sans-Serif" font-size="11.00">smallint[5]</text> |
| <polygon fill="none" stroke="black" points="218,-158 218,-180 377,-180 377,-158 218,-158"/> |
| <text text-anchor="start" x="238" y="-166.2" font-family="Helvetica,sans-Serif" font-size="11.00">first_reminder</text> |
| <polygon fill="none" stroke="black" points="377,-158 377,-180 444,-180 444,-158 377,-158"/> |
| <text text-anchor="start" x="380" y="-166.2" font-family="Helvetica,sans-Serif" font-size="11.00">smallint[5]</text> |
| <polygon fill="none" stroke="black" points="218,-136 218,-158 377,-158 377,-136 218,-136"/> |
| <text text-anchor="start" x="238" y="-144.2" font-family="Helvetica,sans-Serif" font-size="11.00">second_reminder</text> |
| <polygon fill="none" stroke="black" points="377,-136 377,-158 444,-158 444,-136 377,-136"/> |
| <text text-anchor="start" x="380" y="-144.2" font-family="Helvetica,sans-Serif" font-size="11.00">smallint[5]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="218,-118 218,-136 289,-136 289,-118 218,-118"/> |
| <polygon fill="none" stroke="black" points="218,-118 218,-136 289,-136 289,-118 218,-118"/> |
| <text text-anchor="start" x="221" y="-124.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 1</text> |
| <polygon fill="#ffffff" stroke="transparent" points="289,-118 289,-136 377,-136 377,-118 289,-118"/> |
| <polygon fill="none" stroke="black" points="289,-118 289,-136 377,-136 377,-118 289,-118"/> |
| <text text-anchor="start" x="341" y="-124.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="377,-118 377,-136 444,-136 444,-118 377,-118"/> |
| <polygon fill="none" stroke="black" points="377,-118 377,-136 444,-136 444,-118 377,-118"/> |
| <text text-anchor="start" x="425" y="-124.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 ></text> |
| <polygon fill="none" stroke="black" stroke-width="2" points="217,-117 217,-467 445,-467 445,-117 217,-117"/> |
| </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,-190 8,-270 167,-270 167,-190 8,-190"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="8.5,-248 8.5,-270 167.5,-270 167.5,-248 8.5,-248"/> |
| <polygon fill="none" stroke="black" points="8.5,-248 8.5,-270 167.5,-270 167.5,-248 8.5,-248"/> |
| <text text-anchor="start" x="13.5" y="-257.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_calendar</text> |
| <text text-anchor="start" x="132.5" y="-256.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="8.5,-226 8.5,-248 167.5,-248 167.5,-226 8.5,-226"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-243"/> |
| <text text-anchor="start" x="28.5" y="-234.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="none" stroke="black" points="8.5,-208 8.5,-226 167.5,-226 167.5,-208 8.5,-208"/> |
| <text text-anchor="start" x="11.5" y="-214.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-190 8.5,-208 63.5,-208 63.5,-190 8.5,-190"/> |
| <polygon fill="none" stroke="black" points="8.5,-190 8.5,-208 63.5,-208 63.5,-190 8.5,-190"/> |
| <text text-anchor="start" x="11.5" y="-196.2" font-family="Helvetica,sans-Serif" font-size="11.00">  </text> |
| <polygon fill="#ffffff" stroke="transparent" points="63.5,-190 63.5,-208 123.5,-208 123.5,-190 63.5,-190"/> |
| <polygon fill="none" stroke="black" points="63.5,-190 63.5,-208 123.5,-208 123.5,-190 63.5,-190"/> |
| <text text-anchor="start" x="87.5" y="-196.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="123.5,-190 123.5,-208 167.5,-208 167.5,-190 123.5,-190"/> |
| <polygon fill="none" stroke="black" points="123.5,-190 123.5,-208 167.5,-208 167.5,-190 123.5,-190"/> |
| <text text-anchor="start" x="148.5" y="-196.2" font-family="Helvetica,sans-Serif" font-size="11.00">2 ></text> |
| </a> |
| </g> |
| </g> |
| <!-- m_calendar_history->m_calendar --> |
| <g id="edge1" class="edge"> |
| <title>m_calendar_history:w->m_calendar:e</title> |
| <path fill="none" stroke="black" d="M202.78,-408.54C151.53,-387.39 243.14,-237 168.5,-237"/> |
| <polygon fill="black" stroke="black" points="209.12,-409.64 216.39,-414.55 213.06,-410.32 217,-411 217,-411 217,-411 213.06,-410.32 217.61,-407.45 209.12,-409.64 209.12,-409.64"/> |
| <ellipse fill="none" stroke="black" cx="205.96" cy="-409.09" 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="253,-37 253,-95 409,-95 409,-37 253,-37"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="253,-73 253,-95 409,-95 409,-73 253,-73"/> |
| <polygon fill="none" stroke="black" points="253,-73 253,-95 409,-95 409,-73 253,-73"/> |
| <text text-anchor="start" x="258" y="-82.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_calendar_instance</text> |
| <text text-anchor="start" x="374" y="-81.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="253,-55 253,-73 409,-73 409,-55 253,-55"/> |
| <text text-anchor="start" x="256" y="-61.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="253,-37 253,-55 311,-55 311,-37 253,-37"/> |
| <polygon fill="none" stroke="black" points="253,-37 253,-55 311,-55 311,-37 253,-37"/> |
| <text text-anchor="start" x="256" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 1</text> |
| <polygon fill="#ffffff" stroke="transparent" points="311,-37 311,-55 368,-55 368,-37 311,-37"/> |
| <polygon fill="none" stroke="black" points="311,-37 311,-55 368,-55 368,-37 311,-37"/> |
| <text text-anchor="start" x="332" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="368,-37 368,-55 409,-55 409,-37 368,-37"/> |
| <polygon fill="none" stroke="black" points="368,-37 368,-55 409,-55 409,-37 368,-37"/> |
| <text text-anchor="start" x="390" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">1 ></text> |
| </a> |
| </g> |
| </g> |
| <!-- m_calendar_instance->m_calendar --> |
| <g id="edge2" class="edge"> |
| <title>m_calendar_instance:w->m_calendar:e</title> |
| <path fill="none" stroke="black" d="M237.79,-66.39C223.27,-72.18 219.16,-87.82 208,-106 176.18,-157.82 229.31,-237 168.5,-237"/> |
| <polygon fill="black" stroke="black" points="244.11,-65.33 252.6,-67.55 248.06,-64.66 252,-64 252,-64 252,-64 248.06,-64.66 251.4,-60.45 244.11,-65.33 244.11,-65.33"/> |
| <ellipse fill="none" stroke="black" cx="240.96" cy="-65.86" rx="3.2" ry="3.2"/> |
| </g> |
| </g> |
| </svg> |
