seminare

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
Seminar_id VARCHAR 32 0
VeranstaltungsNummer VARCHAR 100 √ null
Institut_id VARCHAR 32 0
Name VARCHAR 255
Untertitel VARCHAR 255 √ null
status TINYINT UNSIGNED 3 1
Beschreibung TEXT 65535 null
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
completion BIT 1 0
parent_course VARCHAR 32 √ null

Indexes

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

Diagram producer might be missing

No diagrams were produced please see application output for any errors