Table iliaseassessment.il_tag Generated by
SchemaSpy
Legend: SourceForge.net
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
obj_id int 10 0
obj_type char 10
sub_obj_id int 10 0
sub_obj_type char 10
user_id int 10 0
tag varchar 100
is_offline tinyint 3 0

Table contained 0 rows at Mon Apr 25 19:42 CEST 2016

Indexes:
Column(s) Type Sort Constraint Name
obj_id + obj_type + sub_obj_id + sub_obj_type + user_id + tag Primary key Asc/Asc/Asc/Asc/Asc/Asc PRIMARY
obj_id + obj_type + sub_obj_id + sub_obj_type Performance Asc/Asc/Asc/Asc i1_idx
tag Performance Asc i2_idx
user_id Performance Asc i3_idx