| <?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="439pt" height="247pt" |
| viewBox="0.00 0.00 439.00 247.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 243)"> |
| <title>oneDegreeRelationshipsDiagram</title> |
| <polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-243 435,-243 435,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_lookup_tables --> |
| <g id="node1" class="node"> |
| <title>m_survey_lookup_tables</title> |
| <g id="a_node1"><a xlink:href="../../tables/m_survey_lookup_tables.html" xlink:title="m_survey_lookup_tables" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="168,-37 168,-235 423,-235 423,-37 168,-37"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="170.5,-211 170.5,-233 421.5,-233 421.5,-211 170.5,-211"/> |
| <polygon fill="none" stroke="black" points="170.5,-211 170.5,-233 421.5,-233 421.5,-211 170.5,-211"/> |
| <text text-anchor="start" x="175.5" y="-220.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="-219.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="170.5,-189 170.5,-211 354.5,-211 354.5,-189 170.5,-189"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="175.5" y="-206"/> |
| <text text-anchor="start" x="190.5" y="-197.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="none" stroke="black" points="354.5,-189 354.5,-211 421.5,-211 421.5,-189 354.5,-189"/> |
| <text text-anchor="start" x="357.5" y="-197.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="170.5,-167 170.5,-189 354.5,-189 354.5,-167 170.5,-167"/> |
| <polygon fill="none" stroke="black" points="170.5,-167 170.5,-189 354.5,-189 354.5,-167 170.5,-167"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="175.5" y="-184"/> |
| <text text-anchor="start" x="190.5" y="-175.2" font-family="Helvetica,sans-Serif" font-size="11.00">survey_id</text> |
| <polygon fill="none" stroke="black" points="354.5,-167 354.5,-189 421.5,-189 421.5,-167 354.5,-167"/> |
| <text text-anchor="start" x="357.5" y="-175.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="none" stroke="black" points="170.5,-145 170.5,-167 354.5,-167 354.5,-145 170.5,-145"/> |
| <text text-anchor="start" x="190.5" y="-153.2" font-family="Helvetica,sans-Serif" font-size="11.00">a_key</text> |
| <polygon fill="none" stroke="black" points="354.5,-145 354.5,-167 421.5,-167 421.5,-145 354.5,-145"/> |
| <text text-anchor="start" x="357.5" y="-153.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[255]</text> |
| <polygon fill="none" stroke="black" points="170.5,-123 170.5,-145 354.5,-145 354.5,-123 170.5,-123"/> |
| <text text-anchor="start" x="190.5" y="-131.2" font-family="Helvetica,sans-Serif" font-size="11.00">description</text> |
| <polygon fill="none" stroke="black" points="354.5,-123 354.5,-145 421.5,-145 421.5,-123 354.5,-123"/> |
| <text text-anchor="start" x="357.5" y="-131.2" font-family="Helvetica,sans-Serif" font-size="11.00">int[10]</text> |
| <polygon fill="none" stroke="black" points="170.5,-101 170.5,-123 354.5,-123 354.5,-101 170.5,-101"/> |
| <text text-anchor="start" x="190.5" y="-109.2" font-family="Helvetica,sans-Serif" font-size="11.00">value_from</text> |
| <polygon fill="none" stroke="black" points="354.5,-101 354.5,-123 421.5,-123 421.5,-101 354.5,-101"/> |
| <text text-anchor="start" x="357.5" y="-109.2" font-family="Helvetica,sans-Serif" font-size="11.00">int[10]</text> |
| <polygon fill="none" stroke="black" points="170.5,-79 170.5,-101 354.5,-101 354.5,-79 170.5,-79"/> |
| <text text-anchor="start" x="190.5" y="-87.2" font-family="Helvetica,sans-Serif" font-size="11.00">value_to</text> |
| <polygon fill="none" stroke="black" points="354.5,-79 354.5,-101 421.5,-101 421.5,-79 354.5,-79"/> |
| <text text-anchor="start" x="357.5" y="-87.2" font-family="Helvetica,sans-Serif" font-size="11.00">int[10]</text> |
| <polygon fill="none" stroke="black" points="170.5,-57 170.5,-79 354.5,-79 354.5,-57 170.5,-57"/> |
| <text text-anchor="start" x="190.5" y="-65.2" font-family="Helvetica,sans-Serif" font-size="11.00">score</text> |
| <polygon fill="none" stroke="black" points="354.5,-57 354.5,-79 421.5,-79 421.5,-57 354.5,-57"/> |
| <text text-anchor="start" x="357.5" y="-65.2" font-family="Helvetica,sans-Serif" font-size="11.00">decimal[5,2]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="170.5,-39 170.5,-57 253.5,-57 253.5,-39 170.5,-39"/> |
| <polygon fill="none" stroke="black" points="170.5,-39 170.5,-57 253.5,-57 253.5,-39 170.5,-39"/> |
| <text text-anchor="start" x="173.5" y="-45.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 1</text> |
| <polygon fill="#ffffff" stroke="transparent" points="253.5,-39 253.5,-57 354.5,-57 354.5,-39 253.5,-39"/> |
| <polygon fill="none" stroke="black" points="253.5,-39 253.5,-57 354.5,-57 354.5,-39 253.5,-39"/> |
| <text text-anchor="start" x="318.5" y="-45.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="354.5,-39 354.5,-57 421.5,-57 421.5,-39 354.5,-39"/> |
| <polygon fill="none" stroke="black" points="354.5,-39 354.5,-57 421.5,-57 421.5,-39 354.5,-39"/> |
| <text text-anchor="start" x="402.5" y="-45.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 ></text> |
| <polygon fill="none" stroke="black" stroke-width="2" points="169,-38 169,-234 422,-234 422,-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,-131 8,-211 119,-211 119,-131 8,-131"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="8.5,-189 8.5,-211 119.5,-211 119.5,-189 8.5,-189"/> |
| <polygon fill="none" stroke="black" points="8.5,-189 8.5,-211 119.5,-211 119.5,-189 8.5,-189"/> |
| <text text-anchor="start" x="13.5" y="-198.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_surveys</text> |
| <text text-anchor="start" x="84.5" y="-197.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="8.5,-167 8.5,-189 119.5,-189 119.5,-167 8.5,-167"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-184"/> |
| <text text-anchor="start" x="28.5" y="-175.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="none" stroke="black" points="8.5,-149 8.5,-167 119.5,-167 119.5,-149 8.5,-149"/> |
| <text text-anchor="start" x="11.5" y="-155.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-131 8.5,-149 39.5,-149 39.5,-131 8.5,-131"/> |
| <polygon fill="none" stroke="black" points="8.5,-131 8.5,-149 39.5,-149 39.5,-131 8.5,-131"/> |
| <text text-anchor="start" x="11.5" y="-137.2" font-family="Helvetica,sans-Serif" font-size="11.00">  </text> |
| <polygon fill="#ffffff" stroke="transparent" points="39.5,-131 39.5,-149 87.5,-149 87.5,-131 39.5,-131"/> |
| <polygon fill="none" stroke="black" points="39.5,-131 39.5,-149 87.5,-149 87.5,-131 39.5,-131"/> |
| <text text-anchor="start" x="51.5" y="-137.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="87.5,-131 87.5,-149 119.5,-149 119.5,-131 87.5,-131"/> |
| <polygon fill="none" stroke="black" points="87.5,-131 87.5,-149 119.5,-149 119.5,-131 87.5,-131"/> |
| <text text-anchor="start" x="100.5" y="-137.2" font-family="Helvetica,sans-Serif" font-size="11.00">4 ></text> |
| </a> |
| </g> |
| </g> |
| <!-- m_survey_lookup_tables->m_surveys --> |
| <g id="edge1" class="edge"> |
| <title>m_survey_lookup_tables:w->m_surveys:e</title> |
| <path fill="none" stroke="black" d="M154.99,-178C143.68,-178 136.49,-178 120.5,-178"/> |
| <polygon fill="black" stroke="black" points="161.5,-178 169.5,-181.6 165.5,-178 169.5,-178 169.5,-178 169.5,-178 165.5,-178 169.5,-174.4 161.5,-178 161.5,-178"/> |
| <ellipse fill="none" stroke="black" cx="158.3" cy="-178" rx="3.2" ry="3.2"/> |
| </g> |
| </g> |
| </svg> |
