| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
| Seminar_id |
varchar |
32 |
|
|
0 |
|
| archiv.seminar_id
|
Implied Constraint R |
|
| VeranstaltungsNummer |
varchar |
100 |
√ |
|
null |
|
|
| Institut_id |
varchar |
32 |
|
|
0 |
|
|
| 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
|