| <?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="488pt" height="370pt" |
| viewBox="0.00 0.00 488.00 370.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 366)"> |
| <title>twoDegreesRelationshipsDiagram</title> |
| <polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-366 484,-366 484,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_holiday_office --> |
| <g id="node1" class="node"> |
| <title>m_holiday_office</title> |
| <g id="a_node1"><a xlink:href="../../tables/m_holiday_office.html" xlink:title="m_holiday_office" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="338,-153 338,-237 472,-237 472,-153 338,-153"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="338,-215 338,-237 472,-237 472,-215 338,-215"/> |
| <polygon fill="none" stroke="black" points="338,-215 338,-237 472,-237 472,-215 338,-215"/> |
| <text text-anchor="start" x="343" y="-224.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_holiday_office</text> |
| <text text-anchor="start" x="437" y="-223.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="338,-193 338,-215 472,-215 472,-193 338,-193"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="343" y="-210"/> |
| <text text-anchor="start" x="359" y="-201.2" font-family="Helvetica,sans-Serif" font-size="11.00">holiday_id</text> |
| <polygon fill="none" stroke="black" points="338,-171 338,-193 472,-193 472,-171 338,-171"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="343" y="-188"/> |
| <text text-anchor="start" x="359" y="-179.2" font-family="Helvetica,sans-Serif" font-size="11.00">office_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="338,-153 338,-171 390,-171 390,-153 338,-153"/> |
| <polygon fill="none" stroke="black" points="338,-153 338,-171 390,-171 390,-153 338,-153"/> |
| <text text-anchor="start" x="341" y="-159.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 2</text> |
| <polygon fill="#ffffff" stroke="transparent" points="390,-153 390,-171 444,-171 444,-153 390,-153"/> |
| <polygon fill="none" stroke="black" points="390,-153 390,-171 444,-171 444,-153 390,-153"/> |
| <text text-anchor="start" x="408" y="-159.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="444,-153 444,-171 472,-171 472,-153 444,-153"/> |
| <polygon fill="none" stroke="black" points="444,-153 444,-171 472,-171 472,-153 444,-153"/> |
| <text text-anchor="start" x="462" y="-159.2" font-family="Helvetica,sans-Serif" font-size="11.00">  </text> |
| </a> |
| </g> |
| </g> |
| <!-- m_holiday --> |
| <g id="node2" class="node"> |
| <title>m_holiday</title> |
| <g id="a_node2"><a xlink:href="../../tables/m_holiday.html" xlink:title="m_holiday" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="8,-116 8,-358 289,-358 289,-116 8,-116"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="10.5,-334 10.5,-356 287.5,-356 287.5,-334 10.5,-334"/> |
| <polygon fill="none" stroke="black" points="10.5,-334 10.5,-356 287.5,-356 287.5,-334 10.5,-334"/> |
| <text text-anchor="start" x="15.5" y="-343.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_holiday</text> |
| <text text-anchor="start" x="252.5" y="-342.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="10.5,-312 10.5,-334 220.5,-334 220.5,-312 10.5,-312"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="15.5" y="-329"/> |
| <text text-anchor="start" x="30.5" y="-320.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="none" stroke="black" points="220.5,-312 220.5,-334 287.5,-334 287.5,-312 220.5,-312"/> |
| <text text-anchor="start" x="223.5" y="-320.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="10.5,-290 10.5,-312 220.5,-312 220.5,-290 10.5,-290"/> |
| <polygon fill="none" stroke="black" points="10.5,-290 10.5,-312 220.5,-312 220.5,-290 10.5,-290"/> |
| <text text-anchor="start" x="30.5" y="-298.2" font-family="Helvetica,sans-Serif" font-size="11.00">name</text> |
| <polygon fill="none" stroke="black" points="220.5,-290 220.5,-312 287.5,-312 287.5,-290 220.5,-290"/> |
| <text text-anchor="start" x="223.5" y="-298.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[100]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="10.5,-268 10.5,-290 220.5,-290 220.5,-268 10.5,-268"/> |
| <polygon fill="none" stroke="black" points="10.5,-268 10.5,-290 220.5,-290 220.5,-268 10.5,-268"/> |
| <text text-anchor="start" x="30.5" y="-276.2" font-family="Helvetica,sans-Serif" font-size="11.00">from_date</text> |
| <polygon fill="none" stroke="black" points="220.5,-268 220.5,-290 287.5,-290 287.5,-268 220.5,-268"/> |
| <text text-anchor="start" x="223.5" y="-276.2" font-family="Helvetica,sans-Serif" font-size="11.00">datetime[19]</text> |
| <polygon fill="none" stroke="black" points="10.5,-246 10.5,-268 220.5,-268 220.5,-246 10.5,-246"/> |
| <text text-anchor="start" x="30.5" y="-254.2" font-family="Helvetica,sans-Serif" font-size="11.00">to_date</text> |
| <polygon fill="none" stroke="black" points="220.5,-246 220.5,-268 287.5,-268 287.5,-246 220.5,-246"/> |
| <text text-anchor="start" x="223.5" y="-254.2" font-family="Helvetica,sans-Serif" font-size="11.00">datetime[19]</text> |
| <polygon fill="none" stroke="black" points="10.5,-224 10.5,-246 220.5,-246 220.5,-224 10.5,-224"/> |
| <text text-anchor="start" x="30.5" y="-232.2" font-family="Helvetica,sans-Serif" font-size="11.00">repayments_rescheduled_to</text> |
| <polygon fill="none" stroke="black" points="220.5,-224 220.5,-246 287.5,-246 287.5,-224 220.5,-224"/> |
| <text text-anchor="start" x="223.5" y="-232.2" font-family="Helvetica,sans-Serif" font-size="11.00">datetime[19]</text> |
| <polygon fill="none" stroke="black" points="10.5,-202 10.5,-224 220.5,-224 220.5,-202 10.5,-202"/> |
| <text text-anchor="start" x="30.5" y="-210.2" font-family="Helvetica,sans-Serif" font-size="11.00">status_enum</text> |
| <polygon fill="none" stroke="black" points="220.5,-202 220.5,-224 287.5,-224 287.5,-202 220.5,-202"/> |
| <text text-anchor="start" x="223.5" y="-210.2" font-family="Helvetica,sans-Serif" font-size="11.00">int[10]</text> |
| <polygon fill="none" stroke="black" points="10.5,-180 10.5,-202 220.5,-202 220.5,-180 10.5,-180"/> |
| <text text-anchor="start" x="30.5" y="-188.2" font-family="Helvetica,sans-Serif" font-size="11.00">processed</text> |
| <polygon fill="none" stroke="black" points="220.5,-180 220.5,-202 287.5,-202 287.5,-180 220.5,-180"/> |
| <text text-anchor="start" x="223.5" y="-188.2" font-family="Helvetica,sans-Serif" font-size="11.00">bit[1]</text> |
| <polygon fill="none" stroke="black" points="10.5,-158 10.5,-180 220.5,-180 220.5,-158 10.5,-158"/> |
| <text text-anchor="start" x="30.5" y="-166.2" font-family="Helvetica,sans-Serif" font-size="11.00">description</text> |
| <polygon fill="none" stroke="black" points="220.5,-158 220.5,-180 287.5,-180 287.5,-158 220.5,-158"/> |
| <text text-anchor="start" x="223.5" y="-166.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[100]</text> |
| <polygon fill="none" stroke="black" points="10.5,-136 10.5,-158 220.5,-158 220.5,-136 10.5,-136"/> |
| <text text-anchor="start" x="30.5" y="-144.2" font-family="Helvetica,sans-Serif" font-size="11.00">rescheduling_type</text> |
| <polygon fill="none" stroke="black" points="220.5,-136 220.5,-158 287.5,-158 287.5,-136 220.5,-136"/> |
| <text text-anchor="start" x="223.5" y="-144.2" font-family="Helvetica,sans-Serif" font-size="11.00">int[10]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="10.5,-118 10.5,-136 106.5,-136 106.5,-118 10.5,-118"/> |
| <polygon fill="none" stroke="black" points="10.5,-118 10.5,-136 106.5,-136 106.5,-118 10.5,-118"/> |
| <text text-anchor="start" x="13.5" y="-124.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 0</text> |
| <polygon fill="#ffffff" stroke="transparent" points="106.5,-118 106.5,-136 220.5,-136 220.5,-118 106.5,-118"/> |
| <polygon fill="none" stroke="black" points="106.5,-118 106.5,-136 220.5,-136 220.5,-118 106.5,-118"/> |
| <text text-anchor="start" x="184.5" y="-124.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="220.5,-118 220.5,-136 287.5,-136 287.5,-118 220.5,-118"/> |
| <polygon fill="none" stroke="black" points="220.5,-118 220.5,-136 287.5,-136 287.5,-118 220.5,-118"/> |
| <text text-anchor="start" x="268.5" y="-124.2" font-family="Helvetica,sans-Serif" font-size="11.00">1 ></text> |
| <polygon fill="none" stroke="black" stroke-width="2" points="9,-117 9,-357 288,-357 288,-117 9,-117"/> |
| </a> |
| </g> |
| </g> |
| <!-- m_holiday_office->m_holiday --> |
| <g id="edge1" class="edge"> |
| <title>m_holiday_office:w->m_holiday:e</title> |
| <path fill="none" stroke="black" d="M322.74,-207.69C292.38,-227.78 339.59,-323 288.5,-323"/> |
| <polygon fill="black" stroke="black" points="329.26,-206.01 337.9,-207.49 333.13,-205 337,-204 337,-204 337,-204 333.13,-205 336.1,-200.51 329.26,-206.01 329.26,-206.01"/> |
| <ellipse fill="none" stroke="black" cx="326.16" cy="-206.81" rx="3.2" ry="3.2"/> |
| </g> |
| <!-- m_office --> |
| <g id="node3" class="node"> |
| <title>m_office</title> |
| <g id="a_node3"><a xlink:href="../../tables/m_office.html" xlink:title="m_office" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="103.5,-37 103.5,-95 193.5,-95 193.5,-37 103.5,-37"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="103.5,-73 103.5,-95 193.5,-95 193.5,-73 103.5,-73"/> |
| <polygon fill="none" stroke="black" points="103.5,-73 103.5,-95 193.5,-95 193.5,-73 103.5,-73"/> |
| <text text-anchor="start" x="108.5" y="-82.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_office</text> |
| <text text-anchor="start" x="158.5" y="-81.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="103.5,-55 103.5,-73 193.5,-73 193.5,-55 103.5,-55"/> |
| <text text-anchor="start" x="106.5" y="-61.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="103.5,-37 103.5,-55 125.5,-55 125.5,-37 103.5,-37"/> |
| <polygon fill="none" stroke="black" points="103.5,-37 103.5,-55 125.5,-55 125.5,-37 103.5,-37"/> |
| <text text-anchor="start" x="106.5" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 1</text> |
| <polygon fill="#ffffff" stroke="transparent" points="125.5,-37 125.5,-55 164.5,-55 164.5,-37 125.5,-37"/> |
| <polygon fill="none" stroke="black" points="125.5,-37 125.5,-55 164.5,-55 164.5,-37 125.5,-37"/> |
| <text text-anchor="start" x="128.5" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="164.5,-37 164.5,-55 193.5,-55 193.5,-37 164.5,-37"/> |
| <polygon fill="none" stroke="black" points="164.5,-37 164.5,-55 193.5,-55 193.5,-37 164.5,-37"/> |
| <text text-anchor="start" x="168.5" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">20 ></text> |
| </a> |
| </g> |
| </g> |
| <!-- m_holiday_office->m_office --> |
| <g id="edge2" class="edge"> |
| <title>m_holiday_office:w->m_office:e</title> |
| <path fill="none" stroke="black" d="M322.9,-178.27C306.03,-166.15 320.61,-127.46 297,-106 260.56,-72.89 243.73,-64 194.5,-64"/> |
| <polygon fill="black" stroke="black" points="329.27,-179.95 336.08,-185.48 333.13,-180.98 337,-182 337,-182 337,-182 333.13,-180.98 337.92,-178.52 329.27,-179.95 329.27,-179.95"/> |
| <ellipse fill="none" stroke="black" cx="326.17" cy="-179.13" rx="3.2" ry="3.2"/> |
| </g> |
| </g> |
| </svg> |
