care_team


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

Contains the care team records for a patient

Columns

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

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
uuid Must be unique Asc uuid

Relationships

Close relationships within degrees of separation