| <?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="853pt" height="269pt" |
| viewBox="0.00 0.00 853.00 269.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 265)"> |
| <title>oneDegreeRelationshipsDiagram</title> |
| <polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-265 849,-265 849,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_variations_borrower_cycle --> |
| <g id="node1" class="node"> |
| <title>m_product_loan_variations_borrower_cycle</title> |
| <g id="a_node1"><a xlink:href="../../tables/m_product_loan_variations_borrower_cycle.html" xlink:title="m_product_loan_variations_borrower_cycle" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="454,-37 454,-257 837,-257 837,-37 454,-37"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="456.5,-233 456.5,-255 835.5,-255 835.5,-233 456.5,-233"/> |
| <polygon fill="none" stroke="black" points="456.5,-233 456.5,-255 835.5,-255 835.5,-233 456.5,-233"/> |
| <text text-anchor="start" x="461.5" y="-242.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_product_loan_variations_borrower_cycle</text> |
| <text text-anchor="start" x="800.5" y="-241.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="456.5,-211 456.5,-233 765.5,-233 765.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">id</text> |
| <polygon fill="none" stroke="black" points="765.5,-211 765.5,-233 835.5,-233 835.5,-211 765.5,-211"/> |
| <text text-anchor="start" x="768.5" y="-219.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="456.5,-189 456.5,-211 765.5,-211 765.5,-189 456.5,-189"/> |
| <polygon fill="none" stroke="black" points="456.5,-189 456.5,-211 765.5,-211 765.5,-189 456.5,-189"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="461.5" y="-206"/> |
| <text text-anchor="start" x="476.5" y="-197.2" font-family="Helvetica,sans-Serif" font-size="11.00">loan_product_id</text> |
| <polygon fill="none" stroke="black" points="765.5,-189 765.5,-211 835.5,-211 835.5,-189 765.5,-189"/> |
| <text text-anchor="start" x="768.5" y="-197.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="none" stroke="black" points="456.5,-167 456.5,-189 765.5,-189 765.5,-167 456.5,-167"/> |
| <text text-anchor="start" x="476.5" y="-175.2" font-family="Helvetica,sans-Serif" font-size="11.00">borrower_cycle_number</text> |
| <polygon fill="none" stroke="black" points="765.5,-167 765.5,-189 835.5,-189 835.5,-167 765.5,-167"/> |
| <text text-anchor="start" x="768.5" y="-175.2" font-family="Helvetica,sans-Serif" font-size="11.00">int[10]</text> |
| <polygon fill="none" stroke="black" points="456.5,-145 456.5,-167 765.5,-167 765.5,-145 456.5,-145"/> |
| <text text-anchor="start" x="476.5" y="-153.2" font-family="Helvetica,sans-Serif" font-size="11.00">value_condition</text> |
| <polygon fill="none" stroke="black" points="765.5,-145 765.5,-167 835.5,-167 835.5,-145 765.5,-145"/> |
| <text text-anchor="start" x="768.5" y="-153.2" font-family="Helvetica,sans-Serif" font-size="11.00">int[10]</text> |
| <polygon fill="none" stroke="black" points="456.5,-123 456.5,-145 765.5,-145 765.5,-123 456.5,-123"/> |
| <text text-anchor="start" x="476.5" y="-131.2" font-family="Helvetica,sans-Serif" font-size="11.00">param_type</text> |
| <polygon fill="none" stroke="black" points="765.5,-123 765.5,-145 835.5,-145 835.5,-123 765.5,-123"/> |
| <text text-anchor="start" x="768.5" y="-131.2" font-family="Helvetica,sans-Serif" font-size="11.00">int[10]</text> |
| <polygon fill="none" stroke="black" points="456.5,-101 456.5,-123 765.5,-123 765.5,-101 456.5,-101"/> |
| <text text-anchor="start" x="476.5" y="-109.2" font-family="Helvetica,sans-Serif" font-size="11.00">default_value</text> |
| <polygon fill="none" stroke="black" points="765.5,-101 765.5,-123 835.5,-123 835.5,-101 765.5,-101"/> |
| <text text-anchor="start" x="768.5" y="-109.2" font-family="Helvetica,sans-Serif" font-size="11.00">decimal[19,6]</text> |
| <polygon fill="none" stroke="black" points="456.5,-79 456.5,-101 765.5,-101 765.5,-79 456.5,-79"/> |
| <text text-anchor="start" x="476.5" y="-87.2" font-family="Helvetica,sans-Serif" font-size="11.00">max_value</text> |
| <polygon fill="none" stroke="black" points="765.5,-79 765.5,-101 835.5,-101 835.5,-79 765.5,-79"/> |
| <text text-anchor="start" x="768.5" y="-87.2" font-family="Helvetica,sans-Serif" font-size="11.00">decimal[19,6]</text> |
| <polygon fill="none" stroke="black" points="456.5,-57 456.5,-79 765.5,-79 765.5,-57 456.5,-57"/> |
| <text text-anchor="start" x="476.5" y="-65.2" font-family="Helvetica,sans-Serif" font-size="11.00">min_value</text> |
| <polygon fill="none" stroke="black" points="765.5,-57 765.5,-79 835.5,-79 835.5,-57 765.5,-57"/> |
| <text text-anchor="start" x="768.5" y="-65.2" font-family="Helvetica,sans-Serif" font-size="11.00">decimal[19,6]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="456.5,-39 456.5,-57 602.5,-57 602.5,-39 456.5,-39"/> |
| <polygon fill="none" stroke="black" points="456.5,-39 456.5,-57 602.5,-57 602.5,-39 456.5,-39"/> |
| <text text-anchor="start" x="459.5" y="-45.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 1</text> |
| <polygon fill="#ffffff" stroke="transparent" points="602.5,-39 602.5,-57 765.5,-57 765.5,-39 602.5,-39"/> |
| <polygon fill="none" stroke="black" points="602.5,-39 602.5,-57 765.5,-57 765.5,-39 602.5,-39"/> |
| <text text-anchor="start" x="729.5" y="-45.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="765.5,-39 765.5,-57 835.5,-57 835.5,-39 765.5,-39"/> |
| <polygon fill="none" stroke="black" points="765.5,-39 765.5,-57 835.5,-57 835.5,-39 765.5,-39"/> |
| <text text-anchor="start" x="816.5" y="-45.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 ></text> |
| <polygon fill="none" stroke="black" stroke-width="2" points="455,-38 455,-256 836,-256 836,-38 455,-38"/> |
| </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,-43 8,-233 405,-233 405,-43 8,-43"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="8.5,-211 8.5,-233 405.5,-233 405.5,-211 8.5,-211"/> |
| <polygon fill="none" stroke="black" points="8.5,-211 8.5,-233 405.5,-233 405.5,-211 8.5,-211"/> |
| <text text-anchor="start" x="13.5" y="-220.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="-219.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="8.5,-189 8.5,-211 405.5,-211 405.5,-189 8.5,-189"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-206"/> |
| <text text-anchor="start" x="28.5" y="-197.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-167 8.5,-189 405.5,-189 405.5,-167 8.5,-167"/> |
| <polygon fill="none" stroke="black" points="8.5,-167 8.5,-189 405.5,-189 405.5,-167 8.5,-167"/> |
| <text text-anchor="start" x="28.5" y="-175.2" font-family="Helvetica,sans-Serif" font-size="11.00">short_name</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-145 8.5,-167 405.5,-167 405.5,-145 8.5,-145"/> |
| <polygon fill="none" stroke="black" points="8.5,-145 8.5,-167 405.5,-167 405.5,-145 8.5,-145"/> |
| <text text-anchor="start" x="28.5" y="-153.2" font-family="Helvetica,sans-Serif" font-size="11.00">name</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-123 8.5,-145 405.5,-145 405.5,-123 8.5,-123"/> |
| <polygon fill="none" stroke="black" points="8.5,-123 8.5,-145 405.5,-145 405.5,-123 8.5,-123"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-140"/> |
| <text text-anchor="start" x="28.5" y="-131.2" font-family="Helvetica,sans-Serif" font-size="11.00">fund_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-101 8.5,-123 405.5,-123 405.5,-101 8.5,-101"/> |
| <polygon fill="none" stroke="black" points="8.5,-101 8.5,-123 405.5,-123 405.5,-101 8.5,-101"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-118"/> |
| <text text-anchor="start" x="28.5" y="-109.2" font-family="Helvetica,sans-Serif" font-size="11.00">loan_transaction_strategy_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-79 8.5,-101 405.5,-101 405.5,-79 8.5,-79"/> |
| <polygon fill="none" stroke="black" points="8.5,-79 8.5,-101 405.5,-101 405.5,-79 8.5,-79"/> |
| <text text-anchor="start" x="28.5" y="-87.2" font-family="Helvetica,sans-Serif" font-size="11.00">external_id</text> |
| <polygon fill="none" stroke="black" points="8.5,-61 8.5,-79 405.5,-79 405.5,-61 8.5,-61"/> |
| <text text-anchor="start" x="11.5" y="-67.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-43 8.5,-61 184.5,-61 184.5,-43 8.5,-43"/> |
| <polygon fill="none" stroke="black" points="8.5,-43 8.5,-61 184.5,-61 184.5,-43 8.5,-43"/> |
| <text text-anchor="start" x="11.5" y="-49.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 2</text> |
| <polygon fill="#ffffff" stroke="transparent" points="184.5,-43 184.5,-61 300.5,-61 300.5,-43 184.5,-43"/> |
| <polygon fill="none" stroke="black" points="184.5,-43 184.5,-61 300.5,-61 300.5,-43 184.5,-43"/> |
| <text text-anchor="start" x="264.5" y="-49.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="300.5,-43 300.5,-61 405.5,-61 405.5,-43 300.5,-43"/> |
| <polygon fill="none" stroke="black" points="300.5,-43 300.5,-61 405.5,-61 405.5,-43 300.5,-43"/> |
| <text text-anchor="start" x="380.5" y="-49.2" font-family="Helvetica,sans-Serif" font-size="11.00">14 ></text> |
| </a> |
| </g> |
| </g> |
| <!-- m_product_loan_variations_borrower_cycle->m_product_loan --> |
| <g id="edge1" class="edge"> |
| <title>m_product_loan_variations_borrower_cycle:w->m_product_loan:e</title> |
| <path fill="none" stroke="black" d="M440.99,-200C429.68,-200 422.49,-200 406.5,-200"/> |
| <polygon fill="black" stroke="black" points="447.5,-200 455.5,-203.6 451.5,-200 455.5,-200 455.5,-200 455.5,-200 451.5,-200 455.5,-196.4 447.5,-200 447.5,-200"/> |
| <ellipse fill="none" stroke="black" cx="444.3" cy="-200" rx="3.2" ry="3.2"/> |
| </g> |
| </g> |
| </svg> |