groups

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_CAMOS_category.groupname | Defined in XML | R | | form_CAMOS_item.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_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