Table ilias4_3.cmi_objective 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
cmi_interaction_id int 10  √  null
cmi_node_id int 10  √  null
cmi_objective_id int 10 0
description longtext 2147483647  √  null
id varchar 4000  √  null
c_max double 22  √  null
c_min double 22  √  null
c_raw double 22  √  null
scaled double 22  √  null
progress_measure double 22  √  null
success_status varchar 32  √  null
scope varchar 16  √  null
completion_status varchar 32  √  null

Table contained 0 rows at Sun May 01 00:15 CEST 2016

Indexes:
Column(s) Type Sort Constraint Name
cmi_objective_id Primary key Asc PRIMARY
cmi_interaction_id Performance Asc i2_idx
id Performance Asc i3_idx
success_status Performance Asc i4_idx