cmi_node

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
accesscount INT 10 null
accessduration VARCHAR 20 null
accessed VARCHAR 20 null
activityabsduration VARCHAR 20 null
activityattemptcount INT 10 null
activityexpduration VARCHAR 20 null
activityprogstatus TINYINT 3 null
attemptabsduration VARCHAR 20 null
attemptcomplamount DOUBLE 22 null
attemptcomplstatus TINYINT 3 null
attemptexpduration VARCHAR 20 null
attemptprogstatus TINYINT 3 null
audio_captioning INT 10 null
audio_level DOUBLE 22 null
availablechildren VARCHAR 255 null
cmi_node_id INT 10 0
completion DOUBLE 22 null
completion_status VARCHAR 32 null
completion_threshold VARCHAR 32 null
cp_node_id INT 10 0
created VARCHAR 20 null
credit VARCHAR 32 null
delivery_speed DOUBLE 22 null
c_entry VARCHAR 255 null
c_exit VARCHAR 255 null
c_language VARCHAR 5 null
launch_data LONGTEXT 2147483647 null
learner_name VARCHAR 255 null
location VARCHAR 255 null
c_max DOUBLE 22 null
c_min DOUBLE 22 null
c_mode VARCHAR 20 null
modified VARCHAR 20 null
progress_measure DOUBLE 22 null
c_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 LONGTEXT 2147483647 null
total_time VARCHAR 20 null
user_id INT 10 0
c_timestamp DATETIME 19 null
additional_tables TINYINT 3 0

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc cmi_node_id
i1_idx Performance Asc cp_node_id
i2_idx Performance Asc completion_status
i3_idx Performance Asc credit
i5_idx Performance Asc user_id

Diagram producer might be missing

No diagrams were produced please see application output for any errors