form_eye_external

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_external.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 recording external eye examination findings.

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

RUL

TEXT

65535

√

NULL

LUL

TEXT

65535

√

NULL

RLL

TEXT

65535

√

NULL

LLL

TEXT

65535

√

NULL

RBROW

TEXT

65535

√

NULL

LBROW

TEXT

65535

√

NULL

RMCT

TEXT

65535

√

NULL

LMCT

TEXT

65535

√

NULL

RADNEXA

TEXT

65535

√

NULL

LADNEXA

TEXT

65535

√

NULL

RMRD

VARCHAR

25

√

NULL

LMRD

VARCHAR

25

√

NULL

RLF

VARCHAR

25

√

NULL

LLF

VARCHAR

25

√

NULL

RVFISSURE

VARCHAR

25

√

NULL

LVFISSURE

VARCHAR

25

√

NULL

ODHERTEL

VARCHAR

25

√

NULL

OSHERTEL

VARCHAR

25

√

NULL

HERTELBASE

VARCHAR

25

√

NULL

RCAROTID

TEXT

65535

√

NULL

LCAROTID

TEXT

65535

√

NULL

RTEMPART

TEXT

65535

√

NULL

LTEMPART

TEXT

65535

√

NULL

RCNV

TEXT

65535

√

NULL

LCNV

TEXT

65535

√

NULL

RCNVII

TEXT

65535

√

NULL

LCNVII

TEXT

65535

√

NULL

EXT_COMMENTS

TEXT

65535

√

NULL

Showing 1 to 30 of 30 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