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 "therapy_groups_participants":"group_id":w
-> "therapy_groups":"group_id":e [
arrowhead=
none dir=back
arrowtail=crowodot]
;
4 "therapy_groups_participants":"pid":w
-> "patient_data":"pid":e [
arrowhead=
none dir=back
arrowtail=crowodot]
;
7 <TABLE BORDER=
"0" CELLBORDER=
"1" CELLSPACING=
"0" BGCOLOR=
"#ffffff">
8 <TR
><TD COLSPAN=
"3" BGCOLOR=
"#f5f5f5"><TABLE BORDER=
"0" CELLSPACING=
"0"><TR
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"85" HEIGHT=
"16"><B
>patient_data
</B
></TD
><TD ALIGN=
"RIGHT">[table]
</TD
></TR
></TABLE
></TD
></TR
>
9 <TR
><TD PORT=
"id" 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">id
</TD
></TR
></TABLE
></TD
></TR
>
10 <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
>
11 <TR
><TD PORT=
"pharmacy_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">pharmacy_id
</TD
></TR
></TABLE
></TD
></TR
>
12 <TR
><TD PORT=
"providerID" 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">providerID
</TD
></TR
></TABLE
></TD
></TR
>
13 <TR
><TD PORT=
"ref_providerID" 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">ref_providerID
</TD
></TR
></TABLE
></TD
></TR
>
14 <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/primaryKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"146" HEIGHT=
"16">pid
</TD
></TR
></TABLE
></TD
></TR
>
15 <TR
><TD PORT=
"created_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=
"146" HEIGHT=
"16">created_by
</TD
></TR
></TABLE
></TD
></TR
>
16 <TR
><TD PORT=
"updated_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=
"146" HEIGHT=
"16">updated_by
</TD
></TR
></TABLE
></TD
></TR
>
17 <TR
><TD PORT=
"elipses" COLSPAN=
"3" ALIGN=
"LEFT">...</TD
></TR
>
18 <TR
><TD ALIGN=
"LEFT" BGCOLOR=
"#ffffff"><
; 5</TD
><TD ALIGN=
"RIGHT" BGCOLOR=
"#ffffff"> </TD
><TD ALIGN=
"RIGHT" BGCOLOR=
"#ffffff">85 >
;</TD
></TR
>
20 URL=
"../../tables/patient_data.html"
22 tooltip=
"patient_data"
26 <TABLE BORDER=
"0" CELLBORDER=
"1" CELLSPACING=
"0" BGCOLOR=
"#ffffff">
27 <TR
><TD COLSPAN=
"3" BGCOLOR=
"#f5f5f5"><TABLE BORDER=
"0" CELLSPACING=
"0"><TR
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"105" HEIGHT=
"16"><B
>therapy_groups
</B
></TD
><TD ALIGN=
"RIGHT">[table]
</TD
></TR
></TABLE
></TD
></TR
>
28 <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/primaryKeys.png"/
></TD
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"163" HEIGHT=
"16">group_id
</TD
></TR
></TABLE
></TD
></TR
>
29 <TR
><TD PORT=
"elipses" COLSPAN=
"3" ALIGN=
"LEFT">...</TD
></TR
>
30 <TR
><TD ALIGN=
"LEFT" BGCOLOR=
"#ffffff"> </TD
><TD ALIGN=
"RIGHT" BGCOLOR=
"#ffffff"> </TD
><TD ALIGN=
"RIGHT" BGCOLOR=
"#ffffff">6 >
;</TD
></TR
>
32 URL=
"../../tables/therapy_groups.html"
34 tooltip=
"therapy_groups"
36 "therapy_groups_participants" [
38 <TABLE BORDER=
"2" CELLBORDER=
"1" CELLSPACING=
"0" BGCOLOR=
"#ffffff">
39 <TR
><TD COLSPAN=
"4" BGCOLOR=
"#f5f5f5"><TABLE BORDER=
"0" CELLSPACING=
"0"><TR
><TD ALIGN=
"LEFT" FIXEDSIZE=
"TRUE" WIDTH=
"193" HEIGHT=
"16"><B
>therapy_groups_participants
</B
></TD
><TD ALIGN=
"RIGHT">[table]
</TD
></TR
></TABLE
></TD
></TR
>
40 <TR
><TD PORT=
"group_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=
"193" HEIGHT=
"16">group_id
</TD
></TR
></TABLE
></TD
><TD PORT=
"group_id.type" ALIGN=
"LEFT">int[
10]
</TD
></TR
>
41 <TR
><TD PORT=
"pid" 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=
"193" HEIGHT=
"16">pid
</TD
></TR
></TABLE
></TD
><TD PORT=
"pid.type" ALIGN=
"LEFT">bigint[
19]
</TD
></TR
>
42 <TR
><TD PORT=
"group_patient_status" 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=
"193" HEIGHT=
"16">group_patient_status
</TD
></TR
></TABLE
></TD
><TD PORT=
"group_patient_status.type" ALIGN=
"LEFT">int[
10]
</TD
></TR
>
43 <TR
><TD PORT=
"group_patient_start" 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=
"193" HEIGHT=
"16">group_patient_start
</TD
></TR
></TABLE
></TD
><TD PORT=
"group_patient_start.type" ALIGN=
"LEFT">date[
10]
</TD
></TR
>
44 <TR
><TD PORT=
"group_patient_end" 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=
"193" HEIGHT=
"16">group_patient_end
</TD
></TR
></TABLE
></TD
><TD PORT=
"group_patient_end.type" ALIGN=
"LEFT">date[
10]
</TD
></TR
>
45 <TR
><TD PORT=
"group_patient_comment" 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=
"193" HEIGHT=
"16">group_patient_comment
</TD
></TR
></TABLE
></TD
><TD PORT=
"group_patient_comment.type" ALIGN=
"LEFT">text[
65535]
</TD
></TR
>
46 <TR
><TD ALIGN=
"LEFT" BGCOLOR=
"#ffffff"><
; 2</TD
><TD ALIGN=
"RIGHT" BGCOLOR=
"#ffffff"> </TD
><TD ALIGN=
"RIGHT" BGCOLOR=
"#ffffff">0 >
;</TD
></TR
>
48 URL=
"../../tables/therapy_groups_participants.html"
50 tooltip=
"therapy_groups_participants"