docs/database/diagrams/tables/m_survey_questions.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="839pt" height="321pt"
 viewBox="0.00 0.00 839.00 321.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 317)">
<title>oneDegreeRelationshipsDiagram</title>
<polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-317 835,-317 835,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,-37 168,-235 402,-235 402,-37 168,-37"/>
<polygon fill="#f5f5f5" stroke="transparent" points="170,-211 170,-233 400,-233 400,-211 170,-211"/>
<polygon fill="none" stroke="black" points="170,-211 170,-233 400,-233 400,-211 170,-211"/>
<text text-anchor="start" x="175" y="-220.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_survey_questions</text>
<text text-anchor="start" x="365" y="-219.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="170,-189 170,-211 327,-211 327,-189 170,-189"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="175" y="-206"/>
<text text-anchor="start" x="190" y="-197.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="none" stroke="black" points="327,-189 327,-211 400,-211 400,-189 327,-189"/>
<text text-anchor="start" x="330" y="-197.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="#ffffff" stroke="transparent" points="170,-167 170,-189 327,-189 327,-167 170,-167"/>
<polygon fill="none" stroke="black" points="170,-167 170,-189 327,-189 327,-167 170,-167"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="175" y="-184"/>
<text text-anchor="start" x="190" y="-175.2" font-family="Helvetica,sans-Serif" font-size="11.00">survey_id</text>
<polygon fill="none" stroke="black" points="327,-167 327,-189 400,-189 400,-167 327,-167"/>
<text text-anchor="start" x="330" y="-175.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="none" stroke="black" points="170,-145 170,-167 327,-167 327,-145 170,-145"/>
<text text-anchor="start" x="190" y="-153.2" font-family="Helvetica,sans-Serif" font-size="11.00">component_key</text>
<polygon fill="none" stroke="black" points="327,-145 327,-167 400,-167 400,-145 327,-145"/>
<text text-anchor="start" x="330" y="-153.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[32]</text>
<polygon fill="none" stroke="black" points="170,-123 170,-145 327,-145 327,-123 170,-123"/>
<text text-anchor="start" x="190" y="-131.2" font-family="Helvetica,sans-Serif" font-size="11.00">a_key</text>
<polygon fill="none" stroke="black" points="327,-123 327,-145 400,-145 400,-123 327,-123"/>
<text text-anchor="start" x="330" y="-131.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[32]</text>
<polygon fill="none" stroke="black" points="170,-101 170,-123 327,-123 327,-101 170,-101"/>
<text text-anchor="start" x="190" y="-109.2" font-family="Helvetica,sans-Serif" font-size="11.00">a_text</text>
<polygon fill="none" stroke="black" points="327,-101 327,-123 400,-123 400,-101 327,-101"/>
<text text-anchor="start" x="330" y="-109.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[255]</text>
<polygon fill="none" stroke="black" points="170,-79 170,-101 327,-101 327,-79 170,-79"/>
<text text-anchor="start" x="190" y="-87.2" font-family="Helvetica,sans-Serif" font-size="11.00">description</text>
<polygon fill="none" stroke="black" points="327,-79 327,-101 400,-101 400,-79 327,-79"/>
<text text-anchor="start" x="330" y="-87.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[4000]</text>
<polygon fill="none" stroke="black" points="170,-57 170,-79 327,-79 327,-57 170,-57"/>
<text text-anchor="start" x="190" y="-65.2" font-family="Helvetica,sans-Serif" font-size="11.00">sequence_no</text>
<polygon fill="none" stroke="black" points="327,-57 327,-79 400,-79 400,-57 327,-57"/>
<text text-anchor="start" x="330" y="-65.2" font-family="Helvetica,sans-Serif" font-size="11.00">int[10]</text>
<polygon fill="#ffffff" stroke="transparent" points="170,-39 170,-57 240,-57 240,-39 170,-39"/>
<polygon fill="none" stroke="black" points="170,-39 170,-57 240,-57 240,-39 170,-39"/>
<text text-anchor="start" x="173" y="-45.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 1</text>
<polygon fill="#ffffff" stroke="transparent" points="240,-39 240,-57 327,-57 327,-39 240,-39"/>
<polygon fill="none" stroke="black" points="240,-39 240,-57 327,-57 327,-39 240,-39"/>
<text text-anchor="start" x="291" y="-45.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="327,-39 327,-57 400,-57 400,-39 327,-39"/>
<polygon fill="none" stroke="black" points="327,-39 327,-57 400,-57 400,-39 327,-39"/>
<text text-anchor="start" x="381" y="-45.2" font-family="Helvetica,sans-Serif" font-size="11.00">2 &gt;</text>
<polygon fill="none" stroke="black" stroke-width="2" points="169,-38 169,-234 401,-234 401,-38 169,-38"/>
</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,-171 8,-251 119,-251 119,-171 8,-171"/>
<polygon fill="#f5f5f5" stroke="transparent" points="8.5,-229 8.5,-251 119.5,-251 119.5,-229 8.5,-229"/>
<polygon fill="none" stroke="black" points="8.5,-229 8.5,-251 119.5,-251 119.5,-229 8.5,-229"/>
<text text-anchor="start" x="13.5" y="-238.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_surveys</text>
<text text-anchor="start" x="84.5" y="-237.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="8.5,-207 8.5,-229 119.5,-229 119.5,-207 8.5,-207"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-224"/>
<text text-anchor="start" x="28.5" y="-215.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="none" stroke="black" points="8.5,-189 8.5,-207 119.5,-207 119.5,-189 8.5,-189"/>
<text text-anchor="start" x="11.5" y="-195.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="8.5,-171 8.5,-189 39.5,-189 39.5,-171 8.5,-171"/>
<polygon fill="none" stroke="black" points="8.5,-171 8.5,-189 39.5,-189 39.5,-171 8.5,-171"/>
<text text-anchor="start" x="11.5" y="-177.2" font-family="Helvetica,sans-Serif" font-size="11.00"> &#160;</text>
<polygon fill="#ffffff" stroke="transparent" points="39.5,-171 39.5,-189 87.5,-189 87.5,-171 39.5,-171"/>
<polygon fill="none" stroke="black" points="39.5,-171 39.5,-189 87.5,-189 87.5,-171 39.5,-171"/>
<text text-anchor="start" x="51.5" y="-177.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="87.5,-171 87.5,-189 119.5,-189 119.5,-171 87.5,-171"/>
<polygon fill="none" stroke="black" points="87.5,-171 87.5,-189 119.5,-189 119.5,-171 87.5,-171"/>
<text text-anchor="start" x="100.5" y="-177.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="M155,-182.9C142.6,-193.59 142.33,-218 120.5,-218"/>
<polygon fill="black" stroke="black" points="161.45,-180.64 170.19,-181.4 165.22,-179.32 169,-178 169,-178 169,-178 165.22,-179.32 167.81,-174.6 161.45,-180.64 161.45,-180.64"/>
<ellipse fill="none" stroke="black" cx="158.43" cy="-181.7" 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="451,-106 451,-208 610,-208 610,-106 451,-106"/>
<polygon fill="#f5f5f5" stroke="transparent" points="451.5,-186 451.5,-208 610.5,-208 610.5,-186 451.5,-186"/>
<polygon fill="none" stroke="black" points="451.5,-186 451.5,-208 610.5,-208 610.5,-186 451.5,-186"/>
<text text-anchor="start" x="456.5" y="-195.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_survey_responses</text>
<text text-anchor="start" x="575.5" y="-194.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="451.5,-164 451.5,-186 610.5,-186 610.5,-164 451.5,-164"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="456.5" y="-181"/>
<text text-anchor="start" x="471.5" y="-172.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="#ffffff" stroke="transparent" points="451.5,-142 451.5,-164 610.5,-164 610.5,-142 451.5,-142"/>
<polygon fill="none" stroke="black" points="451.5,-142 451.5,-164 610.5,-164 610.5,-142 451.5,-142"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="456.5" y="-159"/>
<text text-anchor="start" x="471.5" y="-150.2" font-family="Helvetica,sans-Serif" font-size="11.00">question_id</text>
<polygon fill="none" stroke="black" points="451.5,-124 451.5,-142 610.5,-142 610.5,-124 451.5,-124"/>
<text text-anchor="start" x="454.5" y="-130.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="451.5,-106 451.5,-124 511.5,-124 511.5,-106 451.5,-106"/>
<polygon fill="none" stroke="black" points="451.5,-106 451.5,-124 511.5,-124 511.5,-106 451.5,-106"/>
<text text-anchor="start" x="454.5" y="-112.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 1</text>
<polygon fill="#ffffff" stroke="transparent" points="511.5,-106 511.5,-124 569.5,-124 569.5,-106 511.5,-106"/>
<polygon fill="none" stroke="black" points="511.5,-106 511.5,-124 569.5,-124 569.5,-106 511.5,-106"/>
<text text-anchor="start" x="533.5" y="-112.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="569.5,-106 569.5,-124 610.5,-124 610.5,-106 569.5,-106"/>
<polygon fill="none" stroke="black" points="569.5,-106 569.5,-124 610.5,-124 610.5,-106 569.5,-106"/>
<text text-anchor="start" x="591.5" y="-112.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="M436.86,-157.68C422.94,-169.57 425.41,-200 401,-200"/>
<polygon fill="black" stroke="black" points="442.93,-155.59 451.67,-156.41 446.72,-154.3 450.5,-153 450.5,-153 450.5,-153 446.72,-154.3 449.33,-149.59 442.93,-155.59 442.93,-155.59"/>
<ellipse fill="none" stroke="black" cx="439.91" cy="-156.63" 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="659,-119 659,-309 823,-309 823,-119 659,-119"/>
<polygon fill="#f5f5f5" stroke="transparent" points="659,-287 659,-309 823,-309 823,-287 659,-287"/>
<polygon fill="none" stroke="black" points="659,-287 659,-309 823,-309 823,-287 659,-287"/>
<text text-anchor="start" x="664" y="-296.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_survey_scorecards</text>
<text text-anchor="start" x="788" y="-295.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="659,-265 659,-287 823,-287 823,-265 659,-265"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="664" y="-282"/>
<text text-anchor="start" x="679" y="-273.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="#ffffff" stroke="transparent" points="659,-243 659,-265 823,-265 823,-243 659,-243"/>
<polygon fill="none" stroke="black" points="659,-243 659,-265 823,-265 823,-243 659,-243"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="664" y="-260"/>
<text text-anchor="start" x="679" y="-251.2" font-family="Helvetica,sans-Serif" font-size="11.00">survey_id</text>
<polygon fill="#ffffff" stroke="transparent" points="659,-221 659,-243 823,-243 823,-221 659,-221"/>
<polygon fill="none" stroke="black" points="659,-221 659,-243 823,-243 823,-221 659,-221"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="664" y="-238"/>
<text text-anchor="start" x="679" y="-229.2" font-family="Helvetica,sans-Serif" font-size="11.00">question_id</text>
<polygon fill="#ffffff" stroke="transparent" points="659,-199 659,-221 823,-221 823,-199 659,-199"/>
<polygon fill="none" stroke="black" points="659,-199 659,-221 823,-221 823,-199 659,-199"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="664" y="-216"/>
<text text-anchor="start" x="679" y="-207.2" font-family="Helvetica,sans-Serif" font-size="11.00">response_id</text>
<polygon fill="#ffffff" stroke="transparent" points="659,-177 659,-199 823,-199 823,-177 659,-177"/>
<polygon fill="none" stroke="black" points="659,-177 659,-199 823,-199 823,-177 659,-177"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="664" y="-194"/>
<text text-anchor="start" x="679" y="-185.2" font-family="Helvetica,sans-Serif" font-size="11.00">user_id</text>
<polygon fill="#ffffff" stroke="transparent" points="659,-155 659,-177 823,-177 823,-155 659,-155"/>
<polygon fill="none" stroke="black" points="659,-155 659,-177 823,-177 823,-155 659,-155"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="664" y="-172"/>
<text text-anchor="start" x="679" y="-163.2" font-family="Helvetica,sans-Serif" font-size="11.00">client_id</text>
<polygon fill="none" stroke="black" points="659,-137 659,-155 823,-155 823,-137 659,-137"/>
<text text-anchor="start" x="662" y="-143.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="659,-119 659,-137 726,-137 726,-119 659,-119"/>
<polygon fill="none" stroke="black" points="659,-119 659,-137 726,-137 726,-119 659,-119"/>
<text text-anchor="start" x="662" y="-125.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 5</text>
<polygon fill="#ffffff" stroke="transparent" points="726,-119 726,-137 787,-137 787,-119 726,-119"/>
<polygon fill="none" stroke="black" points="726,-119 726,-137 787,-137 787,-119 726,-119"/>
<text text-anchor="start" x="751" y="-125.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="787,-119 787,-137 823,-137 823,-119 787,-119"/>
<polygon fill="none" stroke="black" points="787,-119 787,-137 823,-137 823,-119 787,-119"/>
<text text-anchor="start" x="813" y="-125.2" font-family="Helvetica,sans-Serif" font-size="11.00"> &#160;</text>
</a>
</g>
</g>
<!-- m_survey_scorecards&#45;&gt;m_survey_questions -->
<g id="edge3" class="edge">
<title>m_survey_scorecards:w&#45;&gt;m_survey_questions:e</title>
<path fill="none" stroke="black" d="M643.41,-232.08C559.31,-232.96 531.03,-240.79 443,-219 423.11,-214.08 421.49,-200 401,-200"/>
<polygon fill="black" stroke="black" points="650,-232.04 658.02,-235.6 654,-232.02 658,-232 658,-232 658,-232 654,-232.02 657.98,-228.4 650,-232.04 650,-232.04"/>
<ellipse fill="none" stroke="black" cx="646.8" cy="-232.06" rx="3.2" ry="3.2"/>
</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="M643.32,-254.09C433.59,-256.67 365.65,-313.32 160,-246 139.55,-239.31 142.02,-218 120.5,-218"/>
<polygon fill="black" stroke="black" points="650,-254.05 658.02,-257.6 654,-254.02 658,-254 658,-254 658,-254 654,-254.02 657.98,-250.4 650,-254.05 650,-254.05"/>
<ellipse fill="none" stroke="black" cx="646.8" cy="-254.07" rx="3.2" ry="3.2"/>
</g>
<!-- m_survey_scorecards&#45;&gt;m_survey_responses -->
<g id="edge4" class="edge">
<title>m_survey_scorecards:w&#45;&gt;m_survey_responses:e</title>
<path fill="none" stroke="black" d="M644.14,-205.13C632.88,-195.52 631.3,-175 611.5,-175"/>
<polygon fill="black" stroke="black" points="650.45,-207.35 656.81,-213.4 654.23,-208.68 658,-210 658,-210 658,-210 654.23,-208.68 659.19,-206.6 650.45,-207.35 650.45,-207.35"/>
<ellipse fill="none" stroke="black" cx="647.43" cy="-206.29" rx="3.2" ry="3.2"/>
</g>
</g>
</svg>