| <?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="736pt" height="423pt" |
| viewBox="0.00 0.00 736.00 423.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 419)"> |
| <title>oneDegreeRelationshipsDiagram</title> |
| <polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-419 732,-419 732,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_mandatory_savings_schedule --> |
| <g id="node1" class="node"> |
| <title>m_mandatory_savings_schedule</title> |
| <g id="a_node1"><a xlink:href="../../tables/m_mandatory_savings_schedule.html" xlink:title="m_mandatory_savings_schedule" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="383,-37 383,-411 720,-411 720,-37 383,-37"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="385.5,-387 385.5,-409 718.5,-409 718.5,-387 385.5,-387"/> |
| <polygon fill="none" stroke="black" points="385.5,-387 385.5,-409 718.5,-409 718.5,-387 385.5,-387"/> |
| <text text-anchor="start" x="390.5" y="-396.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_mandatory_savings_schedule</text> |
| <text text-anchor="start" x="683.5" y="-395.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="385.5,-365 385.5,-387 648.5,-387 648.5,-365 385.5,-365"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="390.5" y="-382"/> |
| <text text-anchor="start" x="405.5" y="-373.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="none" stroke="black" points="648.5,-365 648.5,-387 718.5,-387 718.5,-365 648.5,-365"/> |
| <text text-anchor="start" x="651.5" y="-373.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="385.5,-343 385.5,-365 648.5,-365 648.5,-343 385.5,-343"/> |
| <polygon fill="none" stroke="black" points="385.5,-343 385.5,-365 648.5,-365 648.5,-343 385.5,-343"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="390.5" y="-360"/> |
| <text text-anchor="start" x="405.5" y="-351.2" font-family="Helvetica,sans-Serif" font-size="11.00">savings_account_id</text> |
| <polygon fill="none" stroke="black" points="648.5,-343 648.5,-365 718.5,-365 718.5,-343 648.5,-343"/> |
| <text text-anchor="start" x="651.5" y="-351.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="none" stroke="black" points="385.5,-321 385.5,-343 648.5,-343 648.5,-321 385.5,-321"/> |
| <text text-anchor="start" x="405.5" y="-329.2" font-family="Helvetica,sans-Serif" font-size="11.00">fromdate</text> |
| <polygon fill="none" stroke="black" points="648.5,-321 648.5,-343 718.5,-343 718.5,-321 648.5,-321"/> |
| <text text-anchor="start" x="651.5" y="-329.2" font-family="Helvetica,sans-Serif" font-size="11.00">date[10]</text> |
| <polygon fill="none" stroke="black" points="385.5,-299 385.5,-321 648.5,-321 648.5,-299 385.5,-299"/> |
| <text text-anchor="start" x="405.5" y="-307.2" font-family="Helvetica,sans-Serif" font-size="11.00">duedate</text> |
| <polygon fill="none" stroke="black" points="648.5,-299 648.5,-321 718.5,-321 718.5,-299 648.5,-299"/> |
| <text text-anchor="start" x="651.5" y="-307.2" font-family="Helvetica,sans-Serif" font-size="11.00">date[10]</text> |
| <polygon fill="none" stroke="black" points="385.5,-277 385.5,-299 648.5,-299 648.5,-277 385.5,-277"/> |
| <text text-anchor="start" x="405.5" y="-285.2" font-family="Helvetica,sans-Serif" font-size="11.00">installment</text> |
| <polygon fill="none" stroke="black" points="648.5,-277 648.5,-299 718.5,-299 718.5,-277 648.5,-277"/> |
| <text text-anchor="start" x="651.5" y="-285.2" font-family="Helvetica,sans-Serif" font-size="11.00">smallint[5]</text> |
| <polygon fill="none" stroke="black" points="385.5,-255 385.5,-277 648.5,-277 648.5,-255 385.5,-255"/> |
| <text text-anchor="start" x="405.5" y="-263.2" font-family="Helvetica,sans-Serif" font-size="11.00">deposit_amount</text> |
| <polygon fill="none" stroke="black" points="648.5,-255 648.5,-277 718.5,-277 718.5,-255 648.5,-255"/> |
| <text text-anchor="start" x="651.5" y="-263.2" font-family="Helvetica,sans-Serif" font-size="11.00">decimal[19,6]</text> |
| <polygon fill="none" stroke="black" points="385.5,-233 385.5,-255 648.5,-255 648.5,-233 385.5,-233"/> |
| <text text-anchor="start" x="405.5" y="-241.2" font-family="Helvetica,sans-Serif" font-size="11.00">deposit_amount_completed_derived</text> |
| <polygon fill="none" stroke="black" points="648.5,-233 648.5,-255 718.5,-255 718.5,-233 648.5,-233"/> |
| <text text-anchor="start" x="651.5" y="-241.2" font-family="Helvetica,sans-Serif" font-size="11.00">decimal[19,6]</text> |
| <polygon fill="none" stroke="black" points="385.5,-211 385.5,-233 648.5,-233 648.5,-211 385.5,-211"/> |
| <text text-anchor="start" x="405.5" y="-219.2" font-family="Helvetica,sans-Serif" font-size="11.00">total_paid_in_advance_derived</text> |
| <polygon fill="none" stroke="black" points="648.5,-211 648.5,-233 718.5,-233 718.5,-211 648.5,-211"/> |
| <text text-anchor="start" x="651.5" y="-219.2" font-family="Helvetica,sans-Serif" font-size="11.00">decimal[19,6]</text> |
| <polygon fill="none" stroke="black" points="385.5,-189 385.5,-211 648.5,-211 648.5,-189 385.5,-189"/> |
| <text text-anchor="start" x="405.5" y="-197.2" font-family="Helvetica,sans-Serif" font-size="11.00">total_paid_late_derived</text> |
| <polygon fill="none" stroke="black" points="648.5,-189 648.5,-211 718.5,-211 718.5,-189 648.5,-189"/> |
| <text text-anchor="start" x="651.5" y="-197.2" font-family="Helvetica,sans-Serif" font-size="11.00">decimal[19,6]</text> |
| <polygon fill="none" stroke="black" points="385.5,-167 385.5,-189 648.5,-189 648.5,-167 385.5,-167"/> |
| <text text-anchor="start" x="405.5" y="-175.2" font-family="Helvetica,sans-Serif" font-size="11.00">completed_derived</text> |
| <polygon fill="none" stroke="black" points="648.5,-167 648.5,-189 718.5,-189 718.5,-167 648.5,-167"/> |
| <text text-anchor="start" x="651.5" y="-175.2" font-family="Helvetica,sans-Serif" font-size="11.00">bit[1]</text> |
| <polygon fill="none" stroke="black" points="385.5,-145 385.5,-167 648.5,-167 648.5,-145 385.5,-145"/> |
| <text text-anchor="start" x="405.5" y="-153.2" font-family="Helvetica,sans-Serif" font-size="11.00">obligations_met_on_date</text> |
| <polygon fill="none" stroke="black" points="648.5,-145 648.5,-167 718.5,-167 718.5,-145 648.5,-145"/> |
| <text text-anchor="start" x="651.5" y="-153.2" font-family="Helvetica,sans-Serif" font-size="11.00">date[10]</text> |
| <polygon fill="none" stroke="black" points="385.5,-123 385.5,-145 648.5,-145 648.5,-123 385.5,-123"/> |
| <text text-anchor="start" x="405.5" y="-131.2" font-family="Helvetica,sans-Serif" font-size="11.00">createdby_id</text> |
| <polygon fill="none" stroke="black" points="648.5,-123 648.5,-145 718.5,-145 718.5,-123 648.5,-123"/> |
| <text text-anchor="start" x="651.5" y="-131.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="none" stroke="black" points="385.5,-101 385.5,-123 648.5,-123 648.5,-101 385.5,-101"/> |
| <text text-anchor="start" x="405.5" y="-109.2" font-family="Helvetica,sans-Serif" font-size="11.00">created_date</text> |
| <polygon fill="none" stroke="black" points="648.5,-101 648.5,-123 718.5,-123 718.5,-101 648.5,-101"/> |
| <text text-anchor="start" x="651.5" y="-109.2" font-family="Helvetica,sans-Serif" font-size="11.00">datetime[19]</text> |
| <polygon fill="none" stroke="black" points="385.5,-79 385.5,-101 648.5,-101 648.5,-79 385.5,-79"/> |
| <text text-anchor="start" x="405.5" y="-87.2" font-family="Helvetica,sans-Serif" font-size="11.00">lastmodified_date</text> |
| <polygon fill="none" stroke="black" points="648.5,-79 648.5,-101 718.5,-101 718.5,-79 648.5,-79"/> |
| <text text-anchor="start" x="651.5" y="-87.2" font-family="Helvetica,sans-Serif" font-size="11.00">datetime[19]</text> |
| <polygon fill="none" stroke="black" points="385.5,-57 385.5,-79 648.5,-79 648.5,-57 385.5,-57"/> |
| <text text-anchor="start" x="405.5" y="-65.2" font-family="Helvetica,sans-Serif" font-size="11.00">lastmodifiedby_id</text> |
| <polygon fill="none" stroke="black" points="648.5,-57 648.5,-79 718.5,-79 718.5,-57 648.5,-57"/> |
| <text text-anchor="start" x="651.5" y="-65.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="385.5,-39 385.5,-57 508.5,-57 508.5,-39 385.5,-39"/> |
| <polygon fill="none" stroke="black" points="385.5,-39 385.5,-57 508.5,-57 508.5,-39 385.5,-39"/> |
| <text text-anchor="start" x="388.5" y="-45.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 1</text> |
| <polygon fill="#ffffff" stroke="transparent" points="508.5,-39 508.5,-57 648.5,-57 648.5,-39 508.5,-39"/> |
| <polygon fill="none" stroke="black" points="508.5,-39 508.5,-57 648.5,-57 648.5,-39 508.5,-39"/> |
| <text text-anchor="start" x="612.5" y="-45.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="648.5,-39 648.5,-57 718.5,-57 718.5,-39 648.5,-39"/> |
| <polygon fill="none" stroke="black" points="648.5,-39 648.5,-57 718.5,-57 718.5,-39 648.5,-39"/> |
| <text text-anchor="start" x="699.5" y="-45.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 ></text> |
| <polygon fill="none" stroke="black" stroke-width="2" points="384,-38 384,-410 719,-410 719,-38 384,-38"/> |
| </a> |
| </g> |
| </g> |
| <!-- m_savings_account --> |
| <g id="node2" class="node"> |
| <title>m_savings_account</title> |
| <g id="a_node2"><a xlink:href="../../tables/m_savings_account.html" xlink:title="m_savings_account" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="8,-153 8,-387 334,-387 334,-153 8,-153"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="8,-365 8,-387 334,-387 334,-365 8,-365"/> |
| <polygon fill="none" stroke="black" points="8,-365 8,-387 334,-387 334,-365 8,-365"/> |
| <text text-anchor="start" x="13" y="-374.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_savings_account</text> |
| <text text-anchor="start" x="299" y="-373.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="8,-343 8,-365 334,-365 334,-343 8,-343"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-360"/> |
| <text text-anchor="start" x="28" y="-351.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8,-321 8,-343 334,-343 334,-321 8,-321"/> |
| <polygon fill="none" stroke="black" points="8,-321 8,-343 334,-343 334,-321 8,-321"/> |
| <text text-anchor="start" x="28" y="-329.2" font-family="Helvetica,sans-Serif" font-size="11.00">account_no</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8,-299 8,-321 334,-321 334,-299 8,-299"/> |
| <polygon fill="none" stroke="black" points="8,-299 8,-321 334,-321 334,-299 8,-299"/> |
| <text text-anchor="start" x="28" y="-307.2" font-family="Helvetica,sans-Serif" font-size="11.00">external_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8,-277 8,-299 334,-299 334,-277 8,-277"/> |
| <polygon fill="none" stroke="black" points="8,-277 8,-299 334,-299 334,-277 8,-277"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-294"/> |
| <text text-anchor="start" x="28" y="-285.2" font-family="Helvetica,sans-Serif" font-size="11.00">client_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8,-255 8,-277 334,-277 334,-255 8,-255"/> |
| <polygon fill="none" stroke="black" points="8,-255 8,-277 334,-277 334,-255 8,-255"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-272"/> |
| <text text-anchor="start" x="28" y="-263.2" font-family="Helvetica,sans-Serif" font-size="11.00">group_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8,-233 8,-255 334,-255 334,-233 8,-233"/> |
| <polygon fill="none" stroke="black" points="8,-233 8,-255 334,-255 334,-233 8,-233"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-250"/> |
| <text text-anchor="start" x="28" y="-241.2" font-family="Helvetica,sans-Serif" font-size="11.00">gsim_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8,-211 8,-233 334,-233 334,-211 8,-211"/> |
| <polygon fill="none" stroke="black" points="8,-211 8,-233 334,-233 334,-211 8,-211"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-228"/> |
| <text text-anchor="start" x="28" y="-219.2" font-family="Helvetica,sans-Serif" font-size="11.00">product_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8,-189 8,-211 334,-211 334,-189 8,-189"/> |
| <polygon fill="none" stroke="black" points="8,-189 8,-211 334,-211 334,-189 8,-189"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-206"/> |
| <text text-anchor="start" x="28" y="-197.2" font-family="Helvetica,sans-Serif" font-size="11.00">tax_group_id</text> |
| <polygon fill="none" stroke="black" points="8,-171 8,-189 334,-189 334,-171 8,-171"/> |
| <text text-anchor="start" x="11" y="-177.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8,-153 8,-171 148,-171 148,-153 8,-153"/> |
| <polygon fill="none" stroke="black" points="8,-153 8,-171 148,-171 148,-153 8,-153"/> |
| <text text-anchor="start" x="11" y="-159.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 5</text> |
| <polygon fill="#ffffff" stroke="transparent" points="148,-153 148,-171 246,-171 246,-153 148,-153"/> |
| <polygon fill="none" stroke="black" points="148,-153 148,-171 246,-171 246,-153 148,-153"/> |
| <text text-anchor="start" x="210" y="-159.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="246,-153 246,-171 334,-171 334,-153 246,-153"/> |
| <polygon fill="none" stroke="black" points="246,-153 246,-171 334,-171 334,-153 246,-153"/> |
| <text text-anchor="start" x="309" y="-159.2" font-family="Helvetica,sans-Serif" font-size="11.00">17 ></text> |
| </a> |
| </g> |
| </g> |
| <!-- m_mandatory_savings_schedule->m_savings_account --> |
| <g id="edge1" class="edge"> |
| <title>m_mandatory_savings_schedule:w->m_savings_account:e</title> |
| <path fill="none" stroke="black" d="M369.84,-354C358.41,-354 351.16,-354 335,-354"/> |
| <polygon fill="black" stroke="black" points="376.5,-354 384.5,-357.6 380.5,-354 384.5,-354 384.5,-354 384.5,-354 380.5,-354 384.5,-350.4 376.5,-354 376.5,-354"/> |
| <ellipse fill="none" stroke="black" cx="373.3" cy="-354" rx="3.2" ry="3.2"/> |
| </g> |
| </g> |
| </svg> |