1 digraph "oneDegreeRelationshipsDiagram" {
2 graph [
rankdir=
"RL" bgcolor=
"#ffffff" label=
"\nGenerated by SchemaSpy" labeljust=
"l" nodesep=
"0.18" ranksep=
"0.46" fontname=
"Helvetica" fontsize=
"11" ration=
"compress" ]
; node [
fontname=
"Helvetica" fontsize=
"11" shape=
"plaintext" ]
; edge [
arrowsize=
"0.8" ]
;
3 "billing":"groupname":w
-> "groups":"name.type":e [
arrowhead=
none dir=back
arrowtail=crowodot]
;
4 "billing":"user":w
-> "users":"id":e [
arrowhead=
none dir=back
arrowtail=crowodot]
;
5 "form_aftercare_plan":"groupname":w
-> "groups":"name.type":e [
arrowhead=
none dir=back
arrowtail=crowodot]
;
6 "form_aftercare_plan":"user":w
-> "users":"username":e [
arrowhead=
none dir=back
arrowtail=crowodot]
;
7 "form_ankleinjury":"groupname":w
-> "groups":"name.type":e [
arrowhead=
none dir=back
arrowtail=crowodot]
;
8 "form_ankleinjury":"user":w
-> "users":"username":e [
arrowhead=
none dir=back
arrowtail=crowodot]
;
9 "form_bronchitis":"groupname":w
-> "groups":"name.type":e [
arrowhead=
none dir=back
arrowtail=crowodot]
;
10 "form_bronchitis":"user":w
-> "users":"username":e [
arrowhead=
none dir=back
arrowtail=crowodot]
;
11 "form_CAMOS_category":"groupname":w
-> "groups":"name.type":e [
arrowhead=
none dir=back
arrowtail=crowodot]
;
12 "form_CAMOS_category":"user":w
-> "users":"username":e [
arrowhead=
none dir=back
arrowtail=crowodot]
;
13 "form_CAMOS_item":"groupname":w
-> "groups":"name.type":e [
arrowhead=
none dir=back
arrowtail=crowodot]
;
14 "form_CAMOS_item":"user":w
-> "users":"username":e [
arrowhead=
none dir=back
arrowtail=crowodot]
;
15 "form_group_attendance":"groupname":w
-> "groups":"name.type":e [
arrowhead=
none dir=back
arrowtail=crowodot]
;
16 "form_group_attendance":"id":w
-> "forms":"form_id":e [
arrowhead=
none dir=back
arrowtail=teeodot]
;
17 "form_group_attendance":"user":w
-> "users":"username":e [
arrowhead=
none dir=back
arrowtail=crowodot]
;
18 "form_painmap":"groupname":w
-> "groups":"name.type":e [
arrowhead=
none dir=back
arrowtail=crowodot]
;
19 "form_painmap":"id":w
-> "forms":"form_id":e [
arrowhead=
none dir=back
arrowtail=teeodot]
;
20 "form_painmap":"user":w
-> "users":"id":e [
arrowhead=
none dir=back
arrowtail=crowodot]
;
21 "form_phq9":"groupname":w
-> "groups":"name.type":e [
arrowhead=
none dir=back
arrowtail=crowodot]
;
22 "form_phq9":"id":w
-> "forms":"form_id":e [
arrowhead=
none dir=back
arrowtail=teeodot]
;
23 "form_phq9":"user":w
-> "users":"id":e [
arrowhead=
none dir=back
arrowtail=crowodot]
;
24 "form_questionnaire_assessments":"groupname":w
-> "groups":"name.type":e [
arrowhead=
none dir=back
arrowtail=crowodot]
;
25 "form_questionnaire_assessments":"user":w
-> "users":"username":e [
arrowhead=
none dir=back
arrowtail=crowodot]
;
26 "form_sdoh":"groupname":w
-> "groups":"name.type":e [
arrowhead=
none dir=back
arrowtail=crowodot]
;
27 "form_sdoh":"id":w
-> "forms":"form_id":e [
arrowhead=
none dir=back
arrowtail=teeodot]
;
28 "form_sdoh":"user":w
-> "users":"id":e [
arrowhead=
none dir=back
arrowtail=crowodot]
;
29 "form_treatment_plan":"groupname":w
-> "groups":"name.type":e [
arrowhead=
none dir=back
arrowtail=crowodot]
;
30 "form_treatment_plan":"id":w
-> "forms":"form_id":e [
arrowhead=
none dir=back
arrowtail=teeodot]
;
31 "form_treatment_plan":"user":w
-> "users":"id":e [
arrowhead=
none dir=back
arrowtail=crowodot]
;
32 "form_vitals":"groupname":w
-> "groups":"name.type":e [
arrowhead=
none dir=back
arrowtail=crowodot]
;
33 "form_vitals":"user":w
-> "users":"username":e [
arrowhead=
none dir=back
arrowtail=crowodot]
;
34 "forms":"groupname":w
-> "groups":"name.type":e [
arrowhead=
none dir=back
arrowtail=crowodot]
;
35 "forms":"issue_id":w
-> "lists":"id":e [
arrowhead=
none dir=back
arrowtail=crowodot]
;
36 "forms":"provider_id":w
-> "users":"id":e [
arrowhead=
none dir=back
arrowtail=crowodot]
;
37 "forms":"user":w
-> "users":"username":e [
arrowhead=
none dir=back
arrowtail=crowodot]
;
38 "groups":"user":w
-> "users":"username":e [
arrowhead=
none dir=back
arrowtail=crowodot]
;
39 "lists":"groupname":w
-> "groups":"name.type":e [
arrowhead=
none dir=back
arrowtail=crowodot]
;
40 "lists":"user":w
-> "users":"username":e [
arrowhead=
none dir=back
arrowtail=crowodot]
;
41 "form_gad7":"groupname":w
-> "groups":"name.type":e [
arrowhead=
none dir=back
arrowtail=crowodot]
;
42 "form_gad7":"id":w
-> "forms":"form_id":e [
arrowhead=
none dir=back
arrowtail=crowodot]
;
43 "form_gad7":"user":w
-> "users":"id":e [
arrowhead=
none dir=back
arrowtail=crowodot]
;
44 "pnotes":"assigned_to":w
-> "users":"id":e [
arrowhead=
none dir=back
arrowtail=crowodot]
;
45 "pnotes":"groupname":w
-> "groups":"name.type":e [
arrowhead=
none dir=back
arrowtail=crowodot]
;
46 "pnotes":"update_by":w
-> "users":"id":e [
arrowhead=
none dir=back
arrowtail=crowodot]
;
47 "pnotes":"user":w
-> "users":"id":e [
arrowhead=
none dir=back
arrowtail=crowodot]
;
50 <TABLE BORDER=
"0" CELLBORDER=
"1" CELLSPACING=
"0" BGCOLOR=
"#ffffff">
51 <TR
><TD COLSPAN=
"3" BGCOLOR=
"#f5f5f5"><TABLE BORDER=
"0" CELLSPACING=
"0"><TR
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"42" HEIGHT=
"16"><B
>billing
</B
></TD
><TD ALIGN=
"RIGHT">[table]
</TD
></TR
></TABLE
></TD
></TR
>
52 <TR
><TD PORT=
"id" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/primaryKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"100" HEIGHT=
"16">id
</TD
></TR
></TABLE
></TD
></TR
>
53 <TR
><TD PORT=
"pid" COLSPAN=
"3" BGCOLOR=
"#ffffff" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/foreignKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"100" HEIGHT=
"16">pid
</TD
></TR
></TABLE
></TD
></TR
>
54 <TR
><TD PORT=
"provider_id" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/foreignKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"100" HEIGHT=
"16">provider_id
</TD
></TR
></TABLE
></TD
></TR
>
55 <TR
><TD PORT=
"user" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/foreignKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"100" HEIGHT=
"16">user
</TD
></TR
></TABLE
></TD
></TR
>
56 <TR
><TD PORT=
"groupname" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/foreignKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"100" HEIGHT=
"16">groupname
</TD
></TR
></TABLE
></TD
></TR
>
57 <TR
><TD PORT=
"encounter" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/foreignKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"100" HEIGHT=
"16">encounter
</TD
></TR
></TABLE
></TD
></TR
>
58 <TR
><TD PORT=
"payer_id" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/foreignKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"100" HEIGHT=
"16">payer_id
</TD
></TR
></TABLE
></TD
></TR
>
59 <TR
><TD PORT=
"chargecat" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/foreignKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"100" HEIGHT=
"16">chargecat
</TD
></TR
></TABLE
></TD
></TR
>
60 <TR
><TD PORT=
"elipses" COLSPAN=
"3" ALIGN=
"LEFT">...</TD
></TR
>
61 <TR
><TD ALIGN=
"LEFT" BGCOLOR=
"#ffffff"><
; 7</TD
><TD ALIGN=
"RIGHT" BGCOLOR=
"#ffffff"> </TD
><TD ALIGN=
"RIGHT" BGCOLOR=
"#ffffff"> </TD
></TR
>
63 URL=
"../../tables/billing.html"
67 "form_aftercare_plan" [
69 <TABLE BORDER=
"0" CELLBORDER=
"1" CELLSPACING=
"0" BGCOLOR=
"#ffffff">
70 <TR
><TD COLSPAN=
"3" BGCOLOR=
"#f5f5f5"><TABLE BORDER=
"0" CELLSPACING=
"0"><TR
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"135" HEIGHT=
"16"><B
>form_aftercare_plan
</B
></TD
><TD ALIGN=
"RIGHT">[table]
</TD
></TR
></TABLE
></TD
></TR
>
71 <TR
><TD PORT=
"id" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/primaryKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"281" HEIGHT=
"16">id
</TD
></TR
></TABLE
></TD
></TR
>
72 <TR
><TD PORT=
"pid" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/foreignKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"281" HEIGHT=
"16">pid
</TD
></TR
></TABLE
></TD
></TR
>
73 <TR
><TD PORT=
"user" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/foreignKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"281" HEIGHT=
"16">user
</TD
></TR
></TABLE
></TD
></TR
>
74 <TR
><TD PORT=
"groupname" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/foreignKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"281" HEIGHT=
"16">groupname
</TD
></TR
></TABLE
></TD
></TR
>
75 <TR
><TD PORT=
"elipses" COLSPAN=
"3" ALIGN=
"LEFT">...</TD
></TR
>
76 <TR
><TD ALIGN=
"LEFT" BGCOLOR=
"#ffffff"><
; 3</TD
><TD ALIGN=
"RIGHT" BGCOLOR=
"#ffffff"> </TD
><TD ALIGN=
"RIGHT" BGCOLOR=
"#ffffff"> </TD
></TR
>
78 URL=
"../../tables/form_aftercare_plan.html"
80 tooltip=
"form_aftercare_plan"
84 <TABLE BORDER=
"0" CELLBORDER=
"1" CELLSPACING=
"0" BGCOLOR=
"#ffffff">
85 <TR
><TD COLSPAN=
"3" BGCOLOR=
"#f5f5f5"><TABLE BORDER=
"0" CELLSPACING=
"0"><TR
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"113" HEIGHT=
"16"><B
>form_ankleinjury
</B
></TD
><TD ALIGN=
"RIGHT">[table]
</TD
></TR
></TABLE
></TD
></TR
>
86 <TR
><TD PORT=
"id" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/primaryKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"223" HEIGHT=
"16">id
</TD
></TR
></TABLE
></TD
></TR
>
87 <TR
><TD PORT=
"pid" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/foreignKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"223" HEIGHT=
"16">pid
</TD
></TR
></TABLE
></TD
></TR
>
88 <TR
><TD PORT=
"user" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/foreignKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"223" HEIGHT=
"16">user
</TD
></TR
></TABLE
></TD
></TR
>
89 <TR
><TD PORT=
"groupname" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/foreignKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"223" HEIGHT=
"16">groupname
</TD
></TR
></TABLE
></TD
></TR
>
90 <TR
><TD PORT=
"elipses" COLSPAN=
"3" ALIGN=
"LEFT">...</TD
></TR
>
91 <TR
><TD ALIGN=
"LEFT" BGCOLOR=
"#ffffff"><
; 3</TD
><TD ALIGN=
"RIGHT" BGCOLOR=
"#ffffff"> </TD
><TD ALIGN=
"RIGHT" BGCOLOR=
"#ffffff"> </TD
></TR
>
93 URL=
"../../tables/form_ankleinjury.html"
95 tooltip=
"form_ankleinjury"
99 <TABLE BORDER=
"0" CELLBORDER=
"1" CELLSPACING=
"0" BGCOLOR=
"#ffffff">
100 <TR
><TD COLSPAN=
"3" BGCOLOR=
"#f5f5f5"><TABLE BORDER=
"0" CELLSPACING=
"0"><TR
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"105" HEIGHT=
"16"><B
>form_bronchitis
</B
></TD
><TD ALIGN=
"RIGHT">[table]
</TD
></TR
></TABLE
></TD
></TR
>
101 <TR
><TD PORT=
"id" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/primaryKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"298" HEIGHT=
"16">id
</TD
></TR
></TABLE
></TD
></TR
>
102 <TR
><TD PORT=
"pid" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/foreignKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"298" HEIGHT=
"16">pid
</TD
></TR
></TABLE
></TD
></TR
>
103 <TR
><TD PORT=
"user" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/foreignKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"298" HEIGHT=
"16">user
</TD
></TR
></TABLE
></TD
></TR
>
104 <TR
><TD PORT=
"groupname" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/foreignKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"298" HEIGHT=
"16">groupname
</TD
></TR
></TABLE
></TD
></TR
>
105 <TR
><TD PORT=
"elipses" COLSPAN=
"3" ALIGN=
"LEFT">...</TD
></TR
>
106 <TR
><TD ALIGN=
"LEFT" BGCOLOR=
"#ffffff"><
; 3</TD
><TD ALIGN=
"RIGHT" BGCOLOR=
"#ffffff"> </TD
><TD ALIGN=
"RIGHT" BGCOLOR=
"#ffffff"> </TD
></TR
>
108 URL=
"../../tables/form_bronchitis.html"
110 tooltip=
"form_bronchitis"
112 "form_CAMOS_category" [
114 <TABLE BORDER=
"0" CELLBORDER=
"1" CELLSPACING=
"0" BGCOLOR=
"#ffffff">
115 <TR
><TD COLSPAN=
"3" BGCOLOR=
"#f5f5f5"><TABLE BORDER=
"0" CELLSPACING=
"0"><TR
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"152" HEIGHT=
"16"><B
>form_CAMOS_category
</B
></TD
><TD ALIGN=
"RIGHT">[table]
</TD
></TR
></TABLE
></TD
></TR
>
116 <TR
><TD PORT=
"id" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/primaryKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"152" HEIGHT=
"16">id
</TD
></TR
></TABLE
></TD
></TR
>
117 <TR
><TD PORT=
"pid" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/foreignKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"152" HEIGHT=
"16">pid
</TD
></TR
></TABLE
></TD
></TR
>
118 <TR
><TD PORT=
"user" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/foreignKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"152" HEIGHT=
"16">user
</TD
></TR
></TABLE
></TD
></TR
>
119 <TR
><TD PORT=
"groupname" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/foreignKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"152" HEIGHT=
"16">groupname
</TD
></TR
></TABLE
></TD
></TR
>
120 <TR
><TD PORT=
"category" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/primaryKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"152" HEIGHT=
"16">category
</TD
></TR
></TABLE
></TD
></TR
>
121 <TR
><TD PORT=
"elipses" COLSPAN=
"3" ALIGN=
"LEFT">...</TD
></TR
>
122 <TR
><TD ALIGN=
"LEFT" BGCOLOR=
"#ffffff"><
; 3</TD
><TD ALIGN=
"RIGHT" BGCOLOR=
"#ffffff"> </TD
><TD ALIGN=
"RIGHT" BGCOLOR=
"#ffffff">2 >
;</TD
></TR
>
124 URL=
"../../tables/form_CAMOS_category.html"
126 tooltip=
"form_CAMOS_category"
130 <TABLE BORDER=
"0" CELLBORDER=
"1" CELLSPACING=
"0" BGCOLOR=
"#ffffff">
131 <TR
><TD COLSPAN=
"3" BGCOLOR=
"#f5f5f5"><TABLE BORDER=
"0" CELLSPACING=
"0"><TR
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"123" HEIGHT=
"16"><B
>form_CAMOS_item
</B
></TD
><TD ALIGN=
"RIGHT">[table]
</TD
></TR
></TABLE
></TD
></TR
>
132 <TR
><TD PORT=
"id" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/primaryKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"123" HEIGHT=
"16">id
</TD
></TR
></TABLE
></TD
></TR
>
133 <TR
><TD PORT=
"pid" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/foreignKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"123" HEIGHT=
"16">pid
</TD
></TR
></TABLE
></TD
></TR
>
134 <TR
><TD PORT=
"user" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/foreignKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"123" HEIGHT=
"16">user
</TD
></TR
></TABLE
></TD
></TR
>
135 <TR
><TD PORT=
"groupname" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/foreignKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"123" HEIGHT=
"16">groupname
</TD
></TR
></TABLE
></TD
></TR
>
136 <TR
><TD PORT=
"item" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/primaryKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"123" HEIGHT=
"16">item
</TD
></TR
></TABLE
></TD
></TR
>
137 <TR
><TD PORT=
"subcategory_id" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/foreignKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"123" HEIGHT=
"16">subcategory_id
</TD
></TR
></TABLE
></TD
></TR
>
138 <TR
><TD PORT=
"elipses" COLSPAN=
"3" ALIGN=
"LEFT">...</TD
></TR
>
139 <TR
><TD ALIGN=
"LEFT" BGCOLOR=
"#ffffff"><
; 4</TD
><TD ALIGN=
"RIGHT" BGCOLOR=
"#ffffff"> </TD
><TD ALIGN=
"RIGHT" BGCOLOR=
"#ffffff">2 >
;</TD
></TR
>
141 URL=
"../../tables/form_CAMOS_item.html"
143 tooltip=
"form_CAMOS_item"
145 "form_group_attendance" [
147 <TABLE BORDER=
"0" CELLBORDER=
"1" CELLSPACING=
"0" BGCOLOR=
"#ffffff">
148 <TR
><TD COLSPAN=
"3" BGCOLOR=
"#f5f5f5"><TABLE BORDER=
"0" CELLSPACING=
"0"><TR
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"160" HEIGHT=
"16"><B
>form_group_attendance
</B
></TD
><TD ALIGN=
"RIGHT">[table]
</TD
></TR
></TABLE
></TD
></TR
>
149 <TR
><TD PORT=
"id" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/primaryKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"160" HEIGHT=
"16">id
</TD
></TR
></TABLE
></TD
></TR
>
150 <TR
><TD PORT=
"group_id" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/foreignKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"160" HEIGHT=
"16">group_id
</TD
></TR
></TABLE
></TD
></TR
>
151 <TR
><TD PORT=
"user" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/foreignKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"160" HEIGHT=
"16">user
</TD
></TR
></TABLE
></TD
></TR
>
152 <TR
><TD PORT=
"groupname" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/foreignKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"160" HEIGHT=
"16">groupname
</TD
></TR
></TABLE
></TD
></TR
>
153 <TR
><TD PORT=
"encounter_id" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/foreignKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"160" HEIGHT=
"16">encounter_id
</TD
></TR
></TABLE
></TD
></TR
>
154 <TR
><TD PORT=
"elipses" COLSPAN=
"3" ALIGN=
"LEFT">...</TD
></TR
>
155 <TR
><TD ALIGN=
"LEFT" BGCOLOR=
"#ffffff"><
; 5</TD
><TD ALIGN=
"RIGHT" BGCOLOR=
"#ffffff"> </TD
><TD ALIGN=
"RIGHT" BGCOLOR=
"#ffffff">1 >
;</TD
></TR
>
157 URL=
"../../tables/form_group_attendance.html"
159 tooltip=
"form_group_attendance"
163 <TABLE BORDER=
"0" CELLBORDER=
"1" CELLSPACING=
"0" BGCOLOR=
"#ffffff">
164 <TR
><TD COLSPAN=
"3" BGCOLOR=
"#f5f5f5"><TABLE BORDER=
"0" CELLSPACING=
"0"><TR
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"96" HEIGHT=
"16"><B
>form_painmap
</B
></TD
><TD ALIGN=
"RIGHT">[table]
</TD
></TR
></TABLE
></TD
></TR
>
165 <TR
><TD PORT=
"id" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/primaryKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"96" HEIGHT=
"16">id
</TD
></TR
></TABLE
></TD
></TR
>
166 <TR
><TD PORT=
"pid" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/foreignKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"96" HEIGHT=
"16">pid
</TD
></TR
></TABLE
></TD
></TR
>
167 <TR
><TD PORT=
"user" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/foreignKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"96" HEIGHT=
"16">user
</TD
></TR
></TABLE
></TD
></TR
>
168 <TR
><TD PORT=
"groupname" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/foreignKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"96" HEIGHT=
"16">groupname
</TD
></TR
></TABLE
></TD
></TR
>
169 <TR
><TD PORT=
"elipses" COLSPAN=
"3" ALIGN=
"LEFT">...</TD
></TR
>
170 <TR
><TD ALIGN=
"LEFT" BGCOLOR=
"#ffffff"><
; 4</TD
><TD ALIGN=
"RIGHT" BGCOLOR=
"#ffffff"> </TD
><TD ALIGN=
"RIGHT" BGCOLOR=
"#ffffff"> </TD
></TR
>
172 URL=
"../../tables/form_painmap.html"
174 tooltip=
"form_painmap"
178 <TABLE BORDER=
"0" CELLBORDER=
"1" CELLSPACING=
"0" BGCOLOR=
"#ffffff">
179 <TR
><TD COLSPAN=
"3" BGCOLOR=
"#f5f5f5"><TABLE BORDER=
"0" CELLSPACING=
"0"><TR
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"71" HEIGHT=
"16"><B
>form_phq9
</B
></TD
><TD ALIGN=
"RIGHT">[table]
</TD
></TR
></TABLE
></TD
></TR
>
180 <TR
><TD PORT=
"id" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/primaryKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"161" HEIGHT=
"16">id
</TD
></TR
></TABLE
></TD
></TR
>
181 <TR
><TD PORT=
"pid" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/foreignKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"161" HEIGHT=
"16">pid
</TD
></TR
></TABLE
></TD
></TR
>
182 <TR
><TD PORT=
"user" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/foreignKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"161" HEIGHT=
"16">user
</TD
></TR
></TABLE
></TD
></TR
>
183 <TR
><TD PORT=
"groupname" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/foreignKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"161" HEIGHT=
"16">groupname
</TD
></TR
></TABLE
></TD
></TR
>
184 <TR
><TD PORT=
"elipses" COLSPAN=
"3" ALIGN=
"LEFT">...</TD
></TR
>
185 <TR
><TD ALIGN=
"LEFT" BGCOLOR=
"#ffffff"><
; 4</TD
><TD ALIGN=
"RIGHT" BGCOLOR=
"#ffffff"> </TD
><TD ALIGN=
"RIGHT" BGCOLOR=
"#ffffff"> </TD
></TR
>
187 URL=
"../../tables/form_phq9.html"
191 "form_questionnaire_assessments" [
193 <TABLE BORDER=
"0" CELLBORDER=
"1" CELLSPACING=
"0" BGCOLOR=
"#ffffff">
194 <TR
><TD COLSPAN=
"3" BGCOLOR=
"#f5f5f5"><TABLE BORDER=
"0" CELLSPACING=
"0"><TR
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"224" HEIGHT=
"16"><B
>form_questionnaire_assessments
</B
></TD
><TD ALIGN=
"RIGHT">[table]
</TD
></TR
></TABLE
></TD
></TR
>
195 <TR
><TD PORT=
"id" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/primaryKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"224" HEIGHT=
"16">id
</TD
></TR
></TABLE
></TD
></TR
>
196 <TR
><TD PORT=
"response_id" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/foreignKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"224" HEIGHT=
"16">response_id
</TD
></TR
></TABLE
></TD
></TR
>
197 <TR
><TD PORT=
"pid" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/foreignKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"224" HEIGHT=
"16">pid
</TD
></TR
></TABLE
></TD
></TR
>
198 <TR
><TD PORT=
"user" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/foreignKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"224" HEIGHT=
"16">user
</TD
></TR
></TABLE
></TD
></TR
>
199 <TR
><TD PORT=
"groupname" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/foreignKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"224" HEIGHT=
"16">groupname
</TD
></TR
></TABLE
></TD
></TR
>
200 <TR
><TD PORT=
"questionnaire_id" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/foreignKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"224" HEIGHT=
"16">questionnaire_id
</TD
></TR
></TABLE
></TD
></TR
>
201 <TR
><TD PORT=
"elipses" COLSPAN=
"3" ALIGN=
"LEFT">...</TD
></TR
>
202 <TR
><TD ALIGN=
"LEFT" BGCOLOR=
"#ffffff"><
; 5</TD
><TD ALIGN=
"RIGHT" BGCOLOR=
"#ffffff"> </TD
><TD ALIGN=
"RIGHT" BGCOLOR=
"#ffffff"> </TD
></TR
>
204 URL=
"../../tables/form_questionnaire_assessments.html"
206 tooltip=
"form_questionnaire_assessments"
210 <TABLE BORDER=
"0" CELLBORDER=
"1" CELLSPACING=
"0" BGCOLOR=
"#ffffff">
211 <TR
><TD COLSPAN=
"3" BGCOLOR=
"#f5f5f5"><TABLE BORDER=
"0" CELLSPACING=
"0"><TR
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"70" HEIGHT=
"16"><B
>form_sdoh
</B
></TD
><TD ALIGN=
"RIGHT">[table]
</TD
></TR
></TABLE
></TD
></TR
>
212 <TR
><TD PORT=
"id" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/primaryKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"143" HEIGHT=
"16">id
</TD
></TR
></TABLE
></TD
></TR
>
213 <TR
><TD PORT=
"pid" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/foreignKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"143" HEIGHT=
"16">pid
</TD
></TR
></TABLE
></TD
></TR
>
214 <TR
><TD PORT=
"user" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/foreignKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"143" HEIGHT=
"16">user
</TD
></TR
></TABLE
></TD
></TR
>
215 <TR
><TD PORT=
"groupname" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/foreignKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"143" HEIGHT=
"16">groupname
</TD
></TR
></TABLE
></TD
></TR
>
216 <TR
><TD PORT=
"elipses" COLSPAN=
"3" ALIGN=
"LEFT">...</TD
></TR
>
217 <TR
><TD ALIGN=
"LEFT" BGCOLOR=
"#ffffff"><
; 4</TD
><TD ALIGN=
"RIGHT" BGCOLOR=
"#ffffff"> </TD
><TD ALIGN=
"RIGHT" BGCOLOR=
"#ffffff"> </TD
></TR
>
219 URL=
"../../tables/form_sdoh.html"
223 "form_treatment_plan" [
225 <TABLE BORDER=
"0" CELLBORDER=
"1" CELLSPACING=
"0" BGCOLOR=
"#ffffff">
226 <TR
><TD COLSPAN=
"3" BGCOLOR=
"#f5f5f5"><TABLE BORDER=
"0" CELLSPACING=
"0"><TR
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"141" HEIGHT=
"16"><B
>form_treatment_plan
</B
></TD
><TD ALIGN=
"RIGHT">[table]
</TD
></TR
></TABLE
></TD
></TR
>
227 <TR
><TD PORT=
"id" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/primaryKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"209" HEIGHT=
"16">id
</TD
></TR
></TABLE
></TD
></TR
>
228 <TR
><TD PORT=
"pid" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/foreignKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"209" HEIGHT=
"16">pid
</TD
></TR
></TABLE
></TD
></TR
>
229 <TR
><TD PORT=
"user" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/foreignKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"209" HEIGHT=
"16">user
</TD
></TR
></TABLE
></TD
></TR
>
230 <TR
><TD PORT=
"groupname" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/foreignKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"209" HEIGHT=
"16">groupname
</TD
></TR
></TABLE
></TD
></TR
>
231 <TR
><TD PORT=
"elipses" COLSPAN=
"3" ALIGN=
"LEFT">...</TD
></TR
>
232 <TR
><TD ALIGN=
"LEFT" BGCOLOR=
"#ffffff"><
; 4</TD
><TD ALIGN=
"RIGHT" BGCOLOR=
"#ffffff"> </TD
><TD ALIGN=
"RIGHT" BGCOLOR=
"#ffffff"> </TD
></TR
>
234 URL=
"../../tables/form_treatment_plan.html"
236 tooltip=
"form_treatment_plan"
240 <TABLE BORDER=
"0" CELLBORDER=
"1" CELLSPACING=
"0" BGCOLOR=
"#ffffff">
241 <TR
><TD COLSPAN=
"3" BGCOLOR=
"#f5f5f5"><TABLE BORDER=
"0" CELLSPACING=
"0"><TR
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"74" HEIGHT=
"16"><B
>form_vitals
</B
></TD
><TD ALIGN=
"RIGHT">[table]
</TD
></TR
></TABLE
></TD
></TR
>
242 <TR
><TD PORT=
"id" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/primaryKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"205" HEIGHT=
"16">id
</TD
></TR
></TABLE
></TD
></TR
>
243 <TR
><TD PORT=
"uuid" COLSPAN=
"3" BGCOLOR=
"#ffffff" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"205" HEIGHT=
"16">uuid
</TD
></TR
></TABLE
></TD
></TR
>
244 <TR
><TD PORT=
"pid" COLSPAN=
"3" BGCOLOR=
"#ffffff" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/foreignKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"205" HEIGHT=
"16">pid
</TD
></TR
></TABLE
></TD
></TR
>
245 <TR
><TD PORT=
"user" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/foreignKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"205" HEIGHT=
"16">user
</TD
></TR
></TABLE
></TD
></TR
>
246 <TR
><TD PORT=
"groupname" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/foreignKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"205" HEIGHT=
"16">groupname
</TD
></TR
></TABLE
></TD
></TR
>
247 <TR
><TD PORT=
"elipses" COLSPAN=
"3" ALIGN=
"LEFT">...</TD
></TR
>
248 <TR
><TD ALIGN=
"LEFT" BGCOLOR=
"#ffffff"><
; 3</TD
><TD ALIGN=
"RIGHT" BGCOLOR=
"#ffffff"> </TD
><TD ALIGN=
"RIGHT" BGCOLOR=
"#ffffff">1 >
;</TD
></TR
>
250 URL=
"../../tables/form_vitals.html"
252 tooltip=
"form_vitals"
256 <TABLE BORDER=
"0" CELLBORDER=
"1" CELLSPACING=
"0" BGCOLOR=
"#ffffff">
257 <TR
><TD COLSPAN=
"3" BGCOLOR=
"#f5f5f5"><TABLE BORDER=
"0" CELLSPACING=
"0"><TR
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"39" HEIGHT=
"16"><B
>forms
</B
></TD
><TD ALIGN=
"RIGHT">[table]
</TD
></TR
></TABLE
></TD
></TR
>
258 <TR
><TD PORT=
"id" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/primaryKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"117" HEIGHT=
"16">id
</TD
></TR
></TABLE
></TD
></TR
>
259 <TR
><TD PORT=
"encounter" COLSPAN=
"3" BGCOLOR=
"#ffffff" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"117" HEIGHT=
"16">encounter
</TD
></TR
></TABLE
></TD
></TR
>
260 <TR
><TD PORT=
"form_id" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/primaryKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"117" HEIGHT=
"16">form_id
</TD
></TR
></TABLE
></TD
></TR
>
261 <TR
><TD PORT=
"pid" COLSPAN=
"3" BGCOLOR=
"#ffffff" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/foreignKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"117" HEIGHT=
"16">pid
</TD
></TR
></TABLE
></TD
></TR
>
262 <TR
><TD PORT=
"user" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/foreignKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"117" HEIGHT=
"16">user
</TD
></TR
></TABLE
></TD
></TR
>
263 <TR
><TD PORT=
"groupname" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/foreignKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"117" HEIGHT=
"16">groupname
</TD
></TR
></TABLE
></TD
></TR
>
264 <TR
><TD PORT=
"therapy_group_id" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/foreignKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"117" HEIGHT=
"16">therapy_group_id
</TD
></TR
></TABLE
></TD
></TR
>
265 <TR
><TD PORT=
"issue_id" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/foreignKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"117" HEIGHT=
"16">issue_id
</TD
></TR
></TABLE
></TD
></TR
>
266 <TR
><TD PORT=
"provider_id" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/foreignKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"117" HEIGHT=
"16">provider_id
</TD
></TR
></TABLE
></TD
></TR
>
267 <TR
><TD PORT=
"elipses" COLSPAN=
"3" ALIGN=
"LEFT">...</TD
></TR
>
268 <TR
><TD ALIGN=
"LEFT" BGCOLOR=
"#ffffff"><
; 6</TD
><TD ALIGN=
"RIGHT" BGCOLOR=
"#ffffff"> </TD
><TD ALIGN=
"RIGHT" BGCOLOR=
"#ffffff">13 >
;</TD
></TR
>
270 URL=
"../../tables/forms.html"
276 <TABLE BORDER=
"2" CELLBORDER=
"1" CELLSPACING=
"0" BGCOLOR=
"#ffffff">
277 <TR
><TD COLSPAN=
"4" BGCOLOR=
"#f5f5f5"><TABLE BORDER=
"0" CELLSPACING=
"0"><TR
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"47" HEIGHT=
"16"><B
>groups
</B
></TD
><TD ALIGN=
"RIGHT">[table]
</TD
></TR
></TABLE
></TD
></TR
>
278 <TR
><TD PORT=
"id" COLSPAN=
"2" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/primaryKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"47" HEIGHT=
"16">id
</TD
></TR
></TABLE
></TD
><TD PORT=
"id.type" ALIGN=
"LEFT">bigint[
19]
</TD
></TR
>
279 <TR
><TD PORT=
"name" COLSPAN=
"2" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/primaryKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"47" HEIGHT=
"16">name
</TD
></TR
></TABLE
></TD
><TD PORT=
"name.type" ALIGN=
"LEFT">longtext[
2147483647]
</TD
></TR
>
280 <TR
><TD PORT=
"user" COLSPAN=
"2" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/foreignKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"47" HEIGHT=
"16">user
</TD
></TR
></TABLE
></TD
><TD PORT=
"user.type" ALIGN=
"LEFT">longtext[
2147483647]
</TD
></TR
>
281 <TR
><TD ALIGN=
"LEFT" BGCOLOR=
"#ffffff"><
; 1</TD
><TD ALIGN=
"RIGHT" BGCOLOR=
"#ffffff"> </TD
><TD ALIGN=
"RIGHT" BGCOLOR=
"#ffffff">17 >
;</TD
></TR
>
283 URL=
"../../tables/groups.html"
289 <TABLE BORDER=
"0" CELLBORDER=
"1" CELLSPACING=
"0" BGCOLOR=
"#ffffff">
290 <TR
><TD COLSPAN=
"3" BGCOLOR=
"#f5f5f5"><TABLE BORDER=
"0" CELLSPACING=
"0"><TR
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"28" HEIGHT=
"16"><B
>lists
</B
></TD
><TD ALIGN=
"RIGHT">[table]
</TD
></TR
></TABLE
></TD
></TR
>
291 <TR
><TD PORT=
"id" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/primaryKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"121" HEIGHT=
"16">id
</TD
></TR
></TABLE
></TD
></TR
>
292 <TR
><TD PORT=
"uuid" COLSPAN=
"3" BGCOLOR=
"#ffffff" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"121" HEIGHT=
"16">uuid
</TD
></TR
></TABLE
></TD
></TR
>
293 <TR
><TD PORT=
"type" COLSPAN=
"3" BGCOLOR=
"#ffffff" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/foreignKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"121" HEIGHT=
"16">type
</TD
></TR
></TABLE
></TD
></TR
>
294 <TR
><TD PORT=
"subtype" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/foreignKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"121" HEIGHT=
"16">subtype
</TD
></TR
></TABLE
></TD
></TR
>
295 <TR
><TD PORT=
"occurrence" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/foreignKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"121" HEIGHT=
"16">occurrence
</TD
></TR
></TABLE
></TD
></TR
>
296 <TR
><TD PORT=
"pid" COLSPAN=
"3" BGCOLOR=
"#ffffff" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/foreignKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"121" HEIGHT=
"16">pid
</TD
></TR
></TABLE
></TD
></TR
>
297 <TR
><TD PORT=
"user" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/foreignKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"121" HEIGHT=
"16">user
</TD
></TR
></TABLE
></TD
></TR
>
298 <TR
><TD PORT=
"groupname" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/foreignKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"121" HEIGHT=
"16">groupname
</TD
></TR
></TABLE
></TD
></TR
>
299 <TR
><TD PORT=
"outcome" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/foreignKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"121" HEIGHT=
"16">outcome
</TD
></TR
></TABLE
></TD
></TR
>
300 <TR
><TD PORT=
"reaction" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/foreignKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"121" HEIGHT=
"16">reaction
</TD
></TR
></TABLE
></TD
></TR
>
301 <TR
><TD PORT=
"verification" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/foreignKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"121" HEIGHT=
"16">verification
</TD
></TR
></TABLE
></TD
></TR
>
302 <TR
><TD PORT=
"severity_al" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/foreignKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"121" HEIGHT=
"16">severity_al
</TD
></TR
></TABLE
></TD
></TR
>
303 <TR
><TD PORT=
"list_option_id" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/foreignKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"121" HEIGHT=
"16">list_option_id
</TD
></TR
></TABLE
></TD
></TR
>
304 <TR
><TD PORT=
"elipses" COLSPAN=
"3" ALIGN=
"LEFT">...</TD
></TR
>
305 <TR
><TD ALIGN=
"LEFT" BGCOLOR=
"#ffffff"><
; 11</TD
><TD ALIGN=
"RIGHT" BGCOLOR=
"#ffffff"> </TD
><TD ALIGN=
"RIGHT" BGCOLOR=
"#ffffff">4 >
;</TD
></TR
>
307 URL=
"../../tables/lists.html"
313 <TABLE BORDER=
"0" CELLBORDER=
"1" CELLSPACING=
"0" BGCOLOR=
"#ffffff">
314 <TR
><TD COLSPAN=
"3" BGCOLOR=
"#f5f5f5"><TABLE BORDER=
"0" CELLSPACING=
"0"><TR
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"71" HEIGHT=
"16"><B
>form_gad7
</B
></TD
><TD ALIGN=
"RIGHT">[table]
</TD
></TR
></TABLE
></TD
></TR
>
315 <TR
><TD PORT=
"groupname" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/foreignKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"77" HEIGHT=
"16">groupname
</TD
></TR
></TABLE
></TD
></TR
>
316 <TR
><TD PORT=
"id" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/foreignKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"77" HEIGHT=
"16">id
</TD
></TR
></TABLE
></TD
></TR
>
317 <TR
><TD PORT=
"pid" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/foreignKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"77" HEIGHT=
"16">pid
</TD
></TR
></TABLE
></TD
></TR
>
318 <TR
><TD PORT=
"user" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/foreignKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"77" HEIGHT=
"16">user
</TD
></TR
></TABLE
></TD
></TR
>
319 <TR
><TD ALIGN=
"LEFT" BGCOLOR=
"#ffffff"><
; 4</TD
><TD ALIGN=
"RIGHT" BGCOLOR=
"#ffffff"> </TD
><TD ALIGN=
"RIGHT" BGCOLOR=
"#ffffff"> </TD
></TR
>
321 URL=
"../../tables/form_gad7.html"
327 <TABLE BORDER=
"0" CELLBORDER=
"1" CELLSPACING=
"0" BGCOLOR=
"#ffffff">
328 <TR
><TD COLSPAN=
"3" BGCOLOR=
"#f5f5f5"><TABLE BORDER=
"0" CELLSPACING=
"0"><TR
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"46" HEIGHT=
"16"><B
>pnotes
</B
></TD
><TD ALIGN=
"RIGHT">[table]
</TD
></TR
></TABLE
></TD
></TR
>
329 <TR
><TD PORT=
"id" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/primaryKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"120" HEIGHT=
"16">id
</TD
></TR
></TABLE
></TD
></TR
>
330 <TR
><TD PORT=
"pid" COLSPAN=
"3" BGCOLOR=
"#ffffff" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/foreignKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"120" HEIGHT=
"16">pid
</TD
></TR
></TABLE
></TD
></TR
>
331 <TR
><TD PORT=
"user" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/foreignKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"120" HEIGHT=
"16">user
</TD
></TR
></TABLE
></TD
></TR
>
332 <TR
><TD PORT=
"groupname" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/foreignKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"120" HEIGHT=
"16">groupname
</TD
></TR
></TABLE
></TD
></TR
>
333 <TR
><TD PORT=
"assigned_to" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/foreignKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"120" HEIGHT=
"16">assigned_to
</TD
></TR
></TABLE
></TD
></TR
>
334 <TR
><TD PORT=
"message_status" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/foreignKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"120" HEIGHT=
"16">message_status
</TD
></TR
></TABLE
></TD
></TR
>
335 <TR
><TD PORT=
"update_by" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/foreignKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"120" HEIGHT=
"16">update_by
</TD
></TR
></TABLE
></TD
></TR
>
336 <TR
><TD PORT=
"elipses" COLSPAN=
"3" ALIGN=
"LEFT">...</TD
></TR
>
337 <TR
><TD ALIGN=
"LEFT" BGCOLOR=
"#ffffff"><
; 6</TD
><TD ALIGN=
"RIGHT" BGCOLOR=
"#ffffff"> </TD
><TD ALIGN=
"RIGHT" BGCOLOR=
"#ffffff"> </TD
></TR
>
339 URL=
"../../tables/pnotes.html"
345 <TABLE BORDER=
"0" CELLBORDER=
"1" CELLSPACING=
"0" BGCOLOR=
"#ffffff">
346 <TR
><TD COLSPAN=
"3" BGCOLOR=
"#f5f5f5"><TABLE BORDER=
"0" CELLSPACING=
"0"><TR
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"36" HEIGHT=
"16"><B
>users
</B
></TD
><TD ALIGN=
"RIGHT">[table]
</TD
></TR
></TABLE
></TD
></TR
>
347 <TR
><TD PORT=
"id" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/primaryKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"146" HEIGHT=
"16">id
</TD
></TR
></TABLE
></TD
></TR
>
348 <TR
><TD PORT=
"uuid" COLSPAN=
"3" BGCOLOR=
"#ffffff" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"146" HEIGHT=
"16">uuid
</TD
></TR
></TABLE
></TD
></TR
>
349 <TR
><TD PORT=
"username" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/primaryKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"146" HEIGHT=
"16">username
</TD
></TR
></TABLE
></TD
></TR
>
350 <TR
><TD PORT=
"facility_id" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/foreignKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"146" HEIGHT=
"16">facility_id
</TD
></TR
></TABLE
></TD
></TR
>
351 <TR
><TD PORT=
"google_signin_email" COLSPAN=
"3" BGCOLOR=
"#ffffff" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"146" HEIGHT=
"16">google_signin_email
</TD
></TR
></TABLE
></TD
></TR
>
352 <TR
><TD PORT=
"abook_type" COLSPAN=
"3" BGCOLOR=
"#ffffff" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"146" HEIGHT=
"16">abook_type
</TD
></TR
></TABLE
></TD
></TR
>
353 <TR
><TD PORT=
"billing_facility_id" COLSPAN=
"3" ALIGN=
"LEFT"><TABLE BORDER=
"0" CELLSPACING=
"0" ALIGN=
"LEFT"><TR ALIGN=
"LEFT"><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"15" HEIGHT=
"16"><IMG SRC=
"../../images/foreignKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"146" HEIGHT=
"16">billing_facility_id
</TD
></TR
></TABLE
></TD
></TR
>
354 <TR
><TD PORT=
"elipses" COLSPAN=
"3" ALIGN=
"LEFT">...</TD
></TR
>
355 <TR
><TD ALIGN=
"LEFT" BGCOLOR=
"#ffffff"><
; 2</TD
><TD ALIGN=
"RIGHT" BGCOLOR=
"#ffffff"> </TD
><TD ALIGN=
"RIGHT" BGCOLOR=
"#ffffff">61 >
;</TD
></TR
>
357 URL=
"../../tables/users.html"