therapy_groups_participants


If there is patient data for this table the file for this export will be found in the extracted zip folder location under the filename of therapy_groups_participants.csv

If there are non-patient data column elements that are not part of the designated record set they will be marked in the Comment's column for that data element

Description

Connects the patient participants to a therapy group

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