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)
6 <!-- Title: oneDegreeRelationshipsDiagram Pages: 1 -->
7 <svg width=
"831pt" height=
"521pt"
8 viewBox=
"0.00 0.00 831.00 520.70" 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 516.7)">
10 <title>oneDegreeRelationshipsDiagram
</title>
11 <polygon fill=
"#ffffff" stroke=
"transparent" points=
"-4,4 -4,-516.7 827,-516.7 827,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>
14 <g id=
"node1" class=
"node">
15 <title>form_painmap
</title>
16 <g id=
"a_node1"><a xlink:
href=
"../../tables/form_painmap.html" xlink:
title=
"form_painmap" target=
"_top">
17 <polygon fill=
"#ffffff" stroke=
"transparent" points=
"627,-107.2 627,-329.2 815,-329.2 815,-107.2 627,-107.2"/>
18 <polygon fill=
"#f5f5f5" stroke=
"transparent" points=
"629,-304.2 629,-327.2 813,-327.2 813,-304.2 629,-304.2"/>
19 <polygon fill=
"none" stroke=
"#000000" points=
"629,-304.2 629,-327.2 813,-327.2 813,-304.2 629,-304.2"/>
20 <text text-anchor=
"start" x=
"634" y=
"-312.8" font-family=
"Helvetica,sans-Serif" font-weight=
"bold" font-size=
"11.00" fill=
"#000000">form_painmap
</text>
21 <text text-anchor=
"start" x=
"778.0437" y=
"-312.3" font-family=
"Helvetica,sans-Serif" font-size=
"11.00" fill=
"#000000">[table]
</text>
22 <polygon fill=
"none" stroke=
"#000000" points=
"629,-282.2 629,-304.2 746,-304.2 746,-282.2 629,-282.2"/>
23 <image xlink:
href=
"../../images/primaryKeys.png" width=
"11px" height=
"12px" preserveAspectRatio=
"xMinYMin meet" x=
"634" y=
"-299.2"/>
24 <text text-anchor=
"start" x=
"649" y=
"-289.3" font-family=
"Helvetica,sans-Serif" font-size=
"11.00" fill=
"#000000">id
</text>
25 <polygon fill=
"none" stroke=
"#000000" points=
"746,-282.2 746,-304.2 813,-304.2 813,-282.2 746,-282.2"/>
26 <text text-anchor=
"start" x=
"749" y=
"-289.9" font-family=
"Helvetica,sans-Serif" font-size=
"11.00" fill=
"#000000">bigint[
19]
</text>
27 <polygon fill=
"none" stroke=
"#000000" points=
"629,-260.2 629,-282.2 746,-282.2 746,-260.2 629,-260.2"/>
28 <text text-anchor=
"start" x=
"649" y=
"-267.3" font-family=
"Helvetica,sans-Serif" font-size=
"11.00" fill=
"#000000">date
</text>
29 <polygon fill=
"none" stroke=
"#000000" points=
"746,-260.2 746,-282.2 813,-282.2 813,-260.2 746,-260.2"/>
30 <text text-anchor=
"start" x=
"749" y=
"-267.9" font-family=
"Helvetica,sans-Serif" font-size=
"11.00" fill=
"#000000">datetime[
19]
</text>
31 <polygon fill=
"none" stroke=
"#000000" points=
"629,-238.2 629,-260.2 746,-260.2 746,-238.2 629,-238.2"/>
32 <image xlink:
href=
"../../images/foreignKeys.png" width=
"11px" height=
"12px" preserveAspectRatio=
"xMinYMin meet" x=
"634" y=
"-255.2"/>
33 <text text-anchor=
"start" x=
"649" y=
"-245.3" font-family=
"Helvetica,sans-Serif" font-size=
"11.00" fill=
"#000000">pid
</text>
34 <polygon fill=
"none" stroke=
"#000000" points=
"746,-238.2 746,-260.2 813,-260.2 813,-238.2 746,-238.2"/>
35 <text text-anchor=
"start" x=
"749" y=
"-245.9" font-family=
"Helvetica,sans-Serif" font-size=
"11.00" fill=
"#000000">bigint[
19]
</text>
36 <polygon fill=
"none" stroke=
"#000000" points=
"629,-216.2 629,-238.2 746,-238.2 746,-216.2 629,-216.2"/>
37 <image xlink:
href=
"../../images/foreignKeys.png" width=
"11px" height=
"12px" preserveAspectRatio=
"xMinYMin meet" x=
"634" y=
"-233.2"/>
38 <text text-anchor=
"start" x=
"649" y=
"-223.3" font-family=
"Helvetica,sans-Serif" font-size=
"11.00" fill=
"#000000">user
</text>
39 <polygon fill=
"none" stroke=
"#000000" points=
"746,-216.2 746,-238.2 813,-238.2 813,-216.2 746,-216.2"/>
40 <text text-anchor=
"start" x=
"748.9365" y=
"-223.9" font-family=
"Helvetica,sans-Serif" font-size=
"11.00" fill=
"#000000">varchar[
255]
</text>
41 <polygon fill=
"none" stroke=
"#000000" points=
"629,-194.2 629,-216.2 746,-216.2 746,-194.2 629,-194.2"/>
42 <image xlink:
href=
"../../images/foreignKeys.png" width=
"11px" height=
"12px" preserveAspectRatio=
"xMinYMin meet" x=
"634" y=
"-211.2"/>
43 <text text-anchor=
"start" x=
"649" y=
"-201.3" font-family=
"Helvetica,sans-Serif" font-size=
"11.00" fill=
"#000000">groupname
</text>
44 <polygon fill=
"none" stroke=
"#000000" points=
"746,-194.2 746,-216.2 813,-216.2 813,-194.2 746,-194.2"/>
45 <text text-anchor=
"start" x=
"748.9365" y=
"-201.9" font-family=
"Helvetica,sans-Serif" font-size=
"11.00" fill=
"#000000">varchar[
255]
</text>
46 <polygon fill=
"none" stroke=
"#000000" points=
"629,-172.2 629,-194.2 746,-194.2 746,-172.2 629,-172.2"/>
47 <text text-anchor=
"start" x=
"649" y=
"-179.3" font-family=
"Helvetica,sans-Serif" font-size=
"11.00" fill=
"#000000">authorized
</text>
48 <polygon fill=
"none" stroke=
"#000000" points=
"746,-172.2 746,-194.2 813,-194.2 813,-172.2 746,-172.2"/>
49 <text text-anchor=
"start" x=
"749" y=
"-179.9" font-family=
"Helvetica,sans-Serif" font-size=
"11.00" fill=
"#000000">tinyint[
3]
</text>
50 <polygon fill=
"none" stroke=
"#000000" points=
"629,-150.2 629,-172.2 746,-172.2 746,-150.2 629,-150.2"/>
51 <text text-anchor=
"start" x=
"649" y=
"-157.3" font-family=
"Helvetica,sans-Serif" font-size=
"11.00" fill=
"#000000">activity
</text>
52 <polygon fill=
"none" stroke=
"#000000" points=
"746,-150.2 746,-172.2 813,-172.2 813,-150.2 746,-150.2"/>
53 <text text-anchor=
"start" x=
"749" y=
"-157.9" font-family=
"Helvetica,sans-Serif" font-size=
"11.00" fill=
"#000000">tinyint[
3]
</text>
54 <polygon fill=
"none" stroke=
"#000000" points=
"629,-128.2 629,-150.2 746,-150.2 746,-128.2 629,-128.2"/>
55 <text text-anchor=
"start" x=
"649" y=
"-135.3" font-family=
"Helvetica,sans-Serif" font-size=
"11.00" fill=
"#000000">data
</text>
56 <polygon fill=
"none" stroke=
"#000000" points=
"746,-128.2 746,-150.2 813,-150.2 813,-128.2 746,-128.2"/>
57 <text text-anchor=
"start" x=
"749" y=
"-135.9" font-family=
"Helvetica,sans-Serif" font-size=
"11.00" fill=
"#000000">text[
65535]
</text>
58 <polygon fill=
"#ffffff" stroke=
"transparent" points=
"629,-109.2 629,-128.2 692,-128.2 692,-109.2 629,-109.2"/>
59 <polygon fill=
"none" stroke=
"#000000" points=
"629,-109.2 629,-128.2 692,-128.2 692,-109.2 629,-109.2"/>
60 <text text-anchor=
"start" x=
"632" y=
"-115.3" font-family=
"Helvetica,sans-Serif" font-size=
"11.00" fill=
"#000000">< 4</text>
61 <polygon fill=
"#ffffff" stroke=
"transparent" points=
"692,-109.2 692,-128.2 746,-128.2 746,-109.2 692,-109.2"/>
62 <polygon fill=
"none" stroke=
"#000000" points=
"692,-109.2 692,-128.2 746,-128.2 746,-109.2 692,-109.2"/>
63 <text text-anchor=
"start" x=
"736.8862" y=
"-115.3" font-family=
"Helvetica,sans-Serif" font-size=
"11.00" fill=
"#000000">  </text>
64 <polygon fill=
"#ffffff" stroke=
"transparent" points=
"746,-109.2 746,-128.2 813,-128.2 813,-109.2 746,-109.2"/>
65 <polygon fill=
"none" stroke=
"#000000" points=
"746,-109.2 746,-128.2 813,-128.2 813,-109.2 746,-109.2"/>
66 <text text-anchor=
"start" x=
"794.4053" y=
"-115.3" font-family=
"Helvetica,sans-Serif" font-size=
"11.00" fill=
"#000000">0 ></text>
67 <polygon fill=
"none" stroke=
"#000000" stroke-width=
"2" points=
"628,-108.2 628,-328.2 814,-328.2 814,-108.2 628,-108.2"/>
72 <g id=
"node2" class=
"node">
74 <g id=
"a_node2"><a xlink:
href=
"../../tables/groups.html" xlink:
title=
"groups" target=
"_top">
75 <polygon fill=
"#ffffff" stroke=
"transparent" points=
"264.5,-38.2 264.5,-146.2 350.5,-146.2 350.5,-38.2 264.5,-38.2"/>
76 <polygon fill=
"#f5f5f5" stroke=
"transparent" points=
"264.5,-123.2 264.5,-146.2 350.5,-146.2 350.5,-123.2 264.5,-123.2"/>
77 <polygon fill=
"none" stroke=
"#000000" points=
"264.5,-123.2 264.5,-146.2 350.5,-146.2 350.5,-123.2 264.5,-123.2"/>
78 <text text-anchor=
"start" x=
"269.5" y=
"-131.8" font-family=
"Helvetica,sans-Serif" font-weight=
"bold" font-size=
"11.00" fill=
"#000000">groups
</text>
79 <text text-anchor=
"start" x=
"316.0219" y=
"-131.3" font-family=
"Helvetica,sans-Serif" font-size=
"11.00" fill=
"#000000">[table]
</text>
80 <polygon fill=
"none" stroke=
"#000000" points=
"264.5,-101.2 264.5,-123.2 350.5,-123.2 350.5,-101.2 264.5,-101.2"/>
81 <image xlink:
href=
"../../images/primaryKeys.png" width=
"11px" height=
"12px" preserveAspectRatio=
"xMinYMin meet" x=
"269.5" y=
"-118.2"/>
82 <text text-anchor=
"start" x=
"293.5" y=
"-108.3" font-family=
"Helvetica,sans-Serif" font-size=
"11.00" fill=
"#000000">id
</text>
83 <polygon fill=
"none" stroke=
"#000000" points=
"264.5,-79.2 264.5,-101.2 350.5,-101.2 350.5,-79.2 264.5,-79.2"/>
84 <image xlink:
href=
"../../images/primaryKeys.png" width=
"11px" height=
"12px" preserveAspectRatio=
"xMinYMin meet" x=
"269.5" y=
"-96.2"/>
85 <text text-anchor=
"start" x=
"293.5" y=
"-86.3" font-family=
"Helvetica,sans-Serif" font-size=
"11.00" fill=
"#000000">name
</text>
86 <polygon fill=
"none" stroke=
"#000000" points=
"264.5,-57.2 264.5,-79.2 350.5,-79.2 350.5,-57.2 264.5,-57.2"/>
87 <image xlink:
href=
"../../images/foreignKeys.png" width=
"11px" height=
"12px" preserveAspectRatio=
"xMinYMin meet" x=
"269.5" y=
"-74.2"/>
88 <text text-anchor=
"start" x=
"293.5" y=
"-64.3" font-family=
"Helvetica,sans-Serif" font-size=
"11.00" fill=
"#000000">user
</text>
89 <polygon fill=
"#ffffff" stroke=
"transparent" points=
"264.5,-38.2 264.5,-57.2 298.5,-57.2 298.5,-38.2 264.5,-38.2"/>
90 <polygon fill=
"none" stroke=
"#000000" points=
"264.5,-38.2 264.5,-57.2 298.5,-57.2 298.5,-38.2 264.5,-38.2"/>
91 <text text-anchor=
"start" x=
"267.5" y=
"-44.3" font-family=
"Helvetica,sans-Serif" font-size=
"11.00" fill=
"#000000">< 1</text>
92 <polygon fill=
"#ffffff" stroke=
"transparent" points=
"298.5,-38.2 298.5,-57.2 316.5,-57.2 316.5,-38.2 298.5,-38.2"/>
93 <polygon fill=
"none" stroke=
"#000000" points=
"298.5,-38.2 298.5,-57.2 316.5,-57.2 316.5,-38.2 298.5,-38.2"/>
94 <text text-anchor=
"start" x=
"307.3862" y=
"-44.3" font-family=
"Helvetica,sans-Serif" font-size=
"11.00" fill=
"#000000">  </text>
95 <polygon fill=
"#ffffff" stroke=
"transparent" points=
"316.5,-38.2 316.5,-57.2 350.5,-57.2 350.5,-38.2 316.5,-38.2"/>
96 <polygon fill=
"none" stroke=
"#000000" points=
"316.5,-38.2 316.5,-57.2 350.5,-57.2 350.5,-38.2 316.5,-38.2"/>
97 <text text-anchor=
"start" x=
"325.7904" y=
"-44.3" font-family=
"Helvetica,sans-Serif" font-size=
"11.00" fill=
"#000000">17 ></text>
101 <!-- form_painmap->groups -->
102 <g id=
"edge1" class=
"edge">
103 <title>form_painmap:w
->groups:e
</title>
104 <path fill=
"none" stroke=
"#000000" d=
"M615.1195,-201.135C601.6225,-190.6001 607.3176,-162.2578 586,-148.2 496.0109,-88.8572 458.2943,-90.2 350.5,-90.2"/>
105 <polygon fill=
"#000000" stroke=
"#000000" points=
"621.3225,-202.9516 627.9882,-208.6549 625.1612,-204.0758 629,-205.2 629,-205.2 629,-205.2 625.1612,-204.0758 630.0118,-201.7451 621.3225,-202.9516 621.3225,-202.9516"/>
106 <ellipse fill=
"none" stroke=
"#000000" cx=
"618.2514" cy=
"-202.0522" rx=
"3.2" ry=
"3.2"/>
109 <g id=
"node3" class=
"node">
111 <g id=
"a_node3"><a xlink:
href=
"../../tables/forms.html" xlink:
title=
"forms" target=
"_top">
112 <polygon fill=
"#ffffff" stroke=
"transparent" points=
"440,-182.7 440,-441.7 578,-441.7 578,-182.7 440,-182.7"/>
113 <polygon fill=
"#f5f5f5" stroke=
"transparent" points=
"440,-418.2 440,-441.2 578,-441.2 578,-418.2 440,-418.2"/>
114 <polygon fill=
"none" stroke=
"#000000" points=
"440,-418.2 440,-441.2 578,-441.2 578,-418.2 440,-418.2"/>
115 <text text-anchor=
"start" x=
"445" y=
"-426.8" font-family=
"Helvetica,sans-Serif" font-weight=
"bold" font-size=
"11.00" fill=
"#000000">forms
</text>
116 <text text-anchor=
"start" x=
"543.0437" y=
"-426.3" font-family=
"Helvetica,sans-Serif" font-size=
"11.00" fill=
"#000000">[table]
</text>
117 <polygon fill=
"none" stroke=
"#000000" points=
"440,-396.2 440,-418.2 578,-418.2 578,-396.2 440,-396.2"/>
118 <image xlink:
href=
"../../images/primaryKeys.png" width=
"11px" height=
"12px" preserveAspectRatio=
"xMinYMin meet" x=
"445" y=
"-413.2"/>
119 <text text-anchor=
"start" x=
"460" y=
"-403.3" font-family=
"Helvetica,sans-Serif" font-size=
"11.00" fill=
"#000000">id
</text>
120 <polygon fill=
"#ffffff" stroke=
"transparent" points=
"440,-374.2 440,-396.2 578,-396.2 578,-374.2 440,-374.2"/>
121 <polygon fill=
"none" stroke=
"#000000" points=
"440,-374.2 440,-396.2 578,-396.2 578,-374.2 440,-374.2"/>
122 <text text-anchor=
"start" x=
"460" y=
"-381.3" font-family=
"Helvetica,sans-Serif" font-size=
"11.00" fill=
"#000000">encounter
</text>
123 <polygon fill=
"none" stroke=
"#000000" points=
"440,-352.2 440,-374.2 578,-374.2 578,-352.2 440,-352.2"/>
124 <image xlink:
href=
"../../images/primaryKeys.png" width=
"11px" height=
"12px" preserveAspectRatio=
"xMinYMin meet" x=
"445" y=
"-369.2"/>
125 <text text-anchor=
"start" x=
"460" y=
"-359.3" font-family=
"Helvetica,sans-Serif" font-size=
"11.00" fill=
"#000000">form_id
</text>
126 <polygon fill=
"#ffffff" stroke=
"transparent" points=
"440,-330.2 440,-352.2 578,-352.2 578,-330.2 440,-330.2"/>
127 <polygon fill=
"none" stroke=
"#000000" points=
"440,-330.2 440,-352.2 578,-352.2 578,-330.2 440,-330.2"/>
128 <image xlink:
href=
"../../images/foreignKeys.png" width=
"11px" height=
"12px" preserveAspectRatio=
"xMinYMin meet" x=
"445" y=
"-347.2"/>
129 <text text-anchor=
"start" x=
"460" y=
"-337.3" font-family=
"Helvetica,sans-Serif" font-size=
"11.00" fill=
"#000000">pid
</text>
130 <polygon fill=
"none" stroke=
"#000000" points=
"440,-308.2 440,-330.2 578,-330.2 578,-308.2 440,-308.2"/>
131 <image xlink:
href=
"../../images/foreignKeys.png" width=
"11px" height=
"12px" preserveAspectRatio=
"xMinYMin meet" x=
"445" y=
"-325.2"/>
132 <text text-anchor=
"start" x=
"460" y=
"-315.3" font-family=
"Helvetica,sans-Serif" font-size=
"11.00" fill=
"#000000">user
</text>
133 <polygon fill=
"none" stroke=
"#000000" points=
"440,-286.2 440,-308.2 578,-308.2 578,-286.2 440,-286.2"/>
134 <image xlink:
href=
"../../images/foreignKeys.png" width=
"11px" height=
"12px" preserveAspectRatio=
"xMinYMin meet" x=
"445" y=
"-303.2"/>
135 <text text-anchor=
"start" x=
"460" y=
"-293.3" font-family=
"Helvetica,sans-Serif" font-size=
"11.00" fill=
"#000000">groupname
</text>
136 <polygon fill=
"none" stroke=
"#000000" points=
"440,-264.2 440,-286.2 578,-286.2 578,-264.2 440,-264.2"/>
137 <image xlink:
href=
"../../images/foreignKeys.png" width=
"11px" height=
"12px" preserveAspectRatio=
"xMinYMin meet" x=
"445" y=
"-281.2"/>
138 <text text-anchor=
"start" x=
"460" y=
"-271.3" font-family=
"Helvetica,sans-Serif" font-size=
"11.00" fill=
"#000000">therapy_group_id
</text>
139 <polygon fill=
"none" stroke=
"#000000" points=
"440,-242.2 440,-264.2 578,-264.2 578,-242.2 440,-242.2"/>
140 <image xlink:
href=
"../../images/foreignKeys.png" width=
"11px" height=
"12px" preserveAspectRatio=
"xMinYMin meet" x=
"445" y=
"-259.2"/>
141 <text text-anchor=
"start" x=
"460" y=
"-249.3" font-family=
"Helvetica,sans-Serif" font-size=
"11.00" fill=
"#000000">issue_id
</text>
142 <polygon fill=
"none" stroke=
"#000000" points=
"440,-220.2 440,-242.2 578,-242.2 578,-220.2 440,-220.2"/>
143 <image xlink:
href=
"../../images/foreignKeys.png" width=
"11px" height=
"12px" preserveAspectRatio=
"xMinYMin meet" x=
"445" y=
"-237.2"/>
144 <text text-anchor=
"start" x=
"460" y=
"-227.3" font-family=
"Helvetica,sans-Serif" font-size=
"11.00" fill=
"#000000">provider_id
</text>
145 <polygon fill=
"none" stroke=
"#000000" points=
"440,-201.2 440,-220.2 578,-220.2 578,-201.2 440,-201.2"/>
146 <text text-anchor=
"start" x=
"443" y=
"-207.3" font-family=
"Helvetica,sans-Serif" font-size=
"11.00" fill=
"#000000">...
</text>
147 <polygon fill=
"#ffffff" stroke=
"transparent" points=
"440,-182.2 440,-201.2 500,-201.2 500,-182.2 440,-182.2"/>
148 <polygon fill=
"none" stroke=
"#000000" points=
"440,-182.2 440,-201.2 500,-201.2 500,-182.2 440,-182.2"/>
149 <text text-anchor=
"start" x=
"443" y=
"-188.3" font-family=
"Helvetica,sans-Serif" font-size=
"11.00" fill=
"#000000">< 6</text>
150 <polygon fill=
"#ffffff" stroke=
"transparent" points=
"500,-182.2 500,-201.2 531,-201.2 531,-182.2 500,-182.2"/>
151 <polygon fill=
"none" stroke=
"#000000" points=
"500,-182.2 500,-201.2 531,-201.2 531,-182.2 500,-182.2"/>
152 <text text-anchor=
"start" x=
"521.8862" y=
"-188.3" font-family=
"Helvetica,sans-Serif" font-size=
"11.00" fill=
"#000000">  </text>
153 <polygon fill=
"#ffffff" stroke=
"transparent" points=
"531,-182.2 531,-201.2 578,-201.2 578,-182.2 531,-182.2"/>
154 <polygon fill=
"none" stroke=
"#000000" points=
"531,-182.2 531,-201.2 578,-201.2 578,-182.2 531,-182.2"/>
155 <text text-anchor=
"start" x=
"553.2904" y=
"-188.3" font-family=
"Helvetica,sans-Serif" font-size=
"11.00" fill=
"#000000">13 ></text>
159 <!-- form_painmap->forms -->
160 <g id=
"edge2" class=
"edge">
161 <title>form_painmap:w
->forms:e
</title>
162 <path fill=
"none" stroke=
"#000000" d=
"M618.8211,-295.3717C595.2714,-307.187 612.4328,-363.2 578,-363.2"/>
163 <polygon fill=
"#000000" stroke=
"#000000" points=
"627.3829,-289.455 629.0523,-297.2789 627.4875,-297.6128 625.8182,-289.7888 627.3829,-289.455"/>
164 <polyline fill=
"none" stroke=
"#000000" points=
"629,-293.2 625.088,-294.0347 "/>
165 <ellipse fill=
"none" stroke=
"#000000" cx=
"621.9585" cy=
"-294.7024" rx=
"3.2" ry=
"3.2"/>
167 <!-- patient_data -->
168 <g id=
"node4" class=
"node">
169 <title>patient_data
</title>
170 <g id=
"a_node4"><a xlink:
href=
"../../tables/patient_data.html" xlink:
title=
"patient_data" target=
"_top">
171 <polygon fill=
"#ffffff" stroke=
"transparent" points=
"224,-271.7 224,-508.7 391,-508.7 391,-271.7 224,-271.7"/>
172 <polygon fill=
"#f5f5f5" stroke=
"transparent" points=
"224.5,-485.2 224.5,-508.2 391.5,-508.2 391.5,-485.2 224.5,-485.2"/>
173 <polygon fill=
"none" stroke=
"#000000" points=
"224.5,-485.2 224.5,-508.2 391.5,-508.2 391.5,-485.2 224.5,-485.2"/>
174 <text text-anchor=
"start" x=
"229.5" y=
"-493.8" font-family=
"Helvetica,sans-Serif" font-weight=
"bold" font-size=
"11.00" fill=
"#000000">patient_data
</text>
175 <text text-anchor=
"start" x=
"356.5437" y=
"-493.3" font-family=
"Helvetica,sans-Serif" font-size=
"11.00" fill=
"#000000">[table]
</text>
176 <polygon fill=
"#ffffff" stroke=
"transparent" points=
"224.5,-463.2 224.5,-485.2 391.5,-485.2 391.5,-463.2 224.5,-463.2"/>
177 <polygon fill=
"none" stroke=
"#000000" points=
"224.5,-463.2 224.5,-485.2 391.5,-485.2 391.5,-463.2 224.5,-463.2"/>
178 <text text-anchor=
"start" x=
"244.5" y=
"-470.3" font-family=
"Helvetica,sans-Serif" font-size=
"11.00" fill=
"#000000">id
</text>
179 <polygon fill=
"#ffffff" stroke=
"transparent" points=
"224.5,-441.2 224.5,-463.2 391.5,-463.2 391.5,-441.2 224.5,-441.2"/>
180 <polygon fill=
"none" stroke=
"#000000" points=
"224.5,-441.2 224.5,-463.2 391.5,-463.2 391.5,-441.2 224.5,-441.2"/>
181 <text text-anchor=
"start" x=
"244.5" y=
"-448.3" font-family=
"Helvetica,sans-Serif" font-size=
"11.00" fill=
"#000000">uuid
</text>
182 <polygon fill=
"none" stroke=
"#000000" points=
"224.5,-419.2 224.5,-441.2 391.5,-441.2 391.5,-419.2 224.5,-419.2"/>
183 <image xlink:
href=
"../../images/foreignKeys.png" width=
"11px" height=
"12px" preserveAspectRatio=
"xMinYMin meet" x=
"229.5" y=
"-436.2"/>
184 <text text-anchor=
"start" x=
"244.5" y=
"-426.3" font-family=
"Helvetica,sans-Serif" font-size=
"11.00" fill=
"#000000">pharmacy_id
</text>
185 <polygon fill=
"none" stroke=
"#000000" points=
"224.5,-397.2 224.5,-419.2 391.5,-419.2 391.5,-397.2 224.5,-397.2"/>
186 <image xlink:
href=
"../../images/foreignKeys.png" width=
"11px" height=
"12px" preserveAspectRatio=
"xMinYMin meet" x=
"229.5" y=
"-414.2"/>
187 <text text-anchor=
"start" x=
"244.5" y=
"-404.3" font-family=
"Helvetica,sans-Serif" font-size=
"11.00" fill=
"#000000">providerID
</text>
188 <polygon fill=
"none" stroke=
"#000000" points=
"224.5,-375.2 224.5,-397.2 391.5,-397.2 391.5,-375.2 224.5,-375.2"/>
189 <image xlink:
href=
"../../images/foreignKeys.png" width=
"11px" height=
"12px" preserveAspectRatio=
"xMinYMin meet" x=
"229.5" y=
"-392.2"/>
190 <text text-anchor=
"start" x=
"244.5" y=
"-382.3" font-family=
"Helvetica,sans-Serif" font-size=
"11.00" fill=
"#000000">ref_providerID
</text>
191 <polygon fill=
"none" stroke=
"#000000" points=
"224.5,-353.2 224.5,-375.2 391.5,-375.2 391.5,-353.2 224.5,-353.2"/>
192 <image xlink:
href=
"../../images/primaryKeys.png" width=
"11px" height=
"12px" preserveAspectRatio=
"xMinYMin meet" x=
"229.5" y=
"-370.2"/>
193 <text text-anchor=
"start" x=
"244.5" y=
"-360.3" font-family=
"Helvetica,sans-Serif" font-size=
"11.00" fill=
"#000000">pid
</text>
194 <polygon fill=
"none" stroke=
"#000000" points=
"224.5,-331.2 224.5,-353.2 391.5,-353.2 391.5,-331.2 224.5,-331.2"/>
195 <image xlink:
href=
"../../images/foreignKeys.png" width=
"11px" height=
"12px" preserveAspectRatio=
"xMinYMin meet" x=
"229.5" y=
"-348.2"/>
196 <text text-anchor=
"start" x=
"244.5" y=
"-338.3" font-family=
"Helvetica,sans-Serif" font-size=
"11.00" fill=
"#000000">created_by
</text>
197 <polygon fill=
"none" stroke=
"#000000" points=
"224.5,-309.2 224.5,-331.2 391.5,-331.2 391.5,-309.2 224.5,-309.2"/>
198 <image xlink:
href=
"../../images/foreignKeys.png" width=
"11px" height=
"12px" preserveAspectRatio=
"xMinYMin meet" x=
"229.5" y=
"-326.2"/>
199 <text text-anchor=
"start" x=
"244.5" y=
"-316.3" font-family=
"Helvetica,sans-Serif" font-size=
"11.00" fill=
"#000000">updated_by
</text>
200 <polygon fill=
"none" stroke=
"#000000" points=
"224.5,-290.2 224.5,-309.2 391.5,-309.2 391.5,-290.2 224.5,-290.2"/>
201 <text text-anchor=
"start" x=
"227.5" y=
"-296.3" font-family=
"Helvetica,sans-Serif" font-size=
"11.00" fill=
"#000000">...
</text>
202 <polygon fill=
"#ffffff" stroke=
"transparent" points=
"224.5,-271.2 224.5,-290.2 298.5,-290.2 298.5,-271.2 224.5,-271.2"/>
203 <polygon fill=
"none" stroke=
"#000000" points=
"224.5,-271.2 224.5,-290.2 298.5,-290.2 298.5,-271.2 224.5,-271.2"/>
204 <text text-anchor=
"start" x=
"227.5" y=
"-277.3" font-family=
"Helvetica,sans-Serif" font-size=
"11.00" fill=
"#000000">< 5</text>
205 <polygon fill=
"#ffffff" stroke=
"transparent" points=
"298.5,-271.2 298.5,-290.2 337.5,-290.2 337.5,-271.2 298.5,-271.2"/>
206 <polygon fill=
"none" stroke=
"#000000" points=
"298.5,-271.2 298.5,-290.2 337.5,-290.2 337.5,-271.2 298.5,-271.2"/>
207 <text text-anchor=
"start" x=
"328.3862" y=
"-277.3" font-family=
"Helvetica,sans-Serif" font-size=
"11.00" fill=
"#000000">  </text>
208 <polygon fill=
"#ffffff" stroke=
"transparent" points=
"337.5,-271.2 337.5,-290.2 391.5,-290.2 391.5,-271.2 337.5,-271.2"/>
209 <polygon fill=
"none" stroke=
"#000000" points=
"337.5,-271.2 337.5,-290.2 391.5,-290.2 391.5,-271.2 337.5,-271.2"/>
210 <text text-anchor=
"start" x=
"366.7904" y=
"-277.3" font-family=
"Helvetica,sans-Serif" font-size=
"11.00" fill=
"#000000">85 ></text>
214 <!-- form_painmap->patient_data -->
215 <g id=
"edge3" class=
"edge">
216 <title>form_painmap:w
->patient_data:e
</title>
217 <path fill=
"none" stroke=
"#000000" d=
"M614.5019,-250.7425C550.7074,-266.4324 653.3129,-397.6519 586,-452.2 532.8238,-495.2922 489.6332,-489.1195 432,-452.2 395.7463,-428.9761 434.5544,-364.2 391.5,-364.2"/>
218 <polygon fill=
"#000000" stroke=
"#000000" points=
"621.0449,-250.0464 629.3809,-252.7798 625.0224,-249.6232 629,-249.2 629,-249.2 629,-249.2 625.0224,-249.6232 628.6191,-245.6202 621.0449,-250.0464 621.0449,-250.0464"/>
219 <ellipse fill=
"none" stroke=
"#000000" cx=
"617.8629" cy=
"-250.385" rx=
"3.2" ry=
"3.2"/>
222 <g id=
"node5" class=
"node">
224 <g id=
"a_node5"><a xlink:
href=
"../../tables/users.html" xlink:
title=
"users" target=
"_top">
225 <polygon fill=
"#ffffff" stroke=
"transparent" points=
"8,-124.7 8,-339.7 175,-339.7 175,-124.7 8,-124.7"/>
226 <polygon fill=
"#f5f5f5" stroke=
"transparent" points=
"8.5,-316.2 8.5,-339.2 175.5,-339.2 175.5,-316.2 8.5,-316.2"/>
227 <polygon fill=
"none" stroke=
"#000000" points=
"8.5,-316.2 8.5,-339.2 175.5,-339.2 175.5,-316.2 8.5,-316.2"/>
228 <text text-anchor=
"start" x=
"13.5" y=
"-324.8" font-family=
"Helvetica,sans-Serif" font-weight=
"bold" font-size=
"11.00" fill=
"#000000">users
</text>
229 <text text-anchor=
"start" x=
"140.5437" y=
"-324.3" font-family=
"Helvetica,sans-Serif" font-size=
"11.00" fill=
"#000000">[table]
</text>
230 <polygon fill=
"none" stroke=
"#000000" points=
"8.5,-294.2 8.5,-316.2 175.5,-316.2 175.5,-294.2 8.5,-294.2"/>
231 <image xlink:
href=
"../../images/primaryKeys.png" width=
"11px" height=
"12px" preserveAspectRatio=
"xMinYMin meet" x=
"13.5" y=
"-311.2"/>
232 <text text-anchor=
"start" x=
"28.5" y=
"-301.3" font-family=
"Helvetica,sans-Serif" font-size=
"11.00" fill=
"#000000">id
</text>
233 <polygon fill=
"#ffffff" stroke=
"transparent" points=
"8.5,-272.2 8.5,-294.2 175.5,-294.2 175.5,-272.2 8.5,-272.2"/>
234 <polygon fill=
"none" stroke=
"#000000" points=
"8.5,-272.2 8.5,-294.2 175.5,-294.2 175.5,-272.2 8.5,-272.2"/>
235 <text text-anchor=
"start" x=
"28.5" y=
"-279.3" font-family=
"Helvetica,sans-Serif" font-size=
"11.00" fill=
"#000000">uuid
</text>
236 <polygon fill=
"none" stroke=
"#000000" points=
"8.5,-250.2 8.5,-272.2 175.5,-272.2 175.5,-250.2 8.5,-250.2"/>
237 <image xlink:
href=
"../../images/primaryKeys.png" width=
"11px" height=
"12px" preserveAspectRatio=
"xMinYMin meet" x=
"13.5" y=
"-267.2"/>
238 <text text-anchor=
"start" x=
"28.5" y=
"-257.3" font-family=
"Helvetica,sans-Serif" font-size=
"11.00" fill=
"#000000">username
</text>
239 <polygon fill=
"none" stroke=
"#000000" points=
"8.5,-228.2 8.5,-250.2 175.5,-250.2 175.5,-228.2 8.5,-228.2"/>
240 <image xlink:
href=
"../../images/foreignKeys.png" width=
"11px" height=
"12px" preserveAspectRatio=
"xMinYMin meet" x=
"13.5" y=
"-245.2"/>
241 <text text-anchor=
"start" x=
"28.5" y=
"-235.3" font-family=
"Helvetica,sans-Serif" font-size=
"11.00" fill=
"#000000">facility_id
</text>
242 <polygon fill=
"#ffffff" stroke=
"transparent" points=
"8.5,-206.2 8.5,-228.2 175.5,-228.2 175.5,-206.2 8.5,-206.2"/>
243 <polygon fill=
"none" stroke=
"#000000" points=
"8.5,-206.2 8.5,-228.2 175.5,-228.2 175.5,-206.2 8.5,-206.2"/>
244 <text text-anchor=
"start" x=
"28.5" y=
"-213.3" font-family=
"Helvetica,sans-Serif" font-size=
"11.00" fill=
"#000000">google_signin_email
</text>
245 <polygon fill=
"#ffffff" stroke=
"transparent" points=
"8.5,-184.2 8.5,-206.2 175.5,-206.2 175.5,-184.2 8.5,-184.2"/>
246 <polygon fill=
"none" stroke=
"#000000" points=
"8.5,-184.2 8.5,-206.2 175.5,-206.2 175.5,-184.2 8.5,-184.2"/>
247 <text text-anchor=
"start" x=
"28.5" y=
"-191.3" font-family=
"Helvetica,sans-Serif" font-size=
"11.00" fill=
"#000000">abook_type
</text>
248 <polygon fill=
"none" stroke=
"#000000" points=
"8.5,-162.2 8.5,-184.2 175.5,-184.2 175.5,-162.2 8.5,-162.2"/>
249 <image xlink:
href=
"../../images/foreignKeys.png" width=
"11px" height=
"12px" preserveAspectRatio=
"xMinYMin meet" x=
"13.5" y=
"-179.2"/>
250 <text text-anchor=
"start" x=
"28.5" y=
"-169.3" font-family=
"Helvetica,sans-Serif" font-size=
"11.00" fill=
"#000000">billing_facility_id
</text>
251 <polygon fill=
"none" stroke=
"#000000" points=
"8.5,-143.2 8.5,-162.2 175.5,-162.2 175.5,-143.2 8.5,-143.2"/>
252 <text text-anchor=
"start" x=
"11.5" y=
"-149.3" font-family=
"Helvetica,sans-Serif" font-size=
"11.00" fill=
"#000000">...
</text>
253 <polygon fill=
"#ffffff" stroke=
"transparent" points=
"8.5,-124.2 8.5,-143.2 82.5,-143.2 82.5,-124.2 8.5,-124.2"/>
254 <polygon fill=
"none" stroke=
"#000000" points=
"8.5,-124.2 8.5,-143.2 82.5,-143.2 82.5,-124.2 8.5,-124.2"/>
255 <text text-anchor=
"start" x=
"11.5" y=
"-130.3" font-family=
"Helvetica,sans-Serif" font-size=
"11.00" fill=
"#000000">< 2</text>
256 <polygon fill=
"#ffffff" stroke=
"transparent" points=
"82.5,-124.2 82.5,-143.2 121.5,-143.2 121.5,-124.2 82.5,-124.2"/>
257 <polygon fill=
"none" stroke=
"#000000" points=
"82.5,-124.2 82.5,-143.2 121.5,-143.2 121.5,-124.2 82.5,-124.2"/>
258 <text text-anchor=
"start" x=
"112.3862" y=
"-130.3" font-family=
"Helvetica,sans-Serif" font-size=
"11.00" fill=
"#000000">  </text>
259 <polygon fill=
"#ffffff" stroke=
"transparent" points=
"121.5,-124.2 121.5,-143.2 175.5,-143.2 175.5,-124.2 121.5,-124.2"/>
260 <polygon fill=
"none" stroke=
"#000000" points=
"121.5,-124.2 121.5,-143.2 175.5,-143.2 175.5,-124.2 121.5,-124.2"/>
261 <text text-anchor=
"start" x=
"150.7904" y=
"-130.3" font-family=
"Helvetica,sans-Serif" font-size=
"11.00" fill=
"#000000">61 ></text>
265 <!-- form_painmap->users -->
266 <g id=
"edge4" class=
"edge">
267 <title>form_painmap:w
->users:e
</title>
268 <path fill=
"none" stroke=
"#000000" d=
"M615.1425,-222.6552C602.631,-211.5274 608.2252,-183.0354 586,-172.2 511.7044,-135.9788 280.7363,-158.8093 216,-210.2 180.0513,-238.7378 221.399,-305.2 175.5,-305.2"/>
269 <polygon fill=
"#000000" stroke=
"#000000" points=
"621.3984,-224.7069 627.8781,-230.6207 625.1992,-225.9534 629,-227.2 629,-227.2 629,-227.2 625.1992,-225.9534 630.1219,-223.7793 621.3984,-224.7069 621.3984,-224.7069"/>
270 <ellipse fill=
"none" stroke=
"#000000" cx=
"618.3577" cy=
"-223.7097" rx=
"3.2" ry=
"3.2"/>
272 <!-- groups->users -->
273 <g id=
"edge9" class=
"edge">
274 <title>groups:w
->users:e
</title>
275 <path fill=
"none" stroke=
"#000000" d=
"M249.941,-70.4324C221.9885,-80.5855 232.9799,-123.492 216,-160.2 195.6958,-204.0948 223.8633,-261.2 175.5,-261.2"/>
276 <polygon fill=
"#000000" stroke=
"#000000" points=
"256.5924,-69.4126 265.0457,-71.7584 260.5462,-68.8063 264.5,-68.2 264.5,-68.2 264.5,-68.2 260.5462,-68.8063 263.9543,-64.6416 256.5924,-69.4126 256.5924,-69.4126"/>
277 <ellipse fill=
"none" stroke=
"#000000" cx=
"253.4294" cy=
"-69.8976" rx=
"3.2" ry=
"3.2"/>
279 <!-- forms->groups -->
280 <g id=
"edge5" class=
"edge">
281 <title>forms:w
->groups:e
</title>
282 <path fill=
"none" stroke=
"#000000" d=
"M429.325,-287.216C404.7334,-245.8669 372.2298,-90.2 350.5,-90.2"/>
283 <polygon fill=
"#000000" stroke=
"#000000" points=
"434.1572,-291.7354 437.5409,-299.8293 437.0786,-294.4677 440,-297.2 440,-297.2 440,-297.2 437.0786,-294.4677 442.4591,-294.5707 434.1572,-291.7354 434.1572,-291.7354"/>
284 <ellipse fill=
"none" stroke=
"#000000" cx=
"431.8201" cy=
"-289.5495" rx=
"3.2" ry=
"3.2"/>
286 <!-- forms->patient_data -->
287 <g id=
"edge6" class=
"edge">
288 <title>forms:w
->patient_data:e
</title>
289 <path fill=
"none" stroke=
"#000000" d=
"M425.7122,-344.7938C414.3081,-351.2625 409.3924,-364.2 391.5,-364.2"/>
290 <polygon fill=
"#000000" stroke=
"#000000" points=
"432.2417,-343.1515 440.8782,-344.6913 436.1208,-342.1757 440,-341.2 440,-341.2 440,-341.2 436.1208,-342.1757 439.1218,-337.7087 432.2417,-343.1515 432.2417,-343.1515"/>
291 <ellipse fill=
"none" stroke=
"#000000" cx=
"429.1383" cy=
"-343.9321" rx=
"3.2" ry=
"3.2"/>
293 <!-- forms->users -->
294 <g id=
"edge7" class=
"edge">
295 <title>forms:w
->users:e
</title>
296 <path fill=
"none" stroke=
"#000000" d=
"M425.5609,-230.887C336.457,-227.0159 297.6387,-189.3442 216,-237.2 185.6531,-254.989 210.6765,-305.2 175.5,-305.2"/>
297 <polygon fill=
"#000000" stroke=
"#000000" points=
"432.0019,-231.0266 439.922,-234.7992 436.0009,-231.1133 440,-231.2 440,-231.2 440,-231.2 436.0009,-231.1133 440.078,-227.6008 432.0019,-231.0266 432.0019,-231.0266"/>
298 <ellipse fill=
"none" stroke=
"#000000" cx=
"428.8026" cy=
"-230.9572" rx=
"3.2" ry=
"3.2"/>
300 <!-- forms->users -->
301 <g id=
"edge8" class=
"edge">
302 <title>forms:w
->users:e
</title>
303 <path fill=
"none" stroke=
"#000000" d=
"M426.1619,-314.4246C414.0647,-302.7291 421.3394,-272.7657 399,-261.2 310.7879,-215.5302 274.8333,-261.2 175.5,-261.2"/>
304 <polygon fill=
"#000000" stroke=
"#000000" points=
"432.4376,-316.5903 438.8256,-322.6031 436.2188,-317.8951 440,-319.2 440,-319.2 440,-319.2 436.2188,-317.8951 441.1744,-315.7969 432.4376,-316.5903 432.4376,-316.5903"/>
305 <ellipse fill=
"none" stroke=
"#000000" cx=
"429.4127" cy=
"-315.5464" rx=
"3.2" ry=
"3.2"/>
307 <!-- patient_data->users -->
308 <g id=
"edge10" class=
"edge">
309 <title>patient_data:w
->users:e
</title>
310 <path fill=
"none" stroke=
"#000000" d=
"M210.6217,-337.6631C198.0786,-327.783 196.8196,-305.2 175.5,-305.2"/>
311 <polygon fill=
"#000000" stroke=
"#000000" points=
"216.896,-339.7142 223.3814,-345.6218 220.698,-340.9571 224.5,-342.2 224.5,-342.2 224.5,-342.2 220.698,-340.9571 225.6186,-338.7782 216.896,-339.7142 216.896,-339.7142"/>
312 <ellipse fill=
"none" stroke=
"#000000" cx=
"213.8544" cy=
"-338.7198" rx=
"3.2" ry=
"3.2"/>
314 <!-- patient_data->users -->
315 <g id=
"edge11" class=
"edge">
316 <title>patient_data:w
->users:e
</title>
317 <path fill=
"none" stroke=
"#000000" d=
"M210.593,-404.2881C184.6689,-385.4739 220.2533,-305.2 175.5,-305.2"/>
318 <polygon fill=
"#000000" stroke=
"#000000" points=
"216.7989,-406.0337 223.5252,-411.6655 220.6494,-407.1168 224.5,-408.2 224.5,-408.2 224.5,-408.2 220.6494,-407.1168 225.4748,-404.7345 216.7989,-406.0337 216.7989,-406.0337"/>
319 <ellipse fill=
"none" stroke=
"#000000" cx=
"213.7184" cy=
"-405.1672" rx=
"3.2" ry=
"3.2"/>
321 <!-- patient_data->users -->
322 <g id=
"edge12" class=
"edge">
323 <title>patient_data:w
->users:e
</title>
324 <path fill=
"none" stroke=
"#000000" d=
"M210.6299,-381.613C190.9726,-364.478 211.4935,-305.2 175.5,-305.2"/>
325 <polygon fill=
"#000000" stroke=
"#000000" points=
"216.9046,-383.6881 223.3696,-389.6179 220.7023,-384.944 224.5,-386.2 224.5,-386.2 224.5,-386.2 220.7023,-384.944 225.6304,-382.7821 216.9046,-383.6881 216.9046,-383.6881"/>
326 <ellipse fill=
"none" stroke=
"#000000" cx=
"213.8664" cy=
"-382.6833" rx=
"3.2" ry=
"3.2"/>
328 <!-- patient_data->users -->
329 <g id=
"edge13" class=
"edge">
330 <title>patient_data:w
->users:e
</title>
331 <path fill=
"none" stroke=
"#000000" d=
"M210.076,-317.7231C198.6616,-313.4626 192.4036,-305.2 175.5,-305.2"/>
332 <polygon fill=
"#000000" stroke=
"#000000" points=
"216.6154,-318.846 223.8907,-323.7481 220.5577,-319.523 224.5,-320.2 224.5,-320.2 224.5,-320.2 220.5577,-319.523 225.1093,-316.6519 216.6154,-318.846 216.6154,-318.846"/>
333 <ellipse fill=
"none" stroke=
"#000000" cx=
"213.4616" cy=
"-318.3044" rx=
"3.2" ry=
"3.2"/>