docs/database/diagrams/tables/m_collateral_management.1degree.svg

<?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="853pt" height="327pt"
 viewBox="0.00 0.00 853.00 327.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 323)">
<title>oneDegreeRelationshipsDiagram</title>
<polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-323 849,-323 849,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,-191 596,-315 837,-315 837,-191 596,-191"/>
<polygon fill="#f5f5f5" stroke="transparent" points="596.5,-293 596.5,-315 837.5,-315 837.5,-293 596.5,-293"/>
<polygon fill="none" stroke="black" points="596.5,-293 596.5,-315 837.5,-315 837.5,-293 596.5,-293"/>
<text text-anchor="start" x="601.5" y="-302.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="-301.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="596.5,-271 596.5,-293 837.5,-293 837.5,-271 596.5,-271"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="601.5" y="-288"/>
<text text-anchor="start" x="616.5" y="-279.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="#ffffff" stroke="transparent" points="596.5,-249 596.5,-271 837.5,-271 837.5,-249 596.5,-249"/>
<polygon fill="none" stroke="black" points="596.5,-249 596.5,-271 837.5,-271 837.5,-249 596.5,-249"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="601.5" y="-266"/>
<text text-anchor="start" x="616.5" y="-257.2" font-family="Helvetica,sans-Serif" font-size="11.00">client_id</text>
<polygon fill="#ffffff" stroke="transparent" points="596.5,-227 596.5,-249 837.5,-249 837.5,-227 596.5,-227"/>
<polygon fill="none" stroke="black" points="596.5,-227 596.5,-249 837.5,-249 837.5,-227 596.5,-227"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="601.5" y="-244"/>
<text text-anchor="start" x="616.5" y="-235.2" font-family="Helvetica,sans-Serif" font-size="11.00">collateral_id</text>
<polygon fill="none" stroke="black" points="596.5,-209 596.5,-227 837.5,-227 837.5,-209 596.5,-209"/>
<text text-anchor="start" x="599.5" y="-215.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="596.5,-191 596.5,-209 697.5,-209 697.5,-191 596.5,-191"/>
<polygon fill="none" stroke="black" points="596.5,-191 596.5,-209 697.5,-209 697.5,-191 596.5,-191"/>
<text text-anchor="start" x="599.5" y="-197.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 2</text>
<polygon fill="#ffffff" stroke="transparent" points="697.5,-191 697.5,-209 775.5,-209 775.5,-191 697.5,-191"/>
<polygon fill="none" stroke="black" points="697.5,-191 697.5,-209 775.5,-209 775.5,-191 697.5,-191"/>
<text text-anchor="start" x="739.5" y="-197.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="775.5,-191 775.5,-209 837.5,-209 837.5,-191 775.5,-191"/>
<polygon fill="none" stroke="black" points="775.5,-191 775.5,-209 837.5,-209 837.5,-191 775.5,-191"/>
<text text-anchor="start" x="818.5" y="-197.2" font-family="Helvetica,sans-Serif" font-size="11.00">1 &gt;</text>
</a>
</g>
</g>
<!-- m_collateral_management -->
<g id="node2" class="node">
<title>m_collateral_management</title>
<g id="a_node2"><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">&lt; 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 &gt;</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&#45;&gt;m_collateral_management -->
<g id="edge1" class="edge">
<title>m_client_collateral_management:w&#45;&gt;m_collateral_management:e</title>
<path fill="none" stroke="black" d="M580.84,-238C569.41,-238 562.16,-238 546,-238"/>
<polygon fill="black" stroke="black" points="587.5,-238 595.5,-241.6 591.5,-238 595.5,-238 595.5,-238 595.5,-238 591.5,-238 595.5,-234.4 587.5,-238 587.5,-238"/>
<ellipse fill="none" stroke="black" cx="584.3" cy="-238" rx="3.2" ry="3.2"/>
</g>
<!-- m_currency -->
<g id="node3" class="node">
<title>m_currency</title>
<g id="a_node3"><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"> &#160;</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 &gt;</text>
</a>
</g>
</g>
<!-- m_collateral_management&#45;&gt;m_currency -->
<g id="edge2" class="edge">
<title>m_collateral_management:w&#45;&gt;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>
</g>
</svg>