therapy_groups_participants

Columns

Column	Type	Size	Nulls	Auto	Default	Children	Parents	Comments
group_id	INT	10			null

|

| therapy_groups.group_id | Defined in XML | R |

| | | pid | BIGINT | 19 | | | null |

|

| patient_data.pid | Defined in XML | R |

|

The internal patient identifier

| | group_patient_status | INT | 10 | | | null |

|

| | | group_patient_start | DATE | 10 | | | null |

|

| | | group_patient_end | DATE | 10 | √ | | NULL |

|

| | | group_patient_comment | TEXT | 65535 | √ | | NULL |

|

| |

Indexes

Constraint Name	Type	Sort	Column(s)
PRIMARY	Primary key	Asc/Asc	group_id + pid

Relationships

Close relationships within degrees of separation