Table iliasRelease_3_9_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  √  null
cp_node_id int 10 0
cp_node.cp_node_id Implied Constraint R
dataFromLMS varchar 255  √  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

Table contained 0 rows at Fri Dec 13 20:19 CET 2013

Indexes:
Column(s) Type Sort Constraint Name
cp_node_id Primary key Asc PRIMARY
id Performance Asc cp_itemidentifier
sequencingId Performance Asc ss_sequencing_id

Close relationships: