| <?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="858pt" height="489pt" |
| viewBox="0.00 0.00 858.00 489.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 485)"> |
| <title>oneDegreeRelationshipsDiagram</title> |
| <polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-485 854,-485 854,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_recalculation_details --> |
| <g id="node1" class="node"> |
| <title>m_product_loan_recalculation_details</title> |
| <g id="a_node1"><a xlink:href="../../tables/m_product_loan_recalculation_details.html" xlink:title="m_product_loan_recalculation_details" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="454,-37 454,-477 842,-477 842,-37 454,-37"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="456,-453 456,-475 840,-475 840,-453 456,-453"/> |
| <polygon fill="none" stroke="black" points="456,-453 456,-475 840,-475 840,-453 456,-453"/> |
| <text text-anchor="start" x="461" y="-462.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_product_loan_recalculation_details</text> |
| <text text-anchor="start" x="805" y="-461.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="456,-431 456,-453 785,-453 785,-431 456,-431"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="461" y="-448"/> |
| <text text-anchor="start" x="476" y="-439.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="none" stroke="black" points="785,-431 785,-453 840,-453 840,-431 785,-431"/> |
| <text text-anchor="start" x="788" y="-439.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="456,-409 456,-431 785,-431 785,-409 456,-409"/> |
| <polygon fill="none" stroke="black" points="456,-409 456,-431 785,-431 785,-409 456,-409"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="461" y="-426"/> |
| <text text-anchor="start" x="476" y="-417.2" font-family="Helvetica,sans-Serif" font-size="11.00">product_id</text> |
| <polygon fill="none" stroke="black" points="785,-409 785,-431 840,-431 840,-409 785,-409"/> |
| <text text-anchor="start" x="788" y="-417.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="none" stroke="black" points="456,-387 456,-409 785,-409 785,-387 456,-387"/> |
| <text text-anchor="start" x="476" y="-395.2" font-family="Helvetica,sans-Serif" font-size="11.00">compound_type_enum</text> |
| <polygon fill="none" stroke="black" points="785,-387 785,-409 840,-409 840,-387 785,-387"/> |
| <text text-anchor="start" x="788" y="-395.2" font-family="Helvetica,sans-Serif" font-size="11.00">smallint[5]</text> |
| <polygon fill="none" stroke="black" points="456,-365 456,-387 785,-387 785,-365 456,-365"/> |
| <text text-anchor="start" x="476" y="-373.2" font-family="Helvetica,sans-Serif" font-size="11.00">reschedule_strategy_enum</text> |
| <polygon fill="none" stroke="black" points="785,-365 785,-387 840,-387 840,-365 785,-365"/> |
| <text text-anchor="start" x="788" y="-373.2" font-family="Helvetica,sans-Serif" font-size="11.00">smallint[5]</text> |
| <polygon fill="none" stroke="black" points="456,-343 456,-365 785,-365 785,-343 456,-343"/> |
| <text text-anchor="start" x="476" y="-351.2" font-family="Helvetica,sans-Serif" font-size="11.00">rest_frequency_type_enum</text> |
| <polygon fill="none" stroke="black" points="785,-343 785,-365 840,-365 840,-343 785,-343"/> |
| <text text-anchor="start" x="788" y="-351.2" font-family="Helvetica,sans-Serif" font-size="11.00">smallint[5]</text> |
| <polygon fill="none" stroke="black" points="456,-321 456,-343 785,-343 785,-321 456,-321"/> |
| <text text-anchor="start" x="476" y="-329.2" font-family="Helvetica,sans-Serif" font-size="11.00">rest_frequency_interval</text> |
| <polygon fill="none" stroke="black" points="785,-321 785,-343 840,-343 840,-321 785,-321"/> |
| <text text-anchor="start" x="788" y="-329.2" font-family="Helvetica,sans-Serif" font-size="11.00">smallint[5]</text> |
| <polygon fill="none" stroke="black" points="456,-299 456,-321 785,-321 785,-299 456,-299"/> |
| <text text-anchor="start" x="476" y="-307.2" font-family="Helvetica,sans-Serif" font-size="11.00">arrears_based_on_original_schedule</text> |
| <polygon fill="none" stroke="black" points="785,-299 785,-321 840,-321 840,-299 785,-299"/> |
| <text text-anchor="start" x="788" y="-307.2" font-family="Helvetica,sans-Serif" font-size="11.00">bit[1]</text> |
| <polygon fill="none" stroke="black" points="456,-277 456,-299 785,-299 785,-277 456,-277"/> |
| <text text-anchor="start" x="476" y="-285.2" font-family="Helvetica,sans-Serif" font-size="11.00">pre_close_interest_calculation_strategy</text> |
| <polygon fill="none" stroke="black" points="785,-277 785,-299 840,-299 840,-277 785,-277"/> |
| <text text-anchor="start" x="788" y="-285.2" font-family="Helvetica,sans-Serif" font-size="11.00">smallint[5]</text> |
| <polygon fill="none" stroke="black" points="456,-255 456,-277 785,-277 785,-255 456,-255"/> |
| <text text-anchor="start" x="476" y="-263.2" font-family="Helvetica,sans-Serif" font-size="11.00">compounding_frequency_type_enum</text> |
| <polygon fill="none" stroke="black" points="785,-255 785,-277 840,-277 840,-255 785,-255"/> |
| <text text-anchor="start" x="788" y="-263.2" font-family="Helvetica,sans-Serif" font-size="11.00">smallint[5]</text> |
| <polygon fill="none" stroke="black" points="456,-233 456,-255 785,-255 785,-233 456,-233"/> |
| <text text-anchor="start" x="476" y="-241.2" font-family="Helvetica,sans-Serif" font-size="11.00">compounding_frequency_interval</text> |
| <polygon fill="none" stroke="black" points="785,-233 785,-255 840,-255 840,-233 785,-233"/> |
| <text text-anchor="start" x="788" y="-241.2" font-family="Helvetica,sans-Serif" font-size="11.00">smallint[5]</text> |
| <polygon fill="none" stroke="black" points="456,-211 456,-233 785,-233 785,-211 456,-211"/> |
| <text text-anchor="start" x="476" y="-219.2" font-family="Helvetica,sans-Serif" font-size="11.00">rest_frequency_nth_day_enum</text> |
| <polygon fill="none" stroke="black" points="785,-211 785,-233 840,-233 840,-211 785,-211"/> |
| <text text-anchor="start" x="788" y="-219.2" font-family="Helvetica,sans-Serif" font-size="11.00">int[10]</text> |
| <polygon fill="none" stroke="black" points="456,-189 456,-211 785,-211 785,-189 456,-189"/> |
| <text text-anchor="start" x="476" y="-197.2" font-family="Helvetica,sans-Serif" font-size="11.00">rest_frequency_on_day</text> |
| <polygon fill="none" stroke="black" points="785,-189 785,-211 840,-211 840,-189 785,-189"/> |
| <text text-anchor="start" x="788" y="-197.2" font-family="Helvetica,sans-Serif" font-size="11.00">int[10]</text> |
| <polygon fill="none" stroke="black" points="456,-167 456,-189 785,-189 785,-167 456,-167"/> |
| <text text-anchor="start" x="476" y="-175.2" font-family="Helvetica,sans-Serif" font-size="11.00">rest_frequency_weekday_enum</text> |
| <polygon fill="none" stroke="black" points="785,-167 785,-189 840,-189 840,-167 785,-167"/> |
| <text text-anchor="start" x="788" y="-175.2" font-family="Helvetica,sans-Serif" font-size="11.00">int[10]</text> |
| <polygon fill="none" stroke="black" points="456,-145 456,-167 785,-167 785,-145 456,-145"/> |
| <text text-anchor="start" x="476" y="-153.2" font-family="Helvetica,sans-Serif" font-size="11.00">compounding_frequency_nth_day_enum</text> |
| <polygon fill="none" stroke="black" points="785,-145 785,-167 840,-167 840,-145 785,-145"/> |
| <text text-anchor="start" x="788" y="-153.2" font-family="Helvetica,sans-Serif" font-size="11.00">int[10]</text> |
| <polygon fill="none" stroke="black" points="456,-123 456,-145 785,-145 785,-123 456,-123"/> |
| <text text-anchor="start" x="476" y="-131.2" font-family="Helvetica,sans-Serif" font-size="11.00">compounding_frequency_on_day</text> |
| <polygon fill="none" stroke="black" points="785,-123 785,-145 840,-145 840,-123 785,-123"/> |
| <text text-anchor="start" x="788" y="-131.2" font-family="Helvetica,sans-Serif" font-size="11.00">int[10]</text> |
| <polygon fill="none" stroke="black" points="456,-101 456,-123 785,-123 785,-101 456,-101"/> |
| <text text-anchor="start" x="476" y="-109.2" font-family="Helvetica,sans-Serif" font-size="11.00">compounding_frequency_weekday_enum</text> |
| <polygon fill="none" stroke="black" points="785,-101 785,-123 840,-123 840,-101 785,-101"/> |
| <text text-anchor="start" x="788" y="-109.2" font-family="Helvetica,sans-Serif" font-size="11.00">int[10]</text> |
| <polygon fill="none" stroke="black" points="456,-79 456,-101 785,-101 785,-79 456,-79"/> |
| <text text-anchor="start" x="476" y="-87.2" font-family="Helvetica,sans-Serif" font-size="11.00">is_compounding_to_be_posted_as_transaction</text> |
| <polygon fill="none" stroke="black" points="785,-79 785,-101 840,-101 840,-79 785,-79"/> |
| <text text-anchor="start" x="788" y="-87.2" font-family="Helvetica,sans-Serif" font-size="11.00">bit[1]</text> |
| <polygon fill="none" stroke="black" points="456,-57 456,-79 785,-79 785,-57 456,-57"/> |
| <text text-anchor="start" x="476" y="-65.2" font-family="Helvetica,sans-Serif" font-size="11.00">allow_compounding_on_eod</text> |
| <polygon fill="none" stroke="black" points="785,-57 785,-79 840,-79 840,-57 785,-57"/> |
| <text text-anchor="start" x="788" y="-65.2" font-family="Helvetica,sans-Serif" font-size="11.00">bit[1]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="456,-39 456,-57 612,-57 612,-39 456,-39"/> |
| <polygon fill="none" stroke="black" points="456,-39 456,-57 612,-57 612,-39 456,-39"/> |
| <text text-anchor="start" x="459" y="-45.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 1</text> |
| <polygon fill="#ffffff" stroke="transparent" points="612,-39 612,-57 785,-57 785,-39 612,-39"/> |
| <polygon fill="none" stroke="black" points="612,-39 612,-57 785,-57 785,-39 612,-39"/> |
| <text text-anchor="start" x="749" y="-45.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="785,-39 785,-57 840,-57 840,-39 785,-39"/> |
| <polygon fill="none" stroke="black" points="785,-39 785,-57 840,-57 840,-39 785,-39"/> |
| <text text-anchor="start" x="821" 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,-476 841,-476 841,-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,-263 8,-453 405,-453 405,-263 8,-263"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="8.5,-431 8.5,-453 405.5,-453 405.5,-431 8.5,-431"/> |
| <polygon fill="none" stroke="black" points="8.5,-431 8.5,-453 405.5,-453 405.5,-431 8.5,-431"/> |
| <text text-anchor="start" x="13.5" y="-440.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="-439.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="8.5,-409 8.5,-431 405.5,-431 405.5,-409 8.5,-409"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-426"/> |
| <text text-anchor="start" x="28.5" y="-417.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-387 8.5,-409 405.5,-409 405.5,-387 8.5,-387"/> |
| <polygon fill="none" stroke="black" points="8.5,-387 8.5,-409 405.5,-409 405.5,-387 8.5,-387"/> |
| <text text-anchor="start" x="28.5" y="-395.2" font-family="Helvetica,sans-Serif" font-size="11.00">short_name</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-365 8.5,-387 405.5,-387 405.5,-365 8.5,-365"/> |
| <polygon fill="none" stroke="black" points="8.5,-365 8.5,-387 405.5,-387 405.5,-365 8.5,-365"/> |
| <text text-anchor="start" x="28.5" y="-373.2" font-family="Helvetica,sans-Serif" font-size="11.00">name</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-343 8.5,-365 405.5,-365 405.5,-343 8.5,-343"/> |
| <polygon fill="none" stroke="black" points="8.5,-343 8.5,-365 405.5,-365 405.5,-343 8.5,-343"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-360"/> |
| <text text-anchor="start" x="28.5" y="-351.2" font-family="Helvetica,sans-Serif" font-size="11.00">fund_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-321 8.5,-343 405.5,-343 405.5,-321 8.5,-321"/> |
| <polygon fill="none" stroke="black" points="8.5,-321 8.5,-343 405.5,-343 405.5,-321 8.5,-321"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-338"/> |
| <text text-anchor="start" x="28.5" y="-329.2" font-family="Helvetica,sans-Serif" font-size="11.00">loan_transaction_strategy_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-299 8.5,-321 405.5,-321 405.5,-299 8.5,-299"/> |
| <polygon fill="none" stroke="black" points="8.5,-299 8.5,-321 405.5,-321 405.5,-299 8.5,-299"/> |
| <text text-anchor="start" x="28.5" y="-307.2" font-family="Helvetica,sans-Serif" font-size="11.00">external_id</text> |
| <polygon fill="none" stroke="black" points="8.5,-281 8.5,-299 405.5,-299 405.5,-281 8.5,-281"/> |
| <text text-anchor="start" x="11.5" y="-287.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-263 8.5,-281 184.5,-281 184.5,-263 8.5,-263"/> |
| <polygon fill="none" stroke="black" points="8.5,-263 8.5,-281 184.5,-281 184.5,-263 8.5,-263"/> |
| <text text-anchor="start" x="11.5" y="-269.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 2</text> |
| <polygon fill="#ffffff" stroke="transparent" points="184.5,-263 184.5,-281 300.5,-281 300.5,-263 184.5,-263"/> |
| <polygon fill="none" stroke="black" points="184.5,-263 184.5,-281 300.5,-281 300.5,-263 184.5,-263"/> |
| <text text-anchor="start" x="264.5" y="-269.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="300.5,-263 300.5,-281 405.5,-281 405.5,-263 300.5,-263"/> |
| <polygon fill="none" stroke="black" points="300.5,-263 300.5,-281 405.5,-281 405.5,-263 300.5,-263"/> |
| <text text-anchor="start" x="380.5" y="-269.2" font-family="Helvetica,sans-Serif" font-size="11.00">14 ></text> |
| </a> |
| </g> |
| </g> |
| <!-- m_product_loan_recalculation_details->m_product_loan --> |
| <g id="edge1" class="edge"> |
| <title>m_product_loan_recalculation_details:w->m_product_loan:e</title> |
| <path fill="none" stroke="black" d="M440.28,-420C429.29,-420 422.16,-420 406.5,-420"/> |
| <polygon fill="black" stroke="black" points="447,-420 455,-423.6 451,-420 455,-420 455,-420 455,-420 451,-420 455,-416.4 447,-420 447,-420"/> |
| <ellipse fill="none" stroke="black" cx="443.8" cy="-420" rx="3.2" ry="3.2"/> |
| </g> |
| </g> |
| </svg> |