track_events


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

Telemetry Event Data

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 √ null
event_type TEXT 65535 √ NULL
event_label VARCHAR 255 √ NULL
event_url TEXT 65535 √ NULL
event_target TEXT 65535 √ NULL
first_event DATETIME 19 √ NULL
last_event DATETIME 19 √ NULL
label_count INT UNSIGNED 10 1

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
unique_event_label_target Must be unique Asc/Asc/Asc event_label + event_url + event_target

Relationships

Close relationships within degrees of separation