form_history_sdoh_health_concerns


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

Links SDOH assessments to health concern conditions

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
sdoh_history_id BIGINT UNSIGNED 20 null
form_history_sdoh.id Defined in XML R

FK to form_history_sdoh.id
health_concern_id BIGINT 19 null
lists.id Defined in XML R

FK to lists.id where type=health_concern or medical_problem
created_at DATETIME 19 current_timestamp()
created_by BIGINT 19 √ NULL
users.id Defined in XML R

FK to users.id

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
idx_health_concern Performance Asc health_concern_id
idx_sdoh_history Performance Asc sdoh_history_id
unique_sdoh_concern Must be unique Asc/Asc sdoh_history_id + health_concern_id

Relationships

Close relationships within degrees of separation