form_eye_acuity


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_acuity.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 related to recording visual acuity measurements for different eye conditions.

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
SCODVA VARCHAR 25 √ null
SCOSVA VARCHAR 25 √ null
PHODVA VARCHAR 25 √ null
PHOSVA VARCHAR 25 √ null
CTLODVA VARCHAR 25 √ null
CTLOSVA VARCHAR 25 √ null
MRODVA VARCHAR 25 √ null
MROSVA VARCHAR 25 √ null
SCNEARODVA VARCHAR 25 √ null
SCNEAROSVA VARCHAR 25 √ null
MRNEARODVA VARCHAR 25 √ null
MRNEAROSVA VARCHAR 25 √ null
GLAREODVA VARCHAR 25 √ null
GLAREOSVA VARCHAR 25 √ null
GLARECOMMENTS VARCHAR 255 √ null
ARODVA VARCHAR 25 √ null
AROSVA VARCHAR 25 √ null
CRODVA VARCHAR 25 √ null
CROSVA VARCHAR 25 √ null
CTLODVA1 VARCHAR 25 √ null
CTLOSVA1 VARCHAR 25 √ null
PAMODVA VARCHAR 25 √ null
PAMOSVA VARCHAR 25 √ null
LIODVA VARCHAR 25 null
LIOSVA VARCHAR 25 null
WODVANEAR VARCHAR 25 √ null
OSVANEARCC VARCHAR 25 √ null
BINOCVA VARCHAR 25 √ 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