| <?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="814pt" height="670pt" |
| viewBox="0.00 0.00 814.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 810,-666 810,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> |
| <!-- acc_gl_journal_entry --> |
| <g id="node1" class="node"> |
| <title>acc_gl_journal_entry</title> |
| <g id="a_node1"><a xlink:href="../../tables/acc_gl_journal_entry.html" xlink:title="acc_gl_journal_entry" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="573,-51 573,-373 798,-373 798,-51 573,-51"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="573.5,-351 573.5,-373 798.5,-373 798.5,-351 573.5,-351"/> |
| <polygon fill="none" stroke="black" points="573.5,-351 573.5,-373 798.5,-373 798.5,-351 573.5,-351"/> |
| <text text-anchor="start" x="578.5" y="-360.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">acc_gl_journal_entry</text> |
| <text text-anchor="start" x="763.5" y="-359.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="573.5,-329 573.5,-351 798.5,-351 798.5,-329 573.5,-329"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="578.5" y="-346"/> |
| <text text-anchor="start" x="593.5" y="-337.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="573.5,-307 573.5,-329 798.5,-329 798.5,-307 573.5,-307"/> |
| <polygon fill="none" stroke="black" points="573.5,-307 573.5,-329 798.5,-329 798.5,-307 573.5,-307"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="578.5" y="-324"/> |
| <text text-anchor="start" x="593.5" y="-315.2" font-family="Helvetica,sans-Serif" font-size="11.00">account_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="573.5,-285 573.5,-307 798.5,-307 798.5,-285 573.5,-285"/> |
| <polygon fill="none" stroke="black" points="573.5,-285 573.5,-307 798.5,-307 798.5,-285 573.5,-285"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="578.5" y="-302"/> |
| <text text-anchor="start" x="593.5" y="-293.2" font-family="Helvetica,sans-Serif" font-size="11.00">office_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="573.5,-263 573.5,-285 798.5,-285 798.5,-263 573.5,-263"/> |
| <polygon fill="none" stroke="black" points="573.5,-263 573.5,-285 798.5,-285 798.5,-263 573.5,-263"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="578.5" y="-280"/> |
| <text text-anchor="start" x="593.5" y="-271.2" font-family="Helvetica,sans-Serif" font-size="11.00">reversal_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="573.5,-241 573.5,-263 798.5,-263 798.5,-241 573.5,-241"/> |
| <polygon fill="none" stroke="black" points="573.5,-241 573.5,-263 798.5,-263 798.5,-241 573.5,-241"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="578.5" y="-258"/> |
| <text text-anchor="start" x="593.5" y="-249.2" font-family="Helvetica,sans-Serif" font-size="11.00">loan_transaction_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="573.5,-219 573.5,-241 798.5,-241 798.5,-219 573.5,-219"/> |
| <polygon fill="none" stroke="black" points="573.5,-219 573.5,-241 798.5,-241 798.5,-219 573.5,-219"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="578.5" y="-236"/> |
| <text text-anchor="start" x="593.5" y="-227.2" font-family="Helvetica,sans-Serif" font-size="11.00">savings_transaction_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="573.5,-197 573.5,-219 798.5,-219 798.5,-197 573.5,-197"/> |
| <polygon fill="none" stroke="black" points="573.5,-197 573.5,-219 798.5,-219 798.5,-197 573.5,-197"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="578.5" y="-214"/> |
| <text text-anchor="start" x="593.5" y="-205.2" font-family="Helvetica,sans-Serif" font-size="11.00">client_transaction_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="573.5,-175 573.5,-197 798.5,-197 798.5,-175 573.5,-175"/> |
| <polygon fill="none" stroke="black" points="573.5,-175 573.5,-197 798.5,-197 798.5,-175 573.5,-175"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="578.5" y="-192"/> |
| <text text-anchor="start" x="593.5" y="-183.2" font-family="Helvetica,sans-Serif" font-size="11.00">createdby_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="573.5,-153 573.5,-175 798.5,-175 798.5,-153 573.5,-153"/> |
| <polygon fill="none" stroke="black" points="573.5,-153 573.5,-175 798.5,-175 798.5,-153 573.5,-153"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="578.5" y="-170"/> |
| <text text-anchor="start" x="593.5" y="-161.2" font-family="Helvetica,sans-Serif" font-size="11.00">lastmodifiedby_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="573.5,-131 573.5,-153 798.5,-153 798.5,-131 573.5,-131"/> |
| <polygon fill="none" stroke="black" points="573.5,-131 573.5,-153 798.5,-153 798.5,-131 573.5,-131"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="578.5" y="-148"/> |
| <text text-anchor="start" x="593.5" y="-139.2" font-family="Helvetica,sans-Serif" font-size="11.00">payment_details_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="573.5,-109 573.5,-131 798.5,-131 798.5,-109 573.5,-109"/> |
| <polygon fill="none" stroke="black" points="573.5,-109 573.5,-131 798.5,-131 798.5,-109 573.5,-109"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="578.5" y="-126"/> |
| <text text-anchor="start" x="593.5" y="-117.2" font-family="Helvetica,sans-Serif" font-size="11.00">share_transaction_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="573.5,-87 573.5,-109 798.5,-109 798.5,-87 573.5,-87"/> |
| <polygon fill="none" stroke="black" points="573.5,-87 573.5,-109 798.5,-109 798.5,-87 573.5,-87"/> |
| <text text-anchor="start" x="593.5" y="-95.2" font-family="Helvetica,sans-Serif" font-size="11.00">transaction_date</text> |
| <polygon fill="none" stroke="black" points="573.5,-69 573.5,-87 798.5,-87 798.5,-69 573.5,-69"/> |
| <text text-anchor="start" x="576.5" y="-75.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="573.5,-51 573.5,-69 669.5,-69 669.5,-51 573.5,-51"/> |
| <polygon fill="none" stroke="black" points="573.5,-51 573.5,-69 669.5,-69 669.5,-51 573.5,-51"/> |
| <text text-anchor="start" x="576.5" y="-57.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 10</text> |
| <polygon fill="#ffffff" stroke="transparent" points="669.5,-51 669.5,-69 742.5,-69 742.5,-51 669.5,-51"/> |
| <polygon fill="none" stroke="black" points="669.5,-51 669.5,-69 742.5,-69 742.5,-51 669.5,-51"/> |
| <text text-anchor="start" x="706.5" y="-57.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="742.5,-51 742.5,-69 798.5,-69 798.5,-51 742.5,-51"/> |
| <polygon fill="none" stroke="black" points="742.5,-51 742.5,-69 798.5,-69 798.5,-51 742.5,-51"/> |
| <text text-anchor="start" x="779.5" y="-57.2" font-family="Helvetica,sans-Serif" font-size="11.00">1 ></text> |
| </a> |
| </g> |
| </g> |
| <!-- m_client_transaction --> |
| <g id="node2" class="node"> |
| <title>m_client_transaction</title> |
| <g id="a_node2"><a xlink:href="../../tables/m_client_transaction.html" xlink:title="m_client_transaction" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="272,-210 272,-518 524,-518 524,-210 272,-210"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="274,-494 274,-516 522,-516 522,-494 274,-494"/> |
| <polygon fill="none" stroke="black" points="274,-494 274,-516 522,-516 522,-494 274,-494"/> |
| <text text-anchor="start" x="279" y="-503.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_client_transaction</text> |
| <text text-anchor="start" x="487" y="-502.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="274,-472 274,-494 452,-494 452,-472 274,-472"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="279" y="-489"/> |
| <text text-anchor="start" x="294" y="-480.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="none" stroke="black" points="452,-472 452,-494 522,-494 522,-472 452,-472"/> |
| <text text-anchor="start" x="455" y="-480.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="274,-450 274,-472 452,-472 452,-450 274,-450"/> |
| <polygon fill="none" stroke="black" points="274,-450 274,-472 452,-472 452,-450 274,-450"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="279" y="-467"/> |
| <text text-anchor="start" x="294" y="-458.2" font-family="Helvetica,sans-Serif" font-size="11.00">client_id</text> |
| <polygon fill="none" stroke="black" points="452,-450 452,-472 522,-472 522,-450 452,-450"/> |
| <text text-anchor="start" x="455" y="-458.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="none" stroke="black" points="274,-428 274,-450 452,-450 452,-428 274,-428"/> |
| <text text-anchor="start" x="294" y="-436.2" font-family="Helvetica,sans-Serif" font-size="11.00">office_id</text> |
| <polygon fill="none" stroke="black" points="452,-428 452,-450 522,-450 522,-428 452,-428"/> |
| <text text-anchor="start" x="455" y="-436.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="none" stroke="black" points="274,-406 274,-428 452,-428 452,-406 274,-406"/> |
| <text text-anchor="start" x="294" y="-414.2" font-family="Helvetica,sans-Serif" font-size="11.00">currency_code</text> |
| <polygon fill="none" stroke="black" points="452,-406 452,-428 522,-428 522,-406 452,-406"/> |
| <text text-anchor="start" x="455" y="-414.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[3]</text> |
| <polygon fill="none" stroke="black" points="274,-384 274,-406 452,-406 452,-384 274,-384"/> |
| <text text-anchor="start" x="294" y="-392.2" font-family="Helvetica,sans-Serif" font-size="11.00">payment_detail_id</text> |
| <polygon fill="none" stroke="black" points="452,-384 452,-406 522,-406 522,-384 452,-384"/> |
| <text text-anchor="start" x="455" y="-392.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="none" stroke="black" points="274,-362 274,-384 452,-384 452,-362 274,-362"/> |
| <text text-anchor="start" x="294" y="-370.2" font-family="Helvetica,sans-Serif" font-size="11.00">is_reversed</text> |
| <polygon fill="none" stroke="black" points="452,-362 452,-384 522,-384 522,-362 452,-362"/> |
| <text text-anchor="start" x="455" y="-370.2" font-family="Helvetica,sans-Serif" font-size="11.00">bit[1]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="274,-340 274,-362 452,-362 452,-340 274,-340"/> |
| <polygon fill="none" stroke="black" points="274,-340 274,-362 452,-362 452,-340 274,-340"/> |
| <text text-anchor="start" x="294" y="-348.2" font-family="Helvetica,sans-Serif" font-size="11.00">external_id</text> |
| <polygon fill="none" stroke="black" points="452,-340 452,-362 522,-362 522,-340 452,-340"/> |
| <text text-anchor="start" x="455" y="-348.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[50]</text> |
| <polygon fill="none" stroke="black" points="274,-318 274,-340 452,-340 452,-318 274,-318"/> |
| <text text-anchor="start" x="294" y="-326.2" font-family="Helvetica,sans-Serif" font-size="11.00">transaction_date</text> |
| <polygon fill="none" stroke="black" points="452,-318 452,-340 522,-340 522,-318 452,-318"/> |
| <text text-anchor="start" x="455" y="-326.2" font-family="Helvetica,sans-Serif" font-size="11.00">date[10]</text> |
| <polygon fill="none" stroke="black" points="274,-296 274,-318 452,-318 452,-296 274,-296"/> |
| <text text-anchor="start" x="294" y="-304.2" font-family="Helvetica,sans-Serif" font-size="11.00">transaction_type_enum</text> |
| <polygon fill="none" stroke="black" points="452,-296 452,-318 522,-318 522,-296 452,-296"/> |
| <text text-anchor="start" x="455" y="-304.2" font-family="Helvetica,sans-Serif" font-size="11.00">smallint[5]</text> |
| <polygon fill="none" stroke="black" points="274,-274 274,-296 452,-296 452,-274 274,-274"/> |
| <text text-anchor="start" x="294" y="-282.2" font-family="Helvetica,sans-Serif" font-size="11.00">amount</text> |
| <polygon fill="none" stroke="black" points="452,-274 452,-296 522,-296 522,-274 452,-274"/> |
| <text text-anchor="start" x="455" y="-282.2" font-family="Helvetica,sans-Serif" font-size="11.00">decimal[19,6]</text> |
| <polygon fill="none" stroke="black" points="274,-252 274,-274 452,-274 452,-252 274,-252"/> |
| <text text-anchor="start" x="294" y="-260.2" font-family="Helvetica,sans-Serif" font-size="11.00">created_date</text> |
| <polygon fill="none" stroke="black" points="452,-252 452,-274 522,-274 522,-252 452,-252"/> |
| <text text-anchor="start" x="455" y="-260.2" font-family="Helvetica,sans-Serif" font-size="11.00">datetime[19]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="274,-230 274,-252 452,-252 452,-230 274,-230"/> |
| <polygon fill="none" stroke="black" points="274,-230 274,-252 452,-252 452,-230 274,-230"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="279" y="-247"/> |
| <text text-anchor="start" x="294" y="-238.2" font-family="Helvetica,sans-Serif" font-size="11.00">appuser_id</text> |
| <polygon fill="none" stroke="black" points="452,-230 452,-252 522,-252 522,-230 452,-230"/> |
| <text text-anchor="start" x="455" y="-238.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="274,-212 274,-230 354,-230 354,-212 274,-212"/> |
| <polygon fill="none" stroke="black" points="274,-212 274,-230 354,-230 354,-212 274,-212"/> |
| <text text-anchor="start" x="277" y="-218.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 2</text> |
| <polygon fill="#ffffff" stroke="transparent" points="354,-212 354,-230 452,-230 452,-212 354,-212"/> |
| <polygon fill="none" stroke="black" points="354,-212 354,-230 452,-230 452,-212 354,-212"/> |
| <text text-anchor="start" x="416" y="-218.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="452,-212 452,-230 522,-230 522,-212 452,-212"/> |
| <polygon fill="none" stroke="black" points="452,-212 452,-230 522,-230 522,-212 452,-212"/> |
| <text text-anchor="start" x="503" y="-218.2" font-family="Helvetica,sans-Serif" font-size="11.00">2 ></text> |
| <polygon fill="none" stroke="black" stroke-width="2" points="273,-211 273,-517 523,-517 523,-211 273,-211"/> |
| </a> |
| </g> |
| </g> |
| <!-- acc_gl_journal_entry->m_client_transaction --> |
| <g id="edge1" class="edge"> |
| <title>acc_gl_journal_entry:w->m_client_transaction:e</title> |
| <path fill="none" stroke="black" d="M559.11,-214C522.48,-254.22 579.64,-483 523,-483"/> |
| <polygon fill="black" stroke="black" points="565.2,-211.27 573.97,-211.29 568.85,-209.64 572.5,-208 572.5,-208 572.5,-208 568.85,-209.64 571.03,-204.71 565.2,-211.27 565.2,-211.27"/> |
| <ellipse fill="none" stroke="black" cx="562.28" cy="-212.58" rx="3.2" ry="3.2"/> |
| </g> |
| <!-- m_appuser --> |
| <g id="node3" class="node"> |
| <title>m_appuser</title> |
| <g id="a_node3"><a xlink:href="../../tables/m_appuser.html" xlink:title="m_appuser" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="8,-37 8,-205 223,-205 223,-37 8,-37"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="8.5,-183 8.5,-205 223.5,-205 223.5,-183 8.5,-183"/> |
| <polygon fill="none" stroke="black" points="8.5,-183 8.5,-205 223.5,-205 223.5,-183 8.5,-183"/> |
| <text text-anchor="start" x="13.5" y="-192.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_appuser</text> |
| <text text-anchor="start" x="188.5" y="-191.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="8.5,-161 8.5,-183 223.5,-183 223.5,-161 8.5,-161"/> |
| <image xlink:href="../../images/primaryKeys.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">id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-139 8.5,-161 223.5,-161 223.5,-139 8.5,-139"/> |
| <polygon fill="none" stroke="black" points="8.5,-139 8.5,-161 223.5,-161 223.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">office_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-117 8.5,-139 223.5,-139 223.5,-117 8.5,-117"/> |
| <polygon fill="none" stroke="black" points="8.5,-117 8.5,-139 223.5,-139 223.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">staff_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-95 8.5,-117 223.5,-117 223.5,-95 8.5,-95"/> |
| <polygon fill="none" stroke="black" points="8.5,-95 8.5,-117 223.5,-117 223.5,-95 8.5,-95"/> |
| <text text-anchor="start" x="28.5" y="-103.2" font-family="Helvetica,sans-Serif" font-size="11.00">username</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-73 8.5,-95 223.5,-95 223.5,-73 8.5,-73"/> |
| <polygon fill="none" stroke="black" points="8.5,-73 8.5,-95 223.5,-95 223.5,-73 8.5,-73"/> |
| <text text-anchor="start" x="28.5" y="-81.2" font-family="Helvetica,sans-Serif" font-size="11.00">last_time_password_updated</text> |
| <polygon fill="none" stroke="black" points="8.5,-55 8.5,-73 223.5,-73 223.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 93.5,-55 93.5,-37 8.5,-37"/> |
| <polygon fill="none" stroke="black" points="8.5,-37 8.5,-55 93.5,-55 93.5,-37 8.5,-37"/> |
| <text text-anchor="start" x="11.5" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 2</text> |
| <polygon fill="#ffffff" stroke="transparent" points="93.5,-37 93.5,-55 163.5,-55 163.5,-37 93.5,-37"/> |
| <polygon fill="none" stroke="black" points="93.5,-37 93.5,-55 163.5,-55 163.5,-37 93.5,-37"/> |
| <text text-anchor="start" x="127.5" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="163.5,-37 163.5,-55 223.5,-55 223.5,-37 163.5,-37"/> |
| <polygon fill="none" stroke="black" points="163.5,-37 163.5,-55 223.5,-55 223.5,-37 163.5,-37"/> |
| <text text-anchor="start" x="198.5" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">57 ></text> |
| </a> |
| </g> |
| </g> |
| <!-- acc_gl_journal_entry->m_appuser --> |
| <g id="edge2" class="edge"> |
| <title>acc_gl_journal_entry:w->m_appuser:e</title> |
| <path fill="none" stroke="black" d="M557.89,-185.96C415.11,-185.11 374.3,-172 224.5,-172"/> |
| <polygon fill="black" stroke="black" points="564.5,-185.98 572.49,-189.6 568.5,-185.99 572.5,-186 572.5,-186 572.5,-186 568.5,-185.99 572.51,-182.4 564.5,-185.98 564.5,-185.98"/> |
| <ellipse fill="none" stroke="black" cx="561.3" cy="-185.97" rx="3.2" ry="3.2"/> |
| </g> |
| <!-- acc_gl_journal_entry->m_appuser --> |
| <g id="edge3" class="edge"> |
| <title>acc_gl_journal_entry:w->m_appuser:e</title> |
| <path fill="none" stroke="black" d="M558.03,-164C432.75,-164.09 396.1,-165.37 264,-170 246.43,-170.62 242.08,-172 224.5,-172"/> |
| <polygon fill="black" stroke="black" points="564.5,-164 572.5,-167.6 568.5,-164 572.5,-164 572.5,-164 572.5,-164 568.5,-164 572.5,-160.4 564.5,-164 564.5,-164"/> |
| <ellipse fill="none" stroke="black" cx="561.3" cy="-164" rx="3.2" ry="3.2"/> |
| </g> |
| <!-- m_client_transaction->m_appuser --> |
| <g id="edge5" class="edge"> |
| <title>m_client_transaction:w->m_appuser:e</title> |
| <path fill="none" stroke="black" d="M259.15,-236.04C242.48,-220.22 255.83,-172 224.5,-172"/> |
| <polygon fill="black" stroke="black" points="265.47,-238.3 271.79,-244.39 269.23,-239.65 273,-241 273,-241 273,-241 269.23,-239.65 274.21,-237.61 265.47,-238.3 265.47,-238.3"/> |
| <ellipse fill="none" stroke="black" cx="262.46" cy="-237.22" rx="3.2" ry="3.2"/> |
| </g> |
| <!-- m_client --> |
| <g id="node5" class="node"> |
| <title>m_client</title> |
| <g id="a_node5"><a xlink:href="../../tables/m_client.html" xlink:title="m_client" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="19,-226 19,-658 212,-658 212,-226 19,-226"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="19.5,-636 19.5,-658 212.5,-658 212.5,-636 19.5,-636"/> |
| <polygon fill="none" stroke="black" points="19.5,-636 19.5,-658 212.5,-658 212.5,-636 19.5,-636"/> |
| <text text-anchor="start" x="24.5" y="-645.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_client</text> |
| <text text-anchor="start" x="177.5" y="-644.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="19.5,-614 19.5,-636 212.5,-636 212.5,-614 19.5,-614"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="24.5" y="-631"/> |
| <text text-anchor="start" x="39.5" y="-622.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="19.5,-592 19.5,-614 212.5,-614 212.5,-592 19.5,-592"/> |
| <polygon fill="none" stroke="black" points="19.5,-592 19.5,-614 212.5,-614 212.5,-592 19.5,-592"/> |
| <text text-anchor="start" x="39.5" y="-600.2" font-family="Helvetica,sans-Serif" font-size="11.00">account_no</text> |
| <polygon fill="#ffffff" stroke="transparent" points="19.5,-570 19.5,-592 212.5,-592 212.5,-570 19.5,-570"/> |
| <polygon fill="none" stroke="black" points="19.5,-570 19.5,-592 212.5,-592 212.5,-570 19.5,-570"/> |
| <text text-anchor="start" x="39.5" y="-578.2" font-family="Helvetica,sans-Serif" font-size="11.00">external_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="19.5,-548 19.5,-570 212.5,-570 212.5,-548 19.5,-548"/> |
| <polygon fill="none" stroke="black" points="19.5,-548 19.5,-570 212.5,-570 212.5,-548 19.5,-548"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="24.5" y="-565"/> |
| <text text-anchor="start" x="39.5" y="-556.2" font-family="Helvetica,sans-Serif" font-size="11.00">sub_status</text> |
| <polygon fill="#ffffff" stroke="transparent" points="19.5,-526 19.5,-548 212.5,-548 212.5,-526 19.5,-526"/> |
| <polygon fill="none" stroke="black" points="19.5,-526 19.5,-548 212.5,-548 212.5,-526 19.5,-526"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="24.5" y="-543"/> |
| <text text-anchor="start" x="39.5" y="-534.2" font-family="Helvetica,sans-Serif" font-size="11.00">office_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="19.5,-504 19.5,-526 212.5,-526 212.5,-504 19.5,-504"/> |
| <polygon fill="none" stroke="black" points="19.5,-504 19.5,-526 212.5,-526 212.5,-504 19.5,-504"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="24.5" y="-521"/> |
| <text text-anchor="start" x="39.5" y="-512.2" font-family="Helvetica,sans-Serif" font-size="11.00">transfer_to_office_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="19.5,-482 19.5,-504 212.5,-504 212.5,-482 19.5,-482"/> |
| <polygon fill="none" stroke="black" points="19.5,-482 19.5,-504 212.5,-504 212.5,-482 19.5,-482"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="24.5" y="-499"/> |
| <text text-anchor="start" x="39.5" y="-490.2" font-family="Helvetica,sans-Serif" font-size="11.00">staff_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="19.5,-460 19.5,-482 212.5,-482 212.5,-460 19.5,-460"/> |
| <polygon fill="none" stroke="black" points="19.5,-460 19.5,-482 212.5,-482 212.5,-460 19.5,-460"/> |
| <text text-anchor="start" x="39.5" y="-468.2" font-family="Helvetica,sans-Serif" font-size="11.00">mobile_no</text> |
| <polygon fill="#ffffff" stroke="transparent" points="19.5,-438 19.5,-460 212.5,-460 212.5,-438 19.5,-438"/> |
| <polygon fill="none" stroke="black" points="19.5,-438 19.5,-460 212.5,-460 212.5,-438 19.5,-438"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="24.5" y="-455"/> |
| <text text-anchor="start" x="39.5" y="-446.2" font-family="Helvetica,sans-Serif" font-size="11.00">gender_cv_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="19.5,-416 19.5,-438 212.5,-438 212.5,-416 19.5,-416"/> |
| <polygon fill="none" stroke="black" points="19.5,-416 19.5,-438 212.5,-438 212.5,-416 19.5,-416"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="24.5" y="-433"/> |
| <text text-anchor="start" x="39.5" y="-424.2" font-family="Helvetica,sans-Serif" font-size="11.00">image_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="19.5,-394 19.5,-416 212.5,-416 212.5,-394 19.5,-394"/> |
| <polygon fill="none" stroke="black" points="19.5,-394 19.5,-416 212.5,-416 212.5,-394 19.5,-394"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="24.5" y="-411"/> |
| <text text-anchor="start" x="39.5" y="-402.2" font-family="Helvetica,sans-Serif" font-size="11.00">closure_reason_cv_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="19.5,-372 19.5,-394 212.5,-394 212.5,-372 19.5,-372"/> |
| <polygon fill="none" stroke="black" points="19.5,-372 19.5,-394 212.5,-394 212.5,-372 19.5,-372"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="24.5" y="-389"/> |
| <text text-anchor="start" x="39.5" y="-380.2" font-family="Helvetica,sans-Serif" font-size="11.00">default_savings_product</text> |
| <polygon fill="#ffffff" stroke="transparent" points="19.5,-350 19.5,-372 212.5,-372 212.5,-350 19.5,-350"/> |
| <polygon fill="none" stroke="black" points="19.5,-350 19.5,-372 212.5,-372 212.5,-350 19.5,-350"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="24.5" y="-367"/> |
| <text text-anchor="start" x="39.5" y="-358.2" font-family="Helvetica,sans-Serif" font-size="11.00">default_savings_account</text> |
| <polygon fill="#ffffff" stroke="transparent" points="19.5,-328 19.5,-350 212.5,-350 212.5,-328 19.5,-328"/> |
| <polygon fill="none" stroke="black" points="19.5,-328 19.5,-350 212.5,-350 212.5,-328 19.5,-328"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="24.5" y="-345"/> |
| <text text-anchor="start" x="39.5" y="-336.2" font-family="Helvetica,sans-Serif" font-size="11.00">client_type_cv_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="19.5,-306 19.5,-328 212.5,-328 212.5,-306 19.5,-306"/> |
| <polygon fill="none" stroke="black" points="19.5,-306 19.5,-328 212.5,-328 212.5,-306 19.5,-306"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="24.5" y="-323"/> |
| <text text-anchor="start" x="39.5" y="-314.2" font-family="Helvetica,sans-Serif" font-size="11.00">client_classification_cv_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="19.5,-284 19.5,-306 212.5,-306 212.5,-284 19.5,-284"/> |
| <polygon fill="none" stroke="black" points="19.5,-284 19.5,-306 212.5,-306 212.5,-284 19.5,-284"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="24.5" y="-301"/> |
| <text text-anchor="start" x="39.5" y="-292.2" font-family="Helvetica,sans-Serif" font-size="11.00">reject_reason_cv_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="19.5,-262 19.5,-284 212.5,-284 212.5,-262 19.5,-262"/> |
| <polygon fill="none" stroke="black" points="19.5,-262 19.5,-284 212.5,-284 212.5,-262 19.5,-262"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="24.5" y="-279"/> |
| <text text-anchor="start" x="39.5" y="-270.2" font-family="Helvetica,sans-Serif" font-size="11.00">withdraw_reason_cv_id</text> |
| <polygon fill="none" stroke="black" points="19.5,-244 19.5,-262 212.5,-262 212.5,-244 19.5,-244"/> |
| <text text-anchor="start" x="22.5" y="-250.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="19.5,-226 19.5,-244 96.5,-244 96.5,-226 19.5,-226"/> |
| <polygon fill="none" stroke="black" points="19.5,-226 19.5,-244 96.5,-244 96.5,-226 19.5,-226"/> |
| <text text-anchor="start" x="22.5" y="-232.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 13</text> |
| <polygon fill="#ffffff" stroke="transparent" points="96.5,-226 96.5,-244 159.5,-244 159.5,-226 96.5,-226"/> |
| <polygon fill="none" stroke="black" points="96.5,-226 96.5,-244 159.5,-244 159.5,-226 96.5,-226"/> |
| <text text-anchor="start" x="123.5" y="-232.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="159.5,-226 159.5,-244 212.5,-244 212.5,-226 159.5,-226"/> |
| <polygon fill="none" stroke="black" points="159.5,-226 159.5,-244 212.5,-244 212.5,-226 159.5,-226"/> |
| <text text-anchor="start" x="187.5" y="-232.2" font-family="Helvetica,sans-Serif" font-size="11.00">23 ></text> |
| </a> |
| </g> |
| </g> |
| <!-- m_client_transaction->m_client --> |
| <g id="edge6" class="edge"> |
| <title>m_client_transaction:w->m_client:e</title> |
| <path fill="none" stroke="black" d="M258.77,-463.45C208.37,-483.85 285.43,-625 213.5,-625"/> |
| <polygon fill="black" stroke="black" points="265.12,-462.36 273.61,-464.55 269.06,-461.68 273,-461 273,-461 273,-461 269.06,-461.68 272.39,-457.45 265.12,-462.36 265.12,-462.36"/> |
| <ellipse fill="none" stroke="black" cx="261.96" cy="-462.9" rx="3.2" ry="3.2"/> |
| </g> |
| <!-- m_client_charge_paid_by --> |
| <g id="node4" class="node"> |
| <title>m_client_charge_paid_by</title> |
| <g id="a_node4"><a xlink:href="../../tables/m_client_charge_paid_by.html" xlink:title="m_client_charge_paid_by" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="592,-414 592,-538 779,-538 779,-414 592,-414"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="592.5,-516 592.5,-538 779.5,-538 779.5,-516 592.5,-516"/> |
| <polygon fill="none" stroke="black" points="592.5,-516 592.5,-538 779.5,-538 779.5,-516 592.5,-516"/> |
| <text text-anchor="start" x="597.5" y="-525.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_client_charge_paid_by</text> |
| <text text-anchor="start" x="744.5" y="-524.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="592.5,-494 592.5,-516 779.5,-516 779.5,-494 592.5,-494"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="597.5" y="-511"/> |
| <text text-anchor="start" x="612.5" y="-502.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="592.5,-472 592.5,-494 779.5,-494 779.5,-472 592.5,-472"/> |
| <polygon fill="none" stroke="black" points="592.5,-472 592.5,-494 779.5,-494 779.5,-472 592.5,-472"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="597.5" y="-489"/> |
| <text text-anchor="start" x="612.5" y="-480.2" font-family="Helvetica,sans-Serif" font-size="11.00">client_transaction_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="592.5,-450 592.5,-472 779.5,-472 779.5,-450 592.5,-450"/> |
| <polygon fill="none" stroke="black" points="592.5,-450 592.5,-472 779.5,-472 779.5,-450 592.5,-450"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="597.5" y="-467"/> |
| <text text-anchor="start" x="612.5" y="-458.2" font-family="Helvetica,sans-Serif" font-size="11.00">client_charge_id</text> |
| <polygon fill="none" stroke="black" points="592.5,-432 592.5,-450 779.5,-450 779.5,-432 592.5,-432"/> |
| <text text-anchor="start" x="595.5" y="-438.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="592.5,-414 592.5,-432 670.5,-432 670.5,-414 592.5,-414"/> |
| <polygon fill="none" stroke="black" points="592.5,-414 592.5,-432 670.5,-432 670.5,-414 592.5,-414"/> |
| <text text-anchor="start" x="595.5" y="-420.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 2</text> |
| <polygon fill="#ffffff" stroke="transparent" points="670.5,-414 670.5,-432 737.5,-432 737.5,-414 670.5,-414"/> |
| <polygon fill="none" stroke="black" points="670.5,-414 670.5,-432 737.5,-432 737.5,-414 670.5,-414"/> |
| <text text-anchor="start" x="701.5" y="-420.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="737.5,-414 737.5,-432 779.5,-432 779.5,-414 737.5,-414"/> |
| <polygon fill="none" stroke="black" points="737.5,-414 737.5,-432 779.5,-432 779.5,-414 737.5,-414"/> |
| <text text-anchor="start" x="769.5" y="-420.2" font-family="Helvetica,sans-Serif" font-size="11.00">  </text> |
| </a> |
| </g> |
| </g> |
| <!-- m_client_charge_paid_by->m_client_transaction --> |
| <g id="edge4" class="edge"> |
| <title>m_client_charge_paid_by:w->m_client_transaction:e</title> |
| <path fill="none" stroke="black" d="M577.04,-483C557.58,-483 547.97,-483 523,-483"/> |
| <polygon fill="black" stroke="black" points="583.5,-483 591.5,-486.6 587.5,-483 591.5,-483 591.5,-483 591.5,-483 587.5,-483 591.5,-479.4 583.5,-483 583.5,-483"/> |
| <ellipse fill="none" stroke="black" cx="580.3" cy="-483" rx="3.2" ry="3.2"/> |
| </g> |
| </g> |
| </svg> |