tracker


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 null
monitor_id CHAR 36 null
tracker_perf.monitor_id Defined in XMLR
tracker_tracker_queries.monitor_id Defined in XMLR
user_id CHAR 36 null
users.id Defined in XMLR
module_name VARCHAR 255 null
item_id CHAR 36 null
item_summary VARCHAR 255 null
team_id CHAR 36 null
date_modified DATETIME 19 null
action VARCHAR 255 null
session_id CHAR 36 null
visible BIT 1 0
deleted BIT 1 0

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
idx_tracker_date_modified Performance Asc date_modified
idx_tracker_iid Performance Asc item_id
idx_tracker_monitor_id Performance Asc monitor_id
idx_tracker_userid_del_vis Performance Asc/Asc/Asc user_id + deleted + visible
idx_tracker_userid_itemid_vis Performance Asc/Asc/Asc user_id + item_id + visible
idx_tracker_userid_vis_id Performance Asc/Asc/Asc user_id + visible + id
idx_trckr_mod_uid_dtmod_item Performance Asc/Asc/Asc/Asc module_name + user_id + date_modified + item_id
idx_userid_module_itemid_summary_datemodified Performance Asc/Asc/Asc/Asc/Asc user_id + module_name + item_id + item_summary + date_modified

Relationships