| <?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: oneDegreeRelationshipsDiagram Pages: 1 --> |
| <svg width="502pt" height="608pt" |
| viewBox="0.00 0.00 502.00 608.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 604)"> |
| <title>oneDegreeRelationshipsDiagram</title> |
| <polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-604 498,-604 498,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_client_attendance --> |
| <g id="node1" class="node"> |
| <title>m_client_attendance</title> |
| <g id="a_node1"><a xlink:href="../../tables/m_client_attendance.html" xlink:title="m_client_attendance" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="250,-272 250,-404 486,-404 486,-272 250,-272"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="252,-380 252,-402 484,-402 484,-380 252,-380"/> |
| <polygon fill="none" stroke="black" points="252,-380 252,-402 484,-402 484,-380 252,-380"/> |
| <text text-anchor="start" x="257" y="-389.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_client_attendance</text> |
| <text text-anchor="start" x="449" y="-388.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="252,-358 252,-380 429,-380 429,-358 252,-358"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="257" y="-375"/> |
| <text text-anchor="start" x="272" y="-366.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="none" stroke="black" points="429,-358 429,-380 484,-380 484,-358 429,-358"/> |
| <text text-anchor="start" x="432" y="-366.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="252,-336 252,-358 429,-358 429,-336 252,-336"/> |
| <polygon fill="none" stroke="black" points="252,-336 252,-358 429,-358 429,-336 252,-336"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="257" y="-353"/> |
| <text text-anchor="start" x="272" y="-344.2" font-family="Helvetica,sans-Serif" font-size="11.00">client_id</text> |
| <polygon fill="none" stroke="black" points="429,-336 429,-358 484,-358 484,-336 429,-336"/> |
| <text text-anchor="start" x="432" y="-344.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="252,-314 252,-336 429,-336 429,-314 252,-314"/> |
| <polygon fill="none" stroke="black" points="252,-314 252,-336 429,-336 429,-314 252,-314"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="257" y="-331"/> |
| <text text-anchor="start" x="272" y="-322.2" font-family="Helvetica,sans-Serif" font-size="11.00">meeting_id</text> |
| <polygon fill="none" stroke="black" points="429,-314 429,-336 484,-336 484,-314 429,-314"/> |
| <text text-anchor="start" x="432" y="-322.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="none" stroke="black" points="252,-292 252,-314 429,-314 429,-292 252,-292"/> |
| <text text-anchor="start" x="272" y="-300.2" font-family="Helvetica,sans-Serif" font-size="11.00">attendance_type_enum</text> |
| <polygon fill="none" stroke="black" points="429,-292 429,-314 484,-314 484,-292 429,-292"/> |
| <text text-anchor="start" x="432" y="-300.2" font-family="Helvetica,sans-Serif" font-size="11.00">smallint[5]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="252,-274 252,-292 332,-292 332,-274 252,-274"/> |
| <polygon fill="none" stroke="black" points="252,-274 252,-292 332,-292 332,-274 252,-274"/> |
| <text text-anchor="start" x="255" y="-280.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 2</text> |
| <polygon fill="#ffffff" stroke="transparent" points="332,-274 332,-292 429,-292 429,-274 332,-274"/> |
| <polygon fill="none" stroke="black" points="332,-274 332,-292 429,-292 429,-274 332,-274"/> |
| <text text-anchor="start" x="393" y="-280.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="429,-274 429,-292 484,-292 484,-274 429,-274"/> |
| <polygon fill="none" stroke="black" points="429,-274 429,-292 484,-292 484,-274 429,-274"/> |
| <text text-anchor="start" x="465" y="-280.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 ></text> |
| <polygon fill="none" stroke="black" stroke-width="2" points="251,-273 251,-403 485,-403 485,-273 251,-273"/> |
| </a> |
| </g> |
| </g> |
| <!-- m_client --> |
| <g id="node2" class="node"> |
| <title>m_client</title> |
| <g id="a_node2"><a xlink:href="../../tables/m_client.html" xlink:title="m_client" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="8,-164 8,-596 201,-596 201,-164 8,-164"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="8.5,-574 8.5,-596 201.5,-596 201.5,-574 8.5,-574"/> |
| <polygon fill="none" stroke="black" points="8.5,-574 8.5,-596 201.5,-596 201.5,-574 8.5,-574"/> |
| <text text-anchor="start" x="13.5" y="-583.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_client</text> |
| <text text-anchor="start" x="166.5" y="-582.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="8.5,-552 8.5,-574 201.5,-574 201.5,-552 8.5,-552"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-569"/> |
| <text text-anchor="start" x="28.5" y="-560.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-530 8.5,-552 201.5,-552 201.5,-530 8.5,-530"/> |
| <polygon fill="none" stroke="black" points="8.5,-530 8.5,-552 201.5,-552 201.5,-530 8.5,-530"/> |
| <text text-anchor="start" x="28.5" y="-538.2" font-family="Helvetica,sans-Serif" font-size="11.00">account_no</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-508 8.5,-530 201.5,-530 201.5,-508 8.5,-508"/> |
| <polygon fill="none" stroke="black" points="8.5,-508 8.5,-530 201.5,-530 201.5,-508 8.5,-508"/> |
| <text text-anchor="start" x="28.5" y="-516.2" font-family="Helvetica,sans-Serif" font-size="11.00">external_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-486 8.5,-508 201.5,-508 201.5,-486 8.5,-486"/> |
| <polygon fill="none" stroke="black" points="8.5,-486 8.5,-508 201.5,-508 201.5,-486 8.5,-486"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-503"/> |
| <text text-anchor="start" x="28.5" y="-494.2" font-family="Helvetica,sans-Serif" font-size="11.00">sub_status</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-464 8.5,-486 201.5,-486 201.5,-464 8.5,-464"/> |
| <polygon fill="none" stroke="black" points="8.5,-464 8.5,-486 201.5,-486 201.5,-464 8.5,-464"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-481"/> |
| <text text-anchor="start" x="28.5" y="-472.2" font-family="Helvetica,sans-Serif" font-size="11.00">office_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-442 8.5,-464 201.5,-464 201.5,-442 8.5,-442"/> |
| <polygon fill="none" stroke="black" points="8.5,-442 8.5,-464 201.5,-464 201.5,-442 8.5,-442"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-459"/> |
| <text text-anchor="start" x="28.5" y="-450.2" font-family="Helvetica,sans-Serif" font-size="11.00">transfer_to_office_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-420 8.5,-442 201.5,-442 201.5,-420 8.5,-420"/> |
| <polygon fill="none" stroke="black" points="8.5,-420 8.5,-442 201.5,-442 201.5,-420 8.5,-420"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-437"/> |
| <text text-anchor="start" x="28.5" y="-428.2" font-family="Helvetica,sans-Serif" font-size="11.00">staff_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-398 8.5,-420 201.5,-420 201.5,-398 8.5,-398"/> |
| <polygon fill="none" stroke="black" points="8.5,-398 8.5,-420 201.5,-420 201.5,-398 8.5,-398"/> |
| <text text-anchor="start" x="28.5" y="-406.2" font-family="Helvetica,sans-Serif" font-size="11.00">mobile_no</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-376 8.5,-398 201.5,-398 201.5,-376 8.5,-376"/> |
| <polygon fill="none" stroke="black" points="8.5,-376 8.5,-398 201.5,-398 201.5,-376 8.5,-376"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-393"/> |
| <text text-anchor="start" x="28.5" y="-384.2" font-family="Helvetica,sans-Serif" font-size="11.00">gender_cv_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-354 8.5,-376 201.5,-376 201.5,-354 8.5,-354"/> |
| <polygon fill="none" stroke="black" points="8.5,-354 8.5,-376 201.5,-376 201.5,-354 8.5,-354"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-371"/> |
| <text text-anchor="start" x="28.5" y="-362.2" font-family="Helvetica,sans-Serif" font-size="11.00">image_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-332 8.5,-354 201.5,-354 201.5,-332 8.5,-332"/> |
| <polygon fill="none" stroke="black" points="8.5,-332 8.5,-354 201.5,-354 201.5,-332 8.5,-332"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-349"/> |
| <text text-anchor="start" x="28.5" y="-340.2" font-family="Helvetica,sans-Serif" font-size="11.00">closure_reason_cv_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-310 8.5,-332 201.5,-332 201.5,-310 8.5,-310"/> |
| <polygon fill="none" stroke="black" points="8.5,-310 8.5,-332 201.5,-332 201.5,-310 8.5,-310"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-327"/> |
| <text text-anchor="start" x="28.5" y="-318.2" font-family="Helvetica,sans-Serif" font-size="11.00">default_savings_product</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-288 8.5,-310 201.5,-310 201.5,-288 8.5,-288"/> |
| <polygon fill="none" stroke="black" points="8.5,-288 8.5,-310 201.5,-310 201.5,-288 8.5,-288"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-305"/> |
| <text text-anchor="start" x="28.5" y="-296.2" font-family="Helvetica,sans-Serif" font-size="11.00">default_savings_account</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-266 8.5,-288 201.5,-288 201.5,-266 8.5,-266"/> |
| <polygon fill="none" stroke="black" points="8.5,-266 8.5,-288 201.5,-288 201.5,-266 8.5,-266"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-283"/> |
| <text text-anchor="start" x="28.5" y="-274.2" font-family="Helvetica,sans-Serif" font-size="11.00">client_type_cv_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-244 8.5,-266 201.5,-266 201.5,-244 8.5,-244"/> |
| <polygon fill="none" stroke="black" points="8.5,-244 8.5,-266 201.5,-266 201.5,-244 8.5,-244"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-261"/> |
| <text text-anchor="start" x="28.5" y="-252.2" font-family="Helvetica,sans-Serif" font-size="11.00">client_classification_cv_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-222 8.5,-244 201.5,-244 201.5,-222 8.5,-222"/> |
| <polygon fill="none" stroke="black" points="8.5,-222 8.5,-244 201.5,-244 201.5,-222 8.5,-222"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-239"/> |
| <text text-anchor="start" x="28.5" y="-230.2" font-family="Helvetica,sans-Serif" font-size="11.00">reject_reason_cv_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-200 8.5,-222 201.5,-222 201.5,-200 8.5,-200"/> |
| <polygon fill="none" stroke="black" points="8.5,-200 8.5,-222 201.5,-222 201.5,-200 8.5,-200"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-217"/> |
| <text text-anchor="start" x="28.5" y="-208.2" font-family="Helvetica,sans-Serif" font-size="11.00">withdraw_reason_cv_id</text> |
| <polygon fill="none" stroke="black" points="8.5,-182 8.5,-200 201.5,-200 201.5,-182 8.5,-182"/> |
| <text text-anchor="start" x="11.5" y="-188.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-164 8.5,-182 85.5,-182 85.5,-164 8.5,-164"/> |
| <polygon fill="none" stroke="black" points="8.5,-164 8.5,-182 85.5,-182 85.5,-164 8.5,-164"/> |
| <text text-anchor="start" x="11.5" y="-170.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 13</text> |
| <polygon fill="#ffffff" stroke="transparent" points="85.5,-164 85.5,-182 148.5,-182 148.5,-164 85.5,-164"/> |
| <polygon fill="none" stroke="black" points="85.5,-164 85.5,-182 148.5,-182 148.5,-164 85.5,-164"/> |
| <text text-anchor="start" x="112.5" y="-170.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="148.5,-164 148.5,-182 201.5,-182 201.5,-164 148.5,-164"/> |
| <polygon fill="none" stroke="black" points="148.5,-164 148.5,-182 201.5,-182 201.5,-164 148.5,-164"/> |
| <text text-anchor="start" x="176.5" y="-170.2" font-family="Helvetica,sans-Serif" font-size="11.00">23 ></text> |
| </a> |
| </g> |
| </g> |
| <!-- m_client_attendance->m_client --> |
| <g id="edge1" class="edge"> |
| <title>m_client_attendance:w->m_client:e</title> |
| <path fill="none" stroke="black" d="M236.57,-349C168.62,-370.78 295.32,-563 202.5,-563"/> |
| <polygon fill="black" stroke="black" points="243.08,-348.1 251.49,-350.57 247.04,-347.55 251,-347 251,-347 251,-347 247.04,-347.55 250.51,-343.43 243.08,-348.1 243.08,-348.1"/> |
| <ellipse fill="none" stroke="black" cx="239.91" cy="-348.54" rx="3.2" ry="3.2"/> |
| </g> |
| <!-- m_meeting --> |
| <g id="node3" class="node"> |
| <title>m_meeting</title> |
| <g id="a_node3"><a xlink:href="../../tables/m_meeting.html" xlink:title="m_meeting" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="24,-37 24,-143 185,-143 185,-37 24,-37"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="24.5,-121 24.5,-143 185.5,-143 185.5,-121 24.5,-121"/> |
| <polygon fill="none" stroke="black" points="24.5,-121 24.5,-143 185.5,-143 185.5,-121 24.5,-121"/> |
| <text text-anchor="start" x="29.5" y="-130.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_meeting</text> |
| <text text-anchor="start" x="150.5" y="-129.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="24.5,-99 24.5,-121 185.5,-121 185.5,-99 24.5,-99"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="29.5" y="-116"/> |
| <text text-anchor="start" x="44.5" y="-107.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="24.5,-77 24.5,-99 185.5,-99 185.5,-77 24.5,-77"/> |
| <polygon fill="none" stroke="black" points="24.5,-77 24.5,-99 185.5,-99 185.5,-77 24.5,-77"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="29.5" y="-94"/> |
| <text text-anchor="start" x="44.5" y="-85.2" font-family="Helvetica,sans-Serif" font-size="11.00">calendar_instance_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="24.5,-55 24.5,-77 185.5,-77 185.5,-55 24.5,-55"/> |
| <polygon fill="none" stroke="black" points="24.5,-55 24.5,-77 185.5,-77 185.5,-55 24.5,-55"/> |
| <text text-anchor="start" x="44.5" y="-63.2" font-family="Helvetica,sans-Serif" font-size="11.00">meeting_date</text> |
| <polygon fill="#ffffff" stroke="transparent" points="24.5,-37 24.5,-55 85.5,-55 85.5,-37 24.5,-37"/> |
| <polygon fill="none" stroke="black" points="24.5,-37 24.5,-55 85.5,-55 85.5,-37 24.5,-37"/> |
| <text text-anchor="start" x="27.5" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 1</text> |
| <polygon fill="#ffffff" stroke="transparent" points="85.5,-37 85.5,-55 143.5,-55 143.5,-37 85.5,-37"/> |
| <polygon fill="none" stroke="black" points="85.5,-37 85.5,-55 143.5,-55 143.5,-37 85.5,-37"/> |
| <text text-anchor="start" x="107.5" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="143.5,-37 143.5,-55 185.5,-55 185.5,-37 143.5,-37"/> |
| <polygon fill="none" stroke="black" points="143.5,-37 143.5,-55 185.5,-55 185.5,-37 143.5,-37"/> |
| <text text-anchor="start" x="166.5" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">1 ></text> |
| </a> |
| </g> |
| </g> |
| <!-- m_client_attendance->m_meeting --> |
| <g id="edge2" class="edge"> |
| <title>m_client_attendance:w->m_meeting:e</title> |
| <path fill="none" stroke="black" d="M236.66,-323.14C165.3,-302.13 280.81,-110 186.5,-110"/> |
| <polygon fill="black" stroke="black" points="243.07,-323.97 250.54,-328.57 247.03,-324.49 251,-325 251,-325 251,-325 247.03,-324.49 251.46,-321.43 243.07,-323.97 243.07,-323.97"/> |
| <ellipse fill="none" stroke="black" cx="239.89" cy="-323.56" rx="3.2" ry="3.2"/> |
| </g> |
| </g> |
| </svg> |