| <?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="714pt" height="456pt" |
| viewBox="0.00 0.00 714.00 456.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 452)"> |
| <title>oneDegreeRelationshipsDiagram</title> |
| <polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-452 710,-452 710,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_loan_rate --> |
| <g id="node1" class="node"> |
| <title>m_loan_rate</title> |
| <g id="a_node1"><a xlink:href="../../tables/m_loan_rate.html" xlink:title="m_loan_rate" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="563,-360 563,-444 672,-444 672,-360 563,-360"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="563.5,-422 563.5,-444 672.5,-444 672.5,-422 563.5,-422"/> |
| <polygon fill="none" stroke="black" points="563.5,-422 563.5,-444 672.5,-444 672.5,-422 563.5,-422"/> |
| <text text-anchor="start" x="568.5" y="-431.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_loan_rate</text> |
| <text text-anchor="start" x="637.5" y="-430.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="563.5,-400 563.5,-422 672.5,-422 672.5,-400 563.5,-400"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="568.5" y="-417"/> |
| <text text-anchor="start" x="587.5" y="-408.2" font-family="Helvetica,sans-Serif" font-size="11.00">loan_id</text> |
| <polygon fill="none" stroke="black" points="563.5,-378 563.5,-400 672.5,-400 672.5,-378 563.5,-378"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="568.5" y="-395"/> |
| <text text-anchor="start" x="587.5" y="-386.2" font-family="Helvetica,sans-Serif" font-size="11.00">rate_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="563.5,-360 563.5,-378 602.5,-378 602.5,-360 563.5,-360"/> |
| <polygon fill="none" stroke="black" points="563.5,-360 563.5,-378 602.5,-378 602.5,-360 563.5,-360"/> |
| <text text-anchor="start" x="566.5" y="-366.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 2</text> |
| <polygon fill="#ffffff" stroke="transparent" points="602.5,-360 602.5,-378 650.5,-378 650.5,-360 602.5,-360"/> |
| <polygon fill="none" stroke="black" points="602.5,-360 602.5,-378 650.5,-378 650.5,-360 602.5,-360"/> |
| <text text-anchor="start" x="614.5" y="-366.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="650.5,-360 650.5,-378 672.5,-378 672.5,-360 650.5,-360"/> |
| <polygon fill="none" stroke="black" points="650.5,-360 650.5,-378 672.5,-378 672.5,-360 650.5,-360"/> |
| <text text-anchor="start" x="662.5" y="-366.2" font-family="Helvetica,sans-Serif" font-size="11.00">  </text> |
| </a> |
| </g> |
| </g> |
| <!-- m_rate --> |
| <g id="node2" class="node"> |
| <title>m_rate</title> |
| <g id="a_node2"><a xlink:href="../../tables/m_rate.html" xlink:title="m_rate" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="272,-108 272,-372 488,-372 488,-108 272,-108"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="274,-348 274,-370 486,-370 486,-348 274,-348"/> |
| <polygon fill="none" stroke="black" points="274,-348 274,-370 486,-370 486,-348 274,-348"/> |
| <text text-anchor="start" x="279" y="-357.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_rate</text> |
| <text text-anchor="start" x="451" y="-356.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="274,-326 274,-348 416,-348 416,-326 274,-326"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="279" y="-343"/> |
| <text text-anchor="start" x="294" y="-334.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="none" stroke="black" points="416,-326 416,-348 486,-348 486,-326 416,-326"/> |
| <text text-anchor="start" x="419" y="-334.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="none" stroke="black" points="274,-304 274,-326 416,-326 416,-304 274,-304"/> |
| <text text-anchor="start" x="294" y="-312.2" font-family="Helvetica,sans-Serif" font-size="11.00">name</text> |
| <polygon fill="none" stroke="black" points="416,-304 416,-326 486,-326 486,-304 416,-304"/> |
| <text text-anchor="start" x="419" y="-312.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[250]</text> |
| <polygon fill="none" stroke="black" points="274,-282 274,-304 416,-304 416,-282 274,-282"/> |
| <text text-anchor="start" x="294" y="-290.2" font-family="Helvetica,sans-Serif" font-size="11.00">percentage</text> |
| <polygon fill="none" stroke="black" points="416,-282 416,-304 486,-304 486,-282 416,-282"/> |
| <text text-anchor="start" x="419" y="-290.2" font-family="Helvetica,sans-Serif" font-size="11.00">decimal[10,2]</text> |
| <polygon fill="none" stroke="black" points="274,-260 274,-282 416,-282 416,-260 274,-260"/> |
| <text text-anchor="start" x="294" y="-268.2" font-family="Helvetica,sans-Serif" font-size="11.00">active</text> |
| <polygon fill="none" stroke="black" points="416,-260 416,-282 486,-282 486,-260 416,-260"/> |
| <text text-anchor="start" x="419" y="-268.2" font-family="Helvetica,sans-Serif" font-size="11.00">bit[1]</text> |
| <polygon fill="none" stroke="black" points="274,-238 274,-260 416,-260 416,-238 274,-238"/> |
| <text text-anchor="start" x="294" y="-246.2" font-family="Helvetica,sans-Serif" font-size="11.00">product_apply</text> |
| <polygon fill="none" stroke="black" points="416,-238 416,-260 486,-260 486,-238 416,-238"/> |
| <text text-anchor="start" x="419" y="-246.2" font-family="Helvetica,sans-Serif" font-size="11.00">smallint[5]</text> |
| <polygon fill="none" stroke="black" points="274,-216 274,-238 416,-238 416,-216 274,-216"/> |
| <text text-anchor="start" x="294" y="-224.2" font-family="Helvetica,sans-Serif" font-size="11.00">created_date</text> |
| <polygon fill="none" stroke="black" points="416,-216 416,-238 486,-238 486,-216 416,-216"/> |
| <text text-anchor="start" x="419" y="-224.2" font-family="Helvetica,sans-Serif" font-size="11.00">datetime[19]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="274,-194 274,-216 416,-216 416,-194 274,-194"/> |
| <polygon fill="none" stroke="black" points="274,-194 274,-216 416,-216 416,-194 274,-194"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="279" y="-211"/> |
| <text text-anchor="start" x="294" y="-202.2" font-family="Helvetica,sans-Serif" font-size="11.00">createdby_id</text> |
| <polygon fill="none" stroke="black" points="416,-194 416,-216 486,-216 486,-194 416,-194"/> |
| <text text-anchor="start" x="419" y="-202.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="none" stroke="black" points="274,-172 274,-194 416,-194 416,-172 274,-172"/> |
| <text text-anchor="start" x="294" y="-180.2" font-family="Helvetica,sans-Serif" font-size="11.00">lastmodifiedby_id</text> |
| <polygon fill="none" stroke="black" points="416,-172 416,-194 486,-194 486,-172 416,-172"/> |
| <text text-anchor="start" x="419" y="-180.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="none" stroke="black" points="274,-150 274,-172 416,-172 416,-150 274,-150"/> |
| <text text-anchor="start" x="294" y="-158.2" font-family="Helvetica,sans-Serif" font-size="11.00">lastmodified_date</text> |
| <polygon fill="none" stroke="black" points="416,-150 416,-172 486,-172 486,-150 416,-150"/> |
| <text text-anchor="start" x="419" y="-158.2" font-family="Helvetica,sans-Serif" font-size="11.00">datetime[19]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="274,-128 274,-150 416,-150 416,-128 274,-128"/> |
| <polygon fill="none" stroke="black" points="274,-128 274,-150 416,-150 416,-128 274,-128"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="279" y="-145"/> |
| <text text-anchor="start" x="294" y="-136.2" font-family="Helvetica,sans-Serif" font-size="11.00">approve_user</text> |
| <polygon fill="none" stroke="black" points="416,-128 416,-150 486,-150 486,-128 416,-128"/> |
| <text text-anchor="start" x="419" y="-136.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="274,-110 274,-128 336,-128 336,-110 274,-110"/> |
| <polygon fill="none" stroke="black" points="274,-110 274,-128 336,-128 336,-110 274,-110"/> |
| <text text-anchor="start" x="277" y="-116.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 2</text> |
| <polygon fill="#ffffff" stroke="transparent" points="336,-110 336,-128 416,-128 416,-110 336,-110"/> |
| <polygon fill="none" stroke="black" points="336,-110 336,-128 416,-128 416,-110 336,-110"/> |
| <text text-anchor="start" x="380" y="-116.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="416,-110 416,-128 486,-128 486,-110 416,-110"/> |
| <polygon fill="none" stroke="black" points="416,-110 416,-128 486,-128 486,-110 416,-110"/> |
| <text text-anchor="start" x="467" y="-116.2" font-family="Helvetica,sans-Serif" font-size="11.00">2 ></text> |
| <polygon fill="none" stroke="black" stroke-width="2" points="273,-109 273,-371 487,-371 487,-109 273,-109"/> |
| </a> |
| </g> |
| </g> |
| <!-- m_loan_rate->m_rate --> |
| <g id="edge1" class="edge"> |
| <title>m_loan_rate:w->m_rate:e</title> |
| <path fill="none" stroke="black" d="M548.17,-386.35C522.52,-375.75 522.17,-337 487,-337"/> |
| <polygon fill="black" stroke="black" points="554.63,-387.55 561.85,-392.54 558.57,-388.27 562.5,-389 562.5,-389 562.5,-389 558.57,-388.27 563.15,-385.46 554.63,-387.55 554.63,-387.55"/> |
| <ellipse fill="none" stroke="black" cx="551.49" cy="-386.96" rx="3.2" ry="3.2"/> |
| </g> |
| <!-- m_appuser --> |
| <g id="node4" class="node"> |
| <title>m_appuser</title> |
| <g id="a_node4"><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_rate->m_appuser --> |
| <g id="edge3" class="edge"> |
| <title>m_rate:w->m_appuser:e</title> |
| <path fill="none" stroke="black" d="M259.16,-143.31C247.05,-152.26 244.67,-172 224.5,-172"/> |
| <polygon fill="black" stroke="black" points="265.36,-141.38 274.07,-142.44 269.18,-140.19 273,-139 273,-139 273,-139 269.18,-140.19 271.93,-135.56 265.36,-141.38 265.36,-141.38"/> |
| <ellipse fill="none" stroke="black" cx="262.31" cy="-142.33" rx="3.2" ry="3.2"/> |
| </g> |
| <!-- m_rate->m_appuser --> |
| <g id="edge4" class="edge"> |
| <title>m_rate:w->m_appuser:e</title> |
| <path fill="none" stroke="black" d="M259.16,-200.69C247.05,-191.74 244.67,-172 224.5,-172"/> |
| <polygon fill="black" stroke="black" points="265.36,-202.62 271.93,-208.44 269.18,-203.81 273,-205 273,-205 273,-205 269.18,-203.81 274.07,-201.56 265.36,-202.62 265.36,-202.62"/> |
| <ellipse fill="none" stroke="black" cx="262.31" cy="-201.67" rx="3.2" ry="3.2"/> |
| </g> |
| <!-- m_product_loan_rate --> |
| <g id="node3" class="node"> |
| <title>m_product_loan_rate</title> |
| <g id="a_node3"><a xlink:href="../../tables/m_product_loan_rate.html" xlink:title="m_product_loan_rate" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="537,-255 537,-339 698,-339 698,-255 537,-255"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="537.5,-317 537.5,-339 698.5,-339 698.5,-317 537.5,-317"/> |
| <polygon fill="none" stroke="black" points="537.5,-317 537.5,-339 698.5,-339 698.5,-317 537.5,-317"/> |
| <text text-anchor="start" x="542.5" y="-326.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_product_loan_rate</text> |
| <text text-anchor="start" x="663.5" y="-325.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="537.5,-295 537.5,-317 698.5,-317 698.5,-295 537.5,-295"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="542.5" y="-312"/> |
| <text text-anchor="start" x="557.5" y="-303.2" font-family="Helvetica,sans-Serif" font-size="11.00">product_loan_id</text> |
| <polygon fill="none" stroke="black" points="537.5,-273 537.5,-295 698.5,-295 698.5,-273 537.5,-273"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="542.5" y="-290"/> |
| <text text-anchor="start" x="557.5" y="-281.2" font-family="Helvetica,sans-Serif" font-size="11.00">rate_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="537.5,-255 537.5,-273 602.5,-273 602.5,-255 537.5,-255"/> |
| <polygon fill="none" stroke="black" points="537.5,-255 537.5,-273 602.5,-273 602.5,-255 537.5,-255"/> |
| <text text-anchor="start" x="540.5" y="-261.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 2</text> |
| <polygon fill="#ffffff" stroke="transparent" points="602.5,-255 602.5,-273 663.5,-273 663.5,-255 602.5,-255"/> |
| <polygon fill="none" stroke="black" points="602.5,-255 602.5,-273 663.5,-273 663.5,-255 602.5,-255"/> |
| <text text-anchor="start" x="627.5" y="-261.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="663.5,-255 663.5,-273 698.5,-273 698.5,-255 663.5,-255"/> |
| <polygon fill="none" stroke="black" points="663.5,-255 663.5,-273 698.5,-273 698.5,-255 663.5,-255"/> |
| <text text-anchor="start" x="688.5" y="-261.2" font-family="Helvetica,sans-Serif" font-size="11.00">  </text> |
| </a> |
| </g> |
| </g> |
| <!-- m_product_loan_rate->m_rate --> |
| <g id="edge2" class="edge"> |
| <title>m_product_loan_rate:w->m_rate:e</title> |
| <path fill="none" stroke="black" d="M522.73,-288.89C508.22,-302.01 513.19,-337 487,-337"/> |
| <polygon fill="black" stroke="black" points="528.96,-286.68 537.7,-287.39 532.73,-285.34 536.5,-284 536.5,-284 536.5,-284 532.73,-285.34 535.3,-280.61 528.96,-286.68 528.96,-286.68"/> |
| <ellipse fill="none" stroke="black" cx="525.95" cy="-287.75" rx="3.2" ry="3.2"/> |
| </g> |
| </g> |
| </svg> |
