form_eye_mag_impplan


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_mag_impplan.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

Stores implementation plans for eye-related activities.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
form_id BIGINT 19 null
pid BIGINT 19 null
patient_data.pid Defined in XML R

The internal patient identifier
title VARCHAR 255 null
code VARCHAR 50 √ NULL
codetype VARCHAR 50 √ NULL
codedesc VARCHAR 255 √ NULL
codetext VARCHAR 255 √ NULL
plan VARCHAR 3000 √ NULL
PMSFH_link VARCHAR 50 √ NULL
IMPPLAN_order TINYINT 3 √ NULL

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
second_index Must be unique Asc/Asc/Asc/Asc form_id + pid + title + plan

Relationships

Close relationships within degrees of separation