| <?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="673pt" height="285pt" |
| viewBox="0.00 0.00 673.00 285.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 281)"> |
| <title>oneDegreeRelationshipsDiagram</title> |
| <polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-281 669,-281 669,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_responses --> |
| <g id="node1" class="node"> |
| <title>m_survey_responses</title> |
| <g id="a_node1"><a xlink:href="../../tables/m_survey_responses.html" xlink:title="m_survey_responses" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="214,-37 214,-191 444,-191 444,-37 214,-37"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="216,-167 216,-189 442,-189 442,-167 216,-167"/> |
| <polygon fill="none" stroke="black" points="216,-167 216,-189 442,-189 442,-167 216,-167"/> |
| <text text-anchor="start" x="221" y="-176.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_survey_responses</text> |
| <text text-anchor="start" x="407" y="-175.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="216,-145 216,-167 375,-167 375,-145 216,-145"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="221" y="-162"/> |
| <text text-anchor="start" x="236" y="-153.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="none" stroke="black" points="375,-145 375,-167 442,-167 442,-145 375,-145"/> |
| <text text-anchor="start" x="378" y="-153.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="216,-123 216,-145 375,-145 375,-123 216,-123"/> |
| <polygon fill="none" stroke="black" points="216,-123 216,-145 375,-145 375,-123 216,-123"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="221" y="-140"/> |
| <text text-anchor="start" x="236" y="-131.2" font-family="Helvetica,sans-Serif" font-size="11.00">question_id</text> |
| <polygon fill="none" stroke="black" points="375,-123 375,-145 442,-145 442,-123 375,-123"/> |
| <text text-anchor="start" x="378" y="-131.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="none" stroke="black" points="216,-101 216,-123 375,-123 375,-101 216,-101"/> |
| <text text-anchor="start" x="236" y="-109.2" font-family="Helvetica,sans-Serif" font-size="11.00">a_text</text> |
| <polygon fill="none" stroke="black" points="375,-101 375,-123 442,-123 442,-101 375,-101"/> |
| <text text-anchor="start" x="378" y="-109.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[255]</text> |
| <polygon fill="none" stroke="black" points="216,-79 216,-101 375,-101 375,-79 216,-79"/> |
| <text text-anchor="start" x="236" y="-87.2" font-family="Helvetica,sans-Serif" font-size="11.00">a_value</text> |
| <polygon fill="none" stroke="black" points="375,-79 375,-101 442,-101 442,-79 375,-79"/> |
| <text text-anchor="start" x="378" y="-87.2" font-family="Helvetica,sans-Serif" font-size="11.00">int[10]</text> |
| <polygon fill="none" stroke="black" points="216,-57 216,-79 375,-79 375,-57 216,-57"/> |
| <text text-anchor="start" x="236" y="-65.2" font-family="Helvetica,sans-Serif" font-size="11.00">sequence_no</text> |
| <polygon fill="none" stroke="black" points="375,-57 375,-79 442,-79 442,-57 375,-57"/> |
| <text text-anchor="start" x="378" y="-65.2" font-family="Helvetica,sans-Serif" font-size="11.00">int[10]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="216,-39 216,-57 287,-57 287,-39 216,-39"/> |
| <polygon fill="none" stroke="black" points="216,-39 216,-57 287,-57 287,-39 216,-39"/> |
| <text text-anchor="start" x="219" y="-45.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 1</text> |
| <polygon fill="#ffffff" stroke="transparent" points="287,-39 287,-57 375,-57 375,-39 287,-39"/> |
| <polygon fill="none" stroke="black" points="287,-39 287,-57 375,-57 375,-39 287,-39"/> |
| <text text-anchor="start" x="339" y="-45.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="375,-39 375,-57 442,-57 442,-39 375,-39"/> |
| <polygon fill="none" stroke="black" points="375,-39 375,-57 442,-57 442,-39 375,-39"/> |
| <text text-anchor="start" x="423" y="-45.2" font-family="Helvetica,sans-Serif" font-size="11.00">1 ></text> |
| <polygon fill="none" stroke="black" stroke-width="2" points="215,-38 215,-190 443,-190 443,-38 215,-38"/> |
| </a> |
| </g> |
| </g> |
| <!-- m_survey_questions --> |
| <g id="node2" class="node"> |
| <title>m_survey_questions</title> |
| <g id="a_node2"><a xlink:href="../../tables/m_survey_questions.html" xlink:title="m_survey_questions" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="8,-105 8,-207 165,-207 165,-105 8,-105"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="8.5,-185 8.5,-207 165.5,-207 165.5,-185 8.5,-185"/> |
| <polygon fill="none" stroke="black" points="8.5,-185 8.5,-207 165.5,-207 165.5,-185 8.5,-185"/> |
| <text text-anchor="start" x="13.5" y="-194.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_survey_questions</text> |
| <text text-anchor="start" x="130.5" y="-193.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="8.5,-163 8.5,-185 165.5,-185 165.5,-163 8.5,-163"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-180"/> |
| <text text-anchor="start" x="28.5" y="-171.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-141 8.5,-163 165.5,-163 165.5,-141 8.5,-141"/> |
| <polygon fill="none" stroke="black" points="8.5,-141 8.5,-163 165.5,-163 165.5,-141 8.5,-141"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-158"/> |
| <text text-anchor="start" x="28.5" y="-149.2" font-family="Helvetica,sans-Serif" font-size="11.00">survey_id</text> |
| <polygon fill="none" stroke="black" points="8.5,-123 8.5,-141 165.5,-141 165.5,-123 8.5,-123"/> |
| <text text-anchor="start" x="11.5" y="-129.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-105 8.5,-123 67.5,-123 67.5,-105 8.5,-105"/> |
| <polygon fill="none" stroke="black" points="8.5,-105 8.5,-123 67.5,-123 67.5,-105 8.5,-105"/> |
| <text text-anchor="start" x="11.5" y="-111.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 1</text> |
| <polygon fill="#ffffff" stroke="transparent" points="67.5,-105 67.5,-123 124.5,-123 124.5,-105 67.5,-105"/> |
| <polygon fill="none" stroke="black" points="67.5,-105 67.5,-123 124.5,-123 124.5,-105 67.5,-105"/> |
| <text text-anchor="start" x="88.5" y="-111.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="124.5,-105 124.5,-123 165.5,-123 165.5,-105 124.5,-105"/> |
| <polygon fill="none" stroke="black" points="124.5,-105 124.5,-123 165.5,-123 165.5,-105 124.5,-105"/> |
| <text text-anchor="start" x="146.5" y="-111.2" font-family="Helvetica,sans-Serif" font-size="11.00">2 ></text> |
| </a> |
| </g> |
| </g> |
| <!-- m_survey_responses->m_survey_questions --> |
| <g id="edge1" class="edge"> |
| <title>m_survey_responses:w->m_survey_questions:e</title> |
| <path fill="none" stroke="black" d="M201,-138.9C188.6,-149.59 188.33,-174 166.5,-174"/> |
| <polygon fill="black" stroke="black" points="207.45,-136.64 216.19,-137.4 211.22,-135.32 215,-134 215,-134 215,-134 211.22,-135.32 213.81,-130.6 207.45,-136.64 207.45,-136.64"/> |
| <ellipse fill="none" stroke="black" cx="204.43" cy="-137.7" rx="3.2" ry="3.2"/> |
| </g> |
| <!-- m_survey_scorecards --> |
| <g id="node3" class="node"> |
| <title>m_survey_scorecards</title> |
| <g id="a_node3"><a xlink:href="../../tables/m_survey_scorecards.html" xlink:title="m_survey_scorecards" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="493,-83 493,-273 657,-273 657,-83 493,-83"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="493,-251 493,-273 657,-273 657,-251 493,-251"/> |
| <polygon fill="none" stroke="black" points="493,-251 493,-273 657,-273 657,-251 493,-251"/> |
| <text text-anchor="start" x="498" y="-260.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_survey_scorecards</text> |
| <text text-anchor="start" x="622" y="-259.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="493,-229 493,-251 657,-251 657,-229 493,-229"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="498" y="-246"/> |
| <text text-anchor="start" x="513" y="-237.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="493,-207 493,-229 657,-229 657,-207 493,-207"/> |
| <polygon fill="none" stroke="black" points="493,-207 493,-229 657,-229 657,-207 493,-207"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="498" y="-224"/> |
| <text text-anchor="start" x="513" y="-215.2" font-family="Helvetica,sans-Serif" font-size="11.00">survey_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="493,-185 493,-207 657,-207 657,-185 493,-185"/> |
| <polygon fill="none" stroke="black" points="493,-185 493,-207 657,-207 657,-185 493,-185"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="498" y="-202"/> |
| <text text-anchor="start" x="513" y="-193.2" font-family="Helvetica,sans-Serif" font-size="11.00">question_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="493,-163 493,-185 657,-185 657,-163 493,-163"/> |
| <polygon fill="none" stroke="black" points="493,-163 493,-185 657,-185 657,-163 493,-163"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="498" y="-180"/> |
| <text text-anchor="start" x="513" y="-171.2" font-family="Helvetica,sans-Serif" font-size="11.00">response_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="493,-141 493,-163 657,-163 657,-141 493,-141"/> |
| <polygon fill="none" stroke="black" points="493,-141 493,-163 657,-163 657,-141 493,-141"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="498" y="-158"/> |
| <text text-anchor="start" x="513" y="-149.2" font-family="Helvetica,sans-Serif" font-size="11.00">user_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="493,-119 493,-141 657,-141 657,-119 493,-119"/> |
| <polygon fill="none" stroke="black" points="493,-119 493,-141 657,-141 657,-119 493,-119"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="498" y="-136"/> |
| <text text-anchor="start" x="513" y="-127.2" font-family="Helvetica,sans-Serif" font-size="11.00">client_id</text> |
| <polygon fill="none" stroke="black" points="493,-101 493,-119 657,-119 657,-101 493,-101"/> |
| <text text-anchor="start" x="496" y="-107.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="493,-83 493,-101 560,-101 560,-83 493,-83"/> |
| <polygon fill="none" stroke="black" points="493,-83 493,-101 560,-101 560,-83 493,-83"/> |
| <text text-anchor="start" x="496" y="-89.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 5</text> |
| <polygon fill="#ffffff" stroke="transparent" points="560,-83 560,-101 621,-101 621,-83 560,-83"/> |
| <polygon fill="none" stroke="black" points="560,-83 560,-101 621,-101 621,-83 560,-83"/> |
| <text text-anchor="start" x="585" y="-89.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="621,-83 621,-101 657,-101 657,-83 621,-83"/> |
| <polygon fill="none" stroke="black" points="621,-83 621,-101 657,-101 657,-83 621,-83"/> |
| <text text-anchor="start" x="647" y="-89.2" font-family="Helvetica,sans-Serif" font-size="11.00">  </text> |
| </a> |
| </g> |
| </g> |
| <!-- m_survey_scorecards->m_survey_responses --> |
| <g id="edge3" class="edge"> |
| <title>m_survey_scorecards:w->m_survey_responses:e</title> |
| <path fill="none" stroke="black" d="M477.82,-171.19C466.21,-166.12 460.4,-156 443,-156"/> |
| <polygon fill="black" stroke="black" points="484.15,-172.44 491.3,-177.53 488.08,-173.22 492,-174 492,-174 492,-174 488.08,-173.22 492.7,-170.47 484.15,-172.44 484.15,-172.44"/> |
| <ellipse fill="none" stroke="black" cx="481.01" cy="-171.82" rx="3.2" ry="3.2"/> |
| </g> |
| <!-- m_survey_scorecards->m_survey_questions --> |
| <g id="edge2" class="edge"> |
| <title>m_survey_scorecards:w->m_survey_questions:e</title> |
| <path fill="none" stroke="black" d="M477.53,-197.28C469.71,-198.76 463.9,-201.11 452,-202 342.97,-210.13 310.18,-235.18 206,-202 185.5,-195.47 188.02,-174 166.5,-174"/> |
| <polygon fill="black" stroke="black" points="484.03,-196.7 492.32,-199.59 488.02,-196.35 492,-196 492,-196 492,-196 488.02,-196.35 491.68,-192.41 484.03,-196.7 484.03,-196.7"/> |
| <ellipse fill="none" stroke="black" cx="480.84" cy="-196.98" rx="3.2" ry="3.2"/> |
| </g> |
| </g> |
| </svg> |
