SchemaSpy - Table iliaseassessment.cp

Legend:

Primary key columns

Columns with indexes

Implied relationships

Excluded column relationships

< n > number of related tables

Column	Type	Size	Nulls	Default
activityabsdurlimit	varchar	20	√	null
activityexpdurlimit	varchar	20	√	null
attemptabsdurlimit	varchar	20	√	null
attemptexpdurlimit	varchar	20	√	null
attemptlimit	int	10	√	null
begintimelimit	varchar	20	√	null
choice	tinyint	3	√	null
choiceexit	tinyint	3	√	null
completionbycontent	tinyint	3	√	null
constrainchoice	tinyint	3	√	null
cp_node_id	int	10		0
endtimelimit	varchar	20	√	null
flow	tinyint	3	√	null
forwardonly	tinyint	3	√	null
id	varchar	200	√	null
measuresatisfactive	tinyint	3	√	null
objectivemeasweight	double	22	√	null
objectivebycontent	tinyint	3	√	null
preventactivation	tinyint	3	√	null
randomizationtiming	varchar	50	√	null
reorderchildren	tinyint	3	√	null
requiredcompleted	varchar	50	√	null
requiredincomplete	varchar	50	√	null
requirednotsatisfied	varchar	50	√	null
requiredforsatisfied	varchar	50	√	null
rollupobjectivesatis	tinyint	3	√	null
rollupprogcompletion	tinyint	3	√	null
selectcount	int	10	√	null
selectiontiming	varchar	50	√	null
sequencingid	varchar	50	√	null
tracked	tinyint	3	√	null
usecurattemptobjinfo	tinyint	3	√	null
usecurattemptproginfo	tinyint	3	√	null

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

Indexes:

Column(s)	Type	Sort	Constraint Name
cp_node_id	Primary key	Asc	PRIMARY
id	Performance	Asc	i1_idx