SchemaSpy - Table iliaseassessment.cmi

Legend:

Primary key columns

Columns with indexes

Implied relationships

Excluded column relationships

< n > number of related tables

Column	Type	Size	Nulls	Default
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	√	null
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	√	null
c_timestamp	datetime	19	√	null

Table contained 0 rows at Mon Apr 25 19:42 CEST 2016

Indexes:

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