form_eye_biometrics


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_biometrics.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 stores biometric data related to the eye, including axial length, pupil diameter, and other measurements.

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
ODK1 VARCHAR 10 √ NULL
ODK2 VARCHAR 10 √ NULL
ODK2AXIS VARCHAR 10 √ NULL
OSK1 VARCHAR 10 √ NULL
OSK2 VARCHAR 10 √ NULL
OSK2AXIS VARCHAR 10 √ NULL
ODAXIALLENGTH VARCHAR 20 √ NULL
OSAXIALLENGTH VARCHAR 20 √ NULL
ODPDMeasured VARCHAR 20 √ NULL
OSPDMeasured VARCHAR 20 √ NULL
ODACD VARCHAR 20 √ NULL
OSACD VARCHAR 20 √ NULL
ODW2W VARCHAR 20 √ NULL
OSW2W VARCHAR 20 √ NULL
ODLT VARCHAR 20 √ NULL
OSLT VARCHAR 20 √ 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