extended_log


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

Holds the disclosures of EHI made to third parties for a given patient

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
date DATETIME 19 √ NULL
event VARCHAR 255 √ NULL
user VARCHAR 255 √ NULL
recipient VARCHAR 255 √ NULL
description LONGTEXT 2147483647 √ NULL
patient_id BIGINT 19 √ NULL
patient_data.pid Defined in XML R

The internal patient identifier

Indexes

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

Relationships

Close relationships within degrees of separation