| <?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="531pt" height="505pt" |
| viewBox="0.00 0.00 531.00 505.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 501)"> |
| <title>oneDegreeRelationshipsDiagram</title> |
| <polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-501 527,-501 527,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> |
| <!-- client_device_registration --> |
| <g id="node1" class="node"> |
| <title>client_device_registration</title> |
| <g id="a_node1"><a xlink:href="../../tables/client_device_registration.html" xlink:title="client_device_registration" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="250,-361 250,-493 515,-493 515,-361 250,-361"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="252.5,-469 252.5,-491 513.5,-491 513.5,-469 252.5,-469"/> |
| <polygon fill="none" stroke="black" points="252.5,-469 252.5,-491 513.5,-491 513.5,-469 252.5,-469"/> |
| <text text-anchor="start" x="257.5" y="-478.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">client_device_registration</text> |
| <text text-anchor="start" x="478.5" y="-477.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="252.5,-447 252.5,-469 446.5,-469 446.5,-447 252.5,-447"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="257.5" y="-464"/> |
| <text text-anchor="start" x="272.5" y="-455.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="none" stroke="black" points="446.5,-447 446.5,-469 513.5,-469 513.5,-447 446.5,-447"/> |
| <text text-anchor="start" x="449.5" y="-455.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="252.5,-425 252.5,-447 446.5,-447 446.5,-425 252.5,-425"/> |
| <polygon fill="none" stroke="black" points="252.5,-425 252.5,-447 446.5,-447 446.5,-425 252.5,-425"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="257.5" y="-442"/> |
| <text text-anchor="start" x="272.5" y="-433.2" font-family="Helvetica,sans-Serif" font-size="11.00">client_id</text> |
| <polygon fill="none" stroke="black" points="446.5,-425 446.5,-447 513.5,-447 513.5,-425 446.5,-425"/> |
| <text text-anchor="start" x="449.5" y="-433.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="none" stroke="black" points="252.5,-403 252.5,-425 446.5,-425 446.5,-403 252.5,-403"/> |
| <text text-anchor="start" x="272.5" y="-411.2" font-family="Helvetica,sans-Serif" font-size="11.00">updatedon_date</text> |
| <polygon fill="none" stroke="black" points="446.5,-403 446.5,-425 513.5,-425 513.5,-403 446.5,-403"/> |
| <text text-anchor="start" x="449.5" y="-411.2" font-family="Helvetica,sans-Serif" font-size="11.00">datetime[19]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="252.5,-381 252.5,-403 446.5,-403 446.5,-381 252.5,-381"/> |
| <polygon fill="none" stroke="black" points="252.5,-381 252.5,-403 446.5,-403 446.5,-381 252.5,-381"/> |
| <text text-anchor="start" x="272.5" y="-389.2" font-family="Helvetica,sans-Serif" font-size="11.00">registration_id</text> |
| <polygon fill="none" stroke="black" points="446.5,-381 446.5,-403 513.5,-403 513.5,-381 446.5,-381"/> |
| <text text-anchor="start" x="449.5" y="-389.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[255]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="252.5,-363 252.5,-381 340.5,-381 340.5,-363 252.5,-363"/> |
| <polygon fill="none" stroke="black" points="252.5,-363 252.5,-381 340.5,-381 340.5,-363 252.5,-363"/> |
| <text text-anchor="start" x="255.5" y="-369.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 1</text> |
| <polygon fill="#ffffff" stroke="transparent" points="340.5,-363 340.5,-381 446.5,-381 446.5,-363 340.5,-363"/> |
| <polygon fill="none" stroke="black" points="340.5,-363 340.5,-381 446.5,-381 446.5,-363 340.5,-363"/> |
| <text text-anchor="start" x="410.5" y="-369.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="446.5,-363 446.5,-381 513.5,-381 513.5,-363 446.5,-363"/> |
| <polygon fill="none" stroke="black" points="446.5,-363 446.5,-381 513.5,-381 513.5,-363 446.5,-363"/> |
| <text text-anchor="start" x="494.5" y="-369.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 ></text> |
| <polygon fill="none" stroke="black" stroke-width="2" points="251,-362 251,-492 514,-492 514,-362 251,-362"/> |
| </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,-37 8,-469 201,-469 201,-37 8,-37"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="8.5,-447 8.5,-469 201.5,-469 201.5,-447 8.5,-447"/> |
| <polygon fill="none" stroke="black" points="8.5,-447 8.5,-469 201.5,-469 201.5,-447 8.5,-447"/> |
| <text text-anchor="start" x="13.5" y="-456.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_client</text> |
| <text text-anchor="start" x="166.5" y="-455.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="8.5,-425 8.5,-447 201.5,-447 201.5,-425 8.5,-425"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-442"/> |
| <text text-anchor="start" x="28.5" y="-433.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-403 8.5,-425 201.5,-425 201.5,-403 8.5,-403"/> |
| <polygon fill="none" stroke="black" points="8.5,-403 8.5,-425 201.5,-425 201.5,-403 8.5,-403"/> |
| <text text-anchor="start" x="28.5" y="-411.2" font-family="Helvetica,sans-Serif" font-size="11.00">account_no</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-381 8.5,-403 201.5,-403 201.5,-381 8.5,-381"/> |
| <polygon fill="none" stroke="black" points="8.5,-381 8.5,-403 201.5,-403 201.5,-381 8.5,-381"/> |
| <text text-anchor="start" x="28.5" y="-389.2" font-family="Helvetica,sans-Serif" font-size="11.00">external_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-359 8.5,-381 201.5,-381 201.5,-359 8.5,-359"/> |
| <polygon fill="none" stroke="black" points="8.5,-359 8.5,-381 201.5,-381 201.5,-359 8.5,-359"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-376"/> |
| <text text-anchor="start" x="28.5" y="-367.2" font-family="Helvetica,sans-Serif" font-size="11.00">sub_status</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-337 8.5,-359 201.5,-359 201.5,-337 8.5,-337"/> |
| <polygon fill="none" stroke="black" points="8.5,-337 8.5,-359 201.5,-359 201.5,-337 8.5,-337"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-354"/> |
| <text text-anchor="start" x="28.5" y="-345.2" font-family="Helvetica,sans-Serif" font-size="11.00">office_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-315 8.5,-337 201.5,-337 201.5,-315 8.5,-315"/> |
| <polygon fill="none" stroke="black" points="8.5,-315 8.5,-337 201.5,-337 201.5,-315 8.5,-315"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-332"/> |
| <text text-anchor="start" x="28.5" y="-323.2" font-family="Helvetica,sans-Serif" font-size="11.00">transfer_to_office_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-293 8.5,-315 201.5,-315 201.5,-293 8.5,-293"/> |
| <polygon fill="none" stroke="black" points="8.5,-293 8.5,-315 201.5,-315 201.5,-293 8.5,-293"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-310"/> |
| <text text-anchor="start" x="28.5" y="-301.2" font-family="Helvetica,sans-Serif" font-size="11.00">staff_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-271 8.5,-293 201.5,-293 201.5,-271 8.5,-271"/> |
| <polygon fill="none" stroke="black" points="8.5,-271 8.5,-293 201.5,-293 201.5,-271 8.5,-271"/> |
| <text text-anchor="start" x="28.5" y="-279.2" font-family="Helvetica,sans-Serif" font-size="11.00">mobile_no</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-249 8.5,-271 201.5,-271 201.5,-249 8.5,-249"/> |
| <polygon fill="none" stroke="black" points="8.5,-249 8.5,-271 201.5,-271 201.5,-249 8.5,-249"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-266"/> |
| <text text-anchor="start" x="28.5" y="-257.2" font-family="Helvetica,sans-Serif" font-size="11.00">gender_cv_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-227 8.5,-249 201.5,-249 201.5,-227 8.5,-227"/> |
| <polygon fill="none" stroke="black" points="8.5,-227 8.5,-249 201.5,-249 201.5,-227 8.5,-227"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-244"/> |
| <text text-anchor="start" x="28.5" y="-235.2" font-family="Helvetica,sans-Serif" font-size="11.00">image_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-205 8.5,-227 201.5,-227 201.5,-205 8.5,-205"/> |
| <polygon fill="none" stroke="black" points="8.5,-205 8.5,-227 201.5,-227 201.5,-205 8.5,-205"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-222"/> |
| <text text-anchor="start" x="28.5" y="-213.2" font-family="Helvetica,sans-Serif" font-size="11.00">closure_reason_cv_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-183 8.5,-205 201.5,-205 201.5,-183 8.5,-183"/> |
| <polygon fill="none" stroke="black" points="8.5,-183 8.5,-205 201.5,-205 201.5,-183 8.5,-183"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-200"/> |
| <text text-anchor="start" x="28.5" y="-191.2" font-family="Helvetica,sans-Serif" font-size="11.00">default_savings_product</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-161 8.5,-183 201.5,-183 201.5,-161 8.5,-161"/> |
| <polygon fill="none" stroke="black" points="8.5,-161 8.5,-183 201.5,-183 201.5,-161 8.5,-161"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-178"/> |
| <text text-anchor="start" x="28.5" y="-169.2" font-family="Helvetica,sans-Serif" font-size="11.00">default_savings_account</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-139 8.5,-161 201.5,-161 201.5,-139 8.5,-139"/> |
| <polygon fill="none" stroke="black" points="8.5,-139 8.5,-161 201.5,-161 201.5,-139 8.5,-139"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-156"/> |
| <text text-anchor="start" x="28.5" y="-147.2" font-family="Helvetica,sans-Serif" font-size="11.00">client_type_cv_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-117 8.5,-139 201.5,-139 201.5,-117 8.5,-117"/> |
| <polygon fill="none" stroke="black" points="8.5,-117 8.5,-139 201.5,-139 201.5,-117 8.5,-117"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-134"/> |
| <text text-anchor="start" x="28.5" y="-125.2" font-family="Helvetica,sans-Serif" font-size="11.00">client_classification_cv_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-95 8.5,-117 201.5,-117 201.5,-95 8.5,-95"/> |
| <polygon fill="none" stroke="black" points="8.5,-95 8.5,-117 201.5,-117 201.5,-95 8.5,-95"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-112"/> |
| <text text-anchor="start" x="28.5" y="-103.2" font-family="Helvetica,sans-Serif" font-size="11.00">reject_reason_cv_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-73 8.5,-95 201.5,-95 201.5,-73 8.5,-73"/> |
| <polygon fill="none" stroke="black" points="8.5,-73 8.5,-95 201.5,-95 201.5,-73 8.5,-73"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-90"/> |
| <text text-anchor="start" x="28.5" y="-81.2" font-family="Helvetica,sans-Serif" font-size="11.00">withdraw_reason_cv_id</text> |
| <polygon fill="none" stroke="black" points="8.5,-55 8.5,-73 201.5,-73 201.5,-55 8.5,-55"/> |
| <text text-anchor="start" x="11.5" y="-61.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-37 8.5,-55 85.5,-55 85.5,-37 8.5,-37"/> |
| <polygon fill="none" stroke="black" points="8.5,-37 8.5,-55 85.5,-55 85.5,-37 8.5,-37"/> |
| <text text-anchor="start" x="11.5" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 13</text> |
| <polygon fill="#ffffff" stroke="transparent" points="85.5,-37 85.5,-55 148.5,-55 148.5,-37 85.5,-37"/> |
| <polygon fill="none" stroke="black" points="85.5,-37 85.5,-55 148.5,-55 148.5,-37 85.5,-37"/> |
| <text text-anchor="start" x="112.5" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="148.5,-37 148.5,-55 201.5,-55 201.5,-37 148.5,-37"/> |
| <polygon fill="none" stroke="black" points="148.5,-37 148.5,-55 201.5,-55 201.5,-37 148.5,-37"/> |
| <text text-anchor="start" x="176.5" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">23 ></text> |
| </a> |
| </g> |
| </g> |
| <!-- client_device_registration->m_client --> |
| <g id="edge1" class="edge"> |
| <title>client_device_registration:w->m_client:e</title> |
| <path fill="none" stroke="black" d="M240.76,-436C227.11,-436 220.19,-436 202.5,-436"/> |
| <polygon fill="black" stroke="black" points="250.7,-432 250.7,-440 249.1,-440 249.1,-432 250.7,-432"/> |
| <polyline fill="none" stroke="black" points="251.5,-436 247.5,-436 "/> |
| <ellipse fill="none" stroke="black" cx="244.3" cy="-436" rx="3.2" ry="3.2"/> |
| </g> |
| </g> |
| </svg> |
