Table iliasRelease_3_8_x_branch.crs_settings 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
obj_id int 10 0
ut_lp_settings.obj_id Implied Constraint R
syllabus text 65535  √  null
contact_name varchar 255  √  null
contact_responsibility varchar 255  √  null
contact_phone varchar 255  √  null
contact_email varchar 255  √  null
contact_consultation text 65535  √  null
activation_type bit 0 0
activation_start int 10  √  null
activation_end int 10  √  null
subscription_limitation_type bit 0 0
subscription_start int 10  √  null
subscription_end int 10  √  null
subscription_type int 10  √  null
subscription_password varchar 32  √  null
subscription_max_members int 10  √  null
subscription_notify int 10  √  null
view_mode bit 0 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 bit 0 1
important text 65535
show_members tinyint 3 1
latitude varchar 30
longitude varchar 30
location_zoom int 10 0
enable_course_map tinyint 3 0

Table contained 0 rows at Fri Dec 13 17:53 CET 2013

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

Close relationships: