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

Related columns Constraint Comments

Search:

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

Showing 1 to 18 of 18 entries

Indexes

Search:

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

Showing 1 to 2 of 2 entries

Relationships

Close relationships within degrees of separation

One
Two degrees