Documentation/EHI_Export/docs/diagrams/tables/patient_reminders.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="640pt" height="475pt"
   8  viewBox="0.00 0.00 640.00 475.37" 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 471.3687)">
  10 <title>oneDegreeRelationshipsDiagram</title>
  11 <polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-471.3687 636,-471.3687 636,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 <!-- patient_reminders -->
  14 <g id="node1" class="node">
  15 <title>patient_reminders</title>
  16 <g id="a_node1"><a xlink:href="../../tables/patient_reminders.html" xlink:title="patient_reminders" target="_top">
  17 <polygon fill="#ffffff" stroke="transparent" points="405,-48.7 405,-402.7 624,-402.7 624,-48.7 405,-48.7"/>
  18 <polygon fill="#f5f5f5" stroke="transparent" points="407.5,-377.7 407.5,-400.7 622.5,-400.7 622.5,-377.7 407.5,-377.7"/>
  19 <polygon fill="none" stroke="#000000" points="407.5,-377.7 407.5,-400.7 622.5,-400.7 622.5,-377.7 407.5,-377.7"/>
  20 <text text-anchor="start" x="412.5" y="-386.3" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00" fill="#000000">patient_reminders</text>
  21 <text text-anchor="start" x="587.5437" y="-385.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">[table]</text>
  22 <polygon fill="none" stroke="#000000" points="407.5,-355.7 407.5,-377.7 556.5,-377.7 556.5,-355.7 407.5,-355.7"/>
  23 <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="412.5" y="-372.7"/>
  24 <text text-anchor="start" x="427.5" y="-362.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">id</text>
  25 <polygon fill="none" stroke="#000000" points="556.5,-355.7 556.5,-377.7 622.5,-377.7 622.5,-355.7 556.5,-355.7"/>
  26 <text text-anchor="start" x="559.5" y="-363.4" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">bigint[19]</text>
  27 <polygon fill="none" stroke="#000000" points="407.5,-333.7 407.5,-355.7 556.5,-355.7 556.5,-333.7 407.5,-333.7"/>
  28 <text text-anchor="start" x="427.5" y="-340.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">active</text>
  29 <polygon fill="none" stroke="#000000" points="556.5,-333.7 556.5,-355.7 622.5,-355.7 622.5,-333.7 556.5,-333.7"/>
  30 <text text-anchor="start" x="559.5" y="-341.4" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">bit[1]</text>
  31 <polygon fill="none" stroke="#000000" points="407.5,-311.7 407.5,-333.7 556.5,-333.7 556.5,-311.7 407.5,-311.7"/>
  32 <text text-anchor="start" x="427.5" y="-318.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">date_inactivated</text>
  33 <polygon fill="none" stroke="#000000" points="556.5,-311.7 556.5,-333.7 622.5,-333.7 622.5,-311.7 556.5,-311.7"/>
  34 <text text-anchor="start" x="559.2401" y="-319.4" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">datetime[19]</text>
  35 <polygon fill="none" stroke="#000000" points="407.5,-289.7 407.5,-311.7 556.5,-311.7 556.5,-289.7 407.5,-289.7"/>
  36 <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="412.5" y="-306.7"/>
  37 <text text-anchor="start" x="427.5" y="-296.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">reason_inactivated</text>
  38 <polygon fill="none" stroke="#000000" points="556.5,-289.7 556.5,-311.7 622.5,-311.7 622.5,-289.7 556.5,-289.7"/>
  39 <text text-anchor="start" x="559.5" y="-297.4" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">varchar[31]</text>
  40 <polygon fill="none" stroke="#000000" points="407.5,-267.7 407.5,-289.7 556.5,-289.7 556.5,-267.7 407.5,-267.7"/>
  41 <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="412.5" y="-284.7"/>
  42 <text text-anchor="start" x="427.5" y="-274.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">due_status</text>
  43 <polygon fill="none" stroke="#000000" points="556.5,-267.7 556.5,-289.7 622.5,-289.7 622.5,-267.7 556.5,-267.7"/>
  44 <text text-anchor="start" x="559.5" y="-275.4" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">varchar[31]</text>
  45 <polygon fill="#ffffff" stroke="transparent" points="407.5,-245.7 407.5,-267.7 556.5,-267.7 556.5,-245.7 407.5,-245.7"/>
  46 <polygon fill="none" stroke="#000000" points="407.5,-245.7 407.5,-267.7 556.5,-267.7 556.5,-245.7 407.5,-245.7"/>
  47 <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="412.5" y="-262.7"/>
  48 <text text-anchor="start" x="427.5" y="-252.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">pid</text>
  49 <polygon fill="none" stroke="#000000" points="556.5,-245.7 556.5,-267.7 622.5,-267.7 622.5,-245.7 556.5,-245.7"/>
  50 <text text-anchor="start" x="559.5" y="-253.4" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">bigint[19]</text>
  51 <polygon fill="#ffffff" stroke="transparent" points="407.5,-223.7 407.5,-245.7 556.5,-245.7 556.5,-223.7 407.5,-223.7"/>
  52 <polygon fill="none" stroke="#000000" points="407.5,-223.7 407.5,-245.7 556.5,-245.7 556.5,-223.7 407.5,-223.7"/>
  53 <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="412.5" y="-240.7"/>
  54 <text text-anchor="start" x="427.5" y="-230.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">category</text>
  55 <polygon fill="none" stroke="#000000" points="556.5,-223.7 556.5,-245.7 622.5,-245.7 622.5,-223.7 556.5,-223.7"/>
  56 <text text-anchor="start" x="559.5" y="-231.4" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">varchar[31]</text>
  57 <polygon fill="#ffffff" stroke="transparent" points="407.5,-201.7 407.5,-223.7 556.5,-223.7 556.5,-201.7 407.5,-201.7"/>
  58 <polygon fill="none" stroke="#000000" points="407.5,-201.7 407.5,-223.7 556.5,-223.7 556.5,-201.7 407.5,-201.7"/>
  59 <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="412.5" y="-218.7"/>
  60 <text text-anchor="start" x="427.5" y="-208.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">item</text>
  61 <polygon fill="none" stroke="#000000" points="556.5,-201.7 556.5,-223.7 622.5,-223.7 622.5,-201.7 556.5,-201.7"/>
  62 <text text-anchor="start" x="559.5" y="-209.4" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">varchar[31]</text>
  63 <polygon fill="none" stroke="#000000" points="407.5,-179.7 407.5,-201.7 556.5,-201.7 556.5,-179.7 407.5,-179.7"/>
  64 <text text-anchor="start" x="427.5" y="-186.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">date_created</text>
  65 <polygon fill="none" stroke="#000000" points="556.5,-179.7 556.5,-201.7 622.5,-201.7 622.5,-179.7 556.5,-179.7"/>
  66 <text text-anchor="start" x="559.2401" y="-187.4" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">datetime[19]</text>
  67 <polygon fill="none" stroke="#000000" points="407.5,-157.7 407.5,-179.7 556.5,-179.7 556.5,-157.7 407.5,-157.7"/>
  68 <text text-anchor="start" x="427.5" y="-164.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">date_sent</text>
  69 <polygon fill="none" stroke="#000000" points="556.5,-157.7 556.5,-179.7 622.5,-179.7 622.5,-157.7 556.5,-157.7"/>
  70 <text text-anchor="start" x="559.2401" y="-165.4" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">datetime[19]</text>
  71 <polygon fill="none" stroke="#000000" points="407.5,-135.7 407.5,-157.7 556.5,-157.7 556.5,-135.7 407.5,-135.7"/>
  72 <text text-anchor="start" x="427.5" y="-142.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">voice_status</text>
  73 <polygon fill="none" stroke="#000000" points="556.5,-135.7 556.5,-157.7 622.5,-157.7 622.5,-135.7 556.5,-135.7"/>
  74 <text text-anchor="start" x="559.5" y="-143.4" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">bit[1]</text>
  75 <polygon fill="none" stroke="#000000" points="407.5,-113.7 407.5,-135.7 556.5,-135.7 556.5,-113.7 407.5,-113.7"/>
  76 <text text-anchor="start" x="427.5" y="-120.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">sms_status</text>
  77 <polygon fill="none" stroke="#000000" points="556.5,-113.7 556.5,-135.7 622.5,-135.7 622.5,-113.7 556.5,-113.7"/>
  78 <text text-anchor="start" x="559.5" y="-121.4" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">bit[1]</text>
  79 <polygon fill="none" stroke="#000000" points="407.5,-91.7 407.5,-113.7 556.5,-113.7 556.5,-91.7 407.5,-91.7"/>
  80 <text text-anchor="start" x="427.5" y="-98.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">email_status</text>
  81 <polygon fill="none" stroke="#000000" points="556.5,-91.7 556.5,-113.7 622.5,-113.7 622.5,-91.7 556.5,-91.7"/>
  82 <text text-anchor="start" x="559.5" y="-99.4" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">bit[1]</text>
  83 <polygon fill="none" stroke="#000000" points="407.5,-69.7 407.5,-91.7 556.5,-91.7 556.5,-69.7 407.5,-69.7"/>
  84 <text text-anchor="start" x="427.5" y="-76.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">mail_status</text>
  85 <polygon fill="none" stroke="#000000" points="556.5,-69.7 556.5,-91.7 622.5,-91.7 622.5,-69.7 556.5,-69.7"/>
  86 <text text-anchor="start" x="559.5" y="-77.4" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">bit[1]</text>
  87 <polygon fill="#ffffff" stroke="transparent" points="407.5,-50.7 407.5,-69.7 486.5,-69.7 486.5,-50.7 407.5,-50.7"/>
  88 <polygon fill="none" stroke="#000000" points="407.5,-50.7 407.5,-69.7 486.5,-69.7 486.5,-50.7 407.5,-50.7"/>
  89 <text text-anchor="start" x="410.5" y="-56.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">&lt; 5</text>
  90 <polygon fill="#ffffff" stroke="transparent" points="486.5,-50.7 486.5,-69.7 556.5,-69.7 556.5,-50.7 486.5,-50.7"/>
  91 <polygon fill="none" stroke="#000000" points="486.5,-50.7 486.5,-69.7 556.5,-69.7 556.5,-50.7 486.5,-50.7"/>
  92 <text text-anchor="start" x="547.3862" y="-56.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000"> &#160;</text>
  93 <polygon fill="#ffffff" stroke="transparent" points="556.5,-50.7 556.5,-69.7 622.5,-69.7 622.5,-50.7 556.5,-50.7"/>
  94 <polygon fill="none" stroke="#000000" points="556.5,-50.7 556.5,-69.7 622.5,-69.7 622.5,-50.7 556.5,-50.7"/>
  95 <text text-anchor="start" x="603.9053" y="-56.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">0 &gt;</text>
  96 <polygon fill="none" stroke="#000000" stroke-width="2" points="406,-49.7 406,-401.7 623,-401.7 623,-49.7 406,-49.7"/>
  97 </a>
  98 </g>
  99 </g>
 100 <!-- rule_action_item -->
 101 <g id="node2" class="node">
 102 <title>rule_action_item</title>
 103 <g id="a_node2"><a xlink:href="../../tables/rule_action_item.html" xlink:title="rule_action_item" target="_top">
 104 <polygon fill="#ffffff" stroke="transparent" points="197.5,-38.2 197.5,-143.2 347.5,-143.2 347.5,-38.2 197.5,-38.2"/>
 105 <polygon fill="#f5f5f5" stroke="transparent" points="197.5,-119.7 197.5,-142.7 347.5,-142.7 347.5,-119.7 197.5,-119.7"/>
 106 <polygon fill="none" stroke="#000000" points="197.5,-119.7 197.5,-142.7 347.5,-142.7 347.5,-119.7 197.5,-119.7"/>
 107 <text text-anchor="start" x="202.5" y="-128.3" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00" fill="#000000">rule_action_item</text>
 108 <text text-anchor="start" x="313.0219" y="-127.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">[table]</text>
 109 <polygon fill="none" stroke="#000000" points="197.5,-97.7 197.5,-119.7 347.5,-119.7 347.5,-97.7 197.5,-97.7"/>
 110 <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="202.5" y="-114.7"/>
 111 <text text-anchor="start" x="218.5" y="-104.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">category</text>
 112 <polygon fill="none" stroke="#000000" points="197.5,-75.7 197.5,-97.7 347.5,-97.7 347.5,-75.7 197.5,-75.7"/>
 113 <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="202.5" y="-92.7"/>
 114 <text text-anchor="start" x="218.5" y="-82.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">item</text>
 115 <polygon fill="none" stroke="#000000" points="197.5,-56.7 197.5,-75.7 347.5,-75.7 347.5,-56.7 197.5,-56.7"/>
 116 <text text-anchor="start" x="200.5" y="-62.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">...</text>
 117 <polygon fill="#ffffff" stroke="transparent" points="197.5,-37.7 197.5,-56.7 266.5,-56.7 266.5,-37.7 197.5,-37.7"/>
 118 <polygon fill="none" stroke="#000000" points="197.5,-37.7 197.5,-56.7 266.5,-56.7 266.5,-37.7 197.5,-37.7"/>
 119 <text text-anchor="start" x="200.5" y="-43.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">&lt; 2</text>
 120 <polygon fill="#ffffff" stroke="transparent" points="266.5,-37.7 266.5,-56.7 302.5,-56.7 302.5,-37.7 266.5,-37.7"/>
 121 <polygon fill="none" stroke="#000000" points="266.5,-37.7 266.5,-56.7 302.5,-56.7 302.5,-37.7 266.5,-37.7"/>
 122 <text text-anchor="start" x="293.3862" y="-43.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000"> &#160;</text>
 123 <polygon fill="#ffffff" stroke="transparent" points="302.5,-37.7 302.5,-56.7 347.5,-56.7 347.5,-37.7 302.5,-37.7"/>
 124 <polygon fill="none" stroke="#000000" points="302.5,-37.7 302.5,-56.7 347.5,-56.7 347.5,-37.7 302.5,-37.7"/>
 125 <text text-anchor="start" x="328.9053" y="-43.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">4 &gt;</text>
 126 </a>
 127 </g>
 128 </g>
 129 <!-- patient_reminders&#45;&gt;rule_action_item -->
 130 <g id="edge1" class="edge">
 131 <title>patient_reminders:w&#45;&gt;rule_action_item:e</title>
 132 <path fill="none" stroke="#000000" d="M393.1719,-231.5854C356.3762,-212.1824 403.7102,-108.7 347.5,-108.7"/>
 133 <polygon fill="#000000" stroke="#000000" points="399.6826,-233.0006 406.7353,-238.2178 403.5913,-233.8503 407.5,-234.7 407.5,-234.7 407.5,-234.7 403.5913,-233.8503 408.2647,-231.1822 399.6826,-233.0006 399.6826,-233.0006"/>
 134 <ellipse fill="none" stroke="#000000" cx="396.5556" cy="-232.3209" rx="3.2" ry="3.2"/>
 135 </g>
 136 <!-- patient_reminders&#45;&gt;rule_action_item -->
 137 <g id="edge3" class="edge">
 138 <title>patient_reminders:w&#45;&gt;rule_action_item:e</title>
 139 <path fill="none" stroke="#000000" d="M393.1719,-209.5854C356.3762,-190.1824 403.7102,-86.7 347.5,-86.7"/>
 140 <polygon fill="#000000" stroke="#000000" points="399.6826,-211.0006 406.7353,-216.2178 403.5913,-211.8503 407.5,-212.7 407.5,-212.7 407.5,-212.7 403.5913,-211.8503 408.2647,-209.1822 399.6826,-211.0006 399.6826,-211.0006"/>
 141 <ellipse fill="none" stroke="#000000" cx="396.5556" cy="-210.3209" rx="3.2" ry="3.2"/>
 142 </g>
 143 <!-- list_options -->
 144 <g id="node3" class="node">
 145 <title>list_options</title>
 146 <g id="a_node3"><a xlink:href="../../tables/list_options.html" xlink:title="list_options" target="_top">
 147 <polygon fill="#ffffff" stroke="transparent" points="8,-218.2 8,-323.2 140,-323.2 140,-218.2 8,-218.2"/>
 148 <polygon fill="#f5f5f5" stroke="transparent" points="8,-299.7 8,-322.7 140,-322.7 140,-299.7 8,-299.7"/>
 149 <polygon fill="none" stroke="#000000" points="8,-299.7 8,-322.7 140,-322.7 140,-299.7 8,-299.7"/>
 150 <text text-anchor="start" x="13" y="-308.3" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00" fill="#000000">list_options</text>
 151 <text text-anchor="start" x="105.0437" y="-307.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">[table]</text>
 152 <polygon fill="none" stroke="#000000" points="8,-277.7 8,-299.7 140,-299.7 140,-277.7 8,-277.7"/>
 153 <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-294.7"/>
 154 <text text-anchor="start" x="28" y="-284.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">list_id</text>
 155 <polygon fill="none" stroke="#000000" points="8,-255.7 8,-277.7 140,-277.7 140,-255.7 8,-255.7"/>
 156 <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-272.7"/>
 157 <text text-anchor="start" x="28" y="-262.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">option_id</text>
 158 <polygon fill="none" stroke="#000000" points="8,-236.7 8,-255.7 140,-255.7 140,-236.7 8,-236.7"/>
 159 <text text-anchor="start" x="11" y="-242.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">...</text>
 160 <polygon fill="#ffffff" stroke="transparent" points="8,-217.7 8,-236.7 60,-236.7 60,-217.7 8,-217.7"/>
 161 <polygon fill="none" stroke="#000000" points="8,-217.7 8,-236.7 60,-236.7 60,-217.7 8,-217.7"/>
 162 <text text-anchor="start" x="11" y="-223.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000"> &#160;</text>
 163 <polygon fill="#ffffff" stroke="transparent" points="60,-217.7 60,-236.7 92,-236.7 92,-217.7 60,-217.7"/>
 164 <polygon fill="none" stroke="#000000" points="60,-217.7 60,-236.7 92,-236.7 92,-217.7 60,-217.7"/>
 165 <text text-anchor="start" x="82.8862" y="-223.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000"> &#160;</text>
 166 <polygon fill="#ffffff" stroke="transparent" points="92,-217.7 92,-236.7 140,-236.7 140,-217.7 92,-217.7"/>
 167 <polygon fill="none" stroke="#000000" points="92,-217.7 92,-236.7 140,-236.7 140,-217.7 92,-217.7"/>
 168 <text text-anchor="start" x="115.2904" y="-223.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">46 &gt;</text>
 169 </a>
 170 </g>
 171 </g>
 172 <!-- patient_reminders&#45;&gt;list_options -->
 173 <g id="edge2" class="edge">
 174 <title>patient_reminders:w&#45;&gt;list_options:e</title>
 175 <path fill="none" stroke="#000000" d="M393.2622,-281.1153C357.2037,-296.2652 409.6299,-378.6156 364,-411.7 331.0768,-435.5713 213.4327,-436.2337 181,-411.7 127.5889,-371.2972 206.9712,-266.7 140,-266.7"/>
 176 <polygon fill="#000000" stroke="#000000" points="399.6127,-280.0381 408.1021,-282.2493 403.5563,-279.369 407.5,-278.7 407.5,-278.7 407.5,-278.7 403.5563,-279.369 406.8979,-275.1507 399.6127,-280.0381 399.6127,-280.0381"/>
 177 <ellipse fill="none" stroke="#000000" cx="396.4578" cy="-280.5733" rx="3.2" ry="3.2"/>
 178 </g>
 179 <!-- patient_reminders&#45;&gt;list_options -->
 180 <g id="edge5" class="edge">
 181 <title>patient_reminders:w&#45;&gt;list_options:e</title>
 182 <path fill="none" stroke="#000000" d="M393.0794,-303.2582C358.5253,-318.5775 408.618,-398.5803 364,-430.7 297.9916,-478.2184 245.1074,-480.7535 181,-430.7 121.7804,-384.4628 215.1321,-266.7 140,-266.7"/>
 183 <polygon fill="#000000" stroke="#000000" points="399.623,-302.0974 408.1288,-304.2447 403.5615,-301.3987 407.5,-300.7 407.5,-300.7 407.5,-300.7 403.5615,-301.3987 406.8712,-297.1553 399.623,-302.0974 399.623,-302.0974"/>
 184 <ellipse fill="none" stroke="#000000" cx="396.4722" cy="-302.6564" rx="3.2" ry="3.2"/>
 185 </g>
 186 <!-- patient_data -->
 187 <g id="node4" class="node">
 188 <title>patient_data</title>
 189 <g id="a_node4"><a xlink:href="../../tables/patient_data.html" xlink:title="patient_data" target="_top">
 190 <polygon fill="#ffffff" stroke="transparent" points="189,-164.2 189,-401.2 356,-401.2 356,-164.2 189,-164.2"/>
 191 <polygon fill="#f5f5f5" stroke="transparent" points="189.5,-377.7 189.5,-400.7 356.5,-400.7 356.5,-377.7 189.5,-377.7"/>
 192 <polygon fill="none" stroke="#000000" points="189.5,-377.7 189.5,-400.7 356.5,-400.7 356.5,-377.7 189.5,-377.7"/>
 193 <text text-anchor="start" x="194.5" y="-386.3" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00" fill="#000000">patient_data</text>
 194 <text text-anchor="start" x="321.5437" y="-385.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">[table]</text>
 195 <polygon fill="#ffffff" stroke="transparent" points="189.5,-355.7 189.5,-377.7 356.5,-377.7 356.5,-355.7 189.5,-355.7"/>
 196 <polygon fill="none" stroke="#000000" points="189.5,-355.7 189.5,-377.7 356.5,-377.7 356.5,-355.7 189.5,-355.7"/>
 197 <text text-anchor="start" x="209.5" y="-362.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">id</text>
 198 <polygon fill="#ffffff" stroke="transparent" points="189.5,-333.7 189.5,-355.7 356.5,-355.7 356.5,-333.7 189.5,-333.7"/>
 199 <polygon fill="none" stroke="#000000" points="189.5,-333.7 189.5,-355.7 356.5,-355.7 356.5,-333.7 189.5,-333.7"/>
 200 <text text-anchor="start" x="209.5" y="-340.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">uuid</text>
 201 <polygon fill="none" stroke="#000000" points="189.5,-311.7 189.5,-333.7 356.5,-333.7 356.5,-311.7 189.5,-311.7"/>
 202 <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="194.5" y="-328.7"/>
 203 <text text-anchor="start" x="209.5" y="-318.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">pharmacy_id</text>
 204 <polygon fill="none" stroke="#000000" points="189.5,-289.7 189.5,-311.7 356.5,-311.7 356.5,-289.7 189.5,-289.7"/>
 205 <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="194.5" y="-306.7"/>
 206 <text text-anchor="start" x="209.5" y="-296.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">providerID</text>
 207 <polygon fill="none" stroke="#000000" points="189.5,-267.7 189.5,-289.7 356.5,-289.7 356.5,-267.7 189.5,-267.7"/>
 208 <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="194.5" y="-284.7"/>
 209 <text text-anchor="start" x="209.5" y="-274.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">ref_providerID</text>
 210 <polygon fill="none" stroke="#000000" points="189.5,-245.7 189.5,-267.7 356.5,-267.7 356.5,-245.7 189.5,-245.7"/>
 211 <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="194.5" y="-262.7"/>
 212 <text text-anchor="start" x="209.5" y="-252.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">pid</text>
 213 <polygon fill="none" stroke="#000000" points="189.5,-223.7 189.5,-245.7 356.5,-245.7 356.5,-223.7 189.5,-223.7"/>
 214 <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="194.5" y="-240.7"/>
 215 <text text-anchor="start" x="209.5" y="-230.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">created_by</text>
 216 <polygon fill="none" stroke="#000000" points="189.5,-201.7 189.5,-223.7 356.5,-223.7 356.5,-201.7 189.5,-201.7"/>
 217 <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="194.5" y="-218.7"/>
 218 <text text-anchor="start" x="209.5" y="-208.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">updated_by</text>
 219 <polygon fill="none" stroke="#000000" points="189.5,-182.7 189.5,-201.7 356.5,-201.7 356.5,-182.7 189.5,-182.7"/>
 220 <text text-anchor="start" x="192.5" y="-188.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">...</text>
 221 <polygon fill="#ffffff" stroke="transparent" points="189.5,-163.7 189.5,-182.7 263.5,-182.7 263.5,-163.7 189.5,-163.7"/>
 222 <polygon fill="none" stroke="#000000" points="189.5,-163.7 189.5,-182.7 263.5,-182.7 263.5,-163.7 189.5,-163.7"/>
 223 <text text-anchor="start" x="192.5" y="-169.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">&lt; 5</text>
 224 <polygon fill="#ffffff" stroke="transparent" points="263.5,-163.7 263.5,-182.7 302.5,-182.7 302.5,-163.7 263.5,-163.7"/>
 225 <polygon fill="none" stroke="#000000" points="263.5,-163.7 263.5,-182.7 302.5,-182.7 302.5,-163.7 263.5,-163.7"/>
 226 <text text-anchor="start" x="293.3862" y="-169.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000"> &#160;</text>
 227 <polygon fill="#ffffff" stroke="transparent" points="302.5,-163.7 302.5,-182.7 356.5,-182.7 356.5,-163.7 302.5,-163.7"/>
 228 <polygon fill="none" stroke="#000000" points="302.5,-163.7 302.5,-182.7 356.5,-182.7 356.5,-163.7 302.5,-163.7"/>
 229 <text text-anchor="start" x="331.7904" y="-169.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">85 &gt;</text>
 230 </a>
 231 </g>
 232 </g>
 233 <!-- patient_reminders&#45;&gt;patient_data -->
 234 <g id="edge4" class="edge">
 235 <title>patient_reminders:w&#45;&gt;patient_data:e</title>
 236 <path fill="none" stroke="#000000" d="M392.776,-256.7C380.7815,-256.7 373.3229,-256.7 356.5,-256.7"/>
 237 <polygon fill="#000000" stroke="#000000" points="399.5,-256.7001 407.5,-260.3 403.5,-256.7 407.5,-256.7 407.5,-256.7 407.5,-256.7 403.5,-256.7 407.5,-253.1 399.5,-256.7001 399.5,-256.7001"/>
 238 <ellipse fill="none" stroke="#000000" cx="396.3" cy="-256.7001" rx="3.2" ry="3.2"/>
 239 </g>
 240 <!-- rule_action_item&#45;&gt;list_options -->
 241 <g id="edge6" class="edge">
 242 <title>rule_action_item:w&#45;&gt;list_options:e</title>
 243 <path fill="none" stroke="#000000" d="M183.1776,-111.3106C135.8139,-131.8536 209.0357,-266.7 140,-266.7"/>
 244 <polygon fill="#000000" stroke="#000000" points="189.6297,-110.1346 198.1456,-112.2416 193.5648,-109.4173 197.5,-108.7 197.5,-108.7 197.5,-108.7 193.5648,-109.4173 196.8544,-105.1584 189.6297,-110.1346 189.6297,-110.1346"/>
 245 <ellipse fill="none" stroke="#000000" cx="186.4815" cy="-110.7084" rx="3.2" ry="3.2"/>
 246 </g>
 247 <!-- rule_action_item&#45;&gt;list_options -->
 248 <g id="edge7" class="edge">
 249 <title>rule_action_item:w&#45;&gt;list_options:e</title>
 250 <path fill="none" stroke="#000000" d="M183.2276,-88.9759C127.331,-109.8125 218.4057,-266.7 140,-266.7"/>
 251 <polygon fill="#000000" stroke="#000000" points="189.5998,-87.9598 198.0669,-90.2551 193.5499,-87.3299 197.5,-86.7 197.5,-86.7 197.5,-86.7 193.5499,-87.3299 196.9331,-83.1449 189.5998,-87.9598 189.5998,-87.9598"/>
 252 <ellipse fill="none" stroke="#000000" cx="186.4397" cy="-88.4637" rx="3.2" ry="3.2"/>
 253 </g>
 254 </g>
 255 </svg>