SchemaSpy - Table iliaseassessment.crs

Legend:

Primary key columns

Columns with indexes

Implied relationships

Excluded column relationships

< n > number of related tables

Column	Type	Size	Nulls	Default
obj_id	int	10		0
syllabus	varchar	4000	√	null
contact_name	varchar	255	√	null
contact_responsibility	varchar	255	√	null
contact_phone	varchar	255	√	null
contact_email	varchar	255	√	null
contact_consultation	varchar	4000	√	null
activation_type	tinyint	3		0
activation_start	int	10	√	null
activation_end	int	10	√	null
sub_limitation_type	tinyint	3		0
sub_start	int	10	√	null
sub_end	int	10	√	null
sub_type	int	10	√	null
sub_password	varchar	32	√	null
sub_mem_limit	tinyint	3		0
sub_max_members	int	10	√	null
sub_notify	int	10	√	null
view_mode	tinyint	3		0
sortorder	int	10	√	null
archive_start	int	10	√	null
archive_end	int	10	√	null
archive_type	int	10	√	null
abo	tinyint	3	√	1
waiting_list	tinyint	3		1
important	varchar	4000	√	null
show_members	tinyint	3		1
latitude	varchar	30	√	null
longitude	varchar	30	√	null
location_zoom	int	10		0
enable_course_map	tinyint	3		0
session_limit	tinyint	3		0
session_prev	bigint	19		-1
session_next	bigint	19		-1
reg_ac_enabled	tinyint	3
reg_ac	varchar	32	√	null

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

Indexes:

Column(s)	Type	Sort	Constraint Name
obj_id	Primary key	Asc	PRIMARY