groups


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 groups.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

Represent groups of users in the system

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null

Surrogate id of the record used as the primary incrementing key.
name LONGTEXT 2147483647 √ NULL
billing.groupname Defined in XML R
form_group_attendance.groupname Defined in XML R
form_questionnaire_assessments.groupname Defined in XML R
form_vitals.groupname Defined in XML R
forms.groupname Defined in XML R
lists.groupname Defined in XML R
form_aftercare_plan.groupname Defined in XML R
form_ankleinjury.groupname Defined in XML R
form_bronchitis.groupname Defined in XML R
form_CAMOS_category.groupname Defined in XML R
form_CAMOS_item.groupname Defined in XML R
form_gad7.groupname Defined in XML R
form_painmap.groupname Defined in XML R
form_phq9.groupname Defined in XML R
form_sdoh.groupname Defined in XML R
form_treatment_plan.groupname Defined in XML R
pnotes.groupname Defined in XML R

The name of the group.
user LONGTEXT 2147483647 √ NULL
users.username Defined in XML R

The username of the user that belongs to this group.

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id

Relationships

Close relationships within degrees of separation