docs/database/diagrams/tables/m_survey_lookup_tables.2degrees.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: twoDegreesRelationshipsDiagram Pages: 1 -->
<svg width="648pt" height="432pt"
 viewBox="0.00 0.00 648.00 432.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 428)">
<title>twoDegreesRelationshipsDiagram</title>
<polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-428 644,-428 644,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="212,-362 212,-420 379,-420 379,-362 212,-362"/>
<polygon fill="#f5f5f5" stroke="transparent" points="212.5,-398 212.5,-420 379.5,-420 379.5,-398 212.5,-398"/>
<polygon fill="none" stroke="black" points="212.5,-398 212.5,-420 379.5,-420 379.5,-398 212.5,-398"/>
<text text-anchor="start" x="217.5" y="-407.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_survey_components</text>
<text text-anchor="start" x="344.5" y="-406.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="212.5,-380 212.5,-398 379.5,-398 379.5,-380 212.5,-380"/>
<text text-anchor="start" x="215.5" y="-386.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="212.5,-362 212.5,-380 280.5,-380 280.5,-362 212.5,-362"/>
<polygon fill="none" stroke="black" points="212.5,-362 212.5,-380 280.5,-380 280.5,-362 212.5,-362"/>
<text text-anchor="start" x="215.5" y="-368.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 1</text>
<polygon fill="#ffffff" stroke="transparent" points="280.5,-362 280.5,-380 342.5,-380 342.5,-362 280.5,-362"/>
<polygon fill="none" stroke="black" points="280.5,-362 280.5,-380 342.5,-380 342.5,-362 280.5,-362"/>
<text text-anchor="start" x="306.5" y="-368.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="342.5,-362 342.5,-380 379.5,-380 379.5,-362 342.5,-362"/>
<polygon fill="none" stroke="black" points="342.5,-362 342.5,-380 379.5,-380 379.5,-362 342.5,-362"/>
<text text-anchor="start" x="369.5" y="-368.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,-154 8,-234 119,-234 119,-154 8,-154"/>
<polygon fill="#f5f5f5" stroke="transparent" points="8.5,-212 8.5,-234 119.5,-234 119.5,-212 8.5,-212"/>
<polygon fill="none" stroke="black" points="8.5,-212 8.5,-234 119.5,-234 119.5,-212 8.5,-212"/>
<text text-anchor="start" x="13.5" y="-221.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_surveys</text>
<text text-anchor="start" x="84.5" y="-220.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="8.5,-190 8.5,-212 119.5,-212 119.5,-190 8.5,-190"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-207"/>
<text text-anchor="start" x="28.5" y="-198.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="none" stroke="black" points="8.5,-172 8.5,-190 119.5,-190 119.5,-172 8.5,-172"/>
<text text-anchor="start" x="11.5" y="-178.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="8.5,-154 8.5,-172 39.5,-172 39.5,-154 8.5,-154"/>
<polygon fill="none" stroke="black" points="8.5,-154 8.5,-172 39.5,-172 39.5,-154 8.5,-154"/>
<text text-anchor="start" x="11.5" y="-160.2" font-family="Helvetica,sans-Serif" font-size="11.00"> &#160;</text>
<polygon fill="#ffffff" stroke="transparent" points="39.5,-154 39.5,-172 87.5,-172 87.5,-154 39.5,-154"/>
<polygon fill="none" stroke="black" points="39.5,-154 39.5,-172 87.5,-172 87.5,-154 39.5,-154"/>
<text text-anchor="start" x="51.5" y="-160.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="87.5,-154 87.5,-172 119.5,-172 119.5,-154 87.5,-154"/>
<polygon fill="none" stroke="black" points="87.5,-154 87.5,-172 119.5,-172 119.5,-154 87.5,-154"/>
<text text-anchor="start" x="100.5" y="-160.2" font-family="Helvetica,sans-Serif" font-size="11.00">4 &gt;</text>
</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="M197.15,-387.46C180.11,-383.26 172.84,-370.69 160,-352 120.73,-294.82 189.87,-201 120.5,-201"/>
<polygon fill="black" stroke="black" points="203.55,-388.14 211.11,-392.58 207.52,-388.57 211.5,-389 211.5,-389 211.5,-389 207.52,-388.57 211.89,-385.42 203.55,-388.14 203.55,-388.14"/>
<ellipse fill="none" stroke="black" cx="200.36" cy="-387.8" 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="168,-143 168,-341 423,-341 423,-143 168,-143"/>
<polygon fill="#f5f5f5" stroke="transparent" points="170.5,-317 170.5,-339 421.5,-339 421.5,-317 170.5,-317"/>
<polygon fill="none" stroke="black" points="170.5,-317 170.5,-339 421.5,-339 421.5,-317 170.5,-317"/>
<text text-anchor="start" x="175.5" y="-326.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_survey_lookup_tables</text>
<text text-anchor="start" x="386.5" y="-325.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="170.5,-295 170.5,-317 354.5,-317 354.5,-295 170.5,-295"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="175.5" y="-312"/>
<text text-anchor="start" x="190.5" y="-303.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="none" stroke="black" points="354.5,-295 354.5,-317 421.5,-317 421.5,-295 354.5,-295"/>
<text text-anchor="start" x="357.5" y="-303.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="#ffffff" stroke="transparent" points="170.5,-273 170.5,-295 354.5,-295 354.5,-273 170.5,-273"/>
<polygon fill="none" stroke="black" points="170.5,-273 170.5,-295 354.5,-295 354.5,-273 170.5,-273"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="175.5" y="-290"/>
<text text-anchor="start" x="190.5" y="-281.2" font-family="Helvetica,sans-Serif" font-size="11.00">survey_id</text>
<polygon fill="none" stroke="black" points="354.5,-273 354.5,-295 421.5,-295 421.5,-273 354.5,-273"/>
<text text-anchor="start" x="357.5" y="-281.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="none" stroke="black" points="170.5,-251 170.5,-273 354.5,-273 354.5,-251 170.5,-251"/>
<text text-anchor="start" x="190.5" y="-259.2" font-family="Helvetica,sans-Serif" font-size="11.00">a_key</text>
<polygon fill="none" stroke="black" points="354.5,-251 354.5,-273 421.5,-273 421.5,-251 354.5,-251"/>
<text text-anchor="start" x="357.5" y="-259.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[255]</text>
<polygon fill="none" stroke="black" points="170.5,-229 170.5,-251 354.5,-251 354.5,-229 170.5,-229"/>
<text text-anchor="start" x="190.5" y="-237.2" font-family="Helvetica,sans-Serif" font-size="11.00">description</text>
<polygon fill="none" stroke="black" points="354.5,-229 354.5,-251 421.5,-251 421.5,-229 354.5,-229"/>
<text text-anchor="start" x="357.5" y="-237.2" font-family="Helvetica,sans-Serif" font-size="11.00">int[10]</text>
<polygon fill="none" stroke="black" points="170.5,-207 170.5,-229 354.5,-229 354.5,-207 170.5,-207"/>
<text text-anchor="start" x="190.5" y="-215.2" font-family="Helvetica,sans-Serif" font-size="11.00">value_from</text>
<polygon fill="none" stroke="black" points="354.5,-207 354.5,-229 421.5,-229 421.5,-207 354.5,-207"/>
<text text-anchor="start" x="357.5" y="-215.2" font-family="Helvetica,sans-Serif" font-size="11.00">int[10]</text>
<polygon fill="none" stroke="black" points="170.5,-185 170.5,-207 354.5,-207 354.5,-185 170.5,-185"/>
<text text-anchor="start" x="190.5" y="-193.2" font-family="Helvetica,sans-Serif" font-size="11.00">value_to</text>
<polygon fill="none" stroke="black" points="354.5,-185 354.5,-207 421.5,-207 421.5,-185 354.5,-185"/>
<text text-anchor="start" x="357.5" y="-193.2" font-family="Helvetica,sans-Serif" font-size="11.00">int[10]</text>
<polygon fill="none" stroke="black" points="170.5,-163 170.5,-185 354.5,-185 354.5,-163 170.5,-163"/>
<text text-anchor="start" x="190.5" y="-171.2" font-family="Helvetica,sans-Serif" font-size="11.00">score</text>
<polygon fill="none" stroke="black" points="354.5,-163 354.5,-185 421.5,-185 421.5,-163 354.5,-163"/>
<text text-anchor="start" x="357.5" y="-171.2" font-family="Helvetica,sans-Serif" font-size="11.00">decimal[5,2]</text>
<polygon fill="#ffffff" stroke="transparent" points="170.5,-145 170.5,-163 253.5,-163 253.5,-145 170.5,-145"/>
<polygon fill="none" stroke="black" points="170.5,-145 170.5,-163 253.5,-163 253.5,-145 170.5,-145"/>
<text text-anchor="start" x="173.5" y="-151.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 1</text>
<polygon fill="#ffffff" stroke="transparent" points="253.5,-145 253.5,-163 354.5,-163 354.5,-145 253.5,-145"/>
<polygon fill="none" stroke="black" points="253.5,-145 253.5,-163 354.5,-163 354.5,-145 253.5,-145"/>
<text text-anchor="start" x="318.5" y="-151.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="354.5,-145 354.5,-163 421.5,-163 421.5,-145 354.5,-145"/>
<polygon fill="none" stroke="black" points="354.5,-145 354.5,-163 421.5,-163 421.5,-145 354.5,-145"/>
<text text-anchor="start" x="402.5" y="-151.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 &gt;</text>
<polygon fill="none" stroke="black" stroke-width="2" points="169,-144 169,-340 422,-340 422,-144 169,-144"/>
</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="M155.7,-279.54C135.4,-262.3 157.31,-201 120.5,-201"/>
<polygon fill="black" stroke="black" points="161.89,-281.54 168.39,-287.43 165.69,-282.77 169.5,-284 169.5,-284 169.5,-284 165.69,-282.77 170.61,-280.57 161.89,-281.54 161.89,-281.54"/>
<ellipse fill="none" stroke="black" cx="158.84" cy="-280.55" 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="219,-37 219,-95 372,-95 372,-37 219,-37"/>
<polygon fill="#f5f5f5" stroke="transparent" points="219.5,-73 219.5,-95 372.5,-95 372.5,-73 219.5,-73"/>
<polygon fill="none" stroke="black" points="219.5,-73 219.5,-95 372.5,-95 372.5,-73 219.5,-73"/>
<text text-anchor="start" x="224.5" y="-82.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_survey_questions</text>
<text text-anchor="start" x="337.5" y="-81.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="219.5,-55 219.5,-73 372.5,-73 372.5,-55 219.5,-55"/>
<text text-anchor="start" x="222.5" y="-61.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="219.5,-37 219.5,-55 276.5,-55 276.5,-37 219.5,-37"/>
<polygon fill="none" stroke="black" points="219.5,-37 219.5,-55 276.5,-55 276.5,-37 219.5,-37"/>
<text text-anchor="start" x="222.5" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 1</text>
<polygon fill="#ffffff" stroke="transparent" points="276.5,-37 276.5,-55 332.5,-55 332.5,-37 276.5,-37"/>
<polygon fill="none" stroke="black" points="276.5,-37 276.5,-55 332.5,-55 332.5,-37 276.5,-37"/>
<text text-anchor="start" x="296.5" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="332.5,-37 332.5,-55 372.5,-55 372.5,-37 332.5,-37"/>
<polygon fill="none" stroke="black" points="332.5,-37 332.5,-55 372.5,-55 372.5,-37 332.5,-37"/>
<text text-anchor="start" x="353.5" y="-43.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="M204.08,-65.56C183.41,-70.61 176.74,-87.44 160,-109 132.71,-144.14 165,-201 120.5,-201"/>
<polygon fill="black" stroke="black" points="210.55,-64.86 218.89,-67.58 214.52,-64.43 218.5,-64 218.5,-64 218.5,-64 214.52,-64.43 218.11,-60.42 210.55,-64.86 210.55,-64.86"/>
<ellipse fill="none" stroke="black" cx="207.36" cy="-65.2" 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="472,-64 472,-122 632,-122 632,-64 472,-64"/>
<polygon fill="#f5f5f5" stroke="transparent" points="472,-100 472,-122 632,-122 632,-100 472,-100"/>
<polygon fill="none" stroke="black" points="472,-100 472,-122 632,-122 632,-100 472,-100"/>
<text text-anchor="start" x="477" y="-109.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_survey_scorecards</text>
<text text-anchor="start" x="597" y="-108.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="472,-82 472,-100 632,-100 632,-82 472,-82"/>
<text text-anchor="start" x="475" y="-88.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="472,-64 472,-82 537,-82 537,-64 472,-64"/>
<polygon fill="none" stroke="black" points="472,-64 472,-82 537,-82 537,-64 472,-64"/>
<text text-anchor="start" x="475" y="-70.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 5</text>
<polygon fill="#ffffff" stroke="transparent" points="537,-64 537,-82 597,-82 597,-64 537,-64"/>
<polygon fill="none" stroke="black" points="537,-64 537,-82 597,-82 597,-64 537,-64"/>
<text text-anchor="start" x="561" y="-70.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="597,-64 597,-82 632,-82 632,-64 597,-64"/>
<polygon fill="none" stroke="black" points="597,-64 597,-82 632,-82 632,-64 597,-64"/>
<text text-anchor="start" x="622" y="-70.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="M456.8,-93.53C448.78,-96.74 443.49,-102.21 431,-105 371.91,-118.2 210.85,-100.14 160,-133 130.65,-151.97 155.45,-201 120.5,-201"/>
<polygon fill="black" stroke="black" points="463.12,-92.4 471.63,-94.54 467.06,-91.7 471,-91 471,-91 471,-91 467.06,-91.7 470.37,-87.46 463.12,-92.4 463.12,-92.4"/>
<ellipse fill="none" stroke="black" cx="459.97" cy="-92.96" 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="M456.61,-89.97C423.75,-85.04 413.19,-64 373.5,-64"/>
<polygon fill="black" stroke="black" points="463.02,-90.43 470.74,-94.59 467.01,-90.72 471,-91 471,-91 471,-91 467.01,-90.72 471.26,-87.41 463.02,-90.43 463.02,-90.43"/>
<ellipse fill="none" stroke="black" cx="459.83" cy="-90.2" rx="3.2" ry="3.2"/>
</g>
</g>
</svg>