Documentation/EHI_Export/docs/diagrams/tables/onsite_documents.1degree.svg

   1 <?xml version="1.0" encoding="UTF-8" standalone="no"?>
   2 <!DOCTYPE svg PUBLIC "-//W3C//DTD SVG 1.1//EN"
   3  "http://www.w3.org/Graphics/SVG/1.1/DTD/svg11.dtd">
   4 <!-- Generated by graphviz version 2.40.1 (20161225.0304)
   5  -->
   6 <!-- Title: oneDegreeRelationshipsDiagram Pages: 1 -->
   7 <svg width="1243pt" height="558pt"
   8  viewBox="0.00 0.00 1243.00 558.20" xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink">
   9 <g id="graph0" class="graph" transform="scale(1 1) rotate(0) translate(4 554.2)">
  10 <title>oneDegreeRelationshipsDiagram</title>
  11 <polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-554.2 1239,-554.2 1239,4 -4,4"/>
  12 <text text-anchor="middle" x="72.4936" y="-7.3" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">Generated by SchemaSpy</text>
  13 <!-- form_encounter -->
  14 <g id="node1" class="node">
  15 <title>form_encounter</title>
  16 <g id="a_node1"><a xlink:href="../../tables/form_encounter.html" xlink:title="form_encounter" target="_top">
  17 <polygon fill="#ffffff" stroke="transparent" points="674,-258.7 674,-429.7 882,-429.7 882,-258.7 674,-258.7"/>
  18 <polygon fill="#f5f5f5" stroke="transparent" points="674,-406.2 674,-429.2 882,-429.2 882,-406.2 674,-406.2"/>
  19 <polygon fill="none" stroke="#000000" points="674,-406.2 674,-429.2 882,-429.2 882,-406.2 674,-406.2"/>
  20 <text text-anchor="start" x="679" y="-414.8" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00" fill="#000000">form_encounter</text>
  21 <text text-anchor="start" x="847.0437" y="-414.3" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">[table]</text>
  22 <polygon fill="none" stroke="#000000" points="674,-384.2 674,-406.2 882,-406.2 882,-384.2 674,-384.2"/>
  23 <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="679" y="-401.2"/>
  24 <text text-anchor="start" x="694" y="-391.3" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">id</text>
  25 <polygon fill="#ffffff" stroke="transparent" points="674,-362.2 674,-384.2 882,-384.2 882,-362.2 674,-362.2"/>
  26 <polygon fill="none" stroke="#000000" points="674,-362.2 674,-384.2 882,-384.2 882,-362.2 674,-362.2"/>
  27 <text text-anchor="start" x="694" y="-369.3" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">uuid</text>
  28 <polygon fill="#ffffff" stroke="transparent" points="674,-340.2 674,-362.2 882,-362.2 882,-340.2 674,-340.2"/>
  29 <polygon fill="none" stroke="#000000" points="674,-340.2 674,-362.2 882,-362.2 882,-340.2 674,-340.2"/>
  30 <text text-anchor="start" x="694" y="-347.3" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">date</text>
  31 <polygon fill="#ffffff" stroke="transparent" points="674,-318.2 674,-340.2 882,-340.2 882,-318.2 674,-318.2"/>
  32 <polygon fill="none" stroke="#000000" points="674,-318.2 674,-340.2 882,-340.2 882,-318.2 674,-318.2"/>
  33 <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="679" y="-335.2"/>
  34 <text text-anchor="start" x="694" y="-325.3" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">pid</text>
  35 <polygon fill="none" stroke="#000000" points="674,-296.2 674,-318.2 882,-318.2 882,-296.2 674,-296.2"/>
  36 <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="679" y="-313.2"/>
  37 <text text-anchor="start" x="694" y="-303.3" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">encounter</text>
  38 <polygon fill="none" stroke="#000000" points="674,-277.2 674,-296.2 882,-296.2 882,-277.2 674,-277.2"/>
  39 <text text-anchor="start" x="677" y="-283.3" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">...</text>
  40 <polygon fill="#ffffff" stroke="transparent" points="674,-258.2 674,-277.2 769,-277.2 769,-258.2 674,-258.2"/>
  41 <polygon fill="none" stroke="#000000" points="674,-258.2 674,-277.2 769,-277.2 769,-258.2 674,-258.2"/>
  42 <text text-anchor="start" x="677" y="-264.3" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">&lt; 1</text>
  43 <polygon fill="#ffffff" stroke="transparent" points="769,-258.2 769,-277.2 818,-277.2 818,-258.2 769,-258.2"/>
  44 <polygon fill="none" stroke="#000000" points="769,-258.2 769,-277.2 818,-277.2 818,-258.2 769,-258.2"/>
  45 <text text-anchor="start" x="808.8862" y="-264.3" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000"> &#160;</text>
  46 <polygon fill="#ffffff" stroke="transparent" points="818,-258.2 818,-277.2 882,-277.2 882,-258.2 818,-258.2"/>
  47 <polygon fill="none" stroke="#000000" points="818,-258.2 818,-277.2 882,-277.2 882,-258.2 818,-258.2"/>
  48 <text text-anchor="start" x="857.2904" y="-264.3" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">14 &gt;</text>
  49 </a>
  50 </g>
  51 </g>
  52 <!-- patient_data -->
  53 <g id="node2" class="node">
  54 <title>patient_data</title>
  55 <g id="a_node2"><a xlink:href="../../tables/patient_data.html" xlink:title="patient_data" target="_top">
  56 <polygon fill="#ffffff" stroke="transparent" points="458,-232.7 458,-469.7 625,-469.7 625,-232.7 458,-232.7"/>
  57 <polygon fill="#f5f5f5" stroke="transparent" points="458.5,-446.2 458.5,-469.2 625.5,-469.2 625.5,-446.2 458.5,-446.2"/>
  58 <polygon fill="none" stroke="#000000" points="458.5,-446.2 458.5,-469.2 625.5,-469.2 625.5,-446.2 458.5,-446.2"/>
  59 <text text-anchor="start" x="463.5" y="-454.8" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00" fill="#000000">patient_data</text>
  60 <text text-anchor="start" x="590.5437" y="-454.3" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">[table]</text>
  61 <polygon fill="#ffffff" stroke="transparent" points="458.5,-424.2 458.5,-446.2 625.5,-446.2 625.5,-424.2 458.5,-424.2"/>
  62 <polygon fill="none" stroke="#000000" points="458.5,-424.2 458.5,-446.2 625.5,-446.2 625.5,-424.2 458.5,-424.2"/>
  63 <text text-anchor="start" x="478.5" y="-431.3" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">id</text>
  64 <polygon fill="#ffffff" stroke="transparent" points="458.5,-402.2 458.5,-424.2 625.5,-424.2 625.5,-402.2 458.5,-402.2"/>
  65 <polygon fill="none" stroke="#000000" points="458.5,-402.2 458.5,-424.2 625.5,-424.2 625.5,-402.2 458.5,-402.2"/>
  66 <text text-anchor="start" x="478.5" y="-409.3" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">uuid</text>
  67 <polygon fill="none" stroke="#000000" points="458.5,-380.2 458.5,-402.2 625.5,-402.2 625.5,-380.2 458.5,-380.2"/>
  68 <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="463.5" y="-397.2"/>
  69 <text text-anchor="start" x="478.5" y="-387.3" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">pharmacy_id</text>
  70 <polygon fill="none" stroke="#000000" points="458.5,-358.2 458.5,-380.2 625.5,-380.2 625.5,-358.2 458.5,-358.2"/>
  71 <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="463.5" y="-375.2"/>
  72 <text text-anchor="start" x="478.5" y="-365.3" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">providerID</text>
  73 <polygon fill="none" stroke="#000000" points="458.5,-336.2 458.5,-358.2 625.5,-358.2 625.5,-336.2 458.5,-336.2"/>
  74 <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="463.5" y="-353.2"/>
  75 <text text-anchor="start" x="478.5" y="-343.3" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">ref_providerID</text>
  76 <polygon fill="none" stroke="#000000" points="458.5,-314.2 458.5,-336.2 625.5,-336.2 625.5,-314.2 458.5,-314.2"/>
  77 <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="463.5" y="-331.2"/>
  78 <text text-anchor="start" x="478.5" y="-321.3" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">pid</text>
  79 <polygon fill="none" stroke="#000000" points="458.5,-292.2 458.5,-314.2 625.5,-314.2 625.5,-292.2 458.5,-292.2"/>
  80 <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="463.5" y="-309.2"/>
  81 <text text-anchor="start" x="478.5" y="-299.3" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">created_by</text>
  82 <polygon fill="none" stroke="#000000" points="458.5,-270.2 458.5,-292.2 625.5,-292.2 625.5,-270.2 458.5,-270.2"/>
  83 <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="463.5" y="-287.2"/>
  84 <text text-anchor="start" x="478.5" y="-277.3" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">updated_by</text>
  85 <polygon fill="none" stroke="#000000" points="458.5,-251.2 458.5,-270.2 625.5,-270.2 625.5,-251.2 458.5,-251.2"/>
  86 <text text-anchor="start" x="461.5" y="-257.3" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">...</text>
  87 <polygon fill="#ffffff" stroke="transparent" points="458.5,-232.2 458.5,-251.2 532.5,-251.2 532.5,-232.2 458.5,-232.2"/>
  88 <polygon fill="none" stroke="#000000" points="458.5,-232.2 458.5,-251.2 532.5,-251.2 532.5,-232.2 458.5,-232.2"/>
  89 <text text-anchor="start" x="461.5" y="-238.3" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">&lt; 5</text>
  90 <polygon fill="#ffffff" stroke="transparent" points="532.5,-232.2 532.5,-251.2 571.5,-251.2 571.5,-232.2 532.5,-232.2"/>
  91 <polygon fill="none" stroke="#000000" points="532.5,-232.2 532.5,-251.2 571.5,-251.2 571.5,-232.2 532.5,-232.2"/>
  92 <text text-anchor="start" x="562.3862" y="-238.3" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000"> &#160;</text>
  93 <polygon fill="#ffffff" stroke="transparent" points="571.5,-232.2 571.5,-251.2 625.5,-251.2 625.5,-232.2 571.5,-232.2"/>
  94 <polygon fill="none" stroke="#000000" points="571.5,-232.2 571.5,-251.2 625.5,-251.2 625.5,-232.2 571.5,-232.2"/>
  95 <text text-anchor="start" x="600.7904" y="-238.3" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">85 &gt;</text>
  96 </a>
  97 </g>
  98 </g>
  99 <!-- form_encounter&#45;&gt;patient_data -->
 100 <g id="edge1" class="edge">
 101 <title>form_encounter:w&#45;&gt;patient_data:e</title>
 102 <path fill="none" stroke="#000000" d="M659.2632,-328.4663C648.2791,-327.3116 641.2146,-325.2 625.5,-325.2"/>
 103 <polygon fill="#000000" stroke="#000000" points="666.0099,-328.8022 673.821,-332.7955 670.0049,-329.0011 674,-329.2 674,-329.2 674,-329.2 670.0049,-329.0011 674.179,-325.6045 666.0099,-328.8022 666.0099,-328.8022"/>
 104 <ellipse fill="none" stroke="#000000" cx="662.8139" cy="-328.643" rx="3.2" ry="3.2"/>
 105 </g>
 106 <!-- users -->
 107 <g id="node5" class="node">
 108 <title>users</title>
 109 <g id="a_node5"><a xlink:href="../../tables/users.html" xlink:title="users" target="_top">
 110 <polygon fill="#ffffff" stroke="transparent" points="242,-144.7 242,-359.7 409,-359.7 409,-144.7 242,-144.7"/>
 111 <polygon fill="#f5f5f5" stroke="transparent" points="242.5,-336.2 242.5,-359.2 409.5,-359.2 409.5,-336.2 242.5,-336.2"/>
 112 <polygon fill="none" stroke="#000000" points="242.5,-336.2 242.5,-359.2 409.5,-359.2 409.5,-336.2 242.5,-336.2"/>
 113 <text text-anchor="start" x="247.5" y="-344.8" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00" fill="#000000">users</text>
 114 <text text-anchor="start" x="374.5437" y="-344.3" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">[table]</text>
 115 <polygon fill="none" stroke="#000000" points="242.5,-314.2 242.5,-336.2 409.5,-336.2 409.5,-314.2 242.5,-314.2"/>
 116 <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="247.5" y="-331.2"/>
 117 <text text-anchor="start" x="262.5" y="-321.3" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">id</text>
 118 <polygon fill="#ffffff" stroke="transparent" points="242.5,-292.2 242.5,-314.2 409.5,-314.2 409.5,-292.2 242.5,-292.2"/>
 119 <polygon fill="none" stroke="#000000" points="242.5,-292.2 242.5,-314.2 409.5,-314.2 409.5,-292.2 242.5,-292.2"/>
 120 <text text-anchor="start" x="262.5" y="-299.3" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">uuid</text>
 121 <polygon fill="none" stroke="#000000" points="242.5,-270.2 242.5,-292.2 409.5,-292.2 409.5,-270.2 242.5,-270.2"/>
 122 <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="247.5" y="-287.2"/>
 123 <text text-anchor="start" x="262.5" y="-277.3" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">username</text>
 124 <polygon fill="none" stroke="#000000" points="242.5,-248.2 242.5,-270.2 409.5,-270.2 409.5,-248.2 242.5,-248.2"/>
 125 <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="247.5" y="-265.2"/>
 126 <text text-anchor="start" x="262.5" y="-255.3" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">facility_id</text>
 127 <polygon fill="#ffffff" stroke="transparent" points="242.5,-226.2 242.5,-248.2 409.5,-248.2 409.5,-226.2 242.5,-226.2"/>
 128 <polygon fill="none" stroke="#000000" points="242.5,-226.2 242.5,-248.2 409.5,-248.2 409.5,-226.2 242.5,-226.2"/>
 129 <text text-anchor="start" x="262.5" y="-233.3" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">google_signin_email</text>
 130 <polygon fill="#ffffff" stroke="transparent" points="242.5,-204.2 242.5,-226.2 409.5,-226.2 409.5,-204.2 242.5,-204.2"/>
 131 <polygon fill="none" stroke="#000000" points="242.5,-204.2 242.5,-226.2 409.5,-226.2 409.5,-204.2 242.5,-204.2"/>
 132 <text text-anchor="start" x="262.5" y="-211.3" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">abook_type</text>
 133 <polygon fill="none" stroke="#000000" points="242.5,-182.2 242.5,-204.2 409.5,-204.2 409.5,-182.2 242.5,-182.2"/>
 134 <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="247.5" y="-199.2"/>
 135 <text text-anchor="start" x="262.5" y="-189.3" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">billing_facility_id</text>
 136 <polygon fill="none" stroke="#000000" points="242.5,-163.2 242.5,-182.2 409.5,-182.2 409.5,-163.2 242.5,-163.2"/>
 137 <text text-anchor="start" x="245.5" y="-169.3" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">...</text>
 138 <polygon fill="#ffffff" stroke="transparent" points="242.5,-144.2 242.5,-163.2 316.5,-163.2 316.5,-144.2 242.5,-144.2"/>
 139 <polygon fill="none" stroke="#000000" points="242.5,-144.2 242.5,-163.2 316.5,-163.2 316.5,-144.2 242.5,-144.2"/>
 140 <text text-anchor="start" x="245.5" y="-150.3" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">&lt; 2</text>
 141 <polygon fill="#ffffff" stroke="transparent" points="316.5,-144.2 316.5,-163.2 355.5,-163.2 355.5,-144.2 316.5,-144.2"/>
 142 <polygon fill="none" stroke="#000000" points="316.5,-144.2 316.5,-163.2 355.5,-163.2 355.5,-144.2 316.5,-144.2"/>
 143 <text text-anchor="start" x="346.3862" y="-150.3" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000"> &#160;</text>
 144 <polygon fill="#ffffff" stroke="transparent" points="355.5,-144.2 355.5,-163.2 409.5,-163.2 409.5,-144.2 355.5,-144.2"/>
 145 <polygon fill="none" stroke="#000000" points="355.5,-144.2 355.5,-163.2 409.5,-163.2 409.5,-144.2 355.5,-144.2"/>
 146 <text text-anchor="start" x="384.7904" y="-150.3" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">61 &gt;</text>
 147 </a>
 148 </g>
 149 </g>
 150 <!-- patient_data&#45;&gt;users -->
 151 <g id="edge6" class="edge">
 152 <title>patient_data:w&#45;&gt;users:e</title>
 153 <path fill="none" stroke="#000000" d="M444.1297,-306.6375C432.5865,-312.825 427.4041,-325.2 409.5,-325.2"/>
 154 <polygon fill="#000000" stroke="#000000" points="450.7195,-305.0612 459.3375,-306.7012 454.6098,-304.1306 458.5,-303.2 458.5,-303.2 458.5,-303.2 454.6098,-304.1306 457.6625,-299.6988 450.7195,-305.0612 450.7195,-305.0612"/>
 155 <ellipse fill="none" stroke="#000000" cx="447.6073" cy="-305.8057" rx="3.2" ry="3.2"/>
 156 </g>
 157 <!-- patient_data&#45;&gt;users -->
 158 <g id="edge7" class="edge">
 159 <title>patient_data:w&#45;&gt;users:e</title>
 160 <path fill="none" stroke="#000000" d="M444.8171,-364.4912C431.5046,-353.1404 432.824,-325.2 409.5,-325.2"/>
 161 <polygon fill="#000000" stroke="#000000" points="450.9354,-366.5967 457.3285,-372.6041 454.7177,-367.8984 458.5,-369.2 458.5,-369.2 458.5,-369.2 454.7177,-367.8984 459.6715,-365.7959 450.9354,-366.5967 450.9354,-366.5967"/>
 162 <ellipse fill="none" stroke="#000000" cx="447.9096" cy="-365.5554" rx="3.2" ry="3.2"/>
 163 </g>
 164 <!-- patient_data&#45;&gt;users -->
 165 <g id="edge8" class="edge">
 166 <title>patient_data:w&#45;&gt;users:e</title>
 167 <path fill="none" stroke="#000000" d="M444.1297,-343.7625C432.5865,-337.575 427.4041,-325.2 409.5,-325.2"/>
 168 <polygon fill="#000000" stroke="#000000" points="450.7195,-345.3388 457.6625,-350.7012 454.6098,-346.2694 458.5,-347.2 458.5,-347.2 458.5,-347.2 454.6098,-346.2694 459.3375,-343.6988 450.7195,-345.3388 450.7195,-345.3388"/>
 169 <ellipse fill="none" stroke="#000000" cx="447.6073" cy="-344.5943" rx="3.2" ry="3.2"/>
 170 </g>
 171 <!-- patient_data&#45;&gt;users -->
 172 <g id="edge9" class="edge">
 173 <title>patient_data:w&#45;&gt;users:e</title>
 174 <path fill="none" stroke="#000000" d="M444.8171,-285.9088C431.5046,-297.2596 432.824,-325.2 409.5,-325.2"/>
 175 <polygon fill="#000000" stroke="#000000" points="450.9354,-283.8033 459.6715,-284.6041 454.7177,-282.5016 458.5,-281.2 458.5,-281.2 458.5,-281.2 454.7177,-282.5016 457.3285,-277.7959 450.9354,-283.8033 450.9354,-283.8033"/>
 176 <ellipse fill="none" stroke="#000000" cx="447.9096" cy="-284.8446" rx="3.2" ry="3.2"/>
 177 </g>
 178 <!-- onsite_documents -->
 179 <g id="node3" class="node">
 180 <title>onsite_documents</title>
 181 <g id="a_node3"><a xlink:href="../../tables/onsite_documents.html" xlink:title="onsite_documents" target="_top">
 182 <polygon fill="#ffffff" stroke="transparent" points="931,-38.2 931,-546.2 1227,-546.2 1227,-38.2 931,-38.2"/>
 183 <polygon fill="#f5f5f5" stroke="transparent" points="933,-521.2 933,-544.2 1225,-544.2 1225,-521.2 933,-521.2"/>
 184 <polygon fill="none" stroke="#000000" points="933,-521.2 933,-544.2 1225,-544.2 1225,-521.2 933,-521.2"/>
 185 <text text-anchor="start" x="938" y="-529.8" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00" fill="#000000">onsite_documents</text>
 186 <text text-anchor="start" x="1190.0437" y="-529.3" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">[table]</text>
 187 <polygon fill="none" stroke="#000000" points="933,-499.2 933,-521.2 1105,-521.2 1105,-499.2 933,-499.2"/>
 188 <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="938" y="-516.2"/>
 189 <text text-anchor="start" x="953" y="-506.3" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">id</text>
 190 <polygon fill="none" stroke="#000000" points="1105,-499.2 1105,-521.2 1225,-521.2 1225,-499.2 1105,-499.2"/>
 191 <text text-anchor="start" x="1108" y="-506.9" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">int unsigned[10]</text>
 192 <polygon fill="none" stroke="#000000" points="933,-477.2 933,-499.2 1105,-499.2 1105,-477.2 933,-477.2"/>
 193 <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="938" y="-494.2"/>
 194 <text text-anchor="start" x="953" y="-484.3" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">pid</text>
 195 <polygon fill="none" stroke="#000000" points="1105,-477.2 1105,-499.2 1225,-499.2 1225,-477.2 1105,-477.2"/>
 196 <text text-anchor="start" x="1108" y="-484.9" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">bigint unsigned[20]</text>
 197 <polygon fill="none" stroke="#000000" points="933,-455.2 933,-477.2 1105,-477.2 1105,-455.2 933,-455.2"/>
 198 <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="938" y="-472.2"/>
 199 <text text-anchor="start" x="953" y="-462.3" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">facility</text>
 200 <polygon fill="none" stroke="#000000" points="1105,-455.2 1105,-477.2 1225,-477.2 1225,-455.2 1105,-455.2"/>
 201 <text text-anchor="start" x="1108" y="-462.9" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">int unsigned[10]</text>
 202 <polygon fill="none" stroke="#000000" points="933,-433.2 933,-455.2 1105,-455.2 1105,-433.2 933,-433.2"/>
 203 <text text-anchor="start" x="953" y="-440.3" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">provider</text>
 204 <polygon fill="none" stroke="#000000" points="1105,-433.2 1105,-455.2 1225,-455.2 1225,-433.2 1105,-433.2"/>
 205 <text text-anchor="start" x="1108" y="-440.9" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">int unsigned[10]</text>
 206 <polygon fill="none" stroke="#000000" points="933,-411.2 933,-433.2 1105,-433.2 1105,-411.2 933,-411.2"/>
 207 <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="938" y="-428.2"/>
 208 <text text-anchor="start" x="953" y="-418.3" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">encounter</text>
 209 <polygon fill="none" stroke="#000000" points="1105,-411.2 1105,-433.2 1225,-433.2 1225,-411.2 1105,-411.2"/>
 210 <text text-anchor="start" x="1108" y="-418.9" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">int unsigned[10]</text>
 211 <polygon fill="none" stroke="#000000" points="933,-389.2 933,-411.2 1105,-411.2 1105,-389.2 933,-389.2"/>
 212 <text text-anchor="start" x="953" y="-396.3" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">create_date</text>
 213 <polygon fill="none" stroke="#000000" points="1105,-389.2 1105,-411.2 1225,-411.2 1225,-389.2 1105,-389.2"/>
 214 <text text-anchor="start" x="1108" y="-396.9" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">timestamp[19]</text>
 215 <polygon fill="none" stroke="#000000" points="933,-367.2 933,-389.2 1105,-389.2 1105,-367.2 933,-367.2"/>
 216 <text text-anchor="start" x="953" y="-374.3" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">doc_type</text>
 217 <polygon fill="none" stroke="#000000" points="1105,-367.2 1105,-389.2 1225,-389.2 1225,-367.2 1105,-367.2"/>
 218 <text text-anchor="start" x="1108" y="-374.9" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">varchar[255]</text>
 219 <polygon fill="none" stroke="#000000" points="933,-345.2 933,-367.2 1105,-367.2 1105,-345.2 933,-345.2"/>
 220 <text text-anchor="start" x="953" y="-352.3" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">patient_signed_status</text>
 221 <polygon fill="none" stroke="#000000" points="1105,-345.2 1105,-367.2 1225,-367.2 1225,-345.2 1105,-345.2"/>
 222 <text text-anchor="start" x="1108" y="-352.9" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">smallint unsigned[5]</text>
 223 <polygon fill="none" stroke="#000000" points="933,-323.2 933,-345.2 1105,-345.2 1105,-323.2 933,-323.2"/>
 224 <text text-anchor="start" x="953" y="-330.3" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">patient_signed_time</text>
 225 <polygon fill="none" stroke="#000000" points="1105,-323.2 1105,-345.2 1225,-345.2 1225,-323.2 1105,-323.2"/>
 226 <text text-anchor="start" x="1108" y="-330.9" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">datetime[19]</text>
 227 <polygon fill="none" stroke="#000000" points="933,-301.2 933,-323.2 1105,-323.2 1105,-301.2 933,-301.2"/>
 228 <text text-anchor="start" x="953" y="-308.3" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">authorize_signed_time</text>
 229 <polygon fill="none" stroke="#000000" points="1105,-301.2 1105,-323.2 1225,-323.2 1225,-301.2 1105,-301.2"/>
 230 <text text-anchor="start" x="1108" y="-308.9" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">datetime[19]</text>
 231 <polygon fill="none" stroke="#000000" points="933,-279.2 933,-301.2 1105,-301.2 1105,-279.2 933,-279.2"/>
 232 <text text-anchor="start" x="953" y="-286.3" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">accept_signed_status</text>
 233 <polygon fill="none" stroke="#000000" points="1105,-279.2 1105,-301.2 1225,-301.2 1225,-279.2 1105,-279.2"/>
 234 <text text-anchor="start" x="1108" y="-286.9" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">smallint[5]</text>
 235 <polygon fill="none" stroke="#000000" points="933,-257.2 933,-279.2 1105,-279.2 1105,-257.2 933,-257.2"/>
 236 <text text-anchor="start" x="953" y="-264.3" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">authorizing_signator</text>
 237 <polygon fill="none" stroke="#000000" points="1105,-257.2 1105,-279.2 1225,-279.2 1225,-257.2 1105,-257.2"/>
 238 <text text-anchor="start" x="1108" y="-264.9" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">varchar[50]</text>
 239 <polygon fill="none" stroke="#000000" points="933,-235.2 933,-257.2 1105,-257.2 1105,-235.2 933,-235.2"/>
 240 <text text-anchor="start" x="953" y="-242.3" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">review_date</text>
 241 <polygon fill="none" stroke="#000000" points="1105,-235.2 1105,-257.2 1225,-257.2 1225,-235.2 1105,-235.2"/>
 242 <text text-anchor="start" x="1108" y="-242.9" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">datetime[19]</text>
 243 <polygon fill="none" stroke="#000000" points="933,-213.2 933,-235.2 1105,-235.2 1105,-213.2 933,-213.2"/>
 244 <text text-anchor="start" x="953" y="-220.3" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">denial_reason</text>
 245 <polygon fill="none" stroke="#000000" points="1105,-213.2 1105,-235.2 1225,-235.2 1225,-213.2 1105,-213.2"/>
 246 <text text-anchor="start" x="1108" y="-220.9" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">varchar[255]</text>
 247 <polygon fill="none" stroke="#000000" points="933,-191.2 933,-213.2 1105,-213.2 1105,-191.2 933,-191.2"/>
 248 <text text-anchor="start" x="953" y="-198.3" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">authorized_signature</text>
 249 <polygon fill="none" stroke="#000000" points="1105,-191.2 1105,-213.2 1225,-213.2 1225,-191.2 1105,-191.2"/>
 250 <text text-anchor="start" x="1108" y="-198.9" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">text[65535]</text>
 251 <polygon fill="none" stroke="#000000" points="933,-169.2 933,-191.2 1105,-191.2 1105,-169.2 933,-169.2"/>
 252 <text text-anchor="start" x="953" y="-176.3" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">patient_signature</text>
 253 <polygon fill="none" stroke="#000000" points="1105,-169.2 1105,-191.2 1225,-191.2 1225,-169.2 1105,-169.2"/>
 254 <text text-anchor="start" x="1108" y="-176.9" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">text[65535]</text>
 255 <polygon fill="none" stroke="#000000" points="933,-147.2 933,-169.2 1105,-169.2 1105,-147.2 933,-147.2"/>
 256 <text text-anchor="start" x="953" y="-154.3" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">full_document</text>
 257 <polygon fill="none" stroke="#000000" points="1105,-147.2 1105,-169.2 1225,-169.2 1225,-147.2 1105,-147.2"/>
 258 <text text-anchor="start" x="1107.536" y="-154.9" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">mediumblob[16777215]</text>
 259 <polygon fill="none" stroke="#000000" points="933,-125.2 933,-147.2 1105,-147.2 1105,-125.2 933,-125.2"/>
 260 <text text-anchor="start" x="953" y="-132.3" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">file_name</text>
 261 <polygon fill="none" stroke="#000000" points="1105,-125.2 1105,-147.2 1225,-147.2 1225,-125.2 1105,-125.2"/>
 262 <text text-anchor="start" x="1108" y="-132.9" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">varchar[255]</text>
 263 <polygon fill="none" stroke="#000000" points="933,-103.2 933,-125.2 1105,-125.2 1105,-103.2 933,-103.2"/>
 264 <text text-anchor="start" x="953" y="-110.3" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">file_path</text>
 265 <polygon fill="none" stroke="#000000" points="1105,-103.2 1105,-125.2 1225,-125.2 1225,-103.2 1105,-103.2"/>
 266 <text text-anchor="start" x="1108" y="-110.9" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">varchar[255]</text>
 267 <polygon fill="none" stroke="#000000" points="933,-81.2 933,-103.2 1105,-103.2 1105,-81.2 933,-81.2"/>
 268 <text text-anchor="start" x="953" y="-88.3" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">template_data</text>
 269 <polygon fill="none" stroke="#000000" points="1105,-81.2 1105,-103.2 1225,-103.2 1225,-81.2 1105,-81.2"/>
 270 <text text-anchor="start" x="1108" y="-88.9" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">longtext[2147483647]</text>
 271 <polygon fill="none" stroke="#000000" points="933,-59.2 933,-81.2 1105,-81.2 1105,-59.2 933,-59.2"/>
 272 <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="938" y="-76.2"/>
 273 <text text-anchor="start" x="953" y="-66.3" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">user</text>
 274 <polygon fill="none" stroke="#000000" points="1105,-59.2 1105,-81.2 1225,-81.2 1225,-59.2 1105,-59.2"/>
 275 <text text-anchor="start" x="1108" y="-66.9" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">unknown[0]</text>
 276 <polygon fill="#ffffff" stroke="transparent" points="933,-40.2 933,-59.2 1023,-59.2 1023,-40.2 933,-40.2"/>
 277 <polygon fill="none" stroke="#000000" points="933,-40.2 933,-59.2 1023,-59.2 1023,-40.2 933,-40.2"/>
 278 <text text-anchor="start" x="936" y="-46.3" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">&lt; 4</text>
 279 <polygon fill="#ffffff" stroke="transparent" points="1023,-40.2 1023,-59.2 1105,-59.2 1105,-40.2 1023,-40.2"/>
 280 <polygon fill="none" stroke="#000000" points="1023,-40.2 1023,-59.2 1105,-59.2 1105,-40.2 1023,-40.2"/>
 281 <text text-anchor="start" x="1095.8862" y="-46.3" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000"> &#160;</text>
 282 <polygon fill="#ffffff" stroke="transparent" points="1105,-40.2 1105,-59.2 1225,-59.2 1225,-40.2 1105,-40.2"/>
 283 <polygon fill="none" stroke="#000000" points="1105,-40.2 1105,-59.2 1225,-59.2 1225,-40.2 1105,-40.2"/>
 284 <text text-anchor="start" x="1206.4053" y="-46.3" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">0 &gt;</text>
 285 <polygon fill="none" stroke="#000000" stroke-width="2" points="932,-39.2 932,-545.2 1226,-545.2 1226,-39.2 932,-39.2"/>
 286 </a>
 287 </g>
 288 </g>
 289 <!-- onsite_documents&#45;&gt;form_encounter -->
 290 <g id="edge2" class="edge">
 291 <title>onsite_documents:w&#45;&gt;form_encounter:e</title>
 292 <path fill="none" stroke="#000000" d="M918.9308,-418.6322C888.6197,-399.2214 932.0148,-307.2 882,-307.2"/>
 293 <polygon fill="#000000" stroke="#000000" points="925.2455,-420.2335 932.1151,-425.6895 929.1227,-421.2167 933,-422.2 933,-422.2 933,-422.2 929.1227,-421.2167 933.8849,-418.7105 925.2455,-420.2335 925.2455,-420.2335"/>
 294 <ellipse fill="none" stroke="#000000" cx="922.1436" cy="-419.4469" rx="3.2" ry="3.2"/>
 295 </g>
 296 <!-- onsite_documents&#45;&gt;patient_data -->
 297 <g id="edge4" class="edge">
 298 <title>onsite_documents:w&#45;&gt;patient_data:e</title>
 299 <path fill="none" stroke="#000000" d="M918.417,-486.6365C863.0523,-479.3579 676.0881,-448.7842 666,-440.2 624.7308,-405.083 679.6881,-325.2 625.5,-325.2"/>
 300 <polygon fill="#000000" stroke="#000000" points="925.0456,-487.3471 932.6162,-491.7795 929.0228,-487.7736 933,-488.2 933,-488.2 933,-488.2 929.0228,-487.7736 933.3838,-484.6205 925.0456,-487.3471 925.0456,-487.3471"/>
 301 <ellipse fill="none" stroke="#000000" cx="921.8638" cy="-487.006" rx="3.2" ry="3.2"/>
 302 </g>
 303 <!-- facility -->
 304 <g id="node4" class="node">
 305 <title>facility</title>
 306 <g id="a_node4"><a xlink:href="../../tables/facility.html" xlink:title="facility" target="_top">
 307 <polygon fill="#ffffff" stroke="transparent" points="8,-188.7 8,-293.7 193,-293.7 193,-188.7 8,-188.7"/>
 308 <polygon fill="#f5f5f5" stroke="transparent" points="8.5,-270.2 8.5,-293.2 193.5,-293.2 193.5,-270.2 8.5,-270.2"/>
 309 <polygon fill="none" stroke="#000000" points="8.5,-270.2 8.5,-293.2 193.5,-293.2 193.5,-270.2 8.5,-270.2"/>
 310 <text text-anchor="start" x="13.5" y="-278.8" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00" fill="#000000">facility</text>
 311 <text text-anchor="start" x="158.5437" y="-278.3" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">[table]</text>
 312 <polygon fill="none" stroke="#000000" points="8.5,-248.2 8.5,-270.2 193.5,-270.2 193.5,-248.2 8.5,-248.2"/>
 313 <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-265.2"/>
 314 <text text-anchor="start" x="28.5" y="-255.3" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">id</text>
 315 <polygon fill="#ffffff" stroke="transparent" points="8.5,-226.2 8.5,-248.2 193.5,-248.2 193.5,-226.2 8.5,-226.2"/>
 316 <polygon fill="none" stroke="#000000" points="8.5,-226.2 8.5,-248.2 193.5,-248.2 193.5,-226.2 8.5,-226.2"/>
 317 <text text-anchor="start" x="28.5" y="-233.3" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">uuid</text>
 318 <polygon fill="none" stroke="#000000" points="8.5,-207.2 8.5,-226.2 193.5,-226.2 193.5,-207.2 8.5,-207.2"/>
 319 <text text-anchor="start" x="11.5" y="-213.3" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">...</text>
 320 <polygon fill="#ffffff" stroke="transparent" points="8.5,-188.2 8.5,-207.2 90.5,-207.2 90.5,-188.2 8.5,-188.2"/>
 321 <polygon fill="none" stroke="#000000" points="8.5,-188.2 8.5,-207.2 90.5,-207.2 90.5,-188.2 8.5,-188.2"/>
 322 <text text-anchor="start" x="11.5" y="-194.3" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000"> &#160;</text>
 323 <polygon fill="#ffffff" stroke="transparent" points="90.5,-188.2 90.5,-207.2 137.5,-207.2 137.5,-188.2 90.5,-188.2"/>
 324 <polygon fill="none" stroke="#000000" points="90.5,-188.2 90.5,-207.2 137.5,-207.2 137.5,-188.2 90.5,-188.2"/>
 325 <text text-anchor="start" x="128.3862" y="-194.3" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000"> &#160;</text>
 326 <polygon fill="#ffffff" stroke="transparent" points="137.5,-188.2 137.5,-207.2 193.5,-207.2 193.5,-188.2 137.5,-188.2"/>
 327 <polygon fill="none" stroke="#000000" points="137.5,-188.2 137.5,-207.2 193.5,-207.2 193.5,-188.2 137.5,-188.2"/>
 328 <text text-anchor="start" x="174.9053" y="-194.3" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">8 &gt;</text>
 329 </a>
 330 </g>
 331 </g>
 332 <!-- onsite_documents&#45;&gt;facility -->
 333 <g id="edge3" class="edge">
 334 <title>onsite_documents:w&#45;&gt;facility:e</title>
 335 <path fill="none" stroke="#000000" d="M918.3656,-467.0678C909.474,-468.2141 903.1899,-470.2038 890,-471.2 694.959,-485.9305 640.1969,-525.841 450,-480.2 345.2423,-455.0616 305.4256,-450.8505 234,-370.2 199.1831,-330.8864 246.0145,-259.2 193.5,-259.2"/>
 336 <polygon fill="#000000" stroke="#000000" points="925.014,-466.6736 933.2131,-469.7937 929.007,-466.4368 933,-466.2 933,-466.2 933,-466.2 929.007,-466.4368 932.7869,-462.6063 925.014,-466.6736 925.014,-466.6736"/>
 337 <ellipse fill="none" stroke="#000000" cx="921.8196" cy="-466.8631" rx="3.2" ry="3.2"/>
 338 </g>
 339 <!-- onsite_documents&#45;&gt;users -->
 340 <g id="edge5" class="edge">
 341 <title>onsite_documents:w&#45;&gt;users:e</title>
 342 <path fill="none" stroke="#000000" d="M918.354,-70.1995C703.8168,-70.2095 610.9665,-72.0863 450,-222.2 414.0262,-255.7483 458.6895,-325.2 409.5,-325.2"/>
 343 <polygon fill="#000000" stroke="#000000" points="925,-70.1997 932.9999,-73.8 929,-70.1998 933,-70.2 933,-70.2 933,-70.2 929,-70.1998 933.0001,-66.6 925,-70.1997 925,-70.1997"/>
 344 <ellipse fill="none" stroke="#000000" cx="921.8" cy="-70.1995" rx="3.2" ry="3.2"/>
 345 </g>
 346 <!-- users&#45;&gt;facility -->
 347 <g id="edge10" class="edge">
 348 <title>users:w&#45;&gt;facility:e</title>
 349 <path fill="none" stroke="#000000" d="M228.8768,-197.9466C212.2322,-213.0798 224.0399,-259.2 193.5,-259.2"/>
 350 <polygon fill="#000000" stroke="#000000" points="234.9454,-195.8322 243.6845,-196.5996 238.7227,-194.5161 242.5,-193.2 242.5,-193.2 242.5,-193.2 238.7227,-194.5161 241.3155,-189.8004 234.9454,-195.8322 234.9454,-195.8322"/>
 351 <ellipse fill="none" stroke="#000000" cx="231.9236" cy="-196.8851" rx="3.2" ry="3.2"/>
 352 </g>
 353 <!-- users&#45;&gt;facility -->
 354 <g id="edge11" class="edge">
 355 <title>users:w&#45;&gt;facility:e</title>
 356 <path fill="none" stroke="#000000" d="M227.9909,-259.2C216.6774,-259.2 209.4931,-259.2 193.5,-259.2"/>
 357 <polygon fill="#000000" stroke="#000000" points="234.5,-259.2001 242.5,-262.8 238.5,-259.2 242.5,-259.2 242.5,-259.2 242.5,-259.2 238.5,-259.2 242.5,-255.6 234.5,-259.2001 234.5,-259.2001"/>
 358 <ellipse fill="none" stroke="#000000" cx="231.3" cy="-259.2001" rx="3.2" ry="3.2"/>
 359 </g>
 360 </g>
 361 </svg>