| <?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="599pt" height="670pt" |
| viewBox="0.00 0.00 599.00 670.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 666)"> |
| <title>oneDegreeRelationshipsDiagram</title> |
| <polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-666 595,-666 595,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_selfservice_user_client_mapping --> |
| <g id="node1" class="node"> |
| <title>m_selfservice_user_client_mapping</title> |
| <g id="a_node1"><a xlink:href="../../tables/m_selfservice_user_client_mapping.html" xlink:title="m_selfservice_user_client_mapping" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="272,-488 272,-598 583,-598 583,-488 272,-488"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="274.5,-574 274.5,-596 581.5,-596 581.5,-574 274.5,-574"/> |
| <polygon fill="none" stroke="black" points="274.5,-574 274.5,-596 581.5,-596 581.5,-574 274.5,-574"/> |
| <text text-anchor="start" x="279.5" y="-583.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_selfservice_user_client_mapping</text> |
| <text text-anchor="start" x="546.5" y="-582.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="274.5,-552 274.5,-574 531.5,-574 531.5,-552 274.5,-552"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="279.5" y="-569"/> |
| <text text-anchor="start" x="294.5" y="-560.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="none" stroke="black" points="531.5,-552 531.5,-574 581.5,-574 581.5,-552 531.5,-552"/> |
| <text text-anchor="start" x="534.5" y="-560.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="274.5,-530 274.5,-552 531.5,-552 531.5,-530 274.5,-530"/> |
| <polygon fill="none" stroke="black" points="274.5,-530 274.5,-552 531.5,-552 531.5,-530 274.5,-530"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="279.5" y="-547"/> |
| <text text-anchor="start" x="294.5" y="-538.2" font-family="Helvetica,sans-Serif" font-size="11.00">appuser_id</text> |
| <polygon fill="none" stroke="black" points="531.5,-530 531.5,-552 581.5,-552 581.5,-530 531.5,-530"/> |
| <text text-anchor="start" x="534.5" y="-538.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="274.5,-508 274.5,-530 531.5,-530 531.5,-508 274.5,-508"/> |
| <polygon fill="none" stroke="black" points="274.5,-508 274.5,-530 531.5,-530 531.5,-508 274.5,-508"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="279.5" y="-525"/> |
| <text text-anchor="start" x="294.5" y="-516.2" font-family="Helvetica,sans-Serif" font-size="11.00">client_id</text> |
| <polygon fill="none" stroke="black" points="531.5,-508 531.5,-530 581.5,-530 581.5,-508 531.5,-508"/> |
| <text text-anchor="start" x="534.5" y="-516.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="274.5,-490 274.5,-508 394.5,-508 394.5,-490 274.5,-490"/> |
| <polygon fill="none" stroke="black" points="274.5,-490 274.5,-508 394.5,-508 394.5,-490 274.5,-490"/> |
| <text text-anchor="start" x="277.5" y="-496.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 2</text> |
| <polygon fill="#ffffff" stroke="transparent" points="394.5,-490 394.5,-508 531.5,-508 531.5,-490 394.5,-490"/> |
| <polygon fill="none" stroke="black" points="394.5,-490 394.5,-508 531.5,-508 531.5,-490 394.5,-490"/> |
| <text text-anchor="start" x="495.5" y="-496.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="531.5,-490 531.5,-508 581.5,-508 581.5,-490 531.5,-490"/> |
| <polygon fill="none" stroke="black" points="531.5,-490 531.5,-508 581.5,-508 581.5,-490 531.5,-490"/> |
| <text text-anchor="start" x="562.5" y="-496.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 ></text> |
| <polygon fill="none" stroke="black" stroke-width="2" points="273,-489 273,-597 582,-597 582,-489 273,-489"/> |
| </a> |
| </g> |
| </g> |
| <!-- m_appuser --> |
| <g id="node2" class="node"> |
| <title>m_appuser</title> |
| <g id="a_node2"><a xlink:href="../../tables/m_appuser.html" xlink:title="m_appuser" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="8,-490 8,-658 223,-658 223,-490 8,-490"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="8.5,-636 8.5,-658 223.5,-658 223.5,-636 8.5,-636"/> |
| <polygon fill="none" stroke="black" points="8.5,-636 8.5,-658 223.5,-658 223.5,-636 8.5,-636"/> |
| <text text-anchor="start" x="13.5" y="-645.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_appuser</text> |
| <text text-anchor="start" x="188.5" y="-644.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="8.5,-614 8.5,-636 223.5,-636 223.5,-614 8.5,-614"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-631"/> |
| <text text-anchor="start" x="28.5" y="-622.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-592 8.5,-614 223.5,-614 223.5,-592 8.5,-592"/> |
| <polygon fill="none" stroke="black" points="8.5,-592 8.5,-614 223.5,-614 223.5,-592 8.5,-592"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-609"/> |
| <text text-anchor="start" x="28.5" y="-600.2" font-family="Helvetica,sans-Serif" font-size="11.00">office_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-570 8.5,-592 223.5,-592 223.5,-570 8.5,-570"/> |
| <polygon fill="none" stroke="black" points="8.5,-570 8.5,-592 223.5,-592 223.5,-570 8.5,-570"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-587"/> |
| <text text-anchor="start" x="28.5" y="-578.2" font-family="Helvetica,sans-Serif" font-size="11.00">staff_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-548 8.5,-570 223.5,-570 223.5,-548 8.5,-548"/> |
| <polygon fill="none" stroke="black" points="8.5,-548 8.5,-570 223.5,-570 223.5,-548 8.5,-548"/> |
| <text text-anchor="start" x="28.5" y="-556.2" font-family="Helvetica,sans-Serif" font-size="11.00">username</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-526 8.5,-548 223.5,-548 223.5,-526 8.5,-526"/> |
| <polygon fill="none" stroke="black" points="8.5,-526 8.5,-548 223.5,-548 223.5,-526 8.5,-526"/> |
| <text text-anchor="start" x="28.5" y="-534.2" font-family="Helvetica,sans-Serif" font-size="11.00">last_time_password_updated</text> |
| <polygon fill="none" stroke="black" points="8.5,-508 8.5,-526 223.5,-526 223.5,-508 8.5,-508"/> |
| <text text-anchor="start" x="11.5" y="-514.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-490 8.5,-508 93.5,-508 93.5,-490 8.5,-490"/> |
| <polygon fill="none" stroke="black" points="8.5,-490 8.5,-508 93.5,-508 93.5,-490 8.5,-490"/> |
| <text text-anchor="start" x="11.5" y="-496.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 2</text> |
| <polygon fill="#ffffff" stroke="transparent" points="93.5,-490 93.5,-508 163.5,-508 163.5,-490 93.5,-490"/> |
| <polygon fill="none" stroke="black" points="93.5,-490 93.5,-508 163.5,-508 163.5,-490 93.5,-490"/> |
| <text text-anchor="start" x="127.5" y="-496.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="163.5,-490 163.5,-508 223.5,-508 223.5,-490 163.5,-490"/> |
| <polygon fill="none" stroke="black" points="163.5,-490 163.5,-508 223.5,-508 223.5,-490 163.5,-490"/> |
| <text text-anchor="start" x="198.5" y="-496.2" font-family="Helvetica,sans-Serif" font-size="11.00">57 ></text> |
| </a> |
| </g> |
| </g> |
| <!-- m_selfservice_user_client_mapping->m_appuser --> |
| <g id="edge1" class="edge"> |
| <title>m_selfservice_user_client_mapping:w->m_appuser:e</title> |
| <path fill="none" stroke="black" d="M259.6,-545.52C239.21,-562.96 261.64,-625 224.5,-625"/> |
| <polygon fill="black" stroke="black" points="265.89,-543.47 274.61,-544.42 269.7,-542.24 273.5,-541 273.5,-541 273.5,-541 269.7,-542.24 272.39,-537.58 265.89,-543.47 265.89,-543.47"/> |
| <ellipse fill="none" stroke="black" cx="262.85" cy="-544.46" rx="3.2" ry="3.2"/> |
| </g> |
| <!-- m_client --> |
| <g id="node3" class="node"> |
| <title>m_client</title> |
| <g id="a_node3"><a xlink:href="../../tables/m_client.html" xlink:title="m_client" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="19,-37 19,-469 212,-469 212,-37 19,-37"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="19.5,-447 19.5,-469 212.5,-469 212.5,-447 19.5,-447"/> |
| <polygon fill="none" stroke="black" points="19.5,-447 19.5,-469 212.5,-469 212.5,-447 19.5,-447"/> |
| <text text-anchor="start" x="24.5" y="-456.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_client</text> |
| <text text-anchor="start" x="177.5" y="-455.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="19.5,-425 19.5,-447 212.5,-447 212.5,-425 19.5,-425"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="24.5" y="-442"/> |
| <text text-anchor="start" x="39.5" y="-433.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="19.5,-403 19.5,-425 212.5,-425 212.5,-403 19.5,-403"/> |
| <polygon fill="none" stroke="black" points="19.5,-403 19.5,-425 212.5,-425 212.5,-403 19.5,-403"/> |
| <text text-anchor="start" x="39.5" y="-411.2" font-family="Helvetica,sans-Serif" font-size="11.00">account_no</text> |
| <polygon fill="#ffffff" stroke="transparent" points="19.5,-381 19.5,-403 212.5,-403 212.5,-381 19.5,-381"/> |
| <polygon fill="none" stroke="black" points="19.5,-381 19.5,-403 212.5,-403 212.5,-381 19.5,-381"/> |
| <text text-anchor="start" x="39.5" y="-389.2" font-family="Helvetica,sans-Serif" font-size="11.00">external_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="19.5,-359 19.5,-381 212.5,-381 212.5,-359 19.5,-359"/> |
| <polygon fill="none" stroke="black" points="19.5,-359 19.5,-381 212.5,-381 212.5,-359 19.5,-359"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="24.5" y="-376"/> |
| <text text-anchor="start" x="39.5" y="-367.2" font-family="Helvetica,sans-Serif" font-size="11.00">sub_status</text> |
| <polygon fill="#ffffff" stroke="transparent" points="19.5,-337 19.5,-359 212.5,-359 212.5,-337 19.5,-337"/> |
| <polygon fill="none" stroke="black" points="19.5,-337 19.5,-359 212.5,-359 212.5,-337 19.5,-337"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="24.5" y="-354"/> |
| <text text-anchor="start" x="39.5" y="-345.2" font-family="Helvetica,sans-Serif" font-size="11.00">office_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="19.5,-315 19.5,-337 212.5,-337 212.5,-315 19.5,-315"/> |
| <polygon fill="none" stroke="black" points="19.5,-315 19.5,-337 212.5,-337 212.5,-315 19.5,-315"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="24.5" y="-332"/> |
| <text text-anchor="start" x="39.5" y="-323.2" font-family="Helvetica,sans-Serif" font-size="11.00">transfer_to_office_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="19.5,-293 19.5,-315 212.5,-315 212.5,-293 19.5,-293"/> |
| <polygon fill="none" stroke="black" points="19.5,-293 19.5,-315 212.5,-315 212.5,-293 19.5,-293"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="24.5" y="-310"/> |
| <text text-anchor="start" x="39.5" y="-301.2" font-family="Helvetica,sans-Serif" font-size="11.00">staff_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="19.5,-271 19.5,-293 212.5,-293 212.5,-271 19.5,-271"/> |
| <polygon fill="none" stroke="black" points="19.5,-271 19.5,-293 212.5,-293 212.5,-271 19.5,-271"/> |
| <text text-anchor="start" x="39.5" y="-279.2" font-family="Helvetica,sans-Serif" font-size="11.00">mobile_no</text> |
| <polygon fill="#ffffff" stroke="transparent" points="19.5,-249 19.5,-271 212.5,-271 212.5,-249 19.5,-249"/> |
| <polygon fill="none" stroke="black" points="19.5,-249 19.5,-271 212.5,-271 212.5,-249 19.5,-249"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="24.5" y="-266"/> |
| <text text-anchor="start" x="39.5" y="-257.2" font-family="Helvetica,sans-Serif" font-size="11.00">gender_cv_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="19.5,-227 19.5,-249 212.5,-249 212.5,-227 19.5,-227"/> |
| <polygon fill="none" stroke="black" points="19.5,-227 19.5,-249 212.5,-249 212.5,-227 19.5,-227"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="24.5" y="-244"/> |
| <text text-anchor="start" x="39.5" y="-235.2" font-family="Helvetica,sans-Serif" font-size="11.00">image_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="19.5,-205 19.5,-227 212.5,-227 212.5,-205 19.5,-205"/> |
| <polygon fill="none" stroke="black" points="19.5,-205 19.5,-227 212.5,-227 212.5,-205 19.5,-205"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="24.5" y="-222"/> |
| <text text-anchor="start" x="39.5" y="-213.2" font-family="Helvetica,sans-Serif" font-size="11.00">closure_reason_cv_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="19.5,-183 19.5,-205 212.5,-205 212.5,-183 19.5,-183"/> |
| <polygon fill="none" stroke="black" points="19.5,-183 19.5,-205 212.5,-205 212.5,-183 19.5,-183"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="24.5" y="-200"/> |
| <text text-anchor="start" x="39.5" y="-191.2" font-family="Helvetica,sans-Serif" font-size="11.00">default_savings_product</text> |
| <polygon fill="#ffffff" stroke="transparent" points="19.5,-161 19.5,-183 212.5,-183 212.5,-161 19.5,-161"/> |
| <polygon fill="none" stroke="black" points="19.5,-161 19.5,-183 212.5,-183 212.5,-161 19.5,-161"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="24.5" y="-178"/> |
| <text text-anchor="start" x="39.5" y="-169.2" font-family="Helvetica,sans-Serif" font-size="11.00">default_savings_account</text> |
| <polygon fill="#ffffff" stroke="transparent" points="19.5,-139 19.5,-161 212.5,-161 212.5,-139 19.5,-139"/> |
| <polygon fill="none" stroke="black" points="19.5,-139 19.5,-161 212.5,-161 212.5,-139 19.5,-139"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="24.5" y="-156"/> |
| <text text-anchor="start" x="39.5" y="-147.2" font-family="Helvetica,sans-Serif" font-size="11.00">client_type_cv_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="19.5,-117 19.5,-139 212.5,-139 212.5,-117 19.5,-117"/> |
| <polygon fill="none" stroke="black" points="19.5,-117 19.5,-139 212.5,-139 212.5,-117 19.5,-117"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="24.5" y="-134"/> |
| <text text-anchor="start" x="39.5" y="-125.2" font-family="Helvetica,sans-Serif" font-size="11.00">client_classification_cv_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="19.5,-95 19.5,-117 212.5,-117 212.5,-95 19.5,-95"/> |
| <polygon fill="none" stroke="black" points="19.5,-95 19.5,-117 212.5,-117 212.5,-95 19.5,-95"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="24.5" y="-112"/> |
| <text text-anchor="start" x="39.5" y="-103.2" font-family="Helvetica,sans-Serif" font-size="11.00">reject_reason_cv_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="19.5,-73 19.5,-95 212.5,-95 212.5,-73 19.5,-73"/> |
| <polygon fill="none" stroke="black" points="19.5,-73 19.5,-95 212.5,-95 212.5,-73 19.5,-73"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="24.5" y="-90"/> |
| <text text-anchor="start" x="39.5" y="-81.2" font-family="Helvetica,sans-Serif" font-size="11.00">withdraw_reason_cv_id</text> |
| <polygon fill="none" stroke="black" points="19.5,-55 19.5,-73 212.5,-73 212.5,-55 19.5,-55"/> |
| <text text-anchor="start" x="22.5" y="-61.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="19.5,-37 19.5,-55 96.5,-55 96.5,-37 19.5,-37"/> |
| <polygon fill="none" stroke="black" points="19.5,-37 19.5,-55 96.5,-55 96.5,-37 19.5,-37"/> |
| <text text-anchor="start" x="22.5" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 13</text> |
| <polygon fill="#ffffff" stroke="transparent" points="96.5,-37 96.5,-55 159.5,-55 159.5,-37 96.5,-37"/> |
| <polygon fill="none" stroke="black" points="96.5,-37 96.5,-55 159.5,-55 159.5,-37 96.5,-37"/> |
| <text text-anchor="start" x="123.5" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="159.5,-37 159.5,-55 212.5,-55 212.5,-37 159.5,-37"/> |
| <polygon fill="none" stroke="black" points="159.5,-37 159.5,-55 212.5,-55 212.5,-37 159.5,-37"/> |
| <text text-anchor="start" x="187.5" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">23 ></text> |
| </a> |
| </g> |
| </g> |
| <!-- m_selfservice_user_client_mapping->m_client --> |
| <g id="edge2" class="edge"> |
| <title>m_selfservice_user_client_mapping:w->m_client:e</title> |
| <path fill="none" stroke="black" d="M262.97,-517.11C232.94,-504.76 254.93,-436 213.5,-436"/> |
| <polygon fill="black" stroke="black" points="273.42,-514.92 272.01,-522.8 270.43,-522.51 271.84,-514.64 273.42,-514.92"/> |
| <polyline fill="none" stroke="black" points="273.5,-519 269.56,-518.29 "/> |
| <ellipse fill="none" stroke="black" cx="266.41" cy="-517.73" rx="3.2" ry="3.2"/> |
| </g> |
| </g> |
| </svg> |