blob: c5703855523239e9bb6b10f2112210441513aba4 [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="888pt" height="861pt"
viewBox="0.00 0.00 888.00 861.16" 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 857.16)">
<title>oneDegreeRelationshipsDiagram</title>
<polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-857.16 884,-857.16 884,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_survey_questions -->
<g id="node1" class="node">
<title>m_survey_questions</title>
<g id="a_node1"><a xlink:href="../../tables/m_survey_questions.html" xlink:title="m_survey_questions" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="168,-706 168,-808 325,-808 325,-706 168,-706"/>
<polygon fill="#f5f5f5" stroke="transparent" points="168.5,-786 168.5,-808 325.5,-808 325.5,-786 168.5,-786"/>
<polygon fill="none" stroke="black" points="168.5,-786 168.5,-808 325.5,-808 325.5,-786 168.5,-786"/>
<text text-anchor="start" x="173.5" y="-795.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_survey_questions</text>
<text text-anchor="start" x="290.5" y="-794.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="168.5,-764 168.5,-786 325.5,-786 325.5,-764 168.5,-764"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="173.5" y="-781"/>
<text text-anchor="start" x="188.5" y="-772.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="#ffffff" stroke="transparent" points="168.5,-742 168.5,-764 325.5,-764 325.5,-742 168.5,-742"/>
<polygon fill="none" stroke="black" points="168.5,-742 168.5,-764 325.5,-764 325.5,-742 168.5,-742"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="173.5" y="-759"/>
<text text-anchor="start" x="188.5" y="-750.2" font-family="Helvetica,sans-Serif" font-size="11.00">survey_id</text>
<polygon fill="none" stroke="black" points="168.5,-724 168.5,-742 325.5,-742 325.5,-724 168.5,-724"/>
<text text-anchor="start" x="171.5" y="-730.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="168.5,-706 168.5,-724 227.5,-724 227.5,-706 168.5,-706"/>
<polygon fill="none" stroke="black" points="168.5,-706 168.5,-724 227.5,-724 227.5,-706 168.5,-706"/>
<text text-anchor="start" x="171.5" y="-712.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 1</text>
<polygon fill="#ffffff" stroke="transparent" points="227.5,-706 227.5,-724 284.5,-724 284.5,-706 227.5,-706"/>
<polygon fill="none" stroke="black" points="227.5,-706 227.5,-724 284.5,-724 284.5,-706 227.5,-706"/>
<text text-anchor="start" x="248.5" y="-712.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="284.5,-706 284.5,-724 325.5,-724 325.5,-706 284.5,-706"/>
<polygon fill="none" stroke="black" points="284.5,-706 284.5,-724 325.5,-724 325.5,-706 284.5,-706"/>
<text text-anchor="start" x="306.5" y="-712.2" font-family="Helvetica,sans-Serif" font-size="11.00">2 &gt;</text>
</a>
</g>
</g>
<!-- m_surveys -->
<g id="node2" class="node">
<title>m_surveys</title>
<g id="a_node2"><a xlink:href="../../tables/m_surveys.html" xlink:title="m_surveys" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="8,-745 8,-825 119,-825 119,-745 8,-745"/>
<polygon fill="#f5f5f5" stroke="transparent" points="8.5,-803 8.5,-825 119.5,-825 119.5,-803 8.5,-803"/>
<polygon fill="none" stroke="black" points="8.5,-803 8.5,-825 119.5,-825 119.5,-803 8.5,-803"/>
<text text-anchor="start" x="13.5" y="-812.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_surveys</text>
<text text-anchor="start" x="84.5" y="-811.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="8.5,-781 8.5,-803 119.5,-803 119.5,-781 8.5,-781"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-798"/>
<text text-anchor="start" x="28.5" y="-789.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="none" stroke="black" points="8.5,-763 8.5,-781 119.5,-781 119.5,-763 8.5,-763"/>
<text text-anchor="start" x="11.5" y="-769.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="8.5,-745 8.5,-763 39.5,-763 39.5,-745 8.5,-745"/>
<polygon fill="none" stroke="black" points="8.5,-745 8.5,-763 39.5,-763 39.5,-745 8.5,-745"/>
<text text-anchor="start" x="11.5" y="-751.2" font-family="Helvetica,sans-Serif" font-size="11.00"> &#160;</text>
<polygon fill="#ffffff" stroke="transparent" points="39.5,-745 39.5,-763 87.5,-763 87.5,-745 39.5,-745"/>
<polygon fill="none" stroke="black" points="39.5,-745 39.5,-763 87.5,-763 87.5,-745 39.5,-745"/>
<text text-anchor="start" x="51.5" y="-751.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="87.5,-745 87.5,-763 119.5,-763 119.5,-745 87.5,-745"/>
<polygon fill="none" stroke="black" points="87.5,-745 87.5,-763 119.5,-763 119.5,-745 87.5,-745"/>
<text text-anchor="start" x="100.5" y="-751.2" font-family="Helvetica,sans-Serif" font-size="11.00">4 &gt;</text>
</a>
</g>
</g>
<!-- m_survey_questions&#45;&gt;m_surveys -->
<g id="edge1" class="edge">
<title>m_survey_questions:w&#45;&gt;m_surveys:e</title>
<path fill="none" stroke="black" d="M153.91,-757.78C141.9,-768.2 141.71,-792 120.5,-792"/>
<polygon fill="black" stroke="black" points="159.95,-755.66 168.69,-756.4 163.73,-754.33 167.5,-753 167.5,-753 167.5,-753 163.73,-754.33 166.31,-749.6 159.95,-755.66 159.95,-755.66"/>
<ellipse fill="none" stroke="black" cx="156.93" cy="-756.72" rx="3.2" ry="3.2"/>
</g>
<!-- m_survey_responses -->
<g id="node3" class="node">
<title>m_survey_responses</title>
<g id="a_node3"><a xlink:href="../../tables/m_survey_responses.html" xlink:title="m_survey_responses" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="402,-679 402,-781 561,-781 561,-679 402,-679"/>
<polygon fill="#f5f5f5" stroke="transparent" points="402.5,-759 402.5,-781 561.5,-781 561.5,-759 402.5,-759"/>
<polygon fill="none" stroke="black" points="402.5,-759 402.5,-781 561.5,-781 561.5,-759 402.5,-759"/>
<text text-anchor="start" x="407.5" y="-768.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_survey_responses</text>
<text text-anchor="start" x="526.5" y="-767.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="402.5,-737 402.5,-759 561.5,-759 561.5,-737 402.5,-737"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="407.5" y="-754"/>
<text text-anchor="start" x="422.5" y="-745.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="#ffffff" stroke="transparent" points="402.5,-715 402.5,-737 561.5,-737 561.5,-715 402.5,-715"/>
<polygon fill="none" stroke="black" points="402.5,-715 402.5,-737 561.5,-737 561.5,-715 402.5,-715"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="407.5" y="-732"/>
<text text-anchor="start" x="422.5" y="-723.2" font-family="Helvetica,sans-Serif" font-size="11.00">question_id</text>
<polygon fill="none" stroke="black" points="402.5,-697 402.5,-715 561.5,-715 561.5,-697 402.5,-697"/>
<text text-anchor="start" x="405.5" y="-703.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="402.5,-679 402.5,-697 462.5,-697 462.5,-679 402.5,-679"/>
<polygon fill="none" stroke="black" points="402.5,-679 402.5,-697 462.5,-697 462.5,-679 402.5,-679"/>
<text text-anchor="start" x="405.5" y="-685.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 1</text>
<polygon fill="#ffffff" stroke="transparent" points="462.5,-679 462.5,-697 520.5,-697 520.5,-679 462.5,-679"/>
<polygon fill="none" stroke="black" points="462.5,-679 462.5,-697 520.5,-697 520.5,-679 462.5,-679"/>
<text text-anchor="start" x="484.5" y="-685.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="520.5,-679 520.5,-697 561.5,-697 561.5,-679 520.5,-679"/>
<polygon fill="none" stroke="black" points="520.5,-679 520.5,-697 561.5,-697 561.5,-679 520.5,-679"/>
<text text-anchor="start" x="542.5" y="-685.2" font-family="Helvetica,sans-Serif" font-size="11.00">1 &gt;</text>
</a>
</g>
</g>
<!-- m_survey_responses&#45;&gt;m_survey_questions -->
<g id="edge2" class="edge">
<title>m_survey_responses:w&#45;&gt;m_survey_questions:e</title>
<path fill="none" stroke="black" d="M387.09,-728.63C362.11,-738.81 360.72,-775 326.5,-775"/>
<polygon fill="black" stroke="black" points="393.63,-727.44 402.15,-729.54 397.57,-726.72 401.5,-726 401.5,-726 401.5,-726 397.57,-726.72 400.85,-722.46 393.63,-727.44 393.63,-727.44"/>
<ellipse fill="none" stroke="black" cx="390.48" cy="-728.01" rx="3.2" ry="3.2"/>
</g>
<!-- m_survey_scorecards -->
<g id="node4" class="node">
<title>m_survey_scorecards</title>
<g id="a_node4"><a xlink:href="../../tables/m_survey_scorecards.html" xlink:title="m_survey_scorecards" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="638,-629 638,-849 872,-849 872,-629 638,-629"/>
<polygon fill="#f5f5f5" stroke="transparent" points="640,-825 640,-847 870,-847 870,-825 640,-825"/>
<polygon fill="none" stroke="black" points="640,-825 640,-847 870,-847 870,-825 640,-825"/>
<text text-anchor="start" x="645" y="-834.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_survey_scorecards</text>
<text text-anchor="start" x="835" y="-833.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="640,-803 640,-825 804,-825 804,-803 640,-803"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="645" y="-820"/>
<text text-anchor="start" x="660" y="-811.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="none" stroke="black" points="804,-803 804,-825 870,-825 870,-803 804,-803"/>
<text text-anchor="start" x="807" y="-811.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="#ffffff" stroke="transparent" points="640,-781 640,-803 804,-803 804,-781 640,-781"/>
<polygon fill="none" stroke="black" points="640,-781 640,-803 804,-803 804,-781 640,-781"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="645" y="-798"/>
<text text-anchor="start" x="660" y="-789.2" font-family="Helvetica,sans-Serif" font-size="11.00">survey_id</text>
<polygon fill="none" stroke="black" points="804,-781 804,-803 870,-803 870,-781 804,-781"/>
<text text-anchor="start" x="807" y="-789.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="#ffffff" stroke="transparent" points="640,-759 640,-781 804,-781 804,-759 640,-759"/>
<polygon fill="none" stroke="black" points="640,-759 640,-781 804,-781 804,-759 640,-759"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="645" y="-776"/>
<text text-anchor="start" x="660" y="-767.2" font-family="Helvetica,sans-Serif" font-size="11.00">question_id</text>
<polygon fill="none" stroke="black" points="804,-759 804,-781 870,-781 870,-759 804,-759"/>
<text text-anchor="start" x="807" y="-767.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="#ffffff" stroke="transparent" points="640,-737 640,-759 804,-759 804,-737 640,-737"/>
<polygon fill="none" stroke="black" points="640,-737 640,-759 804,-759 804,-737 640,-737"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="645" y="-754"/>
<text text-anchor="start" x="660" y="-745.2" font-family="Helvetica,sans-Serif" font-size="11.00">response_id</text>
<polygon fill="none" stroke="black" points="804,-737 804,-759 870,-759 870,-737 804,-737"/>
<text text-anchor="start" x="807" y="-745.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="#ffffff" stroke="transparent" points="640,-715 640,-737 804,-737 804,-715 640,-715"/>
<polygon fill="none" stroke="black" points="640,-715 640,-737 804,-737 804,-715 640,-715"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="645" y="-732"/>
<text text-anchor="start" x="660" y="-723.2" font-family="Helvetica,sans-Serif" font-size="11.00">user_id</text>
<polygon fill="none" stroke="black" points="804,-715 804,-737 870,-737 870,-715 804,-715"/>
<text text-anchor="start" x="807" y="-723.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="#ffffff" stroke="transparent" points="640,-693 640,-715 804,-715 804,-693 640,-693"/>
<polygon fill="none" stroke="black" points="640,-693 640,-715 804,-715 804,-693 640,-693"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="645" y="-710"/>
<text text-anchor="start" x="660" y="-701.2" font-family="Helvetica,sans-Serif" font-size="11.00">client_id</text>
<polygon fill="none" stroke="black" points="804,-693 804,-715 870,-715 870,-693 804,-693"/>
<text text-anchor="start" x="807" y="-701.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="none" stroke="black" points="640,-671 640,-693 804,-693 804,-671 640,-671"/>
<text text-anchor="start" x="660" y="-679.2" font-family="Helvetica,sans-Serif" font-size="11.00">created_on</text>
<polygon fill="none" stroke="black" points="804,-671 804,-693 870,-693 870,-671 804,-671"/>
<text text-anchor="start" x="807" y="-679.2" font-family="Helvetica,sans-Serif" font-size="11.00">datetime[19]</text>
<polygon fill="none" stroke="black" points="640,-649 640,-671 804,-671 804,-649 640,-649"/>
<text text-anchor="start" x="660" y="-657.2" font-family="Helvetica,sans-Serif" font-size="11.00">a_value</text>
<polygon fill="none" stroke="black" points="804,-649 804,-671 870,-671 870,-649 804,-649"/>
<text text-anchor="start" x="807" y="-657.2" font-family="Helvetica,sans-Serif" font-size="11.00">int[10]</text>
<polygon fill="#ffffff" stroke="transparent" points="640,-631 640,-649 713,-649 713,-631 640,-631"/>
<polygon fill="none" stroke="black" points="640,-631 640,-649 713,-649 713,-631 640,-631"/>
<text text-anchor="start" x="643" y="-637.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 5</text>
<polygon fill="#ffffff" stroke="transparent" points="713,-631 713,-649 804,-649 804,-631 713,-631"/>
<polygon fill="none" stroke="black" points="713,-631 713,-649 804,-649 804,-631 713,-631"/>
<text text-anchor="start" x="768" y="-637.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="804,-631 804,-649 870,-649 870,-631 804,-631"/>
<polygon fill="none" stroke="black" points="804,-631 804,-649 870,-649 870,-631 804,-631"/>
<text text-anchor="start" x="851" y="-637.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 &gt;</text>
<polygon fill="none" stroke="black" stroke-width="2" points="639,-630 639,-848 871,-848 871,-630 639,-630"/>
</a>
</g>
</g>
<!-- m_survey_scorecards&#45;&gt;m_survey_questions -->
<g id="edge4" class="edge">
<title>m_survey_scorecards:w&#45;&gt;m_survey_questions:e</title>
<path fill="none" stroke="black" d="M624.91,-773.55C615.99,-778.81 611.55,-788.42 597,-792 497.31,-816.53 466.55,-812.72 366,-792 347.28,-788.14 345.61,-775 326.5,-775"/>
<polygon fill="black" stroke="black" points="631.24,-771.96 639.88,-773.49 635.12,-770.98 639,-770 639,-770 639,-770 635.12,-770.98 638.12,-766.51 631.24,-771.96 631.24,-771.96"/>
<ellipse fill="none" stroke="black" cx="628.14" cy="-772.74" rx="3.2" ry="3.2"/>
</g>
<!-- m_survey_scorecards&#45;&gt;m_surveys -->
<g id="edge6" class="edge">
<title>m_survey_scorecards:w&#45;&gt;m_surveys:e</title>
<path fill="none" stroke="black" d="M624.84,-795C616,-799.26 610.94,-806.89 597,-810 407.4,-852.3 345.6,-876.37 160,-819 139.68,-812.72 141.76,-792 120.5,-792"/>
<polygon fill="black" stroke="black" points="631.17,-793.66 639.74,-795.52 635.09,-792.83 639,-792 639,-792 639,-792 635.09,-792.83 638.26,-788.48 631.17,-793.66 631.17,-793.66"/>
<ellipse fill="none" stroke="black" cx="628.04" cy="-794.32" rx="3.2" ry="3.2"/>
</g>
<!-- m_survey_scorecards&#45;&gt;m_survey_responses -->
<g id="edge5" class="edge">
<title>m_survey_scorecards:w&#45;&gt;m_survey_responses:e</title>
<path fill="none" stroke="black" d="M624.42,-748C601.62,-748 591.05,-748 562.5,-748"/>
<polygon fill="black" stroke="black" points="631,-748 639,-751.6 635,-748 639,-748 639,-748 639,-748 635,-748 639,-744.4 631,-748 631,-748"/>
<ellipse fill="none" stroke="black" cx="627.8" cy="-748" rx="3.2" ry="3.2"/>
</g>
<!-- m_client -->
<g id="node5" class="node">
<title>m_client</title>
<g id="a_node5"><a xlink:href="../../tables/m_client.html" xlink:title="m_client" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="385,-37 385,-469 578,-469 578,-37 385,-37"/>
<polygon fill="#f5f5f5" stroke="transparent" points="385.5,-447 385.5,-469 578.5,-469 578.5,-447 385.5,-447"/>
<polygon fill="none" stroke="black" points="385.5,-447 385.5,-469 578.5,-469 578.5,-447 385.5,-447"/>
<text text-anchor="start" x="390.5" y="-456.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_client</text>
<text text-anchor="start" x="543.5" y="-455.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="385.5,-425 385.5,-447 578.5,-447 578.5,-425 385.5,-425"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="390.5" y="-442"/>
<text text-anchor="start" x="405.5" y="-433.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="#ffffff" stroke="transparent" points="385.5,-403 385.5,-425 578.5,-425 578.5,-403 385.5,-403"/>
<polygon fill="none" stroke="black" points="385.5,-403 385.5,-425 578.5,-425 578.5,-403 385.5,-403"/>
<text text-anchor="start" x="405.5" y="-411.2" font-family="Helvetica,sans-Serif" font-size="11.00">account_no</text>
<polygon fill="#ffffff" stroke="transparent" points="385.5,-381 385.5,-403 578.5,-403 578.5,-381 385.5,-381"/>
<polygon fill="none" stroke="black" points="385.5,-381 385.5,-403 578.5,-403 578.5,-381 385.5,-381"/>
<text text-anchor="start" x="405.5" y="-389.2" font-family="Helvetica,sans-Serif" font-size="11.00">external_id</text>
<polygon fill="#ffffff" stroke="transparent" points="385.5,-359 385.5,-381 578.5,-381 578.5,-359 385.5,-359"/>
<polygon fill="none" stroke="black" points="385.5,-359 385.5,-381 578.5,-381 578.5,-359 385.5,-359"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="390.5" y="-376"/>
<text text-anchor="start" x="405.5" y="-367.2" font-family="Helvetica,sans-Serif" font-size="11.00">sub_status</text>
<polygon fill="#ffffff" stroke="transparent" points="385.5,-337 385.5,-359 578.5,-359 578.5,-337 385.5,-337"/>
<polygon fill="none" stroke="black" points="385.5,-337 385.5,-359 578.5,-359 578.5,-337 385.5,-337"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="390.5" y="-354"/>
<text text-anchor="start" x="405.5" y="-345.2" font-family="Helvetica,sans-Serif" font-size="11.00">office_id</text>
<polygon fill="#ffffff" stroke="transparent" points="385.5,-315 385.5,-337 578.5,-337 578.5,-315 385.5,-315"/>
<polygon fill="none" stroke="black" points="385.5,-315 385.5,-337 578.5,-337 578.5,-315 385.5,-315"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="390.5" y="-332"/>
<text text-anchor="start" x="405.5" y="-323.2" font-family="Helvetica,sans-Serif" font-size="11.00">transfer_to_office_id</text>
<polygon fill="#ffffff" stroke="transparent" points="385.5,-293 385.5,-315 578.5,-315 578.5,-293 385.5,-293"/>
<polygon fill="none" stroke="black" points="385.5,-293 385.5,-315 578.5,-315 578.5,-293 385.5,-293"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="390.5" y="-310"/>
<text text-anchor="start" x="405.5" y="-301.2" font-family="Helvetica,sans-Serif" font-size="11.00">staff_id</text>
<polygon fill="#ffffff" stroke="transparent" points="385.5,-271 385.5,-293 578.5,-293 578.5,-271 385.5,-271"/>
<polygon fill="none" stroke="black" points="385.5,-271 385.5,-293 578.5,-293 578.5,-271 385.5,-271"/>
<text text-anchor="start" x="405.5" y="-279.2" font-family="Helvetica,sans-Serif" font-size="11.00">mobile_no</text>
<polygon fill="#ffffff" stroke="transparent" points="385.5,-249 385.5,-271 578.5,-271 578.5,-249 385.5,-249"/>
<polygon fill="none" stroke="black" points="385.5,-249 385.5,-271 578.5,-271 578.5,-249 385.5,-249"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="390.5" y="-266"/>
<text text-anchor="start" x="405.5" y="-257.2" font-family="Helvetica,sans-Serif" font-size="11.00">gender_cv_id</text>
<polygon fill="#ffffff" stroke="transparent" points="385.5,-227 385.5,-249 578.5,-249 578.5,-227 385.5,-227"/>
<polygon fill="none" stroke="black" points="385.5,-227 385.5,-249 578.5,-249 578.5,-227 385.5,-227"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="390.5" y="-244"/>
<text text-anchor="start" x="405.5" y="-235.2" font-family="Helvetica,sans-Serif" font-size="11.00">image_id</text>
<polygon fill="#ffffff" stroke="transparent" points="385.5,-205 385.5,-227 578.5,-227 578.5,-205 385.5,-205"/>
<polygon fill="none" stroke="black" points="385.5,-205 385.5,-227 578.5,-227 578.5,-205 385.5,-205"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="390.5" y="-222"/>
<text text-anchor="start" x="405.5" y="-213.2" font-family="Helvetica,sans-Serif" font-size="11.00">closure_reason_cv_id</text>
<polygon fill="#ffffff" stroke="transparent" points="385.5,-183 385.5,-205 578.5,-205 578.5,-183 385.5,-183"/>
<polygon fill="none" stroke="black" points="385.5,-183 385.5,-205 578.5,-205 578.5,-183 385.5,-183"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="390.5" y="-200"/>
<text text-anchor="start" x="405.5" y="-191.2" font-family="Helvetica,sans-Serif" font-size="11.00">default_savings_product</text>
<polygon fill="#ffffff" stroke="transparent" points="385.5,-161 385.5,-183 578.5,-183 578.5,-161 385.5,-161"/>
<polygon fill="none" stroke="black" points="385.5,-161 385.5,-183 578.5,-183 578.5,-161 385.5,-161"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="390.5" y="-178"/>
<text text-anchor="start" x="405.5" y="-169.2" font-family="Helvetica,sans-Serif" font-size="11.00">default_savings_account</text>
<polygon fill="#ffffff" stroke="transparent" points="385.5,-139 385.5,-161 578.5,-161 578.5,-139 385.5,-139"/>
<polygon fill="none" stroke="black" points="385.5,-139 385.5,-161 578.5,-161 578.5,-139 385.5,-139"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="390.5" y="-156"/>
<text text-anchor="start" x="405.5" y="-147.2" font-family="Helvetica,sans-Serif" font-size="11.00">client_type_cv_id</text>
<polygon fill="#ffffff" stroke="transparent" points="385.5,-117 385.5,-139 578.5,-139 578.5,-117 385.5,-117"/>
<polygon fill="none" stroke="black" points="385.5,-117 385.5,-139 578.5,-139 578.5,-117 385.5,-117"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="390.5" y="-134"/>
<text text-anchor="start" x="405.5" y="-125.2" font-family="Helvetica,sans-Serif" font-size="11.00">client_classification_cv_id</text>
<polygon fill="#ffffff" stroke="transparent" points="385.5,-95 385.5,-117 578.5,-117 578.5,-95 385.5,-95"/>
<polygon fill="none" stroke="black" points="385.5,-95 385.5,-117 578.5,-117 578.5,-95 385.5,-95"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="390.5" y="-112"/>
<text text-anchor="start" x="405.5" y="-103.2" font-family="Helvetica,sans-Serif" font-size="11.00">reject_reason_cv_id</text>
<polygon fill="#ffffff" stroke="transparent" points="385.5,-73 385.5,-95 578.5,-95 578.5,-73 385.5,-73"/>
<polygon fill="none" stroke="black" points="385.5,-73 385.5,-95 578.5,-95 578.5,-73 385.5,-73"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="390.5" y="-90"/>
<text text-anchor="start" x="405.5" y="-81.2" font-family="Helvetica,sans-Serif" font-size="11.00">withdraw_reason_cv_id</text>
<polygon fill="none" stroke="black" points="385.5,-55 385.5,-73 578.5,-73 578.5,-55 385.5,-55"/>
<text text-anchor="start" x="388.5" y="-61.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="385.5,-37 385.5,-55 462.5,-55 462.5,-37 385.5,-37"/>
<polygon fill="none" stroke="black" points="385.5,-37 385.5,-55 462.5,-55 462.5,-37 385.5,-37"/>
<text text-anchor="start" x="388.5" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 13</text>
<polygon fill="#ffffff" stroke="transparent" points="462.5,-37 462.5,-55 525.5,-55 525.5,-37 462.5,-37"/>
<polygon fill="none" stroke="black" points="462.5,-37 462.5,-55 525.5,-55 525.5,-37 462.5,-37"/>
<text text-anchor="start" x="489.5" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="525.5,-37 525.5,-55 578.5,-55 578.5,-37 525.5,-37"/>
<polygon fill="none" stroke="black" points="525.5,-37 525.5,-55 578.5,-55 578.5,-37 525.5,-37"/>
<text text-anchor="start" x="553.5" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">23 &gt;</text>
</a>
</g>
</g>
<!-- m_survey_scorecards&#45;&gt;m_client -->
<g id="edge3" class="edge">
<title>m_survey_scorecards:w&#45;&gt;m_client:e</title>
<path fill="none" stroke="black" d="M625.61,-698.15C588.03,-658.96 635.14,-436 579.5,-436"/>
<polygon fill="black" stroke="black" points="631.67,-700.8 637.56,-707.3 635.33,-702.4 639,-704 639,-704 639,-704 635.33,-702.4 640.44,-700.7 631.67,-700.8 631.67,-700.8"/>
<ellipse fill="none" stroke="black" cx="628.74" cy="-699.52" rx="3.2" ry="3.2"/>
</g>
<!-- m_appuser -->
<g id="node6" class="node">
<title>m_appuser</title>
<g id="a_node6"><a xlink:href="../../tables/m_appuser.html" xlink:title="m_appuser" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="374,-490 374,-658 589,-658 589,-490 374,-490"/>
<polygon fill="#f5f5f5" stroke="transparent" points="374.5,-636 374.5,-658 589.5,-658 589.5,-636 374.5,-636"/>
<polygon fill="none" stroke="black" points="374.5,-636 374.5,-658 589.5,-658 589.5,-636 374.5,-636"/>
<text text-anchor="start" x="379.5" y="-645.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_appuser</text>
<text text-anchor="start" x="554.5" y="-644.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="374.5,-614 374.5,-636 589.5,-636 589.5,-614 374.5,-614"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="379.5" y="-631"/>
<text text-anchor="start" x="394.5" y="-622.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="#ffffff" stroke="transparent" points="374.5,-592 374.5,-614 589.5,-614 589.5,-592 374.5,-592"/>
<polygon fill="none" stroke="black" points="374.5,-592 374.5,-614 589.5,-614 589.5,-592 374.5,-592"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="379.5" y="-609"/>
<text text-anchor="start" x="394.5" y="-600.2" font-family="Helvetica,sans-Serif" font-size="11.00">office_id</text>
<polygon fill="#ffffff" stroke="transparent" points="374.5,-570 374.5,-592 589.5,-592 589.5,-570 374.5,-570"/>
<polygon fill="none" stroke="black" points="374.5,-570 374.5,-592 589.5,-592 589.5,-570 374.5,-570"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="379.5" y="-587"/>
<text text-anchor="start" x="394.5" y="-578.2" font-family="Helvetica,sans-Serif" font-size="11.00">staff_id</text>
<polygon fill="#ffffff" stroke="transparent" points="374.5,-548 374.5,-570 589.5,-570 589.5,-548 374.5,-548"/>
<polygon fill="none" stroke="black" points="374.5,-548 374.5,-570 589.5,-570 589.5,-548 374.5,-548"/>
<text text-anchor="start" x="394.5" y="-556.2" font-family="Helvetica,sans-Serif" font-size="11.00">username</text>
<polygon fill="#ffffff" stroke="transparent" points="374.5,-526 374.5,-548 589.5,-548 589.5,-526 374.5,-526"/>
<polygon fill="none" stroke="black" points="374.5,-526 374.5,-548 589.5,-548 589.5,-526 374.5,-526"/>
<text text-anchor="start" x="394.5" y="-534.2" font-family="Helvetica,sans-Serif" font-size="11.00">last_time_password_updated</text>
<polygon fill="none" stroke="black" points="374.5,-508 374.5,-526 589.5,-526 589.5,-508 374.5,-508"/>
<text text-anchor="start" x="377.5" y="-514.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="374.5,-490 374.5,-508 459.5,-508 459.5,-490 374.5,-490"/>
<polygon fill="none" stroke="black" points="374.5,-490 374.5,-508 459.5,-508 459.5,-490 374.5,-490"/>
<text text-anchor="start" x="377.5" y="-496.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 2</text>
<polygon fill="#ffffff" stroke="transparent" points="459.5,-490 459.5,-508 529.5,-508 529.5,-490 459.5,-490"/>
<polygon fill="none" stroke="black" points="459.5,-490 459.5,-508 529.5,-508 529.5,-490 459.5,-490"/>
<text text-anchor="start" x="493.5" y="-496.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="529.5,-490 529.5,-508 589.5,-508 589.5,-490 529.5,-490"/>
<polygon fill="none" stroke="black" points="529.5,-490 529.5,-508 589.5,-508 589.5,-490 529.5,-490"/>
<text text-anchor="start" x="564.5" y="-496.2" font-family="Helvetica,sans-Serif" font-size="11.00">57 &gt;</text>
</a>
</g>
</g>
<!-- m_survey_scorecards&#45;&gt;m_appuser -->
<g id="edge7" class="edge">
<title>m_survey_scorecards:w&#45;&gt;m_appuser:e</title>
<path fill="none" stroke="black" d="M624.99,-721.92C600.1,-703.02 634.27,-625 590.5,-625"/>
<polygon fill="black" stroke="black" points="631.32,-723.76 637.99,-729.46 635.16,-724.88 639,-726 639,-726 639,-726 635.16,-724.88 640.01,-722.54 631.32,-723.76 631.32,-723.76"/>
<ellipse fill="none" stroke="black" cx="628.25" cy="-722.87" rx="3.2" ry="3.2"/>
</g>
</g>
</svg>