form_eye_hpi

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_hpi.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 the history of present illness (HPI) information related to eye conditions.

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

CC1

VARCHAR

255

√

NULL

HPI1

TEXT

65535

√

NULL

QUALITY1

VARCHAR

255

√

NULL

TIMING1

VARCHAR

255

√

NULL

DURATION1

VARCHAR

255

√

NULL

CONTEXT1

VARCHAR

255

√

NULL

SEVERITY1

VARCHAR

255

√

NULL

MODIFY1

VARCHAR

255

√

NULL

ASSOCIATED1

VARCHAR

255

√

NULL

LOCATION1

VARCHAR

255

√

NULL

CHRONIC1

VARCHAR

255

√

NULL

CHRONIC2

VARCHAR

255

√

NULL

CHRONIC3

VARCHAR

255

√

NULL

CC2

TEXT

65535

√

NULL

HPI2

TEXT

65535

√

NULL

QUALITY2

TEXT

65535

√

NULL

TIMING2

TEXT

65535

√

NULL

DURATION2

TEXT

65535

√

NULL

CONTEXT2

TEXT

65535

√

NULL

SEVERITY2

TEXT

65535

√

NULL

MODIFY2

TEXT

65535

√

NULL

ASSOCIATED2

TEXT

65535

√

NULL

LOCATION2

TEXT

65535

√

NULL

CC3

TEXT

65535

√

NULL

HPI3

TEXT

65535

√

NULL

QUALITY3

TEXT

65535

√

NULL

TIMING3

TEXT

65535

√

NULL

DURATION3

TEXT

65535

√

NULL

CONTEXT3

TEXT

65535

√

NULL

SEVERITY3

TEXT

65535

√

NULL

MODIFY3

TEXT

65535

√

NULL

ASSOCIATED3

TEXT

65535

√

NULL

LOCATION3

TEXT

65535

√

NULL

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