form_dictation

Columns

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

|

| | | date | DATETIME | 19 | √ | | NULL |

|

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

|

| patient_data.pid | Defined in XML | R |

|

The internal patient identifier

| | user | VARCHAR | 255 | √ | | NULL |

|

| | | groupname | VARCHAR | 255 | √ | | NULL |

|

| | | authorized | TINYINT | 3 | √ | | NULL |

|

| | | activity | TINYINT | 3 | √ | | NULL |

|

| | | dictation | LONGTEXT | 2147483647 | √ | | NULL |

|

| | | additional_notes | LONGTEXT | 2147483647 | √ | | NULL |

|

| |

Indexes

Constraint Name	Type	Sort	Column(s)
PRIMARY	Primary key	Asc	id

Relationships

Close relationships within degrees of separation