| <?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="685pt" height="384pt" |
| viewBox="0.00 0.00 685.00 384.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 380)"> |
| <title>oneDegreeRelationshipsDiagram</title> |
| <polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-380 681,-380 681,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_product_loan_rate --> |
| <g id="node1" class="node"> |
| <title>m_product_loan_rate</title> |
| <g id="a_node1"><a xlink:href="../../tables/m_product_loan_rate.html" xlink:title="m_product_loan_rate" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="454,-191 454,-279 669,-279 669,-191 454,-191"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="456.5,-255 456.5,-277 667.5,-277 667.5,-255 456.5,-255"/> |
| <polygon fill="none" stroke="black" points="456.5,-255 456.5,-277 667.5,-277 667.5,-255 456.5,-255"/> |
| <text text-anchor="start" x="461.5" y="-264.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_product_loan_rate</text> |
| <text text-anchor="start" x="632.5" y="-263.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="456.5,-233 456.5,-255 617.5,-255 617.5,-233 456.5,-233"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="461.5" y="-250"/> |
| <text text-anchor="start" x="476.5" y="-241.2" font-family="Helvetica,sans-Serif" font-size="11.00">product_loan_id</text> |
| <polygon fill="none" stroke="black" points="617.5,-233 617.5,-255 667.5,-255 667.5,-233 617.5,-233"/> |
| <text text-anchor="start" x="620.5" y="-241.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="none" stroke="black" points="456.5,-211 456.5,-233 617.5,-233 617.5,-211 456.5,-211"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="461.5" y="-228"/> |
| <text text-anchor="start" x="476.5" y="-219.2" font-family="Helvetica,sans-Serif" font-size="11.00">rate_id</text> |
| <polygon fill="none" stroke="black" points="617.5,-211 617.5,-233 667.5,-233 667.5,-211 617.5,-211"/> |
| <text text-anchor="start" x="620.5" y="-219.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="456.5,-193 456.5,-211 528.5,-211 528.5,-193 456.5,-193"/> |
| <polygon fill="none" stroke="black" points="456.5,-193 456.5,-211 528.5,-211 528.5,-193 456.5,-193"/> |
| <text text-anchor="start" x="459.5" y="-199.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 2</text> |
| <polygon fill="#ffffff" stroke="transparent" points="528.5,-193 528.5,-211 617.5,-211 617.5,-193 528.5,-193"/> |
| <polygon fill="none" stroke="black" points="528.5,-193 528.5,-211 617.5,-211 617.5,-193 528.5,-193"/> |
| <text text-anchor="start" x="581.5" y="-199.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="617.5,-193 617.5,-211 667.5,-211 667.5,-193 617.5,-193"/> |
| <polygon fill="none" stroke="black" points="617.5,-193 617.5,-211 667.5,-211 667.5,-193 617.5,-193"/> |
| <text text-anchor="start" x="648.5" y="-199.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 ></text> |
| <polygon fill="none" stroke="black" stroke-width="2" points="455,-192 455,-278 668,-278 668,-192 455,-192"/> |
| </a> |
| </g> |
| </g> |
| <!-- m_product_loan --> |
| <g id="node2" class="node"> |
| <title>m_product_loan</title> |
| <g id="a_node2"><a xlink:href="../../tables/m_product_loan.html" xlink:title="m_product_loan" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="8,-182 8,-372 405,-372 405,-182 8,-182"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="8.5,-350 8.5,-372 405.5,-372 405.5,-350 8.5,-350"/> |
| <polygon fill="none" stroke="black" points="8.5,-350 8.5,-372 405.5,-372 405.5,-350 8.5,-350"/> |
| <text text-anchor="start" x="13.5" y="-359.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_product_loan</text> |
| <text text-anchor="start" x="370.5" y="-358.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="8.5,-328 8.5,-350 405.5,-350 405.5,-328 8.5,-328"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-345"/> |
| <text text-anchor="start" x="28.5" y="-336.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-306 8.5,-328 405.5,-328 405.5,-306 8.5,-306"/> |
| <polygon fill="none" stroke="black" points="8.5,-306 8.5,-328 405.5,-328 405.5,-306 8.5,-306"/> |
| <text text-anchor="start" x="28.5" y="-314.2" font-family="Helvetica,sans-Serif" font-size="11.00">short_name</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-284 8.5,-306 405.5,-306 405.5,-284 8.5,-284"/> |
| <polygon fill="none" stroke="black" points="8.5,-284 8.5,-306 405.5,-306 405.5,-284 8.5,-284"/> |
| <text text-anchor="start" x="28.5" y="-292.2" font-family="Helvetica,sans-Serif" font-size="11.00">name</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-262 8.5,-284 405.5,-284 405.5,-262 8.5,-262"/> |
| <polygon fill="none" stroke="black" points="8.5,-262 8.5,-284 405.5,-284 405.5,-262 8.5,-262"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-279"/> |
| <text text-anchor="start" x="28.5" y="-270.2" font-family="Helvetica,sans-Serif" font-size="11.00">fund_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-240 8.5,-262 405.5,-262 405.5,-240 8.5,-240"/> |
| <polygon fill="none" stroke="black" points="8.5,-240 8.5,-262 405.5,-262 405.5,-240 8.5,-240"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-257"/> |
| <text text-anchor="start" x="28.5" y="-248.2" font-family="Helvetica,sans-Serif" font-size="11.00">loan_transaction_strategy_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-218 8.5,-240 405.5,-240 405.5,-218 8.5,-218"/> |
| <polygon fill="none" stroke="black" points="8.5,-218 8.5,-240 405.5,-240 405.5,-218 8.5,-218"/> |
| <text text-anchor="start" x="28.5" y="-226.2" font-family="Helvetica,sans-Serif" font-size="11.00">external_id</text> |
| <polygon fill="none" stroke="black" points="8.5,-200 8.5,-218 405.5,-218 405.5,-200 8.5,-200"/> |
| <text text-anchor="start" x="11.5" y="-206.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-182 8.5,-200 184.5,-200 184.5,-182 8.5,-182"/> |
| <polygon fill="none" stroke="black" points="8.5,-182 8.5,-200 184.5,-200 184.5,-182 8.5,-182"/> |
| <text text-anchor="start" x="11.5" y="-188.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 2</text> |
| <polygon fill="#ffffff" stroke="transparent" points="184.5,-182 184.5,-200 300.5,-200 300.5,-182 184.5,-182"/> |
| <polygon fill="none" stroke="black" points="184.5,-182 184.5,-200 300.5,-200 300.5,-182 184.5,-182"/> |
| <text text-anchor="start" x="264.5" y="-188.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="300.5,-182 300.5,-200 405.5,-200 405.5,-182 300.5,-182"/> |
| <polygon fill="none" stroke="black" points="300.5,-182 300.5,-200 405.5,-200 405.5,-182 300.5,-182"/> |
| <text text-anchor="start" x="380.5" y="-188.2" font-family="Helvetica,sans-Serif" font-size="11.00">14 ></text> |
| </a> |
| </g> |
| </g> |
| <!-- m_product_loan_rate->m_product_loan --> |
| <g id="edge1" class="edge"> |
| <title>m_product_loan_rate:w->m_product_loan:e</title> |
| <path fill="none" stroke="black" d="M441.39,-248.33C418.3,-266.91 447.88,-339 406.5,-339"/> |
| <polygon fill="black" stroke="black" points="447.85,-246.35 456.56,-247.44 451.68,-245.17 455.5,-244 455.5,-244 455.5,-244 451.68,-245.17 454.44,-240.56 447.85,-246.35 447.85,-246.35"/> |
| <ellipse fill="none" stroke="black" cx="444.79" cy="-247.28" rx="3.2" ry="3.2"/> |
| </g> |
| <!-- m_rate --> |
| <g id="node3" class="node"> |
| <title>m_rate</title> |
| <g id="a_node3"><a xlink:href="../../tables/m_rate.html" xlink:title="m_rate" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="135.5,-37 135.5,-161 277.5,-161 277.5,-37 135.5,-37"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="135.5,-139 135.5,-161 277.5,-161 277.5,-139 135.5,-139"/> |
| <polygon fill="none" stroke="black" points="135.5,-139 135.5,-161 277.5,-161 277.5,-139 135.5,-139"/> |
| <text text-anchor="start" x="140.5" y="-148.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_rate</text> |
| <text text-anchor="start" x="242.5" y="-147.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="135.5,-117 135.5,-139 277.5,-139 277.5,-117 135.5,-117"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="140.5" y="-134"/> |
| <text text-anchor="start" x="155.5" y="-125.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="135.5,-95 135.5,-117 277.5,-117 277.5,-95 135.5,-95"/> |
| <polygon fill="none" stroke="black" points="135.5,-95 135.5,-117 277.5,-117 277.5,-95 135.5,-95"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="140.5" y="-112"/> |
| <text text-anchor="start" x="155.5" y="-103.2" font-family="Helvetica,sans-Serif" font-size="11.00">createdby_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="135.5,-73 135.5,-95 277.5,-95 277.5,-73 135.5,-73"/> |
| <polygon fill="none" stroke="black" points="135.5,-73 135.5,-95 277.5,-95 277.5,-73 135.5,-73"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="140.5" y="-90"/> |
| <text text-anchor="start" x="155.5" y="-81.2" font-family="Helvetica,sans-Serif" font-size="11.00">approve_user</text> |
| <polygon fill="none" stroke="black" points="135.5,-55 135.5,-73 277.5,-73 277.5,-55 135.5,-55"/> |
| <text text-anchor="start" x="138.5" y="-61.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="135.5,-37 135.5,-55 186.5,-55 186.5,-37 135.5,-37"/> |
| <polygon fill="none" stroke="black" points="135.5,-37 135.5,-55 186.5,-55 186.5,-37 135.5,-37"/> |
| <text text-anchor="start" x="138.5" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 2</text> |
| <polygon fill="#ffffff" stroke="transparent" points="186.5,-37 186.5,-55 240.5,-55 240.5,-37 186.5,-37"/> |
| <polygon fill="none" stroke="black" points="186.5,-37 186.5,-55 240.5,-55 240.5,-37 186.5,-37"/> |
| <text text-anchor="start" x="204.5" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="240.5,-37 240.5,-55 277.5,-55 277.5,-37 240.5,-37"/> |
| <polygon fill="none" stroke="black" points="240.5,-37 240.5,-55 277.5,-55 277.5,-37 240.5,-37"/> |
| <text text-anchor="start" x="258.5" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">2 ></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="M441.32,-217.69C429.42,-208.07 431.92,-184.7 413,-172 360.78,-136.94 341.4,-128 278.5,-128"/> |
| <polygon fill="black" stroke="black" points="447.85,-219.67 454.45,-225.44 451.67,-220.84 455.5,-222 455.5,-222 455.5,-222 451.67,-220.84 456.55,-218.56 447.85,-219.67 447.85,-219.67"/> |
| <ellipse fill="none" stroke="black" cx="444.78" cy="-218.74" rx="3.2" ry="3.2"/> |
| </g> |
| </g> |
| </svg> |