form_phq9


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

Encounter form that holds patient results for the PHQ9 assessment

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
forms.form_id Defined in XML R

The primary key which is the same as the forms.form_id column
date DATETIME 19 √ null
pid BIGINT 19 √ null
patient_data.pid Defined in XML R

The internal patient identifier
user VARCHAR 255 √ null
users.id Defined in XML R

The user that created this record.
groupname VARCHAR 255 √ null
groups.name Defined in XML R

The groupname that created this record.
authorized TINYINT 3 √ null
activity TINYINT 3 √ null
interest_score VARCHAR 255 √ null
interest_extra_info VARCHAR 255 √ null
hopeless_score VARCHAR 255 √ null
hopeless_extra_info VARCHAR 255 √ null
sleep_score VARCHAR 255 √ null
sleep_extra_info VARCHAR 255 √ null
fatigue_score VARCHAR 255 √ null
fatigue_extra_info VARCHAR 255 √ null
appetite_score VARCHAR 255 √ null
appetite_extra_info VARCHAR 255 √ null
failure_score VARCHAR 255 √ null
failure_extra_info VARCHAR 255 √ null
focus_score VARCHAR 255 √ null
focus_extra_info VARCHAR 255 √ null
psychomotor_score VARCHAR 255 √ null
psychomotor_extra_info VARCHAR 255 √ null
suicide_score VARCHAR 255 √ null
suicide_extra_info VARCHAR 255 √ null
difficulty VARCHAR 255 √ null
difficulty_extra_info VARCHAR 255 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id

Relationships

Close relationships within degrees of separation