Table studip30.seminare 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
Seminar_id varchar 32 0
archiv.seminar_id Implied Constraint R
VeranstaltungsNummer varchar 100  √  null
Institut_id varchar 32 0
Institute.Institut_id Implied Constraint R
Name varchar 255
Untertitel varchar 255  √  null
status tinyint unsigned 3 1
Beschreibung text 65535
Ort varchar 255  √  null
Sonstiges text 65535  √  null
Lesezugriff tinyint 3 0
Schreibzugriff tinyint 3 0
start_time int 10  √  0
duration_time int 10  √  null
art varchar 255  √  null
teilnehmer text 65535  √  null
vorrausetzungen text 65535  √  null
lernorga text 65535  √  null
leistungsnachweis text 65535  √  null
mkdate int 10 0
chdate int 10 0
ects varchar 32  √  null
admission_turnout int 10  √  null
admission_binding tinyint 3  √  null
admission_prelim tinyint unsigned 3 0
admission_prelim_txt text 65535  √  null
admission_disable_waitlist tinyint unsigned 3 0
visible tinyint unsigned 3 1
showscore tinyint 3  √  0
modules int unsigned 10  √  null
aux_lock_rule varchar 32  √  null
aux_lock_rule_forced tinyint 3 0
lock_rule varchar 32  √  null
admission_waitlist_max int unsigned 10 0
admission_disable_waitlist_move tinyint unsigned 3 0

Table contained 2 rows at Do Aug 02 15:05 GMT+01:00 2018

Indexes:
Column(s) Type Sort Constraint Name
Seminar_id Primary key Asc PRIMARY
Institut_id Performance Asc Institut_id
status + Seminar_id Performance Asc/Asc status
visible Performance Asc visible

Close relationships: