Table iliasRelease_3_9_x_branch.cmi_node 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
accesscount int 10  √  null
accessduration varchar 20  √  null
accessed varchar 20  √  null
activityAbsoluteDuration varchar 20  √  null
activityAttemptCount int 10  √  null
activityExperiencedDuration varchar 20  √  null
activityProgressStatus tinyint 3  √  null
attemptAbsoluteDuration varchar 20  √  null
attemptCompletionAmount double 22  √  null
attemptCompletionStatus tinyint 3  √  null
attemptExperiencedDuration varchar 20  √  null
attemptProgressStatus tinyint 3  √  null
audio_captioning int 10  √  null
audio_level double 22  √  null
availableChildren varchar 255  √  null
cmi_node_id int 10  √ 
cmi_comment.cmi_node_id Implied Constraint R
cmi_interaction.cmi_node_id Implied Constraint R
cmi_objective.cmi_node_id Implied Constraint R
completion double 22  √  null
completion_status varchar 32  √  null
completion_threshold varchar 32  √  null
cp_node_id int 10  √  null
cp_node.cp_node_id Implied Constraint R
created varchar 20  √  null
credit varchar 32  √  null
delivery_speed double 22  √  null
entry varchar 255  √  null
exit varchar 255  √  null
language varchar 5  √  null
launch_data text 65535  √  null
learner_name varchar 255  √  null
location varchar 255  √  null
max double 22  √  null
min double 22  √  null
mode varchar 20  √  null
modified varchar 20  √  null
progress_measure double 22  √  null
raw double 22  √  null
scaled double 22  √  null
scaled_passing_score double 22  √  null
session_time varchar 20  √  null
success_status varchar 255  √  null
suspend_data text 65535  √  null
total_time varchar 20  √  null
user_id int 10  √  null
member_export_user_settings.user_id Implied Constraint R
TIMESTAMP timestamp 19 CURRENT_TIMESTAMP

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

Indexes:
Column(s) Type Sort Constraint Name
cmi_node_id Primary key Asc PRIMARY
cp_node_id Performance Asc cmi_itemcp_id
completion_status Performance Asc completion_status
credit Performance Asc credit
cmi_node_id Performance Asc id
user_id Performance Asc user_id

Close relationships: