blob: 0aa1f0c5c817688e4b056ff3d0b360f471be3719 [file] [log] [blame]
<?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="692pt" height="737pt"
viewBox="0.00 0.00 692.00 737.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 733)">
<title>oneDegreeRelationshipsDiagram</title>
<polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-733 688,-733 688,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_appuser -->
<g id="node1" class="node">
<title>m_appuser</title>
<g id="a_node1"><a xlink:href="../../tables/m_appuser.html" xlink:title="m_appuser" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="169,-37 169,-205 384,-205 384,-37 169,-37"/>
<polygon fill="#f5f5f5" stroke="transparent" points="169.5,-183 169.5,-205 384.5,-205 384.5,-183 169.5,-183"/>
<polygon fill="none" stroke="black" points="169.5,-183 169.5,-205 384.5,-205 384.5,-183 169.5,-183"/>
<text text-anchor="start" x="174.5" y="-192.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_appuser</text>
<text text-anchor="start" x="349.5" y="-191.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="169.5,-161 169.5,-183 384.5,-183 384.5,-161 169.5,-161"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="174.5" y="-178"/>
<text text-anchor="start" x="189.5" y="-169.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="#ffffff" stroke="transparent" points="169.5,-139 169.5,-161 384.5,-161 384.5,-139 169.5,-139"/>
<polygon fill="none" stroke="black" points="169.5,-139 169.5,-161 384.5,-161 384.5,-139 169.5,-139"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="174.5" y="-156"/>
<text text-anchor="start" x="189.5" y="-147.2" font-family="Helvetica,sans-Serif" font-size="11.00">office_id</text>
<polygon fill="#ffffff" stroke="transparent" points="169.5,-117 169.5,-139 384.5,-139 384.5,-117 169.5,-117"/>
<polygon fill="none" stroke="black" points="169.5,-117 169.5,-139 384.5,-139 384.5,-117 169.5,-117"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="174.5" y="-134"/>
<text text-anchor="start" x="189.5" y="-125.2" font-family="Helvetica,sans-Serif" font-size="11.00">staff_id</text>
<polygon fill="#ffffff" stroke="transparent" points="169.5,-95 169.5,-117 384.5,-117 384.5,-95 169.5,-95"/>
<polygon fill="none" stroke="black" points="169.5,-95 169.5,-117 384.5,-117 384.5,-95 169.5,-95"/>
<text text-anchor="start" x="189.5" y="-103.2" font-family="Helvetica,sans-Serif" font-size="11.00">username</text>
<polygon fill="#ffffff" stroke="transparent" points="169.5,-73 169.5,-95 384.5,-95 384.5,-73 169.5,-73"/>
<polygon fill="none" stroke="black" points="169.5,-73 169.5,-95 384.5,-95 384.5,-73 169.5,-73"/>
<text text-anchor="start" x="189.5" y="-81.2" font-family="Helvetica,sans-Serif" font-size="11.00">last_time_password_updated</text>
<polygon fill="none" stroke="black" points="169.5,-55 169.5,-73 384.5,-73 384.5,-55 169.5,-55"/>
<text text-anchor="start" x="172.5" y="-61.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="169.5,-37 169.5,-55 254.5,-55 254.5,-37 169.5,-37"/>
<polygon fill="none" stroke="black" points="169.5,-37 169.5,-55 254.5,-55 254.5,-37 169.5,-37"/>
<text text-anchor="start" x="172.5" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 2</text>
<polygon fill="#ffffff" stroke="transparent" points="254.5,-37 254.5,-55 324.5,-55 324.5,-37 254.5,-37"/>
<polygon fill="none" stroke="black" points="254.5,-37 254.5,-55 324.5,-55 324.5,-37 254.5,-37"/>
<text text-anchor="start" x="288.5" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="324.5,-37 324.5,-55 384.5,-55 384.5,-37 324.5,-37"/>
<polygon fill="none" stroke="black" points="324.5,-37 324.5,-55 384.5,-55 384.5,-37 324.5,-37"/>
<text text-anchor="start" x="359.5" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">57 &gt;</text>
</a>
</g>
</g>
<!-- m_office -->
<g id="node2" class="node">
<title>m_office</title>
<g id="a_node2"><a xlink:href="../../tables/m_office.html" xlink:title="m_office" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="8,-156 8,-302 120,-302 120,-156 8,-156"/>
<polygon fill="#f5f5f5" stroke="transparent" points="8,-280 8,-302 120,-302 120,-280 8,-280"/>
<polygon fill="none" stroke="black" points="8,-280 8,-302 120,-302 120,-280 8,-280"/>
<text text-anchor="start" x="13" y="-289.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_office</text>
<text text-anchor="start" x="85" y="-288.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="8,-258 8,-280 120,-280 120,-258 8,-258"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-275"/>
<text text-anchor="start" x="28" y="-266.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-236 8,-258 120,-258 120,-236 8,-236"/>
<polygon fill="none" stroke="black" points="8,-236 8,-258 120,-258 120,-236 8,-236"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-253"/>
<text text-anchor="start" x="28" y="-244.2" font-family="Helvetica,sans-Serif" font-size="11.00">parent_id</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-214 8,-236 120,-236 120,-214 8,-214"/>
<polygon fill="none" stroke="black" points="8,-214 8,-236 120,-236 120,-214 8,-214"/>
<text text-anchor="start" x="28" y="-222.2" font-family="Helvetica,sans-Serif" font-size="11.00">external_id</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-192 8,-214 120,-214 120,-192 8,-192"/>
<polygon fill="none" stroke="black" points="8,-192 8,-214 120,-214 120,-192 8,-192"/>
<text text-anchor="start" x="28" y="-200.2" font-family="Helvetica,sans-Serif" font-size="11.00">name</text>
<polygon fill="none" stroke="black" points="8,-174 8,-192 120,-192 120,-174 8,-174"/>
<text text-anchor="start" x="11" y="-180.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-156 8,-174 41,-174 41,-156 8,-156"/>
<polygon fill="none" stroke="black" points="8,-156 8,-174 41,-174 41,-156 8,-156"/>
<text text-anchor="start" x="11" y="-162.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 1</text>
<polygon fill="#ffffff" stroke="transparent" points="41,-156 41,-174 86,-174 86,-156 41,-156"/>
<polygon fill="none" stroke="black" points="41,-156 41,-174 86,-174 86,-156 41,-156"/>
<text text-anchor="start" x="50" y="-162.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="86,-156 86,-174 120,-174 120,-156 86,-156"/>
<polygon fill="none" stroke="black" points="86,-156 86,-174 120,-174 120,-156 86,-156"/>
<text text-anchor="start" x="95" y="-162.2" font-family="Helvetica,sans-Serif" font-size="11.00">20 &gt;</text>
</a>
</g>
</g>
<!-- m_appuser&#45;&gt;m_office -->
<g id="edge1" class="edge">
<title>m_appuser:w&#45;&gt;m_office:e</title>
<path fill="none" stroke="black" d="M154.31,-153.69C124.19,-173.78 171.94,-269 121,-269"/>
<polygon fill="black" stroke="black" points="160.76,-152.01 169.41,-153.48 164.63,-151.01 168.5,-150 168.5,-150 168.5,-150 164.63,-151.01 167.59,-146.52 160.76,-152.01 160.76,-152.01"/>
<ellipse fill="none" stroke="black" cx="157.66" cy="-152.82" 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="180,-293 180,-725 373,-725 373,-293 180,-293"/>
<polygon fill="#f5f5f5" stroke="transparent" points="180.5,-703 180.5,-725 373.5,-725 373.5,-703 180.5,-703"/>
<polygon fill="none" stroke="black" points="180.5,-703 180.5,-725 373.5,-725 373.5,-703 180.5,-703"/>
<text text-anchor="start" x="185.5" y="-712.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_client</text>
<text text-anchor="start" x="338.5" y="-711.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="180.5,-681 180.5,-703 373.5,-703 373.5,-681 180.5,-681"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="185.5" y="-698"/>
<text text-anchor="start" x="200.5" y="-689.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="#ffffff" stroke="transparent" points="180.5,-659 180.5,-681 373.5,-681 373.5,-659 180.5,-659"/>
<polygon fill="none" stroke="black" points="180.5,-659 180.5,-681 373.5,-681 373.5,-659 180.5,-659"/>
<text text-anchor="start" x="200.5" y="-667.2" font-family="Helvetica,sans-Serif" font-size="11.00">account_no</text>
<polygon fill="#ffffff" stroke="transparent" points="180.5,-637 180.5,-659 373.5,-659 373.5,-637 180.5,-637"/>
<polygon fill="none" stroke="black" points="180.5,-637 180.5,-659 373.5,-659 373.5,-637 180.5,-637"/>
<text text-anchor="start" x="200.5" y="-645.2" font-family="Helvetica,sans-Serif" font-size="11.00">external_id</text>
<polygon fill="#ffffff" stroke="transparent" points="180.5,-615 180.5,-637 373.5,-637 373.5,-615 180.5,-615"/>
<polygon fill="none" stroke="black" points="180.5,-615 180.5,-637 373.5,-637 373.5,-615 180.5,-615"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="185.5" y="-632"/>
<text text-anchor="start" x="200.5" y="-623.2" font-family="Helvetica,sans-Serif" font-size="11.00">sub_status</text>
<polygon fill="#ffffff" stroke="transparent" points="180.5,-593 180.5,-615 373.5,-615 373.5,-593 180.5,-593"/>
<polygon fill="none" stroke="black" points="180.5,-593 180.5,-615 373.5,-615 373.5,-593 180.5,-593"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="185.5" y="-610"/>
<text text-anchor="start" x="200.5" y="-601.2" font-family="Helvetica,sans-Serif" font-size="11.00">office_id</text>
<polygon fill="#ffffff" stroke="transparent" points="180.5,-571 180.5,-593 373.5,-593 373.5,-571 180.5,-571"/>
<polygon fill="none" stroke="black" points="180.5,-571 180.5,-593 373.5,-593 373.5,-571 180.5,-571"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="185.5" y="-588"/>
<text text-anchor="start" x="200.5" y="-579.2" font-family="Helvetica,sans-Serif" font-size="11.00">transfer_to_office_id</text>
<polygon fill="#ffffff" stroke="transparent" points="180.5,-549 180.5,-571 373.5,-571 373.5,-549 180.5,-549"/>
<polygon fill="none" stroke="black" points="180.5,-549 180.5,-571 373.5,-571 373.5,-549 180.5,-549"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="185.5" y="-566"/>
<text text-anchor="start" x="200.5" y="-557.2" font-family="Helvetica,sans-Serif" font-size="11.00">staff_id</text>
<polygon fill="#ffffff" stroke="transparent" points="180.5,-527 180.5,-549 373.5,-549 373.5,-527 180.5,-527"/>
<polygon fill="none" stroke="black" points="180.5,-527 180.5,-549 373.5,-549 373.5,-527 180.5,-527"/>
<text text-anchor="start" x="200.5" y="-535.2" font-family="Helvetica,sans-Serif" font-size="11.00">mobile_no</text>
<polygon fill="#ffffff" stroke="transparent" points="180.5,-505 180.5,-527 373.5,-527 373.5,-505 180.5,-505"/>
<polygon fill="none" stroke="black" points="180.5,-505 180.5,-527 373.5,-527 373.5,-505 180.5,-505"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="185.5" y="-522"/>
<text text-anchor="start" x="200.5" y="-513.2" font-family="Helvetica,sans-Serif" font-size="11.00">gender_cv_id</text>
<polygon fill="#ffffff" stroke="transparent" points="180.5,-483 180.5,-505 373.5,-505 373.5,-483 180.5,-483"/>
<polygon fill="none" stroke="black" points="180.5,-483 180.5,-505 373.5,-505 373.5,-483 180.5,-483"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="185.5" y="-500"/>
<text text-anchor="start" x="200.5" y="-491.2" font-family="Helvetica,sans-Serif" font-size="11.00">image_id</text>
<polygon fill="#ffffff" stroke="transparent" points="180.5,-461 180.5,-483 373.5,-483 373.5,-461 180.5,-461"/>
<polygon fill="none" stroke="black" points="180.5,-461 180.5,-483 373.5,-483 373.5,-461 180.5,-461"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="185.5" y="-478"/>
<text text-anchor="start" x="200.5" y="-469.2" font-family="Helvetica,sans-Serif" font-size="11.00">closure_reason_cv_id</text>
<polygon fill="#ffffff" stroke="transparent" points="180.5,-439 180.5,-461 373.5,-461 373.5,-439 180.5,-439"/>
<polygon fill="none" stroke="black" points="180.5,-439 180.5,-461 373.5,-461 373.5,-439 180.5,-439"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="185.5" y="-456"/>
<text text-anchor="start" x="200.5" y="-447.2" font-family="Helvetica,sans-Serif" font-size="11.00">default_savings_product</text>
<polygon fill="#ffffff" stroke="transparent" points="180.5,-417 180.5,-439 373.5,-439 373.5,-417 180.5,-417"/>
<polygon fill="none" stroke="black" points="180.5,-417 180.5,-439 373.5,-439 373.5,-417 180.5,-417"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="185.5" y="-434"/>
<text text-anchor="start" x="200.5" y="-425.2" font-family="Helvetica,sans-Serif" font-size="11.00">default_savings_account</text>
<polygon fill="#ffffff" stroke="transparent" points="180.5,-395 180.5,-417 373.5,-417 373.5,-395 180.5,-395"/>
<polygon fill="none" stroke="black" points="180.5,-395 180.5,-417 373.5,-417 373.5,-395 180.5,-395"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="185.5" y="-412"/>
<text text-anchor="start" x="200.5" y="-403.2" font-family="Helvetica,sans-Serif" font-size="11.00">client_type_cv_id</text>
<polygon fill="#ffffff" stroke="transparent" points="180.5,-373 180.5,-395 373.5,-395 373.5,-373 180.5,-373"/>
<polygon fill="none" stroke="black" points="180.5,-373 180.5,-395 373.5,-395 373.5,-373 180.5,-373"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="185.5" y="-390"/>
<text text-anchor="start" x="200.5" y="-381.2" font-family="Helvetica,sans-Serif" font-size="11.00">client_classification_cv_id</text>
<polygon fill="#ffffff" stroke="transparent" points="180.5,-351 180.5,-373 373.5,-373 373.5,-351 180.5,-351"/>
<polygon fill="none" stroke="black" points="180.5,-351 180.5,-373 373.5,-373 373.5,-351 180.5,-351"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="185.5" y="-368"/>
<text text-anchor="start" x="200.5" y="-359.2" font-family="Helvetica,sans-Serif" font-size="11.00">reject_reason_cv_id</text>
<polygon fill="#ffffff" stroke="transparent" points="180.5,-329 180.5,-351 373.5,-351 373.5,-329 180.5,-329"/>
<polygon fill="none" stroke="black" points="180.5,-329 180.5,-351 373.5,-351 373.5,-329 180.5,-329"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="185.5" y="-346"/>
<text text-anchor="start" x="200.5" y="-337.2" font-family="Helvetica,sans-Serif" font-size="11.00">withdraw_reason_cv_id</text>
<polygon fill="none" stroke="black" points="180.5,-311 180.5,-329 373.5,-329 373.5,-311 180.5,-311"/>
<text text-anchor="start" x="183.5" y="-317.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="180.5,-293 180.5,-311 257.5,-311 257.5,-293 180.5,-293"/>
<polygon fill="none" stroke="black" points="180.5,-293 180.5,-311 257.5,-311 257.5,-293 180.5,-293"/>
<text text-anchor="start" x="183.5" y="-299.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 13</text>
<polygon fill="#ffffff" stroke="transparent" points="257.5,-293 257.5,-311 320.5,-311 320.5,-293 257.5,-293"/>
<polygon fill="none" stroke="black" points="257.5,-293 257.5,-311 320.5,-311 320.5,-293 257.5,-293"/>
<text text-anchor="start" x="284.5" y="-299.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="320.5,-293 320.5,-311 373.5,-311 373.5,-293 320.5,-293"/>
<polygon fill="none" stroke="black" points="320.5,-293 320.5,-311 373.5,-311 373.5,-293 320.5,-293"/>
<text text-anchor="start" x="348.5" y="-299.2" font-family="Helvetica,sans-Serif" font-size="11.00">23 &gt;</text>
</a>
</g>
</g>
<!-- m_client&#45;&gt;m_office -->
<g id="edge2" class="edge">
<title>m_client:w&#45;&gt;m_office:e</title>
<path fill="none" stroke="black" d="M164.99,-602.79C45.01,-580.86 266.83,-269 121,-269"/>
<polygon fill="black" stroke="black" points="171.53,-603.33 179.2,-607.59 175.51,-603.67 179.5,-604 179.5,-604 179.5,-604 175.51,-603.67 179.8,-600.41 171.53,-603.33 171.53,-603.33"/>
<ellipse fill="none" stroke="black" cx="168.34" cy="-603.07" rx="3.2" ry="3.2"/>
</g>
<!-- m_client&#45;&gt;m_office -->
<g id="edge3" class="edge">
<title>m_client:w&#45;&gt;m_office:e</title>
<path fill="none" stroke="black" d="M164.88,-580.67C54.55,-558.61 257.13,-269 121,-269"/>
<polygon fill="black" stroke="black" points="171.53,-581.28 179.17,-585.59 175.52,-581.64 179.5,-582 179.5,-582 179.5,-582 175.52,-581.64 179.83,-578.41 171.53,-581.28 171.53,-581.28"/>
<ellipse fill="none" stroke="black" cx="168.35" cy="-580.99" rx="3.2" ry="3.2"/>
</g>
<!-- m_client_transfer_details -->
<g id="node4" class="node">
<title>m_client_transfer_details</title>
<g id="a_node4"><a xlink:href="../../tables/m_client_transfer_details.html" xlink:title="m_client_transfer_details" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="433,-135 433,-355 676,-355 676,-135 433,-135"/>
<polygon fill="#f5f5f5" stroke="transparent" points="435.5,-331 435.5,-353 674.5,-353 674.5,-331 435.5,-331"/>
<polygon fill="none" stroke="black" points="435.5,-331 435.5,-353 674.5,-353 674.5,-331 435.5,-331"/>
<text text-anchor="start" x="440.5" y="-340.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_client_transfer_details</text>
<text text-anchor="start" x="639.5" y="-339.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="435.5,-309 435.5,-331 624.5,-331 624.5,-309 435.5,-309"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="440.5" y="-326"/>
<text text-anchor="start" x="455.5" y="-317.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="none" stroke="black" points="624.5,-309 624.5,-331 674.5,-331 674.5,-309 624.5,-309"/>
<text text-anchor="start" x="627.5" y="-317.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="#ffffff" stroke="transparent" points="435.5,-287 435.5,-309 624.5,-309 624.5,-287 435.5,-287"/>
<polygon fill="none" stroke="black" points="435.5,-287 435.5,-309 624.5,-309 624.5,-287 435.5,-287"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="440.5" y="-304"/>
<text text-anchor="start" x="455.5" y="-295.2" font-family="Helvetica,sans-Serif" font-size="11.00">client_id</text>
<polygon fill="none" stroke="black" points="624.5,-287 624.5,-309 674.5,-309 674.5,-287 624.5,-287"/>
<text text-anchor="start" x="627.5" y="-295.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="#ffffff" stroke="transparent" points="435.5,-265 435.5,-287 624.5,-287 624.5,-265 435.5,-265"/>
<polygon fill="none" stroke="black" points="435.5,-265 435.5,-287 624.5,-287 624.5,-265 435.5,-265"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="440.5" y="-282"/>
<text text-anchor="start" x="455.5" y="-273.2" font-family="Helvetica,sans-Serif" font-size="11.00">from_office_id</text>
<polygon fill="none" stroke="black" points="624.5,-265 624.5,-287 674.5,-287 674.5,-265 624.5,-265"/>
<text text-anchor="start" x="627.5" y="-273.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="#ffffff" stroke="transparent" points="435.5,-243 435.5,-265 624.5,-265 624.5,-243 435.5,-243"/>
<polygon fill="none" stroke="black" points="435.5,-243 435.5,-265 624.5,-265 624.5,-243 435.5,-243"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="440.5" y="-260"/>
<text text-anchor="start" x="455.5" y="-251.2" font-family="Helvetica,sans-Serif" font-size="11.00">to_office_id</text>
<polygon fill="none" stroke="black" points="624.5,-243 624.5,-265 674.5,-265 674.5,-243 624.5,-243"/>
<text text-anchor="start" x="627.5" y="-251.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="none" stroke="black" points="435.5,-221 435.5,-243 624.5,-243 624.5,-221 435.5,-221"/>
<text text-anchor="start" x="455.5" y="-229.2" font-family="Helvetica,sans-Serif" font-size="11.00">proposed_transfer_date</text>
<polygon fill="none" stroke="black" points="624.5,-221 624.5,-243 674.5,-243 674.5,-221 624.5,-221"/>
<text text-anchor="start" x="627.5" y="-229.2" font-family="Helvetica,sans-Serif" font-size="11.00">date[10]</text>
<polygon fill="none" stroke="black" points="435.5,-199 435.5,-221 624.5,-221 624.5,-199 435.5,-199"/>
<text text-anchor="start" x="455.5" y="-207.2" font-family="Helvetica,sans-Serif" font-size="11.00">transfer_type</text>
<polygon fill="none" stroke="black" points="624.5,-199 624.5,-221 674.5,-221 674.5,-199 624.5,-199"/>
<text text-anchor="start" x="627.5" y="-207.2" font-family="Helvetica,sans-Serif" font-size="11.00">tinyint[3]</text>
<polygon fill="none" stroke="black" points="435.5,-177 435.5,-199 624.5,-199 624.5,-177 435.5,-177"/>
<text text-anchor="start" x="455.5" y="-185.2" font-family="Helvetica,sans-Serif" font-size="11.00">submitted_on</text>
<polygon fill="none" stroke="black" points="624.5,-177 624.5,-199 674.5,-199 674.5,-177 624.5,-177"/>
<text text-anchor="start" x="627.5" y="-185.2" font-family="Helvetica,sans-Serif" font-size="11.00">date[10]</text>
<polygon fill="#ffffff" stroke="transparent" points="435.5,-155 435.5,-177 624.5,-177 624.5,-155 435.5,-155"/>
<polygon fill="none" stroke="black" points="435.5,-155 435.5,-177 624.5,-177 624.5,-155 435.5,-155"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="440.5" y="-172"/>
<text text-anchor="start" x="455.5" y="-163.2" font-family="Helvetica,sans-Serif" font-size="11.00">submitted_by</text>
<polygon fill="none" stroke="black" points="624.5,-155 624.5,-177 674.5,-177 674.5,-155 624.5,-155"/>
<text text-anchor="start" x="627.5" y="-163.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="#ffffff" stroke="transparent" points="435.5,-137 435.5,-155 521.5,-155 521.5,-137 435.5,-137"/>
<polygon fill="none" stroke="black" points="435.5,-137 435.5,-155 521.5,-155 521.5,-137 435.5,-137"/>
<text text-anchor="start" x="438.5" y="-143.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 4</text>
<polygon fill="#ffffff" stroke="transparent" points="521.5,-137 521.5,-155 624.5,-155 624.5,-137 521.5,-137"/>
<polygon fill="none" stroke="black" points="521.5,-137 521.5,-155 624.5,-155 624.5,-137 521.5,-137"/>
<text text-anchor="start" x="588.5" y="-143.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="624.5,-137 624.5,-155 674.5,-155 674.5,-137 624.5,-137"/>
<polygon fill="none" stroke="black" points="624.5,-137 624.5,-155 674.5,-155 674.5,-137 624.5,-137"/>
<text text-anchor="start" x="655.5" y="-143.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 &gt;</text>
<polygon fill="none" stroke="black" stroke-width="2" points="434,-136 434,-354 675,-354 675,-136 434,-136"/>
</a>
</g>
</g>
<!-- m_client_transfer_details&#45;&gt;m_appuser -->
<g id="edge6" class="edge">
<title>m_client_transfer_details:w&#45;&gt;m_appuser:e</title>
<path fill="none" stroke="black" d="M419.95,-167.05C408.65,-168.76 401.61,-172 385.5,-172"/>
<polygon fill="black" stroke="black" points="426.52,-166.57 434.76,-169.59 430.51,-166.29 434.5,-166 434.5,-166 434.5,-166 430.51,-166.29 434.24,-162.41 426.52,-166.57 426.52,-166.57"/>
<ellipse fill="none" stroke="black" cx="423.33" cy="-166.8" rx="3.2" ry="3.2"/>
</g>
<!-- m_client_transfer_details&#45;&gt;m_office -->
<g id="edge5" class="edge">
<title>m_client_transfer_details:w&#45;&gt;m_office:e</title>
<path fill="none" stroke="black" d="M419.79,-275.97C292.48,-275.5 255.33,-269 121,-269"/>
<polygon fill="black" stroke="black" points="426.5,-275.99 434.49,-279.6 430.5,-275.99 434.5,-276 434.5,-276 434.5,-276 430.5,-275.99 434.51,-272.4 426.5,-275.99 426.5,-275.99"/>
<ellipse fill="none" stroke="black" cx="423.3" cy="-275.98" rx="3.2" ry="3.2"/>
</g>
<!-- m_client_transfer_details&#45;&gt;m_office -->
<g id="edge7" class="edge">
<title>m_client_transfer_details:w&#45;&gt;m_office:e</title>
<path fill="none" stroke="black" d="M419.98,-254.02C310.18,-254.4 277.48,-259.08 161,-266 143.2,-267.06 138.83,-269 121,-269"/>
<polygon fill="black" stroke="black" points="426.5,-254.01 434.51,-257.6 430.5,-254.01 434.5,-254 434.5,-254 434.5,-254 430.5,-254.01 434.49,-250.4 426.5,-254.01 426.5,-254.01"/>
<ellipse fill="none" stroke="black" cx="423.3" cy="-254.02" rx="3.2" ry="3.2"/>
</g>
<!-- m_client_transfer_details&#45;&gt;m_client -->
<g id="edge4" class="edge">
<title>m_client_transfer_details:w&#45;&gt;m_client:e</title>
<path fill="none" stroke="black" d="M420.12,-298.99C274.21,-320.75 546.44,-692 374.5,-692"/>
<polygon fill="black" stroke="black" points="426.52,-298.55 434.75,-301.59 430.51,-298.28 434.5,-298 434.5,-298 434.5,-298 430.51,-298.28 434.25,-294.41 426.52,-298.55 426.52,-298.55"/>
<ellipse fill="none" stroke="black" cx="423.33" cy="-298.77" rx="3.2" ry="3.2"/>
</g>
</g>
</svg>