form_eye_postseg


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_postseg.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 storing data related to posterior segment eye examinations, which typically involve the back of the eye, including the retina, optic disc, macula, and blood vessels.

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
ODDISC TEXT 65535 √ null
OSDISC TEXT 65535 √ null
ODCUP TEXT 65535 √ null
OSCUP TEXT 65535 √ null
ODMACULA TEXT 65535 √ null
OSMACULA TEXT 65535 √ null
ODVESSELS TEXT 65535 √ null
OSVESSELS TEXT 65535 √ null
ODVITREOUS TEXT 65535 √ null
OSVITREOUS TEXT 65535 √ null
ODPERIPH TEXT 65535 √ null
OSPERIPH TEXT 65535 √ null
ODCMT TEXT 65535 √ null
OSCMT TEXT 65535 √ null
RETINA_COMMENTS TEXT 65535 √ null
DIL_RISKS CHAR 2 on
DIL_MEDS MEDIUMTEXT 16777215 √ null
WETTYPE VARCHAR 10 null
ATROPINE VARCHAR 25 null
CYCLOMYDRIL VARCHAR 25 null
TROPICAMIDE VARCHAR 25 null
CYCLOGYL VARCHAR 25 null
NEO25 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