form_clinic_note


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_clinic_note.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 patient history, provider examination conducted, patient treatment plan, and follow up status

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
activity BIT 1 1
history TEXT 65535 √ null
examination TEXT 65535 √ null
plan TEXT 65535 √ null
followup_required INT 10 0
followup_timing VARCHAR 255

Indexes

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

Relationships

Close relationships within degrees of separation