form_painmap

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

Patient pain map form. Pain map image for mapping this form is stored in the EHI zip export at images/painmap.png

Columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

data

Unknown

0

null

Data of the patient pain map to overlay ontop of the pain image. Each mapped data element is in the following format x1CoordinatePixels^y1CoordinatePixels^pain1Description}…}.

groupname

Unknown

0

null

groups.name

Defined in XML

R

The groupname that created this record.

id

Unknown

0

null

forms.form_id

Defined in XML

R

The primary key which is the same as the forms.form_id column

pid

Unknown

0

null

patient_data.pid

Defined in XML

R

The internal patient identifier

user

Unknown

0

null

users.id

Defined in XML

R

The user that created this record.

Showing 1 to 5 of 5 entries

Relationships

Close relationships within degrees of separation

One
Two degrees