form_eye_ros


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_ros.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 review of systems (ROS) information related to various aspects of the eye and its associated systems.

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
ROSGENERAL TEXT 65535 √ NULL
ROSHEENT TEXT 65535 √ NULL
ROSCV TEXT 65535 √ NULL
ROSPULM TEXT 65535 √ NULL
ROSGI TEXT 65535 √ NULL
ROSGU TEXT 65535 √ NULL
ROSDERM TEXT 65535 √ NULL
ROSNEURO TEXT 65535 √ NULL
ROSPSYCH TEXT 65535 √ NULL
ROSMUSCULO TEXT 65535 √ NULL
ROSIMMUNO TEXT 65535 √ NULL
ROSENDOCRINE TEXT 65535 √ NULL
ROSCOMMENTS TEXT 65535 √ 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