Table studip31.sem_classes 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
id int 10  √ 
doc_filetype_forbidden.id Implied Constraint R
name varchar 64
compact_mode tinyint 3
workgroup_mode tinyint 3
only_inst_user tinyint 3
turnus_default int 10
default_read_level int 10
default_write_level int 10
bereiche tinyint 3
show_browse tinyint 3
write_access_nobody tinyint 3
topic_create_autor tinyint 3
visible tinyint 3
course_creation_forbidden tinyint 3
overview varchar 64  √  null
forum varchar 64  √  null
admin varchar 64  √  null
documents varchar 64  √  null
schedule varchar 64  √  null
participants varchar 64  √  null
literature varchar 64  √  null
scm varchar 64  √  null
wiki varchar 64  √  null
resources varchar 64  √  null
calendar varchar 64  √  null
elearning_interface varchar 64  √  null
modules text 65535
description text 65535
create_description text 65535
studygroup_mode tinyint 3
admission_prelim_default tinyint 3 0
admission_type_default tinyint 3 0
title_dozent varchar 64  √  null
title_dozent_plural varchar 64  √  null
title_tutor varchar 64  √  null
title_tutor_plural varchar 64  √  null
title_autor varchar 64  √  null
title_autor_plural varchar 64  √  null
mkdate bigint 19
chdate bigint 19

Table contained 4 rows at Do Aug 02 15:27 GMT+01:00 2018

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
name Must be unique Asc name

Close relationships: