form_painmap

Columns

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.

|

Relationships

Close relationships within degrees of separation