| <?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="1112pt" height="364pt" |
| viewBox="0.00 0.00 1112.00 364.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 360)"> |
| <title>twoDegreesRelationshipsDiagram</title> |
| <polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-360 1108,-360 1108,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_client_collateral_management --> |
| <g id="node1" class="node"> |
| <title>m_client_collateral_management</title> |
| <g id="a_node1"><a xlink:href="../../tables/m_client_collateral_management.html" xlink:title="m_client_collateral_management" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="596,-221 596,-345 837,-345 837,-221 596,-221"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="596.5,-323 596.5,-345 837.5,-345 837.5,-323 596.5,-323"/> |
| <polygon fill="none" stroke="black" points="596.5,-323 596.5,-345 837.5,-345 837.5,-323 596.5,-323"/> |
| <text text-anchor="start" x="601.5" y="-332.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_client_collateral_management</text> |
| <text text-anchor="start" x="802.5" y="-331.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="596.5,-301 596.5,-323 837.5,-323 837.5,-301 596.5,-301"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="601.5" y="-318"/> |
| <text text-anchor="start" x="616.5" y="-309.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="596.5,-279 596.5,-301 837.5,-301 837.5,-279 596.5,-279"/> |
| <polygon fill="none" stroke="black" points="596.5,-279 596.5,-301 837.5,-301 837.5,-279 596.5,-279"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="601.5" y="-296"/> |
| <text text-anchor="start" x="616.5" y="-287.2" font-family="Helvetica,sans-Serif" font-size="11.00">client_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="596.5,-257 596.5,-279 837.5,-279 837.5,-257 596.5,-257"/> |
| <polygon fill="none" stroke="black" points="596.5,-257 596.5,-279 837.5,-279 837.5,-257 596.5,-257"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="601.5" y="-274"/> |
| <text text-anchor="start" x="616.5" y="-265.2" font-family="Helvetica,sans-Serif" font-size="11.00">collateral_id</text> |
| <polygon fill="none" stroke="black" points="596.5,-239 596.5,-257 837.5,-257 837.5,-239 596.5,-239"/> |
| <text text-anchor="start" x="599.5" y="-245.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="596.5,-221 596.5,-239 697.5,-239 697.5,-221 596.5,-221"/> |
| <polygon fill="none" stroke="black" points="596.5,-221 596.5,-239 697.5,-239 697.5,-221 596.5,-221"/> |
| <text text-anchor="start" x="599.5" y="-227.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 2</text> |
| <polygon fill="#ffffff" stroke="transparent" points="697.5,-221 697.5,-239 775.5,-239 775.5,-221 697.5,-221"/> |
| <polygon fill="none" stroke="black" points="697.5,-221 697.5,-239 775.5,-239 775.5,-221 697.5,-221"/> |
| <text text-anchor="start" x="739.5" y="-227.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="775.5,-221 775.5,-239 837.5,-239 837.5,-221 775.5,-221"/> |
| <polygon fill="none" stroke="black" points="775.5,-221 775.5,-239 837.5,-239 837.5,-221 775.5,-221"/> |
| <text text-anchor="start" x="818.5" y="-227.2" font-family="Helvetica,sans-Serif" font-size="11.00">1 ></text> |
| </a> |
| </g> |
| </g> |
| <!-- m_client --> |
| <g id="node2" class="node"> |
| <title>m_client</title> |
| <g id="a_node2"><a xlink:href="../../tables/m_client.html" xlink:title="m_client" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="363.5,-294 363.5,-352 458.5,-352 458.5,-294 363.5,-294"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="364,-330 364,-352 459,-352 459,-330 364,-330"/> |
| <polygon fill="none" stroke="black" points="364,-330 364,-352 459,-352 459,-330 364,-330"/> |
| <text text-anchor="start" x="369" y="-339.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_client</text> |
| <text text-anchor="start" x="424" y="-338.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="364,-312 364,-330 459,-330 459,-312 364,-312"/> |
| <text text-anchor="start" x="367" y="-318.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="364,-294 364,-312 392,-312 392,-294 364,-294"/> |
| <polygon fill="none" stroke="black" points="364,-294 364,-312 392,-312 392,-294 364,-294"/> |
| <text text-anchor="start" x="367" y="-300.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 13</text> |
| <polygon fill="#ffffff" stroke="transparent" points="392,-294 392,-312 431,-312 431,-294 392,-294"/> |
| <polygon fill="none" stroke="black" points="392,-294 392,-312 431,-312 431,-294 392,-294"/> |
| <text text-anchor="start" x="395" y="-300.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="431,-294 431,-312 459,-312 459,-294 431,-294"/> |
| <polygon fill="none" stroke="black" points="431,-294 431,-312 459,-312 459,-294 431,-294"/> |
| <text text-anchor="start" x="434" y="-300.2" font-family="Helvetica,sans-Serif" font-size="11.00">23 ></text> |
| </a> |
| </g> |
| </g> |
| <!-- m_client_collateral_management->m_client --> |
| <g id="edge1" class="edge"> |
| <title>m_client_collateral_management:w->m_client:e</title> |
| <path fill="none" stroke="black" d="M580.93,-290.62C531.36,-294.99 516.59,-321 460,-321"/> |
| <polygon fill="black" stroke="black" points="587.51,-290.34 595.65,-293.6 591.5,-290.17 595.5,-290 595.5,-290 595.5,-290 591.5,-290.17 595.35,-286.4 587.51,-290.34 587.51,-290.34"/> |
| <ellipse fill="none" stroke="black" cx="584.31" cy="-290.48" rx="3.2" ry="3.2"/> |
| </g> |
| <!-- m_collateral_management --> |
| <g id="node3" class="node"> |
| <title>m_collateral_management</title> |
| <g id="a_node3"><a xlink:href="../../tables/m_collateral_management.html" xlink:title="m_collateral_management" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="275,-75 275,-273 547,-273 547,-75 275,-75"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="277,-249 277,-271 545,-271 545,-249 277,-249"/> |
| <polygon fill="none" stroke="black" points="277,-249 277,-271 545,-271 545,-249 277,-249"/> |
| <text text-anchor="start" x="282" y="-258.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_collateral_management</text> |
| <text text-anchor="start" x="510" y="-257.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="277,-227 277,-249 475,-249 475,-227 277,-227"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="282" y="-244"/> |
| <text text-anchor="start" x="297" y="-235.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="none" stroke="black" points="475,-227 475,-249 545,-249 545,-227 475,-227"/> |
| <text text-anchor="start" x="478" y="-235.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="none" stroke="black" points="277,-205 277,-227 475,-227 475,-205 277,-205"/> |
| <text text-anchor="start" x="297" y="-213.2" font-family="Helvetica,sans-Serif" font-size="11.00">name</text> |
| <polygon fill="none" stroke="black" points="475,-205 475,-227 545,-227 545,-205 475,-205"/> |
| <text text-anchor="start" x="478" y="-213.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[50]</text> |
| <polygon fill="none" stroke="black" points="277,-183 277,-205 475,-205 475,-183 277,-183"/> |
| <text text-anchor="start" x="297" y="-191.2" font-family="Helvetica,sans-Serif" font-size="11.00">quality</text> |
| <polygon fill="none" stroke="black" points="475,-183 475,-205 545,-205 545,-183 475,-183"/> |
| <text text-anchor="start" x="478" y="-191.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[40]</text> |
| <polygon fill="none" stroke="black" points="277,-161 277,-183 475,-183 475,-161 277,-161"/> |
| <text text-anchor="start" x="297" y="-169.2" font-family="Helvetica,sans-Serif" font-size="11.00">base_price</text> |
| <polygon fill="none" stroke="black" points="475,-161 475,-183 545,-183 545,-161 475,-161"/> |
| <text text-anchor="start" x="478" y="-169.2" font-family="Helvetica,sans-Serif" font-size="11.00">decimal[20,5]</text> |
| <polygon fill="none" stroke="black" points="277,-139 277,-161 475,-161 475,-139 277,-139"/> |
| <text text-anchor="start" x="297" y="-147.2" font-family="Helvetica,sans-Serif" font-size="11.00">unit_type</text> |
| <polygon fill="none" stroke="black" points="475,-139 475,-161 545,-161 545,-139 475,-139"/> |
| <text text-anchor="start" x="478" y="-147.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[10]</text> |
| <polygon fill="none" stroke="black" points="277,-117 277,-139 475,-139 475,-117 277,-117"/> |
| <text text-anchor="start" x="297" y="-125.2" font-family="Helvetica,sans-Serif" font-size="11.00">pct_to_base</text> |
| <polygon fill="none" stroke="black" points="475,-117 475,-139 545,-139 545,-117 475,-117"/> |
| <text text-anchor="start" x="478" y="-125.2" font-family="Helvetica,sans-Serif" font-size="11.00">decimal[20,5]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="277,-95 277,-117 475,-117 475,-95 277,-95"/> |
| <polygon fill="none" stroke="black" points="277,-95 277,-117 475,-117 475,-95 277,-95"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="282" y="-112"/> |
| <text text-anchor="start" x="297" y="-103.2" font-family="Helvetica,sans-Serif" font-size="11.00">currency</text> |
| <polygon fill="none" stroke="black" points="475,-95 475,-117 545,-117 545,-95 475,-95"/> |
| <text text-anchor="start" x="478" y="-103.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="277,-77 277,-95 367,-95 367,-77 277,-77"/> |
| <polygon fill="none" stroke="black" points="277,-77 277,-95 367,-95 367,-77 277,-77"/> |
| <text text-anchor="start" x="280" y="-83.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 1</text> |
| <polygon fill="#ffffff" stroke="transparent" points="367,-77 367,-95 475,-95 475,-77 367,-77"/> |
| <polygon fill="none" stroke="black" points="367,-77 367,-95 475,-95 475,-77 367,-77"/> |
| <text text-anchor="start" x="439" y="-83.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="475,-77 475,-95 545,-95 545,-77 475,-77"/> |
| <polygon fill="none" stroke="black" points="475,-77 475,-95 545,-95 545,-77 475,-77"/> |
| <text text-anchor="start" x="526" y="-83.2" font-family="Helvetica,sans-Serif" font-size="11.00">1 ></text> |
| <polygon fill="none" stroke="black" stroke-width="2" points="276,-76 276,-272 546,-272 546,-76 276,-76"/> |
| </a> |
| </g> |
| </g> |
| <!-- m_client_collateral_management->m_collateral_management --> |
| <g id="edge2" class="edge"> |
| <title>m_client_collateral_management:w->m_collateral_management:e</title> |
| <path fill="none" stroke="black" d="M581.63,-264.08C569.24,-255.95 565.9,-238 546,-238"/> |
| <polygon fill="black" stroke="black" points="587.8,-265.82 594.52,-271.46 591.65,-266.91 595.5,-268 595.5,-268 595.5,-268 591.65,-266.91 596.48,-264.54 587.8,-265.82 587.8,-265.82"/> |
| <ellipse fill="none" stroke="black" cx="584.72" cy="-264.95" rx="3.2" ry="3.2"/> |
| </g> |
| <!-- m_currency --> |
| <g id="node4" class="node"> |
| <title>m_currency</title> |
| <g id="a_node4"><a xlink:href="../../tables/m_currency.html" xlink:title="m_currency" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="8,-37 8,-139 226,-139 226,-37 8,-37"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="8,-117 8,-139 226,-139 226,-117 8,-117"/> |
| <polygon fill="none" stroke="black" points="8,-117 8,-139 226,-139 226,-117 8,-117"/> |
| <text text-anchor="start" x="13" y="-126.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_currency</text> |
| <text text-anchor="start" x="191" y="-125.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="8,-95 8,-117 226,-117 226,-95 8,-95"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-112"/> |
| <text text-anchor="start" x="28" y="-103.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8,-73 8,-95 226,-95 226,-73 8,-73"/> |
| <polygon fill="none" stroke="black" points="8,-73 8,-95 226,-95 226,-73 8,-73"/> |
| <text text-anchor="start" x="28" y="-81.2" font-family="Helvetica,sans-Serif" font-size="11.00">code</text> |
| <polygon fill="none" stroke="black" points="8,-55 8,-73 226,-73 226,-55 8,-55"/> |
| <text text-anchor="start" x="11" y="-61.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8,-37 8,-55 93,-55 93,-37 8,-37"/> |
| <polygon fill="none" stroke="black" points="8,-37 8,-55 93,-55 93,-37 8,-37"/> |
| <text text-anchor="start" x="11" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">  </text> |
| <polygon fill="#ffffff" stroke="transparent" points="93,-37 93,-55 168,-55 168,-37 93,-37"/> |
| <polygon fill="none" stroke="black" points="93,-37 93,-55 168,-55 168,-37 93,-37"/> |
| <text text-anchor="start" x="132" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="168,-37 168,-55 226,-55 226,-37 168,-37"/> |
| <polygon fill="none" stroke="black" points="168,-37 168,-55 226,-55 226,-37 168,-37"/> |
| <text text-anchor="start" x="207" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">1 ></text> |
| </a> |
| </g> |
| </g> |
| <!-- m_collateral_management->m_currency --> |
| <g id="edge3" class="edge"> |
| <title>m_collateral_management:w->m_currency:e</title> |
| <path fill="none" stroke="black" d="M261.49,-106C250.18,-106 242.99,-106 227,-106"/> |
| <polygon fill="black" stroke="black" points="268,-106 276,-109.6 272,-106 276,-106 276,-106 276,-106 272,-106 276,-102.4 268,-106 268,-106"/> |
| <ellipse fill="none" stroke="black" cx="264.8" cy="-106" rx="3.2" ry="3.2"/> |
| </g> |
| <!-- m_loan_collateral_management --> |
| <g id="node5" class="node"> |
| <title>m_loan_collateral_management</title> |
| <g id="a_node5"><a xlink:href="../../tables/m_loan_collateral_management.html" xlink:title="m_loan_collateral_management" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="886,-285 886,-343 1096,-343 1096,-285 886,-285"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="886,-321 886,-343 1096,-343 1096,-321 886,-321"/> |
| <polygon fill="none" stroke="black" points="886,-321 886,-343 1096,-343 1096,-321 886,-321"/> |
| <text text-anchor="start" x="891" y="-330.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_loan_collateral_management</text> |
| <text text-anchor="start" x="1061" y="-329.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="886,-303 886,-321 1096,-321 1096,-303 886,-303"/> |
| <text text-anchor="start" x="889" y="-309.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="886,-285 886,-303 976,-303 976,-285 886,-285"/> |
| <polygon fill="none" stroke="black" points="886,-285 886,-303 976,-303 976,-285 886,-285"/> |
| <text text-anchor="start" x="889" y="-291.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 3</text> |
| <polygon fill="#ffffff" stroke="transparent" points="976,-285 976,-303 1049,-303 1049,-285 976,-285"/> |
| <polygon fill="none" stroke="black" points="976,-285 976,-303 1049,-303 1049,-285 976,-285"/> |
| <text text-anchor="start" x="1013" y="-291.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="1049,-285 1049,-303 1096,-303 1096,-285 1049,-285"/> |
| <polygon fill="none" stroke="black" points="1049,-285 1049,-303 1096,-303 1096,-285 1049,-285"/> |
| <text text-anchor="start" x="1086" y="-291.2" font-family="Helvetica,sans-Serif" font-size="11.00">  </text> |
| </a> |
| </g> |
| </g> |
| <!-- m_loan_collateral_management->m_client_collateral_management --> |
| <g id="edge4" class="edge"> |
| <title>m_loan_collateral_management:w->m_client_collateral_management:e</title> |
| <path fill="none" stroke="black" d="M870.55,-312C860.2,-312 853.35,-312 838.5,-312"/> |
| <polygon fill="black" stroke="black" points="877,-312 885,-315.6 881,-312 885,-312 885,-312 885,-312 881,-312 885,-308.4 877,-312 877,-312"/> |
| <ellipse fill="none" stroke="black" cx="873.8" cy="-312" rx="3.2" ry="3.2"/> |
| </g> |
| </g> |
| </svg> |