docs/database/diagrams/tables/m_surveys.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="658pt" height="451pt"
 viewBox="0.00 0.00 658.00 451.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 447)">
<title>oneDegreeRelationshipsDiagram</title>
<polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-447 654,-447 654,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_components -->
<g id="node1" class="node">
<title>m_survey_components</title>
<g id="a_node1"><a xlink:href="../../tables/m_survey_components.html" xlink:title="m_survey_components" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="250.5,-337 250.5,-439 423.5,-439 423.5,-337 250.5,-337"/>
<polygon fill="#f5f5f5" stroke="transparent" points="251,-417 251,-439 424,-439 424,-417 251,-417"/>
<polygon fill="none" stroke="black" points="251,-417 251,-439 424,-439 424,-417 251,-417"/>
<text text-anchor="start" x="256" y="-426.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_survey_components</text>
<text text-anchor="start" x="389" y="-425.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="251,-395 251,-417 424,-417 424,-395 251,-395"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="256" y="-412"/>
<text text-anchor="start" x="271" y="-403.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="#ffffff" stroke="transparent" points="251,-373 251,-395 424,-395 424,-373 251,-373"/>
<polygon fill="none" stroke="black" points="251,-373 251,-395 424,-395 424,-373 251,-373"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="256" y="-390"/>
<text text-anchor="start" x="271" y="-381.2" font-family="Helvetica,sans-Serif" font-size="11.00">survey_id</text>
<polygon fill="none" stroke="black" points="251,-355 251,-373 424,-373 424,-355 251,-355"/>
<text text-anchor="start" x="254" y="-361.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="251,-337 251,-355 322,-355 322,-337 251,-337"/>
<polygon fill="none" stroke="black" points="251,-337 251,-355 322,-355 322,-337 251,-337"/>
<text text-anchor="start" x="254" y="-343.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 1</text>
<polygon fill="#ffffff" stroke="transparent" points="322,-337 322,-355 386,-355 386,-337 322,-337"/>
<polygon fill="none" stroke="black" points="322,-337 322,-355 386,-355 386,-337 322,-337"/>
<text text-anchor="start" x="350" y="-343.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="386,-337 386,-355 424,-355 424,-337 386,-337"/>
<polygon fill="none" stroke="black" points="386,-337 386,-355 424,-355 424,-337 386,-337"/>
<text text-anchor="start" x="414" y="-343.2" font-family="Helvetica,sans-Serif" font-size="11.00"> &#160;</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,-62 8,-260 196,-260 196,-62 8,-62"/>
<polygon fill="#f5f5f5" stroke="transparent" points="10,-236 10,-258 194,-258 194,-236 10,-236"/>
<polygon fill="none" stroke="black" points="10,-236 10,-258 194,-258 194,-236 10,-236"/>
<text text-anchor="start" x="15" y="-245.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_surveys</text>
<text text-anchor="start" x="159" y="-244.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="10,-214 10,-236 121,-236 121,-214 10,-214"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="15" y="-231"/>
<text text-anchor="start" x="30" y="-222.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="none" stroke="black" points="121,-214 121,-236 194,-236 194,-214 121,-214"/>
<text text-anchor="start" x="124" y="-222.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="none" stroke="black" points="10,-192 10,-214 121,-214 121,-192 10,-192"/>
<text text-anchor="start" x="30" y="-200.2" font-family="Helvetica,sans-Serif" font-size="11.00">a_key</text>
<polygon fill="none" stroke="black" points="121,-192 121,-214 194,-214 194,-192 121,-192"/>
<text text-anchor="start" x="124" y="-200.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[32]</text>
<polygon fill="none" stroke="black" points="10,-170 10,-192 121,-192 121,-170 10,-170"/>
<text text-anchor="start" x="30" y="-178.2" font-family="Helvetica,sans-Serif" font-size="11.00">a_name</text>
<polygon fill="none" stroke="black" points="121,-170 121,-192 194,-192 194,-170 121,-170"/>
<text text-anchor="start" x="124" y="-178.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[255]</text>
<polygon fill="none" stroke="black" points="10,-148 10,-170 121,-170 121,-148 10,-148"/>
<text text-anchor="start" x="30" y="-156.2" font-family="Helvetica,sans-Serif" font-size="11.00">description</text>
<polygon fill="none" stroke="black" points="121,-148 121,-170 194,-170 194,-148 121,-148"/>
<text text-anchor="start" x="124" y="-156.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[4000]</text>
<polygon fill="none" stroke="black" points="10,-126 10,-148 121,-148 121,-126 10,-126"/>
<text text-anchor="start" x="30" y="-134.2" font-family="Helvetica,sans-Serif" font-size="11.00">country_code</text>
<polygon fill="none" stroke="black" points="121,-126 121,-148 194,-148 194,-126 121,-126"/>
<text text-anchor="start" x="124" y="-134.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[2]</text>
<polygon fill="none" stroke="black" points="10,-104 10,-126 121,-126 121,-104 10,-104"/>
<text text-anchor="start" x="30" y="-112.2" font-family="Helvetica,sans-Serif" font-size="11.00">valid_from</text>
<polygon fill="none" stroke="black" points="121,-104 121,-126 194,-126 194,-104 121,-104"/>
<text text-anchor="start" x="124" y="-112.2" font-family="Helvetica,sans-Serif" font-size="11.00">datetime[19]</text>
<polygon fill="none" stroke="black" points="10,-82 10,-104 121,-104 121,-82 10,-82"/>
<text text-anchor="start" x="30" y="-90.2" font-family="Helvetica,sans-Serif" font-size="11.00">valid_to</text>
<polygon fill="none" stroke="black" points="121,-82 121,-104 194,-104 194,-82 121,-82"/>
<text text-anchor="start" x="124" y="-90.2" font-family="Helvetica,sans-Serif" font-size="11.00">datetime[19]</text>
<polygon fill="#ffffff" stroke="transparent" points="10,-64 10,-82 57,-82 57,-64 10,-64"/>
<polygon fill="none" stroke="black" points="10,-64 10,-82 57,-82 57,-64 10,-64"/>
<text text-anchor="start" x="13" y="-70.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 0</text>
<polygon fill="#ffffff" stroke="transparent" points="57,-64 57,-82 121,-82 121,-64 57,-64"/>
<polygon fill="none" stroke="black" points="57,-64 57,-82 121,-82 121,-64 57,-64"/>
<text text-anchor="start" x="85" y="-70.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="121,-64 121,-82 194,-82 194,-64 121,-64"/>
<polygon fill="none" stroke="black" points="121,-64 121,-82 194,-82 194,-64 121,-64"/>
<text text-anchor="start" x="175" y="-70.2" font-family="Helvetica,sans-Serif" font-size="11.00">4 &gt;</text>
<polygon fill="none" stroke="black" stroke-width="2" points="9,-63 9,-259 195,-259 195,-63 9,-63"/>
</a>
</g>
</g>
<!-- m_survey_components&#45;&gt;m_surveys -->
<g id="edge1" class="edge">
<title>m_survey_components:w&#45;&gt;m_surveys:e</title>
<path fill="none" stroke="black" d="M235.71,-381.37C188.65,-360.7 264.08,-225 195,-225"/>
<polygon fill="black" stroke="black" points="242.13,-382.55 249.35,-387.54 246.07,-383.28 250,-384 250,-384 250,-384 246.07,-383.28 250.65,-380.46 242.13,-382.55 242.13,-382.55"/>
<ellipse fill="none" stroke="black" cx="238.98" cy="-381.97" rx="3.2" ry="3.2"/>
</g>
<!-- m_survey_lookup_tables -->
<g id="node3" class="node">
<title>m_survey_lookup_tables</title>
<g id="a_node3"><a xlink:href="../../tables/m_survey_lookup_tables.html" xlink:title="m_survey_lookup_tables" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="245,-214 245,-316 429,-316 429,-214 245,-214"/>
<polygon fill="#f5f5f5" stroke="transparent" points="245,-294 245,-316 429,-316 429,-294 245,-294"/>
<polygon fill="none" stroke="black" points="245,-294 245,-316 429,-316 429,-294 245,-294"/>
<text text-anchor="start" x="250" y="-303.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_survey_lookup_tables</text>
<text text-anchor="start" x="394" y="-302.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="245,-272 245,-294 429,-294 429,-272 245,-272"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="250" y="-289"/>
<text text-anchor="start" x="265" y="-280.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="#ffffff" stroke="transparent" points="245,-250 245,-272 429,-272 429,-250 245,-250"/>
<polygon fill="none" stroke="black" points="245,-250 245,-272 429,-272 429,-250 245,-250"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="250" y="-267"/>
<text text-anchor="start" x="265" y="-258.2" font-family="Helvetica,sans-Serif" font-size="11.00">survey_id</text>
<polygon fill="none" stroke="black" points="245,-232 245,-250 429,-250 429,-232 245,-232"/>
<text text-anchor="start" x="248" y="-238.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="245,-214 245,-232 322,-232 322,-214 245,-214"/>
<polygon fill="none" stroke="black" points="245,-214 245,-232 322,-232 322,-214 245,-214"/>
<text text-anchor="start" x="248" y="-220.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 1</text>
<polygon fill="#ffffff" stroke="transparent" points="322,-214 322,-232 388,-232 388,-214 322,-214"/>
<polygon fill="none" stroke="black" points="322,-214 322,-232 388,-232 388,-214 322,-214"/>
<text text-anchor="start" x="352" y="-220.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="388,-214 388,-232 429,-232 429,-214 388,-214"/>
<polygon fill="none" stroke="black" points="388,-214 388,-232 429,-232 429,-214 388,-214"/>
<text text-anchor="start" x="419" y="-220.2" font-family="Helvetica,sans-Serif" font-size="11.00"> &#160;</text>
</a>
</g>
</g>
<!-- m_survey_lookup_tables&#45;&gt;m_surveys -->
<g id="edge2" class="edge">
<title>m_survey_lookup_tables:w&#45;&gt;m_surveys:e</title>
<path fill="none" stroke="black" d="M230.2,-256.59C217.65,-246.97 216.11,-225 195,-225"/>
<polygon fill="black" stroke="black" points="236.38,-258.56 242.9,-264.43 240.19,-259.78 244,-261 244,-261 244,-261 240.19,-259.78 245.1,-257.57 236.38,-258.56 236.38,-258.56"/>
<ellipse fill="none" stroke="black" cx="233.33" cy="-257.59" rx="3.2" ry="3.2"/>
</g>
<!-- m_survey_questions -->
<g id="node4" class="node">
<title>m_survey_questions</title>
<g id="a_node4"><a xlink:href="../../tables/m_survey_questions.html" xlink:title="m_survey_questions" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="258.5,-64 258.5,-166 415.5,-166 415.5,-64 258.5,-64"/>
<polygon fill="#f5f5f5" stroke="transparent" points="259,-144 259,-166 416,-166 416,-144 259,-144"/>
<polygon fill="none" stroke="black" points="259,-144 259,-166 416,-166 416,-144 259,-144"/>
<text text-anchor="start" x="264" y="-153.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_survey_questions</text>
<text text-anchor="start" x="381" y="-152.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="259,-122 259,-144 416,-144 416,-122 259,-122"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="264" y="-139"/>
<text text-anchor="start" x="279" y="-130.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="#ffffff" stroke="transparent" points="259,-100 259,-122 416,-122 416,-100 259,-100"/>
<polygon fill="none" stroke="black" points="259,-100 259,-122 416,-122 416,-100 259,-100"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="264" y="-117"/>
<text text-anchor="start" x="279" y="-108.2" font-family="Helvetica,sans-Serif" font-size="11.00">survey_id</text>
<polygon fill="none" stroke="black" points="259,-82 259,-100 416,-100 416,-82 259,-82"/>
<text text-anchor="start" x="262" y="-88.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="259,-64 259,-82 318,-82 318,-64 259,-64"/>
<polygon fill="none" stroke="black" points="259,-64 259,-82 318,-82 318,-64 259,-64"/>
<text text-anchor="start" x="262" y="-70.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 1</text>
<polygon fill="#ffffff" stroke="transparent" points="318,-64 318,-82 375,-82 375,-64 318,-64"/>
<polygon fill="none" stroke="black" points="318,-64 318,-82 375,-82 375,-64 318,-64"/>
<text text-anchor="start" x="339" y="-70.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="375,-64 375,-82 416,-82 416,-64 375,-64"/>
<polygon fill="none" stroke="black" points="375,-64 375,-82 416,-82 416,-64 375,-64"/>
<text text-anchor="start" x="397" y="-70.2" font-family="Helvetica,sans-Serif" font-size="11.00">2 &gt;</text>
</a>
</g>
</g>
<!-- m_survey_questions&#45;&gt;m_surveys -->
<g id="edge3" class="edge">
<title>m_survey_questions:w&#45;&gt;m_surveys:e</title>
<path fill="none" stroke="black" d="M243.55,-114.29C209.69,-132.98 247.01,-225 195,-225"/>
<polygon fill="black" stroke="black" points="250.2,-112.78 258.8,-114.51 254.1,-111.89 258,-111 258,-111 258,-111 254.1,-111.89 257.2,-107.49 250.2,-112.78 250.2,-112.78"/>
<ellipse fill="none" stroke="black" cx="247.08" cy="-113.49" rx="3.2" ry="3.2"/>
</g>
<!-- m_survey_scorecards -->
<g id="node5" class="node">
<title>m_survey_scorecards</title>
<g id="a_node5"><a xlink:href="../../tables/m_survey_scorecards.html" xlink:title="m_survey_scorecards" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="478,-37 478,-227 642,-227 642,-37 478,-37"/>
<polygon fill="#f5f5f5" stroke="transparent" points="478,-205 478,-227 642,-227 642,-205 478,-205"/>
<polygon fill="none" stroke="black" points="478,-205 478,-227 642,-227 642,-205 478,-205"/>
<text text-anchor="start" x="483" y="-214.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_survey_scorecards</text>
<text text-anchor="start" x="607" y="-213.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="478,-183 478,-205 642,-205 642,-183 478,-183"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="483" y="-200"/>
<text text-anchor="start" x="498" y="-191.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="#ffffff" stroke="transparent" points="478,-161 478,-183 642,-183 642,-161 478,-161"/>
<polygon fill="none" stroke="black" points="478,-161 478,-183 642,-183 642,-161 478,-161"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="483" y="-178"/>
<text text-anchor="start" x="498" y="-169.2" font-family="Helvetica,sans-Serif" font-size="11.00">survey_id</text>
<polygon fill="#ffffff" stroke="transparent" points="478,-139 478,-161 642,-161 642,-139 478,-139"/>
<polygon fill="none" stroke="black" points="478,-139 478,-161 642,-161 642,-139 478,-139"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="483" y="-156"/>
<text text-anchor="start" x="498" y="-147.2" font-family="Helvetica,sans-Serif" font-size="11.00">question_id</text>
<polygon fill="#ffffff" stroke="transparent" points="478,-117 478,-139 642,-139 642,-117 478,-117"/>
<polygon fill="none" stroke="black" points="478,-117 478,-139 642,-139 642,-117 478,-117"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="483" y="-134"/>
<text text-anchor="start" x="498" y="-125.2" font-family="Helvetica,sans-Serif" font-size="11.00">response_id</text>
<polygon fill="#ffffff" stroke="transparent" points="478,-95 478,-117 642,-117 642,-95 478,-95"/>
<polygon fill="none" stroke="black" points="478,-95 478,-117 642,-117 642,-95 478,-95"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="483" y="-112"/>
<text text-anchor="start" x="498" y="-103.2" font-family="Helvetica,sans-Serif" font-size="11.00">user_id</text>
<polygon fill="#ffffff" stroke="transparent" points="478,-73 478,-95 642,-95 642,-73 478,-73"/>
<polygon fill="none" stroke="black" points="478,-73 478,-95 642,-95 642,-73 478,-73"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="483" y="-90"/>
<text text-anchor="start" x="498" y="-81.2" font-family="Helvetica,sans-Serif" font-size="11.00">client_id</text>
<polygon fill="none" stroke="black" points="478,-55 478,-73 642,-73 642,-55 478,-55"/>
<text text-anchor="start" x="481" y="-61.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="478,-37 478,-55 545,-55 545,-37 478,-37"/>
<polygon fill="none" stroke="black" points="478,-37 478,-55 545,-55 545,-37 478,-37"/>
<text text-anchor="start" x="481" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 5</text>
<polygon fill="#ffffff" stroke="transparent" points="545,-37 545,-55 606,-55 606,-37 545,-37"/>
<polygon fill="none" stroke="black" points="545,-37 545,-55 606,-55 606,-37 545,-37"/>
<text text-anchor="start" x="570" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="606,-37 606,-55 642,-55 642,-37 606,-37"/>
<polygon fill="none" stroke="black" points="606,-37 606,-55 642,-55 642,-37 606,-37"/>
<text text-anchor="start" x="632" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00"> &#160;</text>
</a>
</g>
</g>
<!-- m_survey_scorecards&#45;&gt;m_surveys -->
<g id="edge5" class="edge">
<title>m_survey_scorecards:w&#45;&gt;m_surveys:e</title>
<path fill="none" stroke="black" d="M462.51,-173.76C410.97,-180.34 239.75,-203.16 237,-204 217.05,-210.13 215.87,-225 195,-225"/>
<polygon fill="black" stroke="black" points="469.06,-172.96 477.43,-175.57 473.03,-172.48 477,-172 477,-172 477,-172 473.03,-172.48 476.57,-168.43 469.06,-172.96 469.06,-172.96"/>
<ellipse fill="none" stroke="black" cx="465.88" cy="-173.35" rx="3.2" ry="3.2"/>
</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="M462.59,-148.18C446.47,-143.8 439.09,-133 417,-133"/>
<polygon fill="black" stroke="black" points="469.06,-149 476.55,-153.57 473.03,-149.5 477,-150 477,-150 477,-150 473.03,-149.5 477.45,-146.43 469.06,-149 469.06,-149"/>
<ellipse fill="none" stroke="black" cx="465.89" cy="-148.6" rx="3.2" ry="3.2"/>
</g>
</g>
</svg>