Documentation/EHI_Export/docs/diagrams/tables/external_procedures.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="771pt" height="327pt"
   8  viewBox="0.00 0.00 771.00 327.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 323.2)">
  10 <title>oneDegreeRelationshipsDiagram</title>
  11 <polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-323.2 767,-323.2 767,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 <!-- external_procedures -->
  14 <g id="node1" class="node">
  15 <title>external_procedures</title>
  16 <g id="a_node1"><a xlink:href="../../tables/external_procedures.html" xlink:title="external_procedures" target="_top">
  17 <polygon fill="#ffffff" stroke="transparent" points="481,-50.7 481,-294.7 755,-294.7 755,-50.7 481,-50.7"/>
  18 <polygon fill="#f5f5f5" stroke="transparent" points="483,-269.7 483,-292.7 753,-292.7 753,-269.7 483,-269.7"/>
  19 <polygon fill="none" stroke="#000000" points="483,-269.7 483,-292.7 753,-292.7 753,-269.7 483,-269.7"/>
  20 <text text-anchor="start" x="488" y="-278.3" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00" fill="#000000">external_procedures</text>
  21 <text text-anchor="start" x="718.0437" y="-277.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">[table]</text>
  22 <polygon fill="none" stroke="#000000" points="483,-247.7 483,-269.7 642,-269.7 642,-247.7 483,-247.7"/>
  23 <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="488" y="-264.7"/>
  24 <text text-anchor="start" x="503" y="-254.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">ep_id</text>
  25 <polygon fill="none" stroke="#000000" points="642,-247.7 642,-269.7 753,-269.7 753,-247.7 642,-247.7"/>
  26 <text text-anchor="start" x="645" y="-255.4" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">int[10]</text>
  27 <polygon fill="none" stroke="#000000" points="483,-225.7 483,-247.7 642,-247.7 642,-225.7 483,-225.7"/>
  28 <text text-anchor="start" x="503" y="-232.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">ep_date</text>
  29 <polygon fill="none" stroke="#000000" points="642,-225.7 642,-247.7 753,-247.7 753,-225.7 642,-225.7"/>
  30 <text text-anchor="start" x="645" y="-233.4" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">date[10]</text>
  31 <polygon fill="none" stroke="#000000" points="483,-203.7 483,-225.7 642,-225.7 642,-203.7 483,-203.7"/>
  32 <text text-anchor="start" x="503" y="-210.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">ep_code_type</text>
  33 <polygon fill="none" stroke="#000000" points="642,-203.7 642,-225.7 753,-225.7 753,-203.7 642,-203.7"/>
  34 <text text-anchor="start" x="645" y="-211.4" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">varchar[20]</text>
  35 <polygon fill="none" stroke="#000000" points="483,-181.7 483,-203.7 642,-203.7 642,-181.7 483,-181.7"/>
  36 <text text-anchor="start" x="503" y="-188.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">ep_code</text>
  37 <polygon fill="none" stroke="#000000" points="642,-181.7 642,-203.7 753,-203.7 753,-181.7 642,-181.7"/>
  38 <text text-anchor="start" x="645" y="-189.4" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">varchar[9]</text>
  39 <polygon fill="#ffffff" stroke="transparent" points="483,-159.7 483,-181.7 642,-181.7 642,-159.7 483,-159.7"/>
  40 <polygon fill="none" stroke="#000000" points="483,-159.7 483,-181.7 642,-181.7 642,-159.7 483,-159.7"/>
  41 <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="488" y="-176.7"/>
  42 <text text-anchor="start" x="503" y="-166.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">ep_pid</text>
  43 <polygon fill="none" stroke="#000000" points="642,-159.7 642,-181.7 753,-181.7 753,-159.7 642,-159.7"/>
  44 <text text-anchor="start" x="645" y="-167.4" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">int[10]</text>
  45 <polygon fill="none" stroke="#000000" points="483,-137.7 483,-159.7 642,-159.7 642,-137.7 483,-137.7"/>
  46 <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="488" y="-154.7"/>
  47 <text text-anchor="start" x="503" y="-144.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">ep_encounter</text>
  48 <polygon fill="none" stroke="#000000" points="642,-137.7 642,-159.7 753,-159.7 753,-137.7 642,-137.7"/>
  49 <text text-anchor="start" x="645" y="-145.4" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">int[10]</text>
  50 <polygon fill="none" stroke="#000000" points="483,-115.7 483,-137.7 642,-137.7 642,-115.7 483,-115.7"/>
  51 <text text-anchor="start" x="503" y="-122.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">ep_code_text</text>
  52 <polygon fill="none" stroke="#000000" points="642,-115.7 642,-137.7 753,-137.7 753,-115.7 642,-115.7"/>
  53 <text text-anchor="start" x="644.6115" y="-123.4" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">longtext[2147483647]</text>
  54 <polygon fill="none" stroke="#000000" points="483,-93.7 483,-115.7 642,-115.7 642,-93.7 483,-93.7"/>
  55 <text text-anchor="start" x="503" y="-100.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">ep_facility_id</text>
  56 <polygon fill="none" stroke="#000000" points="642,-93.7 642,-115.7 753,-115.7 753,-93.7 642,-93.7"/>
  57 <text text-anchor="start" x="645" y="-101.4" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">varchar[255]</text>
  58 <polygon fill="none" stroke="#000000" points="483,-71.7 483,-93.7 642,-93.7 642,-71.7 483,-71.7"/>
  59 <text text-anchor="start" x="503" y="-78.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">ep_external_id</text>
  60 <polygon fill="none" stroke="#000000" points="642,-71.7 642,-93.7 753,-93.7 753,-71.7 642,-71.7"/>
  61 <text text-anchor="start" x="645" y="-79.4" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">varchar[255]</text>
  62 <polygon fill="#ffffff" stroke="transparent" points="483,-52.7 483,-71.7 567,-71.7 567,-52.7 483,-52.7"/>
  63 <polygon fill="none" stroke="#000000" points="483,-52.7 483,-71.7 567,-71.7 567,-52.7 483,-52.7"/>
  64 <text text-anchor="start" x="486" y="-58.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">&lt; 2</text>
  65 <polygon fill="#ffffff" stroke="transparent" points="567,-52.7 567,-71.7 642,-71.7 642,-52.7 567,-52.7"/>
  66 <polygon fill="none" stroke="#000000" points="567,-52.7 567,-71.7 642,-71.7 642,-52.7 567,-52.7"/>
  67 <text text-anchor="start" x="632.8862" y="-58.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000"> &#160;</text>
  68 <polygon fill="#ffffff" stroke="transparent" points="642,-52.7 642,-71.7 753,-71.7 753,-52.7 642,-52.7"/>
  69 <polygon fill="none" stroke="#000000" points="642,-52.7 642,-71.7 753,-71.7 753,-52.7 642,-52.7"/>
  70 <text text-anchor="start" x="734.4053" y="-58.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">0 &gt;</text>
  71 <polygon fill="none" stroke="#000000" stroke-width="2" points="482,-51.7 482,-293.7 754,-293.7 754,-51.7 482,-51.7"/>
  72 </a>
  73 </g>
  74 </g>
  75 <!-- form_encounter -->
  76 <g id="node2" class="node">
  77 <title>form_encounter</title>
  78 <g id="a_node2"><a xlink:href="../../tables/form_encounter.html" xlink:title="form_encounter" target="_top">
  79 <polygon fill="#ffffff" stroke="transparent" points="224,-38.2 224,-209.2 432,-209.2 432,-38.2 224,-38.2"/>
  80 <polygon fill="#f5f5f5" stroke="transparent" points="224,-185.7 224,-208.7 432,-208.7 432,-185.7 224,-185.7"/>
  81 <polygon fill="none" stroke="#000000" points="224,-185.7 224,-208.7 432,-208.7 432,-185.7 224,-185.7"/>
  82 <text text-anchor="start" x="229" y="-194.3" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00" fill="#000000">form_encounter</text>
  83 <text text-anchor="start" x="397.0437" y="-193.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">[table]</text>
  84 <polygon fill="none" stroke="#000000" points="224,-163.7 224,-185.7 432,-185.7 432,-163.7 224,-163.7"/>
  85 <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="229" y="-180.7"/>
  86 <text text-anchor="start" x="244" y="-170.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">id</text>
  87 <polygon fill="#ffffff" stroke="transparent" points="224,-141.7 224,-163.7 432,-163.7 432,-141.7 224,-141.7"/>
  88 <polygon fill="none" stroke="#000000" points="224,-141.7 224,-163.7 432,-163.7 432,-141.7 224,-141.7"/>
  89 <text text-anchor="start" x="244" y="-148.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">uuid</text>
  90 <polygon fill="#ffffff" stroke="transparent" points="224,-119.7 224,-141.7 432,-141.7 432,-119.7 224,-119.7"/>
  91 <polygon fill="none" stroke="#000000" points="224,-119.7 224,-141.7 432,-141.7 432,-119.7 224,-119.7"/>
  92 <text text-anchor="start" x="244" y="-126.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">date</text>
  93 <polygon fill="#ffffff" stroke="transparent" points="224,-97.7 224,-119.7 432,-119.7 432,-97.7 224,-97.7"/>
  94 <polygon fill="none" stroke="#000000" points="224,-97.7 224,-119.7 432,-119.7 432,-97.7 224,-97.7"/>
  95 <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="229" y="-114.7"/>
  96 <text text-anchor="start" x="244" y="-104.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">pid</text>
  97 <polygon fill="none" stroke="#000000" points="224,-75.7 224,-97.7 432,-97.7 432,-75.7 224,-75.7"/>
  98 <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="229" y="-92.7"/>
  99 <text text-anchor="start" x="244" y="-82.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">encounter</text>
 100 <polygon fill="none" stroke="#000000" points="224,-56.7 224,-75.7 432,-75.7 432,-56.7 224,-56.7"/>
 101 <text text-anchor="start" x="227" y="-62.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">...</text>
 102 <polygon fill="#ffffff" stroke="transparent" points="224,-37.7 224,-56.7 319,-56.7 319,-37.7 224,-37.7"/>
 103 <polygon fill="none" stroke="#000000" points="224,-37.7 224,-56.7 319,-56.7 319,-37.7 224,-37.7"/>
 104 <text text-anchor="start" x="227" y="-43.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">&lt; 1</text>
 105 <polygon fill="#ffffff" stroke="transparent" points="319,-37.7 319,-56.7 368,-56.7 368,-37.7 319,-37.7"/>
 106 <polygon fill="none" stroke="#000000" points="319,-37.7 319,-56.7 368,-56.7 368,-37.7 319,-37.7"/>
 107 <text text-anchor="start" x="358.8862" y="-43.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000"> &#160;</text>
 108 <polygon fill="#ffffff" stroke="transparent" points="368,-37.7 368,-56.7 432,-56.7 432,-37.7 368,-37.7"/>
 109 <polygon fill="none" stroke="#000000" points="368,-37.7 368,-56.7 432,-56.7 432,-37.7 368,-37.7"/>
 110 <text text-anchor="start" x="407.2904" y="-43.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">14 &gt;</text>
 111 </a>
 112 </g>
 113 </g>
 114 <!-- external_procedures&#45;&gt;form_encounter -->
 115 <g id="edge1" class="edge">
 116 <title>external_procedures:w&#45;&gt;form_encounter:e</title>
 117 <path fill="none" stroke="#000000" d="M468.9998,-143.835C452.6631,-129.219 461.5478,-86.7 432,-86.7"/>
 118 <polygon fill="#000000" stroke="#000000" points="475.4433,-146.074 481.8183,-152.1005 479.2216,-147.387 483,-148.7 483,-148.7 483,-148.7 479.2216,-147.387 484.1817,-145.2995 475.4433,-146.074 475.4433,-146.074"/>
 119 <ellipse fill="none" stroke="#000000" cx="472.4206" cy="-145.0236" rx="3.2" ry="3.2"/>
 120 </g>
 121 <!-- patient_data -->
 122 <g id="node3" class="node">
 123 <title>patient_data</title>
 124 <g id="a_node3"><a xlink:href="../../tables/patient_data.html" xlink:title="patient_data" target="_top">
 125 <polygon fill="#ffffff" stroke="transparent" points="8,-78.2 8,-315.2 175,-315.2 175,-78.2 8,-78.2"/>
 126 <polygon fill="#f5f5f5" stroke="transparent" points="8.5,-291.7 8.5,-314.7 175.5,-314.7 175.5,-291.7 8.5,-291.7"/>
 127 <polygon fill="none" stroke="#000000" points="8.5,-291.7 8.5,-314.7 175.5,-314.7 175.5,-291.7 8.5,-291.7"/>
 128 <text text-anchor="start" x="13.5" y="-300.3" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00" fill="#000000">patient_data</text>
 129 <text text-anchor="start" x="140.5437" y="-299.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">[table]</text>
 130 <polygon fill="#ffffff" stroke="transparent" points="8.5,-269.7 8.5,-291.7 175.5,-291.7 175.5,-269.7 8.5,-269.7"/>
 131 <polygon fill="none" stroke="#000000" points="8.5,-269.7 8.5,-291.7 175.5,-291.7 175.5,-269.7 8.5,-269.7"/>
 132 <text text-anchor="start" x="28.5" y="-276.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">id</text>
 133 <polygon fill="#ffffff" stroke="transparent" points="8.5,-247.7 8.5,-269.7 175.5,-269.7 175.5,-247.7 8.5,-247.7"/>
 134 <polygon fill="none" stroke="#000000" points="8.5,-247.7 8.5,-269.7 175.5,-269.7 175.5,-247.7 8.5,-247.7"/>
 135 <text text-anchor="start" x="28.5" y="-254.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">uuid</text>
 136 <polygon fill="none" stroke="#000000" points="8.5,-225.7 8.5,-247.7 175.5,-247.7 175.5,-225.7 8.5,-225.7"/>
 137 <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-242.7"/>
 138 <text text-anchor="start" x="28.5" y="-232.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">pharmacy_id</text>
 139 <polygon fill="none" stroke="#000000" points="8.5,-203.7 8.5,-225.7 175.5,-225.7 175.5,-203.7 8.5,-203.7"/>
 140 <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-220.7"/>
 141 <text text-anchor="start" x="28.5" y="-210.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">providerID</text>
 142 <polygon fill="none" stroke="#000000" points="8.5,-181.7 8.5,-203.7 175.5,-203.7 175.5,-181.7 8.5,-181.7"/>
 143 <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-198.7"/>
 144 <text text-anchor="start" x="28.5" y="-188.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">ref_providerID</text>
 145 <polygon fill="none" stroke="#000000" points="8.5,-159.7 8.5,-181.7 175.5,-181.7 175.5,-159.7 8.5,-159.7"/>
 146 <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-176.7"/>
 147 <text text-anchor="start" x="28.5" y="-166.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">pid</text>
 148 <polygon fill="none" stroke="#000000" points="8.5,-137.7 8.5,-159.7 175.5,-159.7 175.5,-137.7 8.5,-137.7"/>
 149 <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-154.7"/>
 150 <text text-anchor="start" x="28.5" y="-144.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">created_by</text>
 151 <polygon fill="none" stroke="#000000" points="8.5,-115.7 8.5,-137.7 175.5,-137.7 175.5,-115.7 8.5,-115.7"/>
 152 <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-132.7"/>
 153 <text text-anchor="start" x="28.5" y="-122.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">updated_by</text>
 154 <polygon fill="none" stroke="#000000" points="8.5,-96.7 8.5,-115.7 175.5,-115.7 175.5,-96.7 8.5,-96.7"/>
 155 <text text-anchor="start" x="11.5" y="-102.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">...</text>
 156 <polygon fill="#ffffff" stroke="transparent" points="8.5,-77.7 8.5,-96.7 82.5,-96.7 82.5,-77.7 8.5,-77.7"/>
 157 <polygon fill="none" stroke="#000000" points="8.5,-77.7 8.5,-96.7 82.5,-96.7 82.5,-77.7 8.5,-77.7"/>
 158 <text text-anchor="start" x="11.5" y="-83.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">&lt; 5</text>
 159 <polygon fill="#ffffff" stroke="transparent" points="82.5,-77.7 82.5,-96.7 121.5,-96.7 121.5,-77.7 82.5,-77.7"/>
 160 <polygon fill="none" stroke="#000000" points="82.5,-77.7 82.5,-96.7 121.5,-96.7 121.5,-77.7 82.5,-77.7"/>
 161 <text text-anchor="start" x="112.3862" y="-83.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000"> &#160;</text>
 162 <polygon fill="#ffffff" stroke="transparent" points="121.5,-77.7 121.5,-96.7 175.5,-96.7 175.5,-77.7 121.5,-77.7"/>
 163 <polygon fill="none" stroke="#000000" points="121.5,-77.7 121.5,-96.7 175.5,-96.7 175.5,-77.7 121.5,-77.7"/>
 164 <text text-anchor="start" x="150.7904" y="-83.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">85 &gt;</text>
 165 </a>
 166 </g>
 167 </g>
 168 <!-- external_procedures&#45;&gt;patient_data -->
 169 <g id="edge2" class="edge">
 170 <title>external_procedures:w&#45;&gt;patient_data:e</title>
 171 <path fill="none" stroke="#000000" d="M469.082,-175.3677C457.5819,-185.7071 460.6199,-210.3613 440,-219.7 349.3118,-260.7726 306.0712,-262.1085 216,-219.7 190.4379,-207.6645 203.7537,-170.7 175.5,-170.7"/>
 172 <polygon fill="#000000" stroke="#000000" points="475.4152,-173.2438 484.1447,-174.1132 479.2076,-171.9719 483,-170.7 483,-170.7 483,-170.7 479.2076,-171.9719 481.8553,-167.2868 475.4152,-173.2438 475.4152,-173.2438"/>
 173 <ellipse fill="none" stroke="#000000" cx="472.3813" cy="-174.2613" rx="3.2" ry="3.2"/>
 174 </g>
 175 <!-- form_encounter&#45;&gt;patient_data -->
 176 <g id="edge3" class="edge">
 177 <title>form_encounter:w&#45;&gt;patient_data:e</title>
 178 <path fill="none" stroke="#000000" d="M210.3908,-113.565C194.7276,-128.181 204.472,-170.7 175.5,-170.7"/>
 179 <polygon fill="#000000" stroke="#000000" points="216.4669,-111.393 225.2118,-112.0899 220.2334,-110.0465 224,-108.7 224,-108.7 224,-108.7 220.2334,-110.0465 222.7882,-105.3101 216.4669,-111.393 216.4669,-111.393"/>
 180 <ellipse fill="none" stroke="#000000" cx="213.4536" cy="-112.4702" rx="3.2" ry="3.2"/>
 181 </g>
 182 </g>
 183 </svg>