Documentation/EHI_Export/docs/tables/care_team_member.html
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | INT | 10 | √ | null |
|
| | | care_team_id | INT | 10 | | | null |
|
| patient_data.pid | Defined in XML | R |
|
The care team this member belongs to
| | user_id | BIGINT | 19 | √ | | NULL |
|
| users.id | Defined in XML | R |
|
fk to users.id and is populated if the member is a staff member
| | contact_id | BIGINT | 19 | √ | | NULL |
|
| users.id | Defined in XML | R |
|
fk to contact.id and is populated if the member is a related person or another patient
| | role | VARCHAR | 50 | | | null |
|
| list_options.option_id | Defined in XML | R |
|
fk to list_options.option_id WHERE list_options.list_id=‘care_team_roles’
| | facility_id | BIGINT | 19 | √ | | NULL |
|
| facility.id | Defined in XML | R |
|
fk to facility.id and is populated if the member is an organization or facility
| | provider_since | DATE | 10 | √ | | NULL |
|
| | | 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’
| | 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
| | note | TEXT | 65535 | √ | | NULL |
|
| |
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| care_team_member_unique | Must be unique | Asc/Asc/Asc/Asc | care_team_id + user_id + facility_id + contact_id |