form_eye_vitals


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

This table is used for recording vital signs and measurements related to the eye.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null

Links to forms.form_id
pid BIGINT 19 √ null
patient_data.pid Defined in XML R

The internal patient identifier
alert CHAR 3 √ yes
oriented CHAR 3 √ TPP
confused CHAR 3 √ nml
ODIOPAP VARCHAR 10 √ null
OSIOPAP VARCHAR 10 √ null
ODIOPTPN VARCHAR 10 √ null
OSIOPTPN VARCHAR 10 √ null
ODIOPFTN VARCHAR 10 √ null
OSIOPFTN VARCHAR 10 √ null
IOPTIME TIME 8 null
ODIOPPOST VARCHAR 10 null
OSIOPPOST VARCHAR 10 null
IOPPOSTTIME TIME 8 √ null
ODIOPTARGET VARCHAR 10 null
OSIOPTARGET VARCHAR 10 null
AMSLEROD SMALLINT 5 √ null
AMSLEROS SMALLINT 5 √ null
ODVF1 BIT 1 √ null
ODVF2 BIT 1 √ null
ODVF3 BIT 1 √ null
ODVF4 BIT 1 √ null
OSVF1 BIT 1 √ null
OSVF2 BIT 1 √ null
OSVF3 BIT 1 √ null
OSVF4 BIT 1 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
id_pid Must be unique Asc/Asc id + pid

Relationships

Close relationships within degrees of separation