blob: 2268a5f45e33acc34c8190eabff371d0fbff2ff0 [file] [log] [blame]
<?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="698pt" height="494pt"
viewBox="0.00 0.00 698.00 494.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 490)">
<title>oneDegreeRelationshipsDiagram</title>
<polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-490 694,-490 694,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_share_account_dividend_details -->
<g id="node1" class="node">
<title>m_share_account_dividend_details</title>
<g id="a_node1"><a xlink:href="../../tables/m_share_account_dividend_details.html" xlink:title="m_share_account_dividend_details" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="355,-257 355,-433 682,-433 682,-257 355,-257"/>
<polygon fill="#f5f5f5" stroke="transparent" points="357.5,-409 357.5,-431 680.5,-431 680.5,-409 357.5,-409"/>
<polygon fill="none" stroke="black" points="357.5,-409 357.5,-431 680.5,-431 680.5,-409 357.5,-409"/>
<text text-anchor="start" x="362.5" y="-418.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_share_account_dividend_details</text>
<text text-anchor="start" x="645.5" y="-417.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="357.5,-387 357.5,-409 610.5,-409 610.5,-387 357.5,-387"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="362.5" y="-404"/>
<text text-anchor="start" x="377.5" y="-395.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="none" stroke="black" points="610.5,-387 610.5,-409 680.5,-409 680.5,-387 610.5,-387"/>
<text text-anchor="start" x="613.5" y="-395.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="#ffffff" stroke="transparent" points="357.5,-365 357.5,-387 610.5,-387 610.5,-365 357.5,-365"/>
<polygon fill="none" stroke="black" points="357.5,-365 357.5,-387 610.5,-387 610.5,-365 357.5,-365"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="362.5" y="-382"/>
<text text-anchor="start" x="377.5" y="-373.2" font-family="Helvetica,sans-Serif" font-size="11.00">dividend_pay_out_id</text>
<polygon fill="none" stroke="black" points="610.5,-365 610.5,-387 680.5,-387 680.5,-365 610.5,-365"/>
<text text-anchor="start" x="613.5" y="-373.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="#ffffff" stroke="transparent" points="357.5,-343 357.5,-365 610.5,-365 610.5,-343 357.5,-343"/>
<polygon fill="none" stroke="black" points="357.5,-343 357.5,-365 610.5,-365 610.5,-343 357.5,-343"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="362.5" y="-360"/>
<text text-anchor="start" x="377.5" y="-351.2" font-family="Helvetica,sans-Serif" font-size="11.00">account_id</text>
<polygon fill="none" stroke="black" points="610.5,-343 610.5,-365 680.5,-365 680.5,-343 610.5,-343"/>
<text text-anchor="start" x="613.5" y="-351.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="none" stroke="black" points="357.5,-321 357.5,-343 610.5,-343 610.5,-321 357.5,-321"/>
<text text-anchor="start" x="377.5" y="-329.2" font-family="Helvetica,sans-Serif" font-size="11.00">amount</text>
<polygon fill="none" stroke="black" points="610.5,-321 610.5,-343 680.5,-343 680.5,-321 610.5,-321"/>
<text text-anchor="start" x="613.5" y="-329.2" font-family="Helvetica,sans-Serif" font-size="11.00">decimal[19,6]</text>
<polygon fill="none" stroke="black" points="357.5,-299 357.5,-321 610.5,-321 610.5,-299 357.5,-299"/>
<text text-anchor="start" x="377.5" y="-307.2" font-family="Helvetica,sans-Serif" font-size="11.00">status</text>
<polygon fill="none" stroke="black" points="610.5,-299 610.5,-321 680.5,-321 680.5,-299 610.5,-299"/>
<text text-anchor="start" x="613.5" y="-307.2" font-family="Helvetica,sans-Serif" font-size="11.00">smallint[5]</text>
<polygon fill="none" stroke="black" points="357.5,-277 357.5,-299 610.5,-299 610.5,-277 357.5,-277"/>
<text text-anchor="start" x="377.5" y="-285.2" font-family="Helvetica,sans-Serif" font-size="11.00">savings_transaction_id</text>
<polygon fill="none" stroke="black" points="610.5,-277 610.5,-299 680.5,-299 680.5,-277 610.5,-277"/>
<text text-anchor="start" x="613.5" y="-285.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="#ffffff" stroke="transparent" points="357.5,-259 357.5,-277 475.5,-277 475.5,-259 357.5,-259"/>
<polygon fill="none" stroke="black" points="357.5,-259 357.5,-277 475.5,-277 475.5,-259 357.5,-259"/>
<text text-anchor="start" x="360.5" y="-265.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 2</text>
<polygon fill="#ffffff" stroke="transparent" points="475.5,-259 475.5,-277 610.5,-277 610.5,-259 475.5,-259"/>
<polygon fill="none" stroke="black" points="475.5,-259 475.5,-277 610.5,-277 610.5,-259 475.5,-259"/>
<text text-anchor="start" x="574.5" y="-265.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="610.5,-259 610.5,-277 680.5,-277 680.5,-259 610.5,-259"/>
<polygon fill="none" stroke="black" points="610.5,-259 610.5,-277 680.5,-277 680.5,-259 610.5,-259"/>
<text text-anchor="start" x="661.5" y="-265.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 &gt;</text>
<polygon fill="none" stroke="black" stroke-width="2" points="356,-258 356,-432 681,-432 681,-258 356,-258"/>
</a>
</g>
</g>
<!-- m_share_account -->
<g id="node2" class="node">
<title>m_share_account</title>
<g id="a_node2"><a xlink:href="../../tables/m_share_account.html" xlink:title="m_share_account" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="8,-37 8,-315 306,-315 306,-37 8,-37"/>
<polygon fill="#f5f5f5" stroke="transparent" points="8,-293 8,-315 306,-315 306,-293 8,-293"/>
<polygon fill="none" stroke="black" points="8,-293 8,-315 306,-315 306,-293 8,-293"/>
<text text-anchor="start" x="13" y="-302.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_share_account</text>
<text text-anchor="start" x="271" y="-301.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="8,-271 8,-293 306,-293 306,-271 8,-271"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-288"/>
<text text-anchor="start" x="28" y="-279.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-249 8,-271 306,-271 306,-249 8,-249"/>
<polygon fill="none" stroke="black" points="8,-249 8,-271 306,-271 306,-249 8,-249"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-266"/>
<text text-anchor="start" x="28" y="-257.2" font-family="Helvetica,sans-Serif" font-size="11.00">product_id</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-227 8,-249 306,-249 306,-227 8,-227"/>
<polygon fill="none" stroke="black" points="8,-227 8,-249 306,-249 306,-227 8,-227"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-244"/>
<text text-anchor="start" x="28" y="-235.2" font-family="Helvetica,sans-Serif" font-size="11.00">client_id</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-205 8,-227 306,-227 306,-205 8,-205"/>
<polygon fill="none" stroke="black" points="8,-205 8,-227 306,-227 306,-205 8,-205"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-222"/>
<text text-anchor="start" x="28" y="-213.2" font-family="Helvetica,sans-Serif" font-size="11.00">submitted_userid</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-183 8,-205 306,-205 306,-183 8,-183"/>
<polygon fill="none" stroke="black" points="8,-183 8,-205 306,-205 306,-183 8,-183"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-200"/>
<text text-anchor="start" x="28" y="-191.2" font-family="Helvetica,sans-Serif" font-size="11.00">approved_userid</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-161 8,-183 306,-183 306,-161 8,-161"/>
<polygon fill="none" stroke="black" points="8,-161 8,-183 306,-183 306,-161 8,-161"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-178"/>
<text text-anchor="start" x="28" y="-169.2" font-family="Helvetica,sans-Serif" font-size="11.00">rejected_userid</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-139 8,-161 306,-161 306,-139 8,-139"/>
<polygon fill="none" stroke="black" points="8,-139 8,-161 306,-161 306,-139 8,-139"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-156"/>
<text text-anchor="start" x="28" y="-147.2" font-family="Helvetica,sans-Serif" font-size="11.00">activated_userid</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-117 8,-139 306,-139 306,-117 8,-117"/>
<polygon fill="none" stroke="black" points="8,-117 8,-139 306,-139 306,-117 8,-117"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-134"/>
<text text-anchor="start" x="28" y="-125.2" font-family="Helvetica,sans-Serif" font-size="11.00">closed_userid</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-95 8,-117 306,-117 306,-95 8,-95"/>
<polygon fill="none" stroke="black" points="8,-95 8,-117 306,-117 306,-95 8,-95"/>
<image xlink:href="../../images/foreignKeys.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">savings_account_id</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-73 8,-95 306,-95 306,-73 8,-73"/>
<polygon fill="none" stroke="black" points="8,-73 8,-95 306,-95 306,-73 8,-73"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-90"/>
<text text-anchor="start" x="28" y="-81.2" font-family="Helvetica,sans-Serif" font-size="11.00">lastmodifiedby_id</text>
<polygon fill="none" stroke="black" points="8,-55 8,-73 306,-73 306,-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 137,-55 137,-37 8,-37"/>
<polygon fill="none" stroke="black" points="8,-37 8,-55 137,-55 137,-37 8,-37"/>
<text text-anchor="start" x="11" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 9</text>
<polygon fill="#ffffff" stroke="transparent" points="137,-37 137,-55 230,-55 230,-37 137,-37"/>
<polygon fill="none" stroke="black" points="137,-37 137,-55 230,-55 230,-37 137,-37"/>
<text text-anchor="start" x="194" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="230,-37 230,-55 306,-55 306,-37 230,-37"/>
<polygon fill="none" stroke="black" points="230,-37 230,-55 306,-55 306,-37 230,-37"/>
<text text-anchor="start" x="287" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">3 &gt;</text>
</a>
</g>
</g>
<!-- m_share_account_dividend_details&#45;&gt;m_share_account -->
<g id="edge1" class="edge">
<title>m_share_account_dividend_details:w&#45;&gt;m_share_account:e</title>
<path fill="none" stroke="black" d="M342.69,-349.28C324.83,-333.26 339.77,-282 307,-282"/>
<polygon fill="black" stroke="black" points="348.93,-351.41 355.33,-357.41 352.72,-352.71 356.5,-354 356.5,-354 356.5,-354 352.72,-352.71 357.67,-350.59 348.93,-351.41 348.93,-351.41"/>
<ellipse fill="none" stroke="black" cx="345.9" cy="-350.37" rx="3.2" ry="3.2"/>
</g>
<!-- m_share_product_dividend_pay_out -->
<g id="node3" class="node">
<title>m_share_product_dividend_pay_out</title>
<g id="a_node3"><a xlink:href="../../tables/m_share_product_dividend_pay_out.html" xlink:title="m_share_product_dividend_pay_out" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="27.5,-336 27.5,-482 286.5,-482 286.5,-336 27.5,-336"/>
<polygon fill="#f5f5f5" stroke="transparent" points="28,-460 28,-482 287,-482 287,-460 28,-460"/>
<polygon fill="none" stroke="black" points="28,-460 28,-482 287,-482 287,-460 28,-460"/>
<text text-anchor="start" x="33" y="-469.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_share_product_dividend_pay_out</text>
<text text-anchor="start" x="252" y="-468.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="28,-438 28,-460 287,-460 287,-438 28,-438"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="33" y="-455"/>
<text text-anchor="start" x="48" y="-446.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="#ffffff" stroke="transparent" points="28,-416 28,-438 287,-438 287,-416 28,-416"/>
<polygon fill="none" stroke="black" points="28,-416 28,-438 287,-438 287,-416 28,-416"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="33" y="-433"/>
<text text-anchor="start" x="48" y="-424.2" font-family="Helvetica,sans-Serif" font-size="11.00">product_id</text>
<polygon fill="#ffffff" stroke="transparent" points="28,-394 28,-416 287,-416 287,-394 28,-394"/>
<polygon fill="none" stroke="black" points="28,-394 28,-416 287,-416 287,-394 28,-394"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="33" y="-411"/>
<text text-anchor="start" x="48" y="-402.2" font-family="Helvetica,sans-Serif" font-size="11.00">createdby_id</text>
<polygon fill="#ffffff" stroke="transparent" points="28,-372 28,-394 287,-394 287,-372 28,-372"/>
<polygon fill="none" stroke="black" points="28,-372 28,-394 287,-394 287,-372 28,-372"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="33" y="-389"/>
<text text-anchor="start" x="48" y="-380.2" font-family="Helvetica,sans-Serif" font-size="11.00">lastmodifiedby_id</text>
<polygon fill="none" stroke="black" points="28,-354 28,-372 287,-372 287,-354 28,-354"/>
<text text-anchor="start" x="31" y="-360.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="28,-336 28,-354 138,-354 138,-336 28,-336"/>
<polygon fill="none" stroke="black" points="28,-336 28,-354 138,-354 138,-336 28,-336"/>
<text text-anchor="start" x="31" y="-342.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 3</text>
<polygon fill="#ffffff" stroke="transparent" points="138,-336 138,-354 221,-354 221,-336 138,-336"/>
<polygon fill="none" stroke="black" points="138,-336 138,-354 221,-354 221,-336 138,-336"/>
<text text-anchor="start" x="185" y="-342.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="221,-336 221,-354 287,-354 287,-336 221,-336"/>
<polygon fill="none" stroke="black" points="221,-336 221,-354 287,-354 287,-336 221,-336"/>
<text text-anchor="start" x="268" y="-342.2" font-family="Helvetica,sans-Serif" font-size="11.00">1 &gt;</text>
</a>
</g>
</g>
<!-- m_share_account_dividend_details&#45;&gt;m_share_product_dividend_pay_out -->
<g id="edge2" class="edge">
<title>m_share_account_dividend_details:w&#45;&gt;m_share_product_dividend_pay_out:e</title>
<path fill="none" stroke="black" d="M342.25,-379.33C316.21,-393.61 326.76,-449 288,-449"/>
<polygon fill="black" stroke="black" points="348.71,-377.82 357.32,-379.51 352.6,-376.91 356.5,-376 356.5,-376 356.5,-376 352.6,-376.91 355.68,-372.49 348.71,-377.82 348.71,-377.82"/>
<ellipse fill="none" stroke="black" cx="345.59" cy="-378.55" rx="3.2" ry="3.2"/>
</g>
</g>
</svg>