Table iliasRelease_4_2_x_branch.cp_item 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
completionthreshold varchar 50  √  1.0
cp_node_id int 10 0
datafromlms varchar 4000  √  null
id varchar 200  √  null
isvisible varchar 32  √  null
parameters varchar 255  √  null
resourceid varchar 200  √  null
sequencingid varchar 50  √  null
timelimitaction varchar 30  √  null
title varchar 255  √  null
progressweight varchar 50  √  1.0
completedbymeasure tinyint 3  √  0

Table contained 0 rows at Fri Apr 22 21:41 CEST 2016

Indexes:
Column(s) Type Sort Constraint Name
cp_node_id Primary key Asc PRIMARY
id Performance Asc i1_idx
sequencingid Performance Asc i2_idx