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
is_complete BIT 1 0
public_topics TINYINT 3 1
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