| <?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="821pt" height="305pt" |
| viewBox="0.00 0.00 821.00 305.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 301)"> |
| <title>oneDegreeRelationshipsDiagram</title> |
| <polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-301 817,-301 817,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_loanproduct_provisioning_entry --> |
| <g id="node1" class="node"> |
| <title>m_loanproduct_provisioning_entry</title> |
| <g id="a_node1"><a xlink:href="../../tables/m_loanproduct_provisioning_entry.html" xlink:title="m_loanproduct_provisioning_entry" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="552,-59 552,-293 805,-293 805,-59 552,-59"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="552.5,-271 552.5,-293 805.5,-293 805.5,-271 552.5,-271"/> |
| <polygon fill="none" stroke="black" points="552.5,-271 552.5,-293 805.5,-293 805.5,-271 552.5,-271"/> |
| <text text-anchor="start" x="557.5" y="-280.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_loanproduct_provisioning_entry</text> |
| <text text-anchor="start" x="770.5" y="-279.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="552.5,-249 552.5,-271 805.5,-271 805.5,-249 552.5,-249"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="557.5" y="-266"/> |
| <text text-anchor="start" x="572.5" y="-257.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="552.5,-227 552.5,-249 805.5,-249 805.5,-227 552.5,-227"/> |
| <polygon fill="none" stroke="black" points="552.5,-227 552.5,-249 805.5,-249 805.5,-227 552.5,-227"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="557.5" y="-244"/> |
| <text text-anchor="start" x="572.5" y="-235.2" font-family="Helvetica,sans-Serif" font-size="11.00">history_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="552.5,-205 552.5,-227 805.5,-227 805.5,-205 552.5,-205"/> |
| <polygon fill="none" stroke="black" points="552.5,-205 552.5,-227 805.5,-227 805.5,-205 552.5,-205"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="557.5" y="-222"/> |
| <text text-anchor="start" x="572.5" y="-213.2" font-family="Helvetica,sans-Serif" font-size="11.00">criteria_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="552.5,-183 552.5,-205 805.5,-205 805.5,-183 552.5,-183"/> |
| <polygon fill="none" stroke="black" points="552.5,-183 552.5,-205 805.5,-205 805.5,-183 552.5,-183"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="557.5" y="-200"/> |
| <text text-anchor="start" x="572.5" y="-191.2" font-family="Helvetica,sans-Serif" font-size="11.00">office_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="552.5,-161 552.5,-183 805.5,-183 805.5,-161 552.5,-161"/> |
| <polygon fill="none" stroke="black" points="552.5,-161 552.5,-183 805.5,-183 805.5,-161 552.5,-161"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="557.5" y="-178"/> |
| <text text-anchor="start" x="572.5" y="-169.2" font-family="Helvetica,sans-Serif" font-size="11.00">product_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="552.5,-139 552.5,-161 805.5,-161 805.5,-139 552.5,-139"/> |
| <polygon fill="none" stroke="black" points="552.5,-139 552.5,-161 805.5,-161 805.5,-139 552.5,-139"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="557.5" y="-156"/> |
| <text text-anchor="start" x="572.5" y="-147.2" font-family="Helvetica,sans-Serif" font-size="11.00">category_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="552.5,-117 552.5,-139 805.5,-139 805.5,-117 552.5,-117"/> |
| <polygon fill="none" stroke="black" points="552.5,-117 552.5,-139 805.5,-139 805.5,-117 552.5,-117"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="557.5" y="-134"/> |
| <text text-anchor="start" x="572.5" y="-125.2" font-family="Helvetica,sans-Serif" font-size="11.00">liability_account</text> |
| <polygon fill="#ffffff" stroke="transparent" points="552.5,-95 552.5,-117 805.5,-117 805.5,-95 552.5,-95"/> |
| <polygon fill="none" stroke="black" points="552.5,-95 552.5,-117 805.5,-117 805.5,-95 552.5,-95"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="557.5" y="-112"/> |
| <text text-anchor="start" x="572.5" y="-103.2" font-family="Helvetica,sans-Serif" font-size="11.00">expense_account</text> |
| <polygon fill="none" stroke="black" points="552.5,-77 552.5,-95 805.5,-95 805.5,-77 552.5,-77"/> |
| <text text-anchor="start" x="555.5" y="-83.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="552.5,-59 552.5,-77 663.5,-77 663.5,-59 552.5,-59"/> |
| <polygon fill="none" stroke="black" points="552.5,-59 552.5,-77 663.5,-77 663.5,-59 552.5,-59"/> |
| <text text-anchor="start" x="555.5" y="-65.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 7</text> |
| <polygon fill="#ffffff" stroke="transparent" points="663.5,-59 663.5,-77 747.5,-77 747.5,-59 663.5,-59"/> |
| <polygon fill="none" stroke="black" points="663.5,-59 663.5,-77 747.5,-77 747.5,-59 663.5,-59"/> |
| <text text-anchor="start" x="711.5" y="-65.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="747.5,-59 747.5,-77 805.5,-77 805.5,-59 747.5,-59"/> |
| <polygon fill="none" stroke="black" points="747.5,-59 747.5,-77 805.5,-77 805.5,-59 747.5,-59"/> |
| <text text-anchor="start" x="795.5" y="-65.2" font-family="Helvetica,sans-Serif" font-size="11.00">  </text> |
| </a> |
| </g> |
| </g> |
| <!-- m_provisioning_history --> |
| <g id="node2" class="node"> |
| <title>m_provisioning_history</title> |
| <g id="a_node2"><a xlink:href="../../tables/m_provisioning_history.html" xlink:title="m_provisioning_history" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="272,-97 272,-273 503,-273 503,-97 272,-97"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="274.5,-249 274.5,-271 501.5,-271 501.5,-249 274.5,-249"/> |
| <polygon fill="none" stroke="black" points="274.5,-249 274.5,-271 501.5,-271 501.5,-249 274.5,-249"/> |
| <text text-anchor="start" x="279.5" y="-258.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_provisioning_history</text> |
| <text text-anchor="start" x="466.5" y="-257.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="274.5,-227 274.5,-249 451.5,-249 451.5,-227 274.5,-227"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="279.5" y="-244"/> |
| <text text-anchor="start" x="294.5" y="-235.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="none" stroke="black" points="451.5,-227 451.5,-249 501.5,-249 501.5,-227 451.5,-227"/> |
| <text text-anchor="start" x="454.5" y="-235.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="none" stroke="black" points="274.5,-205 274.5,-227 451.5,-227 451.5,-205 274.5,-205"/> |
| <text text-anchor="start" x="294.5" y="-213.2" font-family="Helvetica,sans-Serif" font-size="11.00">journal_entry_created</text> |
| <polygon fill="none" stroke="black" points="451.5,-205 451.5,-227 501.5,-227 501.5,-205 451.5,-205"/> |
| <text text-anchor="start" x="454.5" y="-213.2" font-family="Helvetica,sans-Serif" font-size="11.00">bit[1]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="274.5,-183 274.5,-205 451.5,-205 451.5,-183 274.5,-183"/> |
| <polygon fill="none" stroke="black" points="274.5,-183 274.5,-205 451.5,-205 451.5,-183 274.5,-183"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="279.5" y="-200"/> |
| <text text-anchor="start" x="294.5" y="-191.2" font-family="Helvetica,sans-Serif" font-size="11.00">createdby_id</text> |
| <polygon fill="none" stroke="black" points="451.5,-183 451.5,-205 501.5,-205 501.5,-183 451.5,-183"/> |
| <text text-anchor="start" x="454.5" y="-191.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="none" stroke="black" points="274.5,-161 274.5,-183 451.5,-183 451.5,-161 274.5,-161"/> |
| <text text-anchor="start" x="294.5" y="-169.2" font-family="Helvetica,sans-Serif" font-size="11.00">created_date</text> |
| <polygon fill="none" stroke="black" points="451.5,-161 451.5,-183 501.5,-183 501.5,-161 451.5,-161"/> |
| <text text-anchor="start" x="454.5" y="-169.2" font-family="Helvetica,sans-Serif" font-size="11.00">date[10]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="274.5,-139 274.5,-161 451.5,-161 451.5,-139 274.5,-139"/> |
| <polygon fill="none" stroke="black" points="274.5,-139 274.5,-161 451.5,-161 451.5,-139 274.5,-139"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="279.5" y="-156"/> |
| <text text-anchor="start" x="294.5" y="-147.2" font-family="Helvetica,sans-Serif" font-size="11.00">lastmodifiedby_id</text> |
| <polygon fill="none" stroke="black" points="451.5,-139 451.5,-161 501.5,-161 501.5,-139 451.5,-139"/> |
| <text text-anchor="start" x="454.5" y="-147.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="none" stroke="black" points="274.5,-117 274.5,-139 451.5,-139 451.5,-117 274.5,-117"/> |
| <text text-anchor="start" x="294.5" y="-125.2" font-family="Helvetica,sans-Serif" font-size="11.00">lastmodified_date</text> |
| <polygon fill="none" stroke="black" points="451.5,-117 451.5,-139 501.5,-139 501.5,-117 451.5,-117"/> |
| <text text-anchor="start" x="454.5" y="-125.2" font-family="Helvetica,sans-Serif" font-size="11.00">date[10]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="274.5,-99 274.5,-117 354.5,-117 354.5,-99 274.5,-99"/> |
| <polygon fill="none" stroke="black" points="274.5,-99 274.5,-117 354.5,-117 354.5,-99 274.5,-99"/> |
| <text text-anchor="start" x="277.5" y="-105.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 2</text> |
| <polygon fill="#ffffff" stroke="transparent" points="354.5,-99 354.5,-117 451.5,-117 451.5,-99 354.5,-99"/> |
| <polygon fill="none" stroke="black" points="354.5,-99 354.5,-117 451.5,-117 451.5,-99 354.5,-99"/> |
| <text text-anchor="start" x="415.5" y="-105.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="451.5,-99 451.5,-117 501.5,-117 501.5,-99 451.5,-99"/> |
| <polygon fill="none" stroke="black" points="451.5,-99 451.5,-117 501.5,-117 501.5,-99 451.5,-99"/> |
| <text text-anchor="start" x="482.5" y="-105.2" font-family="Helvetica,sans-Serif" font-size="11.00">1 ></text> |
| <polygon fill="none" stroke="black" stroke-width="2" points="273,-98 273,-272 502,-272 502,-98 273,-98"/> |
| </a> |
| </g> |
| </g> |
| <!-- m_loanproduct_provisioning_entry->m_provisioning_history --> |
| <g id="edge1" class="edge"> |
| <title>m_loanproduct_provisioning_entry:w->m_provisioning_history:e</title> |
| <path fill="none" stroke="black" d="M536.99,-238C525.68,-238 518.49,-238 502.5,-238"/> |
| <polygon fill="black" stroke="black" points="543.5,-238 551.5,-241.6 547.5,-238 551.5,-238 551.5,-238 551.5,-238 547.5,-238 551.5,-234.4 543.5,-238 543.5,-238"/> |
| <ellipse fill="none" stroke="black" cx="540.3" cy="-238" 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> |
| <!-- m_provisioning_history->m_appuser --> |
| <g id="edge2" class="edge"> |
| <title>m_provisioning_history:w->m_appuser:e</title> |
| <path fill="none" stroke="black" d="M259.13,-190.56C247.59,-184.38 242.4,-172 224.5,-172"/> |
| <polygon fill="black" stroke="black" points="265.72,-192.14 272.66,-197.5 269.61,-193.07 273.5,-194 273.5,-194 273.5,-194 269.61,-193.07 274.34,-190.5 265.72,-192.14 265.72,-192.14"/> |
| <ellipse fill="none" stroke="black" cx="262.61" cy="-191.39" rx="3.2" ry="3.2"/> |
| </g> |
| <!-- m_provisioning_history->m_appuser --> |
| <g id="edge3" class="edge"> |
| <title>m_provisioning_history:w->m_appuser:e</title> |
| <path fill="none" stroke="black" d="M259.13,-153.44C247.59,-159.62 242.4,-172 224.5,-172"/> |
| <polygon fill="black" stroke="black" points="265.72,-151.86 274.34,-153.5 269.61,-150.93 273.5,-150 273.5,-150 273.5,-150 269.61,-150.93 272.66,-146.5 265.72,-151.86 265.72,-151.86"/> |
| <ellipse fill="none" stroke="black" cx="262.61" cy="-152.61" rx="3.2" ry="3.2"/> |
| </g> |
| </g> |
| </svg> |
