| <?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="501pt" height="659pt" |
| viewBox="0.00 0.00 501.00 659.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 655)"> |
| <title>oneDegreeRelationshipsDiagram</title> |
| <polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-655 497,-655 497,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> |
| <!-- request_audit_table --> |
| <g id="node1" class="node"> |
| <title>request_audit_table</title> |
| <g id="a_node1"><a xlink:href="../../tables/request_audit_table.html" xlink:title="request_audit_table" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="250,-361 250,-647 485,-647 485,-361 250,-361"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="252.5,-623 252.5,-645 483.5,-645 483.5,-623 252.5,-623"/> |
| <polygon fill="none" stroke="black" points="252.5,-623 252.5,-645 483.5,-645 483.5,-623 252.5,-623"/> |
| <text text-anchor="start" x="257.5" y="-632.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">request_audit_table</text> |
| <text text-anchor="start" x="448.5" y="-631.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="252.5,-601 252.5,-623 416.5,-623 416.5,-601 252.5,-601"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="257.5" y="-618"/> |
| <text text-anchor="start" x="272.5" y="-609.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="none" stroke="black" points="416.5,-601 416.5,-623 483.5,-623 483.5,-601 416.5,-601"/> |
| <text text-anchor="start" x="419.5" y="-609.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="none" stroke="black" points="252.5,-579 252.5,-601 416.5,-601 416.5,-579 252.5,-579"/> |
| <text text-anchor="start" x="272.5" y="-587.2" font-family="Helvetica,sans-Serif" font-size="11.00">lastname</text> |
| <polygon fill="none" stroke="black" points="416.5,-579 416.5,-601 483.5,-601 483.5,-579 416.5,-579"/> |
| <text text-anchor="start" x="419.5" y="-587.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[100]</text> |
| <polygon fill="none" stroke="black" points="252.5,-557 252.5,-579 416.5,-579 416.5,-557 252.5,-557"/> |
| <text text-anchor="start" x="272.5" y="-565.2" font-family="Helvetica,sans-Serif" font-size="11.00">username</text> |
| <polygon fill="none" stroke="black" points="416.5,-557 416.5,-579 483.5,-579 483.5,-557 416.5,-557"/> |
| <text text-anchor="start" x="419.5" y="-565.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[100]</text> |
| <polygon fill="none" stroke="black" points="252.5,-535 252.5,-557 416.5,-557 416.5,-535 252.5,-535"/> |
| <text text-anchor="start" x="272.5" y="-543.2" font-family="Helvetica,sans-Serif" font-size="11.00">mobile_number</text> |
| <polygon fill="none" stroke="black" points="416.5,-535 416.5,-557 483.5,-557 483.5,-535 416.5,-535"/> |
| <text text-anchor="start" x="419.5" y="-543.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[50]</text> |
| <polygon fill="none" stroke="black" points="252.5,-513 252.5,-535 416.5,-535 416.5,-513 252.5,-513"/> |
| <text text-anchor="start" x="272.5" y="-521.2" font-family="Helvetica,sans-Serif" font-size="11.00">firstname</text> |
| <polygon fill="none" stroke="black" points="416.5,-513 416.5,-535 483.5,-535 483.5,-513 416.5,-513"/> |
| <text text-anchor="start" x="419.5" y="-521.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[100]</text> |
| <polygon fill="none" stroke="black" points="252.5,-491 252.5,-513 416.5,-513 416.5,-491 252.5,-491"/> |
| <text text-anchor="start" x="272.5" y="-499.2" font-family="Helvetica,sans-Serif" font-size="11.00">authentication_token</text> |
| <polygon fill="none" stroke="black" points="416.5,-491 416.5,-513 483.5,-513 483.5,-491 416.5,-491"/> |
| <text text-anchor="start" x="419.5" y="-499.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[100]</text> |
| <polygon fill="none" stroke="black" points="252.5,-469 252.5,-491 416.5,-491 416.5,-469 252.5,-469"/> |
| <text text-anchor="start" x="272.5" y="-477.2" font-family="Helvetica,sans-Serif" font-size="11.00">password</text> |
| <polygon fill="none" stroke="black" points="416.5,-469 416.5,-491 483.5,-491 483.5,-469 416.5,-469"/> |
| <text text-anchor="start" x="419.5" y="-477.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[250]</text> |
| <polygon fill="none" stroke="black" points="252.5,-447 252.5,-469 416.5,-469 416.5,-447 252.5,-447"/> |
| <text text-anchor="start" x="272.5" y="-455.2" font-family="Helvetica,sans-Serif" font-size="11.00">email</text> |
| <polygon fill="none" stroke="black" points="416.5,-447 416.5,-469 483.5,-469 483.5,-447 416.5,-447"/> |
| <text text-anchor="start" x="419.5" y="-455.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[100]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="252.5,-425 252.5,-447 416.5,-447 416.5,-425 252.5,-425"/> |
| <polygon fill="none" stroke="black" points="252.5,-425 252.5,-447 416.5,-447 416.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="416.5,-425 416.5,-447 483.5,-447 483.5,-425 416.5,-425"/> |
| <text text-anchor="start" x="419.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 416.5,-425 416.5,-403 252.5,-403"/> |
| <text text-anchor="start" x="272.5" y="-411.2" font-family="Helvetica,sans-Serif" font-size="11.00">created_date</text> |
| <polygon fill="none" stroke="black" points="416.5,-403 416.5,-425 483.5,-425 483.5,-403 416.5,-403"/> |
| <text text-anchor="start" x="419.5" y="-411.2" font-family="Helvetica,sans-Serif" font-size="11.00">date[10]</text> |
| <polygon fill="none" stroke="black" points="252.5,-381 252.5,-403 416.5,-403 416.5,-381 252.5,-381"/> |
| <text text-anchor="start" x="272.5" y="-389.2" font-family="Helvetica,sans-Serif" font-size="11.00">account_number</text> |
| <polygon fill="none" stroke="black" points="416.5,-381 416.5,-403 483.5,-403 483.5,-381 416.5,-381"/> |
| <text text-anchor="start" x="419.5" y="-389.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[100]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="252.5,-363 252.5,-381 325.5,-381 325.5,-363 252.5,-363"/> |
| <polygon fill="none" stroke="black" points="252.5,-363 252.5,-381 325.5,-381 325.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="325.5,-363 325.5,-381 416.5,-381 416.5,-363 325.5,-363"/> |
| <polygon fill="none" stroke="black" points="325.5,-363 325.5,-381 416.5,-381 416.5,-363 325.5,-363"/> |
| <text text-anchor="start" x="380.5" y="-369.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="416.5,-363 416.5,-381 483.5,-381 483.5,-363 416.5,-363"/> |
| <polygon fill="none" stroke="black" points="416.5,-363 416.5,-381 483.5,-381 483.5,-363 416.5,-363"/> |
| <text text-anchor="start" x="464.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,-646 484,-646 484,-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> |
| <!-- request_audit_table->m_client --> |
| <g id="edge1" class="edge"> |
| <title>request_audit_table:w->m_client:e</title> |
| <path fill="none" stroke="black" d="M236.99,-436C225.68,-436 218.49,-436 202.5,-436"/> |
| <polygon fill="black" stroke="black" points="243.5,-436 251.5,-439.6 247.5,-436 251.5,-436 251.5,-436 251.5,-436 247.5,-436 251.5,-432.4 243.5,-436 243.5,-436"/> |
| <ellipse fill="none" stroke="black" cx="240.3" cy="-436" rx="3.2" ry="3.2"/> |
| </g> |
| </g> |
| </svg> |