document_templates

Columns

Column	Type	Size	Nulls	Auto	Default	Children	Parents	Comments
id	BIGINT UNSIGNED	20		√	null

|

| | | pid | BIGINT | 19 | √ | | NULL |

|

| patient_data.pid | Defined in XML | R |

|

The internal patient identifier.

| | provider | INT UNSIGNED | 10 | √ | | NULL |

|

| | | encounter | INT UNSIGNED | 10 | √ | | NULL |

|

| | | modified_date | DATETIME | 19 | | | current_timestamp() |

|

| | | profile | VARCHAR | 63 | | | null |

|

| | | category | VARCHAR | 63 | | | null |

|

| | | location | VARCHAR | 255 | √ | | NULL |

|

| | | template_name | VARCHAR | 255 | √ | | NULL |

|

| | | status | VARCHAR | 31 | √ | | NULL |

|

| | | send_date | DATETIME | 19 | | | current_timestamp() |

|

| | | end_date | DATETIME | 19 | √ | | NULL |

|

| | | size | INT | 10 | | | 0 |

|

| | | template_content | MEDIUMBLOB | 16777215 | √ | | NULL |

|

|

Digital document template that is assigned to a patient to be filled out. Uses Domain Specific Language (DSL) template tags to inject specific functionality into the template for patients to fill out. Patient data template tags can be found at the following URL: https://www.open-emr.org/wiki/index.php/Patient_Portal_Document_Templates

| | mime | VARCHAR | 31 | √ | | NULL |

|

| |

Indexes

Constraint Name	Type	Sort	Column(s)
PRIMARY	Primary key	Asc	id
location	Must be unique	Asc/Asc/Asc/Asc	pid + profile + category + template_name

Relationships

Close relationships within degrees of separation