dsi_source_attributes


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

Holds information about decission support intervention system source attributes

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT UNSIGNED 20 √ null
client_id VARCHAR 80 null
list_id VARCHAR 100 null
option_id VARCHAR 100 null
clinical_rule_id VARCHAR 31 √ NULL
source_value TEXT 65535 √ NULL
created_by BIGINT 19 √ NULL
last_updated_by BIGINT 19 √ NULL
created_at TIMESTAMP 19 current_timestamp()
last_updated_at TIMESTAMP 19 current_timestamp()

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
list_id Must be unique Asc/Asc/Asc list_id + option_id + client_id

Relationships

Close relationships within degrees of separation