| <?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: twoDegreesRelationshipsDiagram Pages: 1 --> |
| <svg width="823pt" height="441pt" |
| viewBox="0.00 0.00 823.00 441.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 437)"> |
| <title>twoDegreesRelationshipsDiagram</title> |
| <polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-437 819,-437 819,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_configuration --> |
| <g id="node1" class="node"> |
| <title>m_creditbureau_configuration</title> |
| <g id="a_node1"><a xlink:href="../../tables/m_creditbureau_configuration.html" xlink:title="m_creditbureau_configuration" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="286,-305 286,-429 509,-429 509,-305 286,-305"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="286.5,-407 286.5,-429 509.5,-429 509.5,-407 286.5,-407"/> |
| <polygon fill="none" stroke="black" points="286.5,-407 286.5,-429 509.5,-429 509.5,-407 286.5,-407"/> |
| <text text-anchor="start" x="291.5" y="-416.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_creditbureau_configuration</text> |
| <text text-anchor="start" x="474.5" y="-415.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="286.5,-385 286.5,-407 509.5,-407 509.5,-385 286.5,-385"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="291.5" y="-402"/> |
| <text text-anchor="start" x="306.5" y="-393.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="286.5,-363 286.5,-385 509.5,-385 509.5,-363 286.5,-363"/> |
| <polygon fill="none" stroke="black" points="286.5,-363 286.5,-385 509.5,-385 509.5,-363 286.5,-363"/> |
| <text text-anchor="start" x="306.5" y="-371.2" font-family="Helvetica,sans-Serif" font-size="11.00">configkey</text> |
| <polygon fill="#ffffff" stroke="transparent" points="286.5,-341 286.5,-363 509.5,-363 509.5,-341 286.5,-341"/> |
| <polygon fill="none" stroke="black" points="286.5,-341 286.5,-363 509.5,-363 509.5,-341 286.5,-341"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="291.5" y="-358"/> |
| <text text-anchor="start" x="306.5" y="-349.2" font-family="Helvetica,sans-Serif" font-size="11.00">organisation_creditbureau_id</text> |
| <polygon fill="none" stroke="black" points="286.5,-323 286.5,-341 509.5,-341 509.5,-323 286.5,-323"/> |
| <text text-anchor="start" x="289.5" y="-329.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="286.5,-305 286.5,-323 382.5,-323 382.5,-305 286.5,-305"/> |
| <polygon fill="none" stroke="black" points="286.5,-305 286.5,-323 382.5,-323 382.5,-305 286.5,-305"/> |
| <text text-anchor="start" x="289.5" y="-311.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 1</text> |
| <polygon fill="#ffffff" stroke="transparent" points="382.5,-305 382.5,-323 458.5,-323 458.5,-305 382.5,-305"/> |
| <polygon fill="none" stroke="black" points="382.5,-305 382.5,-323 458.5,-323 458.5,-305 382.5,-305"/> |
| <text text-anchor="start" x="422.5" y="-311.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="458.5,-305 458.5,-323 509.5,-323 509.5,-305 458.5,-305"/> |
| <polygon fill="none" stroke="black" points="458.5,-305 458.5,-323 509.5,-323 509.5,-305 458.5,-305"/> |
| <text text-anchor="start" x="499.5" y="-311.2" font-family="Helvetica,sans-Serif" font-size="11.00">  </text> |
| </a> |
| </g> |
| </g> |
| <!-- m_creditbureau --> |
| <g id="node2" class="node"> |
| <title>m_creditbureau</title> |
| <g id="a_node2"><a xlink:href="../../tables/m_creditbureau.html" xlink:title="m_creditbureau" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="8,-88 8,-242 237,-242 237,-88 8,-88"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="10.5,-218 10.5,-240 235.5,-240 235.5,-218 10.5,-218"/> |
| <polygon fill="none" stroke="black" points="10.5,-218 10.5,-240 235.5,-240 235.5,-218 10.5,-218"/> |
| <text text-anchor="start" x="15.5" y="-227.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_creditbureau</text> |
| <text text-anchor="start" x="200.5" y="-226.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="10.5,-196 10.5,-218 168.5,-218 168.5,-196 10.5,-196"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="15.5" y="-213"/> |
| <text text-anchor="start" x="30.5" y="-204.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="none" stroke="black" points="168.5,-196 168.5,-218 235.5,-218 235.5,-196 168.5,-196"/> |
| <text text-anchor="start" x="171.5" y="-204.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="10.5,-174 10.5,-196 168.5,-196 168.5,-174 10.5,-174"/> |
| <polygon fill="none" stroke="black" points="10.5,-174 10.5,-196 168.5,-196 168.5,-174 10.5,-174"/> |
| <text text-anchor="start" x="30.5" y="-182.2" font-family="Helvetica,sans-Serif" font-size="11.00">name</text> |
| <polygon fill="none" stroke="black" points="168.5,-174 168.5,-196 235.5,-196 235.5,-174 168.5,-174"/> |
| <text text-anchor="start" x="171.5" y="-182.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[100]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="10.5,-152 10.5,-174 168.5,-174 168.5,-152 10.5,-152"/> |
| <polygon fill="none" stroke="black" points="10.5,-152 10.5,-174 168.5,-174 168.5,-152 10.5,-152"/> |
| <text text-anchor="start" x="30.5" y="-160.2" font-family="Helvetica,sans-Serif" font-size="11.00">product</text> |
| <polygon fill="none" stroke="black" points="168.5,-152 168.5,-174 235.5,-174 235.5,-152 168.5,-152"/> |
| <text text-anchor="start" x="171.5" y="-160.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[100]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="10.5,-130 10.5,-152 168.5,-152 168.5,-130 10.5,-130"/> |
| <polygon fill="none" stroke="black" points="10.5,-130 10.5,-152 168.5,-152 168.5,-130 10.5,-130"/> |
| <text text-anchor="start" x="30.5" y="-138.2" font-family="Helvetica,sans-Serif" font-size="11.00">country</text> |
| <polygon fill="none" stroke="black" points="168.5,-130 168.5,-152 235.5,-152 235.5,-130 168.5,-130"/> |
| <text text-anchor="start" x="171.5" y="-138.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[100]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="10.5,-108 10.5,-130 168.5,-130 168.5,-108 10.5,-108"/> |
| <polygon fill="none" stroke="black" points="10.5,-108 10.5,-130 168.5,-130 168.5,-108 10.5,-108"/> |
| <text text-anchor="start" x="30.5" y="-116.2" font-family="Helvetica,sans-Serif" font-size="11.00">implementation_key</text> |
| <polygon fill="none" stroke="black" points="168.5,-108 168.5,-130 235.5,-130 235.5,-108 168.5,-108"/> |
| <text text-anchor="start" x="171.5" y="-116.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[100]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="10.5,-90 10.5,-108 83.5,-108 83.5,-90 10.5,-90"/> |
| <polygon fill="none" stroke="black" points="10.5,-90 10.5,-108 83.5,-108 83.5,-90 10.5,-90"/> |
| <text text-anchor="start" x="13.5" y="-96.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 0</text> |
| <polygon fill="#ffffff" stroke="transparent" points="83.5,-90 83.5,-108 168.5,-108 168.5,-90 83.5,-90"/> |
| <polygon fill="none" stroke="black" points="83.5,-90 83.5,-108 168.5,-108 168.5,-90 83.5,-90"/> |
| <text text-anchor="start" x="137.5" y="-96.2" font-family="Helvetica,sans-Serif" font-size="11.00">1 row</text> |
| <polygon fill="#ffffff" stroke="transparent" points="168.5,-90 168.5,-108 235.5,-108 235.5,-90 168.5,-90"/> |
| <polygon fill="none" stroke="black" points="168.5,-90 168.5,-108 235.5,-108 235.5,-90 168.5,-90"/> |
| <text text-anchor="start" x="216.5" y="-96.2" font-family="Helvetica,sans-Serif" font-size="11.00">3 ></text> |
| <polygon fill="none" stroke="black" stroke-width="2" points="9,-89 9,-241 236,-241 236,-89 9,-89"/> |
| </a> |
| </g> |
| </g> |
| <!-- m_creditbureau_configuration->m_creditbureau --> |
| <g id="edge1" class="edge"> |
| <title>m_creditbureau_configuration:w->m_creditbureau:e</title> |
| <path fill="none" stroke="black" d="M271.2,-348.97C231.29,-328.15 298.68,-207 236.5,-207"/> |
| <polygon fill="black" stroke="black" points="277.67,-350.34 284.75,-355.52 281.59,-351.17 285.5,-352 285.5,-352 285.5,-352 281.59,-351.17 286.25,-348.48 277.67,-350.34 277.67,-350.34"/> |
| <ellipse fill="none" stroke="black" cx="274.54" cy="-349.68" rx="3.2" ry="3.2"/> |
| </g> |
| <!-- m_creditbureau_loanproduct_mapping --> |
| <g id="node3" class="node"> |
| <title>m_creditbureau_loanproduct_mapping</title> |
| <g id="a_node3"><a xlink:href="../../tables/m_creditbureau_loanproduct_mapping.html" xlink:title="m_creditbureau_loanproduct_mapping" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="558,-224 558,-282 807,-282 807,-224 558,-224"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="558.5,-260 558.5,-282 807.5,-282 807.5,-260 558.5,-260"/> |
| <polygon fill="none" stroke="black" points="558.5,-260 558.5,-282 807.5,-282 807.5,-260 558.5,-260"/> |
| <text text-anchor="start" x="563.5" y="-269.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_creditbureau_loanproduct_mapping</text> |
| <text text-anchor="start" x="772.5" y="-268.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="558.5,-242 558.5,-260 807.5,-260 807.5,-242 558.5,-242"/> |
| <text text-anchor="start" x="561.5" y="-248.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="558.5,-224 558.5,-242 667.5,-242 667.5,-224 558.5,-224"/> |
| <polygon fill="none" stroke="black" points="558.5,-224 558.5,-242 667.5,-242 667.5,-224 558.5,-224"/> |
| <text text-anchor="start" x="561.5" y="-230.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 2</text> |
| <polygon fill="#ffffff" stroke="transparent" points="667.5,-224 667.5,-242 750.5,-242 750.5,-224 667.5,-224"/> |
| <polygon fill="none" stroke="black" points="667.5,-224 667.5,-242 750.5,-242 750.5,-224 667.5,-224"/> |
| <text text-anchor="start" x="714.5" y="-230.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="750.5,-224 750.5,-242 807.5,-242 807.5,-224 750.5,-224"/> |
| <polygon fill="none" stroke="black" points="750.5,-224 750.5,-242 807.5,-242 807.5,-224 750.5,-224"/> |
| <text text-anchor="start" x="797.5" y="-230.2" font-family="Helvetica,sans-Serif" font-size="11.00">  </text> |
| </a> |
| </g> |
| </g> |
| <!-- m_organisation_creditbureau --> |
| <g id="node4" class="node"> |
| <title>m_organisation_creditbureau</title> |
| <g id="a_node4"><a xlink:href="../../tables/m_organisation_creditbureau.html" xlink:title="m_organisation_creditbureau" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="288.5,-160 288.5,-284 506.5,-284 506.5,-160 288.5,-160"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="288.5,-262 288.5,-284 506.5,-284 506.5,-262 288.5,-262"/> |
| <polygon fill="none" stroke="black" points="288.5,-262 288.5,-284 506.5,-284 506.5,-262 288.5,-262"/> |
| <text text-anchor="start" x="293.5" y="-271.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_organisation_creditbureau</text> |
| <text text-anchor="start" x="471.5" y="-270.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="288.5,-240 288.5,-262 506.5,-262 506.5,-240 288.5,-240"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="293.5" y="-257"/> |
| <text text-anchor="start" x="308.5" y="-248.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="288.5,-218 288.5,-240 506.5,-240 506.5,-218 288.5,-218"/> |
| <polygon fill="none" stroke="black" points="288.5,-218 288.5,-240 506.5,-240 506.5,-218 288.5,-218"/> |
| <text text-anchor="start" x="308.5" y="-226.2" font-family="Helvetica,sans-Serif" font-size="11.00">alias</text> |
| <polygon fill="#ffffff" stroke="transparent" points="288.5,-196 288.5,-218 506.5,-218 506.5,-196 288.5,-196"/> |
| <polygon fill="none" stroke="black" points="288.5,-196 288.5,-218 506.5,-218 506.5,-196 288.5,-196"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="293.5" y="-213"/> |
| <text text-anchor="start" x="308.5" y="-204.2" font-family="Helvetica,sans-Serif" font-size="11.00">creditbureau_id</text> |
| <polygon fill="none" stroke="black" points="288.5,-178 288.5,-196 506.5,-196 506.5,-178 288.5,-178"/> |
| <text text-anchor="start" x="291.5" y="-184.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="288.5,-160 288.5,-178 377.5,-178 377.5,-160 288.5,-160"/> |
| <polygon fill="none" stroke="black" points="288.5,-160 288.5,-178 377.5,-178 377.5,-160 288.5,-160"/> |
| <text text-anchor="start" x="291.5" y="-166.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 1</text> |
| <polygon fill="#ffffff" stroke="transparent" points="377.5,-160 377.5,-178 450.5,-178 450.5,-160 377.5,-160"/> |
| <polygon fill="none" stroke="black" points="377.5,-160 377.5,-178 450.5,-178 450.5,-160 377.5,-160"/> |
| <text text-anchor="start" x="414.5" y="-166.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="450.5,-160 450.5,-178 506.5,-178 506.5,-160 450.5,-160"/> |
| <polygon fill="none" stroke="black" points="450.5,-160 450.5,-178 506.5,-178 506.5,-160 450.5,-160"/> |
| <text text-anchor="start" x="487.5" y="-166.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="M543.06,-251C531.31,-251 523.99,-251 507.5,-251"/> |
| <polygon fill="black" stroke="black" points="549.5,-251 557.5,-254.6 553.5,-251 557.5,-251 557.5,-251 557.5,-251 553.5,-251 557.5,-247.4 549.5,-251 549.5,-251"/> |
| <ellipse fill="none" stroke="black" cx="546.3" cy="-251" rx="3.2" ry="3.2"/> |
| </g> |
| <!-- m_organisation_creditbureau->m_creditbureau --> |
| <g id="edge4" class="edge"> |
| <title>m_organisation_creditbureau:w->m_creditbureau:e</title> |
| <path fill="none" stroke="black" d="M272.78,-207C260.78,-207 253.32,-207 236.5,-207"/> |
| <polygon fill="black" stroke="black" points="279.5,-207 287.5,-210.6 283.5,-207 287.5,-207 287.5,-207 287.5,-207 283.5,-207 287.5,-203.4 279.5,-207 279.5,-207"/> |
| <ellipse fill="none" stroke="black" cx="276.3" cy="-207" rx="3.2" ry="3.2"/> |
| </g> |
| <!-- m_creditreport --> |
| <g id="node5" class="node"> |
| <title>m_creditreport</title> |
| <g id="a_node5"><a xlink:href="../../tables/m_creditreport.html" xlink:title="m_creditreport" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="331,-37 331,-139 464,-139 464,-37 331,-37"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="331.5,-117 331.5,-139 464.5,-139 464.5,-117 331.5,-117"/> |
| <polygon fill="none" stroke="black" points="331.5,-117 331.5,-139 464.5,-139 464.5,-117 331.5,-117"/> |
| <text text-anchor="start" x="336.5" y="-126.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_creditreport</text> |
| <text text-anchor="start" x="429.5" y="-125.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="331.5,-95 331.5,-117 464.5,-117 464.5,-95 331.5,-95"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="336.5" y="-112"/> |
| <text text-anchor="start" x="351.5" y="-103.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="331.5,-73 331.5,-95 464.5,-95 464.5,-73 331.5,-73"/> |
| <polygon fill="none" stroke="black" points="331.5,-73 331.5,-95 464.5,-95 464.5,-73 331.5,-73"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="336.5" y="-90"/> |
| <text text-anchor="start" x="351.5" y="-81.2" font-family="Helvetica,sans-Serif" font-size="11.00">credit_bureau_id</text> |
| <polygon fill="none" stroke="black" points="331.5,-55 331.5,-73 464.5,-73 464.5,-55 331.5,-55"/> |
| <text text-anchor="start" x="334.5" y="-61.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="331.5,-37 331.5,-55 382.5,-55 382.5,-37 331.5,-37"/> |
| <polygon fill="none" stroke="black" points="331.5,-37 331.5,-55 382.5,-55 382.5,-37 331.5,-37"/> |
| <text text-anchor="start" x="334.5" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 1</text> |
| <polygon fill="#ffffff" stroke="transparent" points="382.5,-37 382.5,-55 436.5,-55 436.5,-37 382.5,-37"/> |
| <polygon fill="none" stroke="black" points="382.5,-37 382.5,-55 436.5,-55 436.5,-37 382.5,-37"/> |
| <text text-anchor="start" x="400.5" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="436.5,-37 436.5,-55 464.5,-55 464.5,-37 436.5,-37"/> |
| <polygon fill="none" stroke="black" points="436.5,-37 436.5,-55 464.5,-55 464.5,-37 436.5,-37"/> |
| <text text-anchor="start" x="454.5" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">  </text> |
| </a> |
| </g> |
| </g> |
| <!-- m_creditreport->m_creditbureau --> |
| <g id="edge3" class="edge"> |
| <title>m_creditreport:w->m_creditbureau:e</title> |
| <path fill="none" stroke="black" d="M316.05,-86.44C294.87,-94.93 296.97,-124.06 278,-149 258.81,-174.23 268.2,-207 236.5,-207"/> |
| <polygon fill="black" stroke="black" points="322.61,-85.33 331.1,-87.55 326.56,-84.67 330.5,-84 330.5,-84 330.5,-84 326.56,-84.67 329.9,-80.45 322.61,-85.33 322.61,-85.33"/> |
| <ellipse fill="none" stroke="black" cx="319.46" cy="-85.86" rx="3.2" ry="3.2"/> |
| </g> |
| </g> |
| </svg> |