patient_care_experience_preferences


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
uuid BINARY 16 √ NULL
patient_id INT 10 null
patient_data.pid Defined in XML R
observation_code VARCHAR 50 null
list_options.option_id Defined in XML R

LOINC code
observation_code_text VARCHAR 255 √ NULL
value_type enum('coded', 'text', 'boolean') 7 √ 'coded'
value_code VARCHAR 50 √ NULL
preference_value_sets.answer_code Defined in XML R
value_code_system VARCHAR 255 √ NULL
preference_value_sets.answer_system Defined in XML R
value_display VARCHAR 255 √ NULL
preference_value_sets.answer_display Defined in XML R
value_text TEXT 65535 √ NULL
value_boolean BOOLEAN 3 √ NULL
effective_datetime DATETIME 19 current_timestamp()
status VARCHAR 20 √ 'final'
note TEXT 65535 √ NULL

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
observation_code Performance Asc observation_code
patient_id Performance Asc patient_id
status Performance Asc status
unq_uuid Must be unique Asc uuid

Relationships

Close relationships within degrees of separation