| <?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="803pt" height="384pt" |
| viewBox="0.00 0.00 803.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 799,-380 799,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_creditbureau_loanproduct_mapping --> |
| <g id="node1" class="node"> |
| <title>m_creditbureau_loanproduct_mapping</title> |
| <g id="a_node1"><a xlink:href="../../tables/m_creditbureau_loanproduct_mapping.html" xlink:title="m_creditbureau_loanproduct_mapping" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="454,-136 454,-334 787,-334 787,-136 454,-136"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="456.5,-310 456.5,-332 785.5,-332 785.5,-310 456.5,-310"/> |
| <polygon fill="none" stroke="black" points="456.5,-310 456.5,-332 785.5,-332 785.5,-310 456.5,-310"/> |
| <text text-anchor="start" x="461.5" y="-319.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_creditbureau_loanproduct_mapping</text> |
| <text text-anchor="start" x="750.5" y="-318.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="456.5,-288 456.5,-310 735.5,-310 735.5,-288 456.5,-288"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="461.5" y="-305"/> |
| <text text-anchor="start" x="476.5" y="-296.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="none" stroke="black" points="735.5,-288 735.5,-310 785.5,-310 785.5,-288 735.5,-288"/> |
| <text text-anchor="start" x="738.5" y="-296.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="456.5,-266 456.5,-288 735.5,-288 735.5,-266 456.5,-266"/> |
| <polygon fill="none" stroke="black" points="456.5,-266 456.5,-288 735.5,-288 735.5,-266 456.5,-266"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="461.5" y="-283"/> |
| <text text-anchor="start" x="476.5" y="-274.2" font-family="Helvetica,sans-Serif" font-size="11.00">organisation_creditbureau_id</text> |
| <polygon fill="none" stroke="black" points="735.5,-266 735.5,-288 785.5,-288 785.5,-266 735.5,-266"/> |
| <text text-anchor="start" x="738.5" y="-274.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="456.5,-244 456.5,-266 735.5,-266 735.5,-244 456.5,-244"/> |
| <polygon fill="none" stroke="black" points="456.5,-244 456.5,-266 735.5,-266 735.5,-244 456.5,-244"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="461.5" y="-261"/> |
| <text text-anchor="start" x="476.5" y="-252.2" font-family="Helvetica,sans-Serif" font-size="11.00">loan_product_id</text> |
| <polygon fill="none" stroke="black" points="735.5,-244 735.5,-266 785.5,-266 785.5,-244 735.5,-244"/> |
| <text text-anchor="start" x="738.5" y="-252.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="none" stroke="black" points="456.5,-222 456.5,-244 735.5,-244 735.5,-222 456.5,-222"/> |
| <text text-anchor="start" x="476.5" y="-230.2" font-family="Helvetica,sans-Serif" font-size="11.00">is_creditcheck_mandatory</text> |
| <polygon fill="none" stroke="black" points="735.5,-222 735.5,-244 785.5,-244 785.5,-222 735.5,-222"/> |
| <text text-anchor="start" x="738.5" y="-230.2" font-family="Helvetica,sans-Serif" font-size="11.00">bit[1]</text> |
| <polygon fill="none" stroke="black" points="456.5,-200 456.5,-222 735.5,-222 735.5,-200 456.5,-200"/> |
| <text text-anchor="start" x="476.5" y="-208.2" font-family="Helvetica,sans-Serif" font-size="11.00">skip_creditcheck_in_failure</text> |
| <polygon fill="none" stroke="black" points="735.5,-200 735.5,-222 785.5,-222 785.5,-200 735.5,-200"/> |
| <text text-anchor="start" x="738.5" y="-208.2" font-family="Helvetica,sans-Serif" font-size="11.00">bit[1]</text> |
| <polygon fill="none" stroke="black" points="456.5,-178 456.5,-200 735.5,-200 735.5,-178 456.5,-178"/> |
| <text text-anchor="start" x="476.5" y="-186.2" font-family="Helvetica,sans-Serif" font-size="11.00">stale_period</text> |
| <polygon fill="none" stroke="black" points="735.5,-178 735.5,-200 785.5,-200 785.5,-178 735.5,-178"/> |
| <text text-anchor="start" x="738.5" y="-186.2" font-family="Helvetica,sans-Serif" font-size="11.00">int[10]</text> |
| <polygon fill="none" stroke="black" points="456.5,-156 456.5,-178 735.5,-178 735.5,-156 456.5,-156"/> |
| <text text-anchor="start" x="476.5" y="-164.2" font-family="Helvetica,sans-Serif" font-size="11.00">is_active</text> |
| <polygon fill="none" stroke="black" points="735.5,-156 735.5,-178 785.5,-178 785.5,-156 735.5,-156"/> |
| <text text-anchor="start" x="738.5" y="-164.2" font-family="Helvetica,sans-Serif" font-size="11.00">bit[1]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="456.5,-138 456.5,-156 587.5,-156 587.5,-138 456.5,-138"/> |
| <polygon fill="none" stroke="black" points="456.5,-138 456.5,-156 587.5,-156 587.5,-138 456.5,-138"/> |
| <text text-anchor="start" x="459.5" y="-144.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 2</text> |
| <polygon fill="#ffffff" stroke="transparent" points="587.5,-138 587.5,-156 735.5,-156 735.5,-138 587.5,-138"/> |
| <polygon fill="none" stroke="black" points="587.5,-138 587.5,-156 735.5,-156 735.5,-138 587.5,-138"/> |
| <text text-anchor="start" x="699.5" y="-144.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="735.5,-138 735.5,-156 785.5,-156 785.5,-138 735.5,-138"/> |
| <polygon fill="none" stroke="black" points="735.5,-138 735.5,-156 785.5,-156 785.5,-138 735.5,-138"/> |
| <text text-anchor="start" x="766.5" y="-144.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 ></text> |
| <polygon fill="none" stroke="black" stroke-width="2" points="455,-137 455,-333 786,-333 786,-137 455,-137"/> |
| </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,-37 8,-227 405,-227 405,-37 8,-37"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="8.5,-205 8.5,-227 405.5,-227 405.5,-205 8.5,-205"/> |
| <polygon fill="none" stroke="black" points="8.5,-205 8.5,-227 405.5,-227 405.5,-205 8.5,-205"/> |
| <text text-anchor="start" x="13.5" y="-214.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="-213.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="8.5,-183 8.5,-205 405.5,-205 405.5,-183 8.5,-183"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-200"/> |
| <text text-anchor="start" x="28.5" y="-191.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-161 8.5,-183 405.5,-183 405.5,-161 8.5,-161"/> |
| <polygon fill="none" stroke="black" points="8.5,-161 8.5,-183 405.5,-183 405.5,-161 8.5,-161"/> |
| <text text-anchor="start" x="28.5" y="-169.2" font-family="Helvetica,sans-Serif" font-size="11.00">short_name</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-139 8.5,-161 405.5,-161 405.5,-139 8.5,-139"/> |
| <polygon fill="none" stroke="black" points="8.5,-139 8.5,-161 405.5,-161 405.5,-139 8.5,-139"/> |
| <text text-anchor="start" x="28.5" y="-147.2" font-family="Helvetica,sans-Serif" font-size="11.00">name</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-117 8.5,-139 405.5,-139 405.5,-117 8.5,-117"/> |
| <polygon fill="none" stroke="black" points="8.5,-117 8.5,-139 405.5,-139 405.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">fund_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-95 8.5,-117 405.5,-117 405.5,-95 8.5,-95"/> |
| <polygon fill="none" stroke="black" points="8.5,-95 8.5,-117 405.5,-117 405.5,-95 8.5,-95"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-112"/> |
| <text text-anchor="start" x="28.5" y="-103.2" font-family="Helvetica,sans-Serif" font-size="11.00">loan_transaction_strategy_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-73 8.5,-95 405.5,-95 405.5,-73 8.5,-73"/> |
| <polygon fill="none" stroke="black" points="8.5,-73 8.5,-95 405.5,-95 405.5,-73 8.5,-73"/> |
| <text text-anchor="start" x="28.5" y="-81.2" font-family="Helvetica,sans-Serif" font-size="11.00">external_id</text> |
| <polygon fill="none" stroke="black" points="8.5,-55 8.5,-73 405.5,-73 405.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 184.5,-55 184.5,-37 8.5,-37"/> |
| <polygon fill="none" stroke="black" points="8.5,-37 8.5,-55 184.5,-55 184.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="184.5,-37 184.5,-55 300.5,-55 300.5,-37 184.5,-37"/> |
| <polygon fill="none" stroke="black" points="184.5,-37 184.5,-55 300.5,-55 300.5,-37 184.5,-37"/> |
| <text text-anchor="start" x="264.5" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="300.5,-37 300.5,-55 405.5,-55 405.5,-37 300.5,-37"/> |
| <polygon fill="none" stroke="black" points="300.5,-37 300.5,-55 405.5,-55 405.5,-37 300.5,-37"/> |
| <text text-anchor="start" x="380.5" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">14 ></text> |
| </a> |
| </g> |
| </g> |
| <!-- m_creditbureau_loanproduct_mapping->m_product_loan --> |
| <g id="edge1" class="edge"> |
| <title>m_creditbureau_loanproduct_mapping:w->m_product_loan:e</title> |
| <path fill="none" stroke="black" d="M441.91,-250.21C426.15,-235.83 435.3,-194 406.5,-194"/> |
| <polygon fill="black" stroke="black" points="447.95,-252.34 454.3,-258.4 451.73,-253.67 455.5,-255 455.5,-255 455.5,-255 451.73,-253.67 456.7,-251.6 447.95,-252.34 447.95,-252.34"/> |
| <ellipse fill="none" stroke="black" cx="444.94" cy="-251.28" rx="3.2" ry="3.2"/> |
| </g> |
| <!-- m_organisation_creditbureau --> |
| <g id="node3" class="node"> |
| <title>m_organisation_creditbureau</title> |
| <g id="a_node3"><a xlink:href="../../tables/m_organisation_creditbureau.html" xlink:title="m_organisation_creditbureau" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="97.5,-248 97.5,-372 315.5,-372 315.5,-248 97.5,-248"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="97.5,-350 97.5,-372 315.5,-372 315.5,-350 97.5,-350"/> |
| <polygon fill="none" stroke="black" points="97.5,-350 97.5,-372 315.5,-372 315.5,-350 97.5,-350"/> |
| <text text-anchor="start" x="102.5" y="-359.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_organisation_creditbureau</text> |
| <text text-anchor="start" x="280.5" y="-358.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="97.5,-328 97.5,-350 315.5,-350 315.5,-328 97.5,-328"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="102.5" y="-345"/> |
| <text text-anchor="start" x="117.5" y="-336.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="97.5,-306 97.5,-328 315.5,-328 315.5,-306 97.5,-306"/> |
| <polygon fill="none" stroke="black" points="97.5,-306 97.5,-328 315.5,-328 315.5,-306 97.5,-306"/> |
| <text text-anchor="start" x="117.5" y="-314.2" font-family="Helvetica,sans-Serif" font-size="11.00">alias</text> |
| <polygon fill="#ffffff" stroke="transparent" points="97.5,-284 97.5,-306 315.5,-306 315.5,-284 97.5,-284"/> |
| <polygon fill="none" stroke="black" points="97.5,-284 97.5,-306 315.5,-306 315.5,-284 97.5,-284"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="102.5" y="-301"/> |
| <text text-anchor="start" x="117.5" y="-292.2" font-family="Helvetica,sans-Serif" font-size="11.00">creditbureau_id</text> |
| <polygon fill="none" stroke="black" points="97.5,-266 97.5,-284 315.5,-284 315.5,-266 97.5,-266"/> |
| <text text-anchor="start" x="100.5" y="-272.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="97.5,-248 97.5,-266 186.5,-266 186.5,-248 97.5,-248"/> |
| <polygon fill="none" stroke="black" points="97.5,-248 97.5,-266 186.5,-266 186.5,-248 97.5,-248"/> |
| <text text-anchor="start" x="100.5" y="-254.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 1</text> |
| <polygon fill="#ffffff" stroke="transparent" points="186.5,-248 186.5,-266 259.5,-266 259.5,-248 186.5,-248"/> |
| <polygon fill="none" stroke="black" points="186.5,-248 186.5,-266 259.5,-266 259.5,-248 186.5,-248"/> |
| <text text-anchor="start" x="223.5" y="-254.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="259.5,-248 259.5,-266 315.5,-266 315.5,-248 259.5,-248"/> |
| <polygon fill="none" stroke="black" points="259.5,-248 259.5,-266 315.5,-266 315.5,-248 259.5,-248"/> |
| <text text-anchor="start" x="296.5" y="-254.2" font-family="Helvetica,sans-Serif" font-size="11.00">1 ></text> |
| </a> |
| </g> |
| </g> |
| <!-- m_creditbureau_loanproduct_mapping->m_organisation_creditbureau --> |
| <g id="edge2" class="edge"> |
| <title>m_creditbureau_loanproduct_mapping:w->m_organisation_creditbureau:e</title> |
| <path fill="none" stroke="black" d="M441.1,-278.02C386.92,-286.09 378.99,-339 316.5,-339"/> |
| <polygon fill="black" stroke="black" points="447.52,-277.57 455.76,-280.59 451.51,-277.28 455.5,-277 455.5,-277 455.5,-277 451.51,-277.28 455.24,-273.41 447.52,-277.57 447.52,-277.57"/> |
| <ellipse fill="none" stroke="black" cx="444.33" cy="-277.79" rx="3.2" ry="3.2"/> |
| </g> |
| </g> |
| </svg> |
