Table iliasRelease_5_0_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
self_eval tinyint 3 0

Table contained 0 rows at Thu Apr 28 00:43 CEST 2016

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