Table iliasRelease_4_4_x_branch.skl_user_has_level 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
level_id int 10
user_id int 10
status_date datetime 19
skill_id int 10
trigger_ref_id int 10
trigger_obj_id int 10
trigger_title varchar 200  √  null
tref_id int 10 0
trigger_obj_type varchar 4 crs

Table contained 0 rows at Wed Apr 27 21:48 CEST 2016

Indexes:
Column(s) Type Sort Constraint Name
level_id + tref_id + user_id + trigger_obj_id Primary key Asc/Asc/Asc/Asc PRIMARY