Table iliasRelease_5_0_x_branch.skl_user_skill_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
status tinyint 3
valid tinyint 3 0
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 Performance Asc ilv_idx
status_date Performance Asc isd_idx
skill_id Performance Asc isk_idx
status Performance Asc ist_idx
user_id Performance Asc ius_idx
valid Performance Asc ivl_idx