| <?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="643pt" height="410pt" |
| viewBox="0.00 0.00 643.00 410.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 406)"> |
| <title>twoDegreesRelationshipsDiagram</title> |
| <polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-406 639,-406 639,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="168,-222 168,-398 418,-398 418,-222 168,-222"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="170,-374 170,-396 416,-396 416,-374 170,-374"/> |
| <polygon fill="none" stroke="black" points="170,-374 170,-396 416,-396 416,-374 170,-374"/> |
| <text text-anchor="start" x="175" y="-383.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_survey_components</text> |
| <text text-anchor="start" x="381" y="-382.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="170,-352 170,-374 343,-374 343,-352 170,-352"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="175" y="-369"/> |
| <text text-anchor="start" x="190" y="-360.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="none" stroke="black" points="343,-352 343,-374 416,-374 416,-352 343,-352"/> |
| <text text-anchor="start" x="346" y="-360.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="170,-330 170,-352 343,-352 343,-330 170,-330"/> |
| <polygon fill="none" stroke="black" points="170,-330 170,-352 343,-352 343,-330 170,-330"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="175" y="-347"/> |
| <text text-anchor="start" x="190" y="-338.2" font-family="Helvetica,sans-Serif" font-size="11.00">survey_id</text> |
| <polygon fill="none" stroke="black" points="343,-330 343,-352 416,-352 416,-330 343,-330"/> |
| <text text-anchor="start" x="346" y="-338.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="none" stroke="black" points="170,-308 170,-330 343,-330 343,-308 170,-308"/> |
| <text text-anchor="start" x="190" y="-316.2" font-family="Helvetica,sans-Serif" font-size="11.00">a_key</text> |
| <polygon fill="none" stroke="black" points="343,-308 343,-330 416,-330 416,-308 343,-308"/> |
| <text text-anchor="start" x="346" y="-316.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[32]</text> |
| <polygon fill="none" stroke="black" points="170,-286 170,-308 343,-308 343,-286 170,-286"/> |
| <text text-anchor="start" x="190" y="-294.2" font-family="Helvetica,sans-Serif" font-size="11.00">a_text</text> |
| <polygon fill="none" stroke="black" points="343,-286 343,-308 416,-308 416,-286 343,-286"/> |
| <text text-anchor="start" x="346" y="-294.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[255]</text> |
| <polygon fill="none" stroke="black" points="170,-264 170,-286 343,-286 343,-264 170,-264"/> |
| <text text-anchor="start" x="190" y="-272.2" font-family="Helvetica,sans-Serif" font-size="11.00">description</text> |
| <polygon fill="none" stroke="black" points="343,-264 343,-286 416,-286 416,-264 343,-264"/> |
| <text text-anchor="start" x="346" y="-272.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[4000]</text> |
| <polygon fill="none" stroke="black" points="170,-242 170,-264 343,-264 343,-242 170,-242"/> |
| <text text-anchor="start" x="190" y="-250.2" font-family="Helvetica,sans-Serif" font-size="11.00">sequence_no</text> |
| <polygon fill="none" stroke="black" points="343,-242 343,-264 416,-264 416,-242 343,-242"/> |
| <text text-anchor="start" x="346" y="-250.2" font-family="Helvetica,sans-Serif" font-size="11.00">int[10]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="170,-224 170,-242 248,-242 248,-224 170,-224"/> |
| <polygon fill="none" stroke="black" points="170,-224 170,-242 248,-242 248,-224 170,-224"/> |
| <text text-anchor="start" x="173" y="-230.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 1</text> |
| <polygon fill="#ffffff" stroke="transparent" points="248,-224 248,-242 343,-242 343,-224 248,-224"/> |
| <polygon fill="none" stroke="black" points="248,-224 248,-242 343,-242 343,-224 248,-224"/> |
| <text text-anchor="start" x="307" y="-230.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="343,-224 343,-242 416,-242 416,-224 343,-224"/> |
| <polygon fill="none" stroke="black" points="343,-224 343,-242 416,-242 416,-224 343,-224"/> |
| <text text-anchor="start" x="397" y="-230.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 ></text> |
| <polygon fill="none" stroke="black" stroke-width="2" points="169,-223 169,-397 417,-397 417,-223 169,-223"/> |
| </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,-97 8,-177 119,-177 119,-97 8,-97"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="8.5,-155 8.5,-177 119.5,-177 119.5,-155 8.5,-155"/> |
| <polygon fill="none" stroke="black" points="8.5,-155 8.5,-177 119.5,-177 119.5,-155 8.5,-155"/> |
| <text text-anchor="start" x="13.5" y="-164.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_surveys</text> |
| <text text-anchor="start" x="84.5" y="-163.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="8.5,-133 8.5,-155 119.5,-155 119.5,-133 8.5,-133"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-150"/> |
| <text text-anchor="start" x="28.5" y="-141.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="none" stroke="black" points="8.5,-115 8.5,-133 119.5,-133 119.5,-115 8.5,-115"/> |
| <text text-anchor="start" x="11.5" y="-121.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-97 8.5,-115 39.5,-115 39.5,-97 8.5,-97"/> |
| <polygon fill="none" stroke="black" points="8.5,-97 8.5,-115 39.5,-115 39.5,-97 8.5,-97"/> |
| <text text-anchor="start" x="11.5" y="-103.2" font-family="Helvetica,sans-Serif" font-size="11.00">  </text> |
| <polygon fill="#ffffff" stroke="transparent" points="39.5,-97 39.5,-115 87.5,-115 87.5,-97 39.5,-97"/> |
| <polygon fill="none" stroke="black" points="39.5,-97 39.5,-115 87.5,-115 87.5,-97 39.5,-97"/> |
| <text text-anchor="start" x="51.5" y="-103.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="87.5,-97 87.5,-115 119.5,-115 119.5,-97 87.5,-97"/> |
| <polygon fill="none" stroke="black" points="87.5,-97 87.5,-115 119.5,-115 119.5,-97 87.5,-97"/> |
| <text text-anchor="start" x="100.5" y="-103.2" font-family="Helvetica,sans-Serif" font-size="11.00">4 ></text> |
| </a> |
| </g> |
| </g> |
| <!-- m_survey_components->m_surveys --> |
| <g id="edge1" class="edge"> |
| <title>m_survey_components:w->m_surveys:e</title> |
| <path fill="none" stroke="black" d="M154.59,-338.79C94.44,-317.14 205.03,-144 120.5,-144"/> |
| <polygon fill="black" stroke="black" points="161.09,-339.79 168.45,-344.56 165.05,-340.39 169,-341 169,-341 169,-341 165.05,-340.39 169.55,-337.44 161.09,-339.79 161.09,-339.79"/> |
| <ellipse fill="none" stroke="black" cx="157.93" cy="-339.3" 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="205.5,-143 205.5,-201 380.5,-201 380.5,-143 205.5,-143"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="206,-179 206,-201 381,-201 381,-179 206,-179"/> |
| <polygon fill="none" stroke="black" points="206,-179 206,-201 381,-201 381,-179 206,-179"/> |
| <text text-anchor="start" x="211" y="-188.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_survey_lookup_tables</text> |
| <text text-anchor="start" x="346" y="-187.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="206,-161 206,-179 381,-179 381,-161 206,-161"/> |
| <text text-anchor="start" x="209" y="-167.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="206,-143 206,-161 278,-161 278,-143 206,-143"/> |
| <polygon fill="none" stroke="black" points="206,-143 206,-161 278,-161 278,-143 206,-143"/> |
| <text text-anchor="start" x="209" y="-149.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 1</text> |
| <polygon fill="#ffffff" stroke="transparent" points="278,-143 278,-161 342,-161 342,-143 278,-143"/> |
| <polygon fill="none" stroke="black" points="278,-143 278,-161 342,-161 342,-143 278,-143"/> |
| <text text-anchor="start" x="306" y="-149.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="342,-143 342,-161 381,-161 381,-143 342,-143"/> |
| <polygon fill="none" stroke="black" points="342,-143 342,-161 381,-161 381,-143 342,-143"/> |
| <text text-anchor="start" x="371" y="-149.2" font-family="Helvetica,sans-Serif" font-size="11.00">  </text> |
| </a> |
| </g> |
| </g> |
| <!-- m_survey_lookup_tables->m_surveys --> |
| <g id="edge2" class="edge"> |
| <title>m_survey_lookup_tables:w->m_surveys:e</title> |
| <path fill="none" stroke="black" d="M190.58,-168.67C163.47,-163.38 154.42,-144 120.5,-144"/> |
| <polygon fill="black" stroke="black" points="197.03,-169.27 204.67,-173.58 201.02,-169.63 205,-170 205,-170 205,-170 201.02,-169.63 205.33,-166.42 197.03,-169.27 197.03,-169.27"/> |
| <ellipse fill="none" stroke="black" cx="193.85" cy="-168.97" 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="216.5,-37 216.5,-95 369.5,-95 369.5,-37 216.5,-37"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="217,-73 217,-95 370,-95 370,-73 217,-73"/> |
| <polygon fill="none" stroke="black" points="217,-73 217,-95 370,-95 370,-73 217,-73"/> |
| <text text-anchor="start" x="222" y="-82.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_survey_questions</text> |
| <text text-anchor="start" x="335" y="-81.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="217,-55 217,-73 370,-73 370,-55 217,-55"/> |
| <text text-anchor="start" x="220" y="-61.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="217,-37 217,-55 274,-55 274,-37 217,-37"/> |
| <polygon fill="none" stroke="black" points="217,-37 217,-55 274,-55 274,-37 217,-37"/> |
| <text text-anchor="start" x="220" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 1</text> |
| <polygon fill="#ffffff" stroke="transparent" points="274,-37 274,-55 330,-55 330,-37 274,-37"/> |
| <polygon fill="none" stroke="black" points="274,-37 274,-55 330,-55 330,-37 274,-37"/> |
| <text text-anchor="start" x="294" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="330,-37 330,-55 370,-55 370,-37 330,-37"/> |
| <polygon fill="none" stroke="black" points="330,-37 330,-55 370,-55 370,-37 330,-37"/> |
| <text text-anchor="start" x="351" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">2 ></text> |
| </a> |
| </g> |
| </g> |
| <!-- m_survey_questions->m_surveys --> |
| <g id="edge3" class="edge"> |
| <title>m_survey_questions:w->m_surveys:e</title> |
| <path fill="none" stroke="black" d="M201.58,-66.2C183.39,-72.65 180.02,-92.11 160,-109 142.08,-124.13 143.96,-144 120.5,-144"/> |
| <polygon fill="black" stroke="black" points="208.09,-65.21 216.54,-67.56 212.05,-64.6 216,-64 216,-64 216,-64 212.05,-64.6 215.46,-60.44 208.09,-65.21 208.09,-65.21"/> |
| <ellipse fill="none" stroke="black" cx="204.93" cy="-65.69" 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="467,-64 467,-122 627,-122 627,-64 467,-64"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="467,-100 467,-122 627,-122 627,-100 467,-100"/> |
| <polygon fill="none" stroke="black" points="467,-100 467,-122 627,-122 627,-100 467,-100"/> |
| <text text-anchor="start" x="472" y="-109.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_survey_scorecards</text> |
| <text text-anchor="start" x="592" y="-108.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="467,-82 467,-100 627,-100 627,-82 467,-82"/> |
| <text text-anchor="start" x="470" y="-88.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="467,-64 467,-82 532,-82 532,-64 467,-64"/> |
| <polygon fill="none" stroke="black" points="467,-64 467,-82 532,-82 532,-64 467,-64"/> |
| <text text-anchor="start" x="470" y="-70.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 5</text> |
| <polygon fill="#ffffff" stroke="transparent" points="532,-64 532,-82 592,-82 592,-64 532,-64"/> |
| <polygon fill="none" stroke="black" points="532,-64 532,-82 592,-82 592,-64 532,-64"/> |
| <text text-anchor="start" x="556" y="-70.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="592,-64 592,-82 627,-82 627,-64 592,-64"/> |
| <polygon fill="none" stroke="black" points="592,-64 592,-82 627,-82 627,-64 592,-64"/> |
| <text text-anchor="start" x="617" y="-70.2" font-family="Helvetica,sans-Serif" font-size="11.00">  </text> |
| </a> |
| </g> |
| </g> |
| <!-- m_survey_scorecards->m_surveys --> |
| <g id="edge5" class="edge"> |
| <title>m_survey_scorecards:w->m_surveys:e</title> |
| <path fill="none" stroke="black" d="M451.8,-93.53C443.78,-96.74 438.49,-102.2 426,-105 310.01,-131.03 276.78,-110.76 160,-133 142.1,-136.41 138.72,-144 120.5,-144"/> |
| <polygon fill="black" stroke="black" points="458.12,-92.4 466.63,-94.54 462.06,-91.7 466,-91 466,-91 466,-91 462.06,-91.7 465.37,-87.46 458.12,-92.4 458.12,-92.4"/> |
| <ellipse fill="none" stroke="black" cx="454.97" cy="-92.96" rx="3.2" ry="3.2"/> |
| </g> |
| <!-- m_survey_scorecards->m_survey_questions --> |
| <g id="edge4" class="edge"> |
| <title>m_survey_scorecards:w->m_survey_questions:e</title> |
| <path fill="none" stroke="black" d="M451.54,-89.91C419.82,-84.86 409.58,-64 371,-64"/> |
| <polygon fill="black" stroke="black" points="458.02,-90.4 465.73,-94.59 462.01,-90.7 466,-91 466,-91 466,-91 462.01,-90.7 466.27,-87.41 458.02,-90.4 458.02,-90.4"/> |
| <ellipse fill="none" stroke="black" cx="454.83" cy="-90.16" rx="3.2" ry="3.2"/> |
| </g> |
| </g> |
| </svg> |
