patient_history

Columns

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

|

| | | uuid | BINARY | 16 | √ | | NULL |

|

| | | date | DATETIME | 19 | | | current_timestamp() |

|

| | | care_team_provider | TEXT | 65535 | √ | | NULL |

|

|

List of care team providers where each id is the provider id contained in the users.id. Entries are separated by a the pipe | symbol.

| | care_team_facility | TEXT | 65535 | √ | | NULL |

|

|

List of care team facilities where each id is the facility/organization id contained in the facilities.id. Entries are separated by a the pipe | symbol

| | pid | BIGINT | 19 | | | null |

|

| patient_data.pid | Defined in XML | R |

|

The internal patient identifier

| | history_type_key | VARCHAR | 36 | √ | | NULL |

|

| | | previous_name_prefix | TEXT | 65535 | √ | | NULL |

|

| | | previous_name_first | TEXT | 65535 | √ | | NULL |

|

| | | previous_name_middle | TEXT | 65535 | √ | | NULL |

|

| | | previous_name_last | TEXT | 65535 | √ | | NULL |

|

| | | previous_name_suffix | TEXT | 65535 | √ | | NULL |

|

| | | previous_name_enddate | DATE | 10 | √ | | NULL |

|

| | | created_by | BIGINT | 19 | √ | | NULL |

|

| users.id | Defined in XML | R |

|

The user that created this record

|

Indexes

Constraint Name	Type	Sort	Column(s)
PRIMARY	Primary key	Asc	id
pid_idx	Performance	Asc	pid
uuid	Must be unique	Asc	uuid

Relationships

Close relationships within degrees of separation