| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| id | BIGINT | 19 | √ | null |
|
|
The primary key which is the same as the forms.form_id column |
|||||||
| date | DATE | 10 | √ | NULL |
|
|
||||||||
| group_id | INT | 10 | √ | NULL |
|
|
FK to the therapy group that this attendance form is tracking |
|||||||
| user | VARCHAR | 255 | √ | NULL |
|
|
The username of the user that created this record. |
|||||||
| groupname | VARCHAR | 255 | √ | NULL |
|
|
User Group that the user was part of that created this record (This is not the therapy group) |
|||||||
| authorized | TINYINT | 3 | √ | NULL |
|
|
Authorization status (1 for authorized, 0 for unauthorized) |
|||||||
| encounter_id | INT | 10 | √ | NULL |
|
|
The group encounter that this group attendance form is part of |
|||||||
| activity | TINYINT | 3 | √ | NULL |
|
|
Activity status (1 for active, 0 for inactive) |
Showing 1 to 8 of 8 entries