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 "form_clinic_note":"id":w
-> "forms":"form_id":e [
arrowhead=
none dir=back
arrowtail=teeodot]
;
6 <TABLE BORDER=
"2" CELLBORDER=
"1" CELLSPACING=
"0" BGCOLOR=
"#ffffff">
7 <TR
><TD COLSPAN=
"4" BGCOLOR=
"#f5f5f5"><TABLE BORDER=
"0" CELLSPACING=
"0"><TR
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"109" HEIGHT=
"16"><B
>form_clinic_note
</B
></TD
><TD ALIGN=
"RIGHT">[table]
</TD
></TR
></TABLE
></TD
></TR
>
8 <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=
"122" HEIGHT=
"16">id
</TD
></TR
></TABLE
></TD
><TD PORT=
"id.type" ALIGN=
"LEFT">bigint[
19]
</TD
></TR
>
9 <TR
><TD PORT=
"activity" COLSPAN=
"2" 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=
"122" HEIGHT=
"16">activity
</TD
></TR
></TABLE
></TD
><TD PORT=
"activity.type" ALIGN=
"LEFT">bit[
1]
</TD
></TR
>
10 <TR
><TD PORT=
"history" COLSPAN=
"2" 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=
"122" HEIGHT=
"16">history
</TD
></TR
></TABLE
></TD
><TD PORT=
"history.type" ALIGN=
"LEFT">text[
65535]
</TD
></TR
>
11 <TR
><TD PORT=
"examination" COLSPAN=
"2" 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=
"122" HEIGHT=
"16">examination
</TD
></TR
></TABLE
></TD
><TD PORT=
"examination.type" ALIGN=
"LEFT">text[
65535]
</TD
></TR
>
12 <TR
><TD PORT=
"plan" COLSPAN=
"2" 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=
"122" HEIGHT=
"16">plan
</TD
></TR
></TABLE
></TD
><TD PORT=
"plan.type" ALIGN=
"LEFT">text[
65535]
</TD
></TR
>
13 <TR
><TD PORT=
"followup_required" COLSPAN=
"2" 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=
"122" HEIGHT=
"16">followup_required
</TD
></TR
></TABLE
></TD
><TD PORT=
"followup_required.type" ALIGN=
"LEFT">int[
10]
</TD
></TR
>
14 <TR
><TD PORT=
"followup_timing" COLSPAN=
"2" 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=
"122" HEIGHT=
"16">followup_timing
</TD
></TR
></TABLE
></TD
><TD PORT=
"followup_timing.type" ALIGN=
"LEFT">varchar[
255]
</TD
></TR
>
15 <TR
><TD ALIGN=
"LEFT" BGCOLOR=
"#ffffff"><
; 1</TD
><TD ALIGN=
"RIGHT" BGCOLOR=
"#ffffff"> </TD
><TD ALIGN=
"RIGHT" BGCOLOR=
"#ffffff">0 >
;</TD
></TR
>
17 URL=
"../../tables/form_clinic_note.html"
19 tooltip=
"form_clinic_note"
23 <TABLE BORDER=
"0" CELLBORDER=
"1" CELLSPACING=
"0" BGCOLOR=
"#ffffff">
24 <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
>
25 <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
>
26 <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
>
27 <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
>
28 <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
>
29 <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
>
30 <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
>
31 <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
>
32 <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
>
33 <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
>
34 <TR
><TD PORT=
"elipses" COLSPAN=
"3" ALIGN=
"LEFT">...</TD
></TR
>
35 <TR
><TD ALIGN=
"LEFT" BGCOLOR=
"#ffffff"><
; 6</TD
><TD ALIGN=
"RIGHT" BGCOLOR=
"#ffffff"> </TD
><TD ALIGN=
"RIGHT" BGCOLOR=
"#ffffff">13 >
;</TD
></TR
>
37 URL=
"../../tables/forms.html"