SchemaSpy - Table ac05e4dc.tracker

Generated by
SchemaSpy

Legend:

Primary key columns

Columns with indexes

Implied relationships

Excluded column relationships

< n > number of related tables

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

id

int

11

√

monitor_id

char

36

tracker_tracker_queries.monitor_id	Defined in XML R
tracker_perf.monitor_id	Defined in XML R

user_id

char

36

√

null

users.id

Defined in XML R

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

Analyzed at Tue Jan 07 09:13 UTC 2020

Indexes:

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