Documentation/EHI_Export/docs/tables/care_team.html
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | INT | 10 | √ | null |
|
| | | uuid | BINARY | 16 | √ | | NULL |
|
| | | pid | INT | 10 | | | null |
|
| patient_data.pid | Defined in XML | R |
|
The internal patient identifier
| | status | VARCHAR | 100 | √ | | 'active' |
|
| list_options.option_id | Defined in XML | R |
|
fk to list_options.option_id WHERE list_options.list_id=‘Care_Team_Status’
| | team_name | VARCHAR | 255 | √ | | NULL |
|
| | | note | TEXT | 65535 | √ | | NULL |
|
| | | date_created | DATETIME | 19 | √ | | current_timestamp() |
|
| | | date_updated | DATETIME | 19 | √ | | current_timestamp() |
|
| | | created_by | BIGINT | 19 | √ | | NULL |
|
| users.id | Defined in XML | R |
|
The id of the user that initially created this record
| | updated_by | BIGINT | 19 | √ | | NULL |
|
| users.id | Defined in XML | R |
|
The id of the user that last updated this record
|
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| uuid | Must be unique | Asc | uuid |