| <?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="579pt" height="555pt" |
| viewBox="0.00 0.00 579.00 555.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 551)"> |
| <title>oneDegreeRelationshipsDiagram</title> |
| <polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-551 575,-551 575,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_portfolio_command_source --> |
| <g id="node1" class="node"> |
| <title>m_portfolio_command_source</title> |
| <g id="a_node1"><a xlink:href="../../tables/m_portfolio_command_source.html" xlink:title="m_portfolio_command_source" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="272,-37 272,-543 563,-543 563,-37 272,-37"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="274.5,-519 274.5,-541 561.5,-541 561.5,-519 274.5,-519"/> |
| <polygon fill="none" stroke="black" points="274.5,-519 274.5,-541 561.5,-541 561.5,-519 274.5,-519"/> |
| <text text-anchor="start" x="279.5" y="-528.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_portfolio_command_source</text> |
| <text text-anchor="start" x="526.5" y="-527.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="274.5,-497 274.5,-519 494.5,-519 494.5,-497 274.5,-497"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="279.5" y="-514"/> |
| <text text-anchor="start" x="294.5" y="-505.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="none" stroke="black" points="494.5,-497 494.5,-519 561.5,-519 561.5,-497 494.5,-497"/> |
| <text text-anchor="start" x="497.5" y="-505.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="274.5,-475 274.5,-497 494.5,-497 494.5,-475 274.5,-475"/> |
| <polygon fill="none" stroke="black" points="274.5,-475 274.5,-497 494.5,-497 494.5,-475 274.5,-475"/> |
| <text text-anchor="start" x="294.5" y="-483.2" font-family="Helvetica,sans-Serif" font-size="11.00">action_name</text> |
| <polygon fill="none" stroke="black" points="494.5,-475 494.5,-497 561.5,-497 561.5,-475 494.5,-475"/> |
| <text text-anchor="start" x="497.5" y="-483.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[50]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="274.5,-453 274.5,-475 494.5,-475 494.5,-453 274.5,-453"/> |
| <polygon fill="none" stroke="black" points="274.5,-453 274.5,-475 494.5,-475 494.5,-453 274.5,-453"/> |
| <text text-anchor="start" x="294.5" y="-461.2" font-family="Helvetica,sans-Serif" font-size="11.00">entity_name</text> |
| <polygon fill="none" stroke="black" points="494.5,-453 494.5,-475 561.5,-475 561.5,-453 494.5,-453"/> |
| <text text-anchor="start" x="497.5" y="-461.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[50]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="274.5,-431 274.5,-453 494.5,-453 494.5,-431 274.5,-431"/> |
| <polygon fill="none" stroke="black" points="274.5,-431 274.5,-453 494.5,-453 494.5,-431 274.5,-431"/> |
| <text text-anchor="start" x="294.5" y="-439.2" font-family="Helvetica,sans-Serif" font-size="11.00">office_id</text> |
| <polygon fill="none" stroke="black" points="494.5,-431 494.5,-453 561.5,-453 561.5,-431 494.5,-431"/> |
| <text text-anchor="start" x="497.5" y="-439.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="none" stroke="black" points="274.5,-409 274.5,-431 494.5,-431 494.5,-409 274.5,-409"/> |
| <text text-anchor="start" x="294.5" y="-417.2" font-family="Helvetica,sans-Serif" font-size="11.00">group_id</text> |
| <polygon fill="none" stroke="black" points="494.5,-409 494.5,-431 561.5,-431 561.5,-409 494.5,-409"/> |
| <text text-anchor="start" x="497.5" y="-417.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="none" stroke="black" points="274.5,-387 274.5,-409 494.5,-409 494.5,-387 274.5,-387"/> |
| <text text-anchor="start" x="294.5" y="-395.2" font-family="Helvetica,sans-Serif" font-size="11.00">client_id</text> |
| <polygon fill="none" stroke="black" points="494.5,-387 494.5,-409 561.5,-409 561.5,-387 494.5,-387"/> |
| <text text-anchor="start" x="497.5" y="-395.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="none" stroke="black" points="274.5,-365 274.5,-387 494.5,-387 494.5,-365 274.5,-365"/> |
| <text text-anchor="start" x="294.5" y="-373.2" font-family="Helvetica,sans-Serif" font-size="11.00">loan_id</text> |
| <polygon fill="none" stroke="black" points="494.5,-365 494.5,-387 561.5,-387 561.5,-365 494.5,-365"/> |
| <text text-anchor="start" x="497.5" y="-373.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="none" stroke="black" points="274.5,-343 274.5,-365 494.5,-365 494.5,-343 274.5,-343"/> |
| <text text-anchor="start" x="294.5" y="-351.2" font-family="Helvetica,sans-Serif" font-size="11.00">savings_account_id</text> |
| <polygon fill="none" stroke="black" points="494.5,-343 494.5,-365 561.5,-365 561.5,-343 494.5,-343"/> |
| <text text-anchor="start" x="497.5" y="-351.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="none" stroke="black" points="274.5,-321 274.5,-343 494.5,-343 494.5,-321 274.5,-321"/> |
| <text text-anchor="start" x="294.5" y="-329.2" font-family="Helvetica,sans-Serif" font-size="11.00">api_get_url</text> |
| <polygon fill="none" stroke="black" points="494.5,-321 494.5,-343 561.5,-343 561.5,-321 494.5,-321"/> |
| <text text-anchor="start" x="497.5" y="-329.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[100]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="274.5,-299 274.5,-321 494.5,-321 494.5,-299 274.5,-299"/> |
| <polygon fill="none" stroke="black" points="274.5,-299 274.5,-321 494.5,-321 494.5,-299 274.5,-299"/> |
| <text text-anchor="start" x="294.5" y="-307.2" font-family="Helvetica,sans-Serif" font-size="11.00">resource_id</text> |
| <polygon fill="none" stroke="black" points="494.5,-299 494.5,-321 561.5,-321 561.5,-299 494.5,-299"/> |
| <text text-anchor="start" x="497.5" y="-307.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="none" stroke="black" points="274.5,-277 274.5,-299 494.5,-299 494.5,-277 274.5,-277"/> |
| <text text-anchor="start" x="294.5" y="-285.2" font-family="Helvetica,sans-Serif" font-size="11.00">subresource_id</text> |
| <polygon fill="none" stroke="black" points="494.5,-277 494.5,-299 561.5,-299 561.5,-277 494.5,-277"/> |
| <text text-anchor="start" x="497.5" y="-285.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="none" stroke="black" points="274.5,-255 274.5,-277 494.5,-277 494.5,-255 274.5,-255"/> |
| <text text-anchor="start" x="294.5" y="-263.2" font-family="Helvetica,sans-Serif" font-size="11.00">command_as_json</text> |
| <polygon fill="none" stroke="black" points="494.5,-255 494.5,-277 561.5,-277 561.5,-255 494.5,-255"/> |
| <text text-anchor="start" x="497.5" y="-263.2" font-family="Helvetica,sans-Serif" font-size="11.00">text[65535]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="274.5,-233 274.5,-255 494.5,-255 494.5,-233 274.5,-233"/> |
| <polygon fill="none" stroke="black" points="274.5,-233 274.5,-255 494.5,-255 494.5,-233 274.5,-233"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="279.5" y="-250"/> |
| <text text-anchor="start" x="294.5" y="-241.2" font-family="Helvetica,sans-Serif" font-size="11.00">maker_id</text> |
| <polygon fill="none" stroke="black" points="494.5,-233 494.5,-255 561.5,-255 561.5,-233 494.5,-233"/> |
| <text text-anchor="start" x="497.5" y="-241.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="274.5,-211 274.5,-233 494.5,-233 494.5,-211 274.5,-211"/> |
| <polygon fill="none" stroke="black" points="274.5,-211 274.5,-233 494.5,-233 494.5,-211 274.5,-211"/> |
| <text text-anchor="start" x="294.5" y="-219.2" font-family="Helvetica,sans-Serif" font-size="11.00">made_on_date</text> |
| <polygon fill="none" stroke="black" points="494.5,-211 494.5,-233 561.5,-233 561.5,-211 494.5,-211"/> |
| <text text-anchor="start" x="497.5" y="-219.2" font-family="Helvetica,sans-Serif" font-size="11.00">datetime[19]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="274.5,-189 274.5,-211 494.5,-211 494.5,-189 274.5,-189"/> |
| <polygon fill="none" stroke="black" points="274.5,-189 274.5,-211 494.5,-211 494.5,-189 274.5,-189"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="279.5" y="-206"/> |
| <text text-anchor="start" x="294.5" y="-197.2" font-family="Helvetica,sans-Serif" font-size="11.00">checker_id</text> |
| <polygon fill="none" stroke="black" points="494.5,-189 494.5,-211 561.5,-211 561.5,-189 494.5,-189"/> |
| <text text-anchor="start" x="497.5" y="-197.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="274.5,-167 274.5,-189 494.5,-189 494.5,-167 274.5,-167"/> |
| <polygon fill="none" stroke="black" points="274.5,-167 274.5,-189 494.5,-189 494.5,-167 274.5,-167"/> |
| <text text-anchor="start" x="294.5" y="-175.2" font-family="Helvetica,sans-Serif" font-size="11.00">checked_on_date</text> |
| <polygon fill="none" stroke="black" points="494.5,-167 494.5,-189 561.5,-189 561.5,-167 494.5,-167"/> |
| <text text-anchor="start" x="497.5" y="-175.2" font-family="Helvetica,sans-Serif" font-size="11.00">datetime[19]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="274.5,-145 274.5,-167 494.5,-167 494.5,-145 274.5,-145"/> |
| <polygon fill="none" stroke="black" points="274.5,-145 274.5,-167 494.5,-167 494.5,-145 274.5,-145"/> |
| <text text-anchor="start" x="294.5" y="-153.2" font-family="Helvetica,sans-Serif" font-size="11.00">processing_result_enum</text> |
| <polygon fill="none" stroke="black" points="494.5,-145 494.5,-167 561.5,-167 561.5,-145 494.5,-145"/> |
| <text text-anchor="start" x="497.5" y="-153.2" font-family="Helvetica,sans-Serif" font-size="11.00">smallint[5]</text> |
| <polygon fill="none" stroke="black" points="274.5,-123 274.5,-145 494.5,-145 494.5,-123 274.5,-123"/> |
| <text text-anchor="start" x="294.5" y="-131.2" font-family="Helvetica,sans-Serif" font-size="11.00">product_id</text> |
| <polygon fill="none" stroke="black" points="494.5,-123 494.5,-145 561.5,-145 561.5,-123 494.5,-123"/> |
| <text text-anchor="start" x="497.5" y="-131.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="none" stroke="black" points="274.5,-101 274.5,-123 494.5,-123 494.5,-101 274.5,-101"/> |
| <text text-anchor="start" x="294.5" y="-109.2" font-family="Helvetica,sans-Serif" font-size="11.00">transaction_id</text> |
| <polygon fill="none" stroke="black" points="494.5,-101 494.5,-123 561.5,-123 561.5,-101 494.5,-101"/> |
| <text text-anchor="start" x="497.5" y="-109.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[100]</text> |
| <polygon fill="none" stroke="black" points="274.5,-79 274.5,-101 494.5,-101 494.5,-79 274.5,-79"/> |
| <text text-anchor="start" x="294.5" y="-87.2" font-family="Helvetica,sans-Serif" font-size="11.00">creditbureau_id</text> |
| <polygon fill="none" stroke="black" points="494.5,-79 494.5,-101 561.5,-101 561.5,-79 494.5,-79"/> |
| <text text-anchor="start" x="497.5" y="-87.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="none" stroke="black" points="274.5,-57 274.5,-79 494.5,-79 494.5,-57 274.5,-57"/> |
| <text text-anchor="start" x="294.5" y="-65.2" font-family="Helvetica,sans-Serif" font-size="11.00">organisation_creditbureau_id</text> |
| <polygon fill="none" stroke="black" points="494.5,-57 494.5,-79 561.5,-79 561.5,-57 494.5,-57"/> |
| <text text-anchor="start" x="497.5" y="-65.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="274.5,-39 274.5,-57 372.5,-57 372.5,-39 274.5,-39"/> |
| <polygon fill="none" stroke="black" points="274.5,-39 274.5,-57 372.5,-57 372.5,-39 274.5,-39"/> |
| <text text-anchor="start" x="277.5" y="-45.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 2</text> |
| <polygon fill="#ffffff" stroke="transparent" points="372.5,-39 372.5,-57 494.5,-57 494.5,-39 372.5,-39"/> |
| <polygon fill="none" stroke="black" points="372.5,-39 372.5,-57 494.5,-57 494.5,-39 372.5,-39"/> |
| <text text-anchor="start" x="452.5" y="-45.2" font-family="Helvetica,sans-Serif" font-size="11.00">15 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="494.5,-39 494.5,-57 561.5,-57 561.5,-39 494.5,-39"/> |
| <polygon fill="none" stroke="black" points="494.5,-39 494.5,-57 561.5,-57 561.5,-39 494.5,-39"/> |
| <text text-anchor="start" x="542.5" y="-45.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 ></text> |
| <polygon fill="none" stroke="black" stroke-width="2" points="273,-38 273,-542 562,-542 562,-38 273,-38"/> |
| </a> |
| </g> |
| </g> |
| <!-- m_appuser --> |
| <g id="node2" class="node"> |
| <title>m_appuser</title> |
| <g id="a_node2"><a xlink:href="../../tables/m_appuser.html" xlink:title="m_appuser" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="8,-87 8,-255 223,-255 223,-87 8,-87"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="8.5,-233 8.5,-255 223.5,-255 223.5,-233 8.5,-233"/> |
| <polygon fill="none" stroke="black" points="8.5,-233 8.5,-255 223.5,-255 223.5,-233 8.5,-233"/> |
| <text text-anchor="start" x="13.5" y="-242.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_appuser</text> |
| <text text-anchor="start" x="188.5" y="-241.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="8.5,-211 8.5,-233 223.5,-233 223.5,-211 8.5,-211"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-228"/> |
| <text text-anchor="start" x="28.5" y="-219.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-189 8.5,-211 223.5,-211 223.5,-189 8.5,-189"/> |
| <polygon fill="none" stroke="black" points="8.5,-189 8.5,-211 223.5,-211 223.5,-189 8.5,-189"/> |
| <image xlink:href="../../images/foreignKeys.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">office_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-167 8.5,-189 223.5,-189 223.5,-167 8.5,-167"/> |
| <polygon fill="none" stroke="black" points="8.5,-167 8.5,-189 223.5,-189 223.5,-167 8.5,-167"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-184"/> |
| <text text-anchor="start" x="28.5" y="-175.2" font-family="Helvetica,sans-Serif" font-size="11.00">staff_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-145 8.5,-167 223.5,-167 223.5,-145 8.5,-145"/> |
| <polygon fill="none" stroke="black" points="8.5,-145 8.5,-167 223.5,-167 223.5,-145 8.5,-145"/> |
| <text text-anchor="start" x="28.5" y="-153.2" font-family="Helvetica,sans-Serif" font-size="11.00">username</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-123 8.5,-145 223.5,-145 223.5,-123 8.5,-123"/> |
| <polygon fill="none" stroke="black" points="8.5,-123 8.5,-145 223.5,-145 223.5,-123 8.5,-123"/> |
| <text text-anchor="start" x="28.5" y="-131.2" font-family="Helvetica,sans-Serif" font-size="11.00">last_time_password_updated</text> |
| <polygon fill="none" stroke="black" points="8.5,-105 8.5,-123 223.5,-123 223.5,-105 8.5,-105"/> |
| <text text-anchor="start" x="11.5" y="-111.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-87 8.5,-105 93.5,-105 93.5,-87 8.5,-87"/> |
| <polygon fill="none" stroke="black" points="8.5,-87 8.5,-105 93.5,-105 93.5,-87 8.5,-87"/> |
| <text text-anchor="start" x="11.5" y="-93.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 2</text> |
| <polygon fill="#ffffff" stroke="transparent" points="93.5,-87 93.5,-105 163.5,-105 163.5,-87 93.5,-87"/> |
| <polygon fill="none" stroke="black" points="93.5,-87 93.5,-105 163.5,-105 163.5,-87 93.5,-87"/> |
| <text text-anchor="start" x="127.5" y="-93.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="163.5,-87 163.5,-105 223.5,-105 223.5,-87 163.5,-87"/> |
| <polygon fill="none" stroke="black" points="163.5,-87 163.5,-105 223.5,-105 223.5,-87 163.5,-87"/> |
| <text text-anchor="start" x="198.5" y="-93.2" font-family="Helvetica,sans-Serif" font-size="11.00">57 ></text> |
| </a> |
| </g> |
| </g> |
| <!-- m_portfolio_command_source->m_appuser --> |
| <g id="edge1" class="edge"> |
| <title>m_portfolio_command_source:w->m_appuser:e</title> |
| <path fill="none" stroke="black" d="M259.13,-203.44C247.59,-209.62 242.4,-222 224.5,-222"/> |
| <polygon fill="black" stroke="black" points="265.72,-201.86 274.34,-203.5 269.61,-200.93 273.5,-200 273.5,-200 273.5,-200 269.61,-200.93 272.66,-196.5 265.72,-201.86 265.72,-201.86"/> |
| <ellipse fill="none" stroke="black" cx="262.61" cy="-202.61" rx="3.2" ry="3.2"/> |
| </g> |
| <!-- m_portfolio_command_source->m_appuser --> |
| <g id="edge2" class="edge"> |
| <title>m_portfolio_command_source:w->m_appuser:e</title> |
| <path fill="none" stroke="black" d="M259.13,-240.56C247.59,-234.38 242.4,-222 224.5,-222"/> |
| <polygon fill="black" stroke="black" points="265.72,-242.14 272.66,-247.5 269.61,-243.07 273.5,-244 273.5,-244 273.5,-244 269.61,-243.07 274.34,-240.5 265.72,-242.14 265.72,-242.14"/> |
| <ellipse fill="none" stroke="black" cx="262.61" cy="-241.39" rx="3.2" ry="3.2"/> |
| </g> |
| </g> |
| </svg> |
