Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
---|---|---|---|---|---|---|---|---|
modulteil_id | VARCHAR | 32 | null |
|
|
|||
modul_id | VARCHAR | 32 | null |
|
|
|||
position | INT | 10 | 9999 |
|
|
|||
flexnow_modul | VARCHAR | 250 | √ | null |
|
|
||
nummer | VARCHAR | 20 | √ | null |
|
|
||
num_bezeichnung | VARCHAR | 32 | √ | null |
|
|
||
lernlehrform | VARCHAR | 32 | √ | null |
|
|
||
semester | VARCHAR | 32 | √ | null |
|
|
||
kapazitaet | VARCHAR | 50 | √ | null |
|
|
||
kp | INT | 10 | √ | null |
|
|
||
sws | INT | 10 | √ | null |
|
|
||
wl_praesenz | INT | 10 | √ | null |
|
|
||
wl_bereitung | INT | 10 | √ | null |
|
|
||
wl_selbst | INT | 10 | √ | null |
|
|
||
wl_pruef | INT | 10 | √ | null |
|
|
||
anteil_note | INT | 10 | √ | null |
|
|
||
ausgleichbar | INT | 10 | 0 |
|
|
|||
pflicht | INT | 10 | 0 |
|
|
|||
VARCHAR | 32 | null |
|
|
||||
editor_id | VARCHAR | 32 | null |
|
|
|||
mkdate | BIGINT | 19 | null |
|
|
|||
chdate | BIGINT | 19 | null |
|
|
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
PRIMARY | Primary key | Asc | modulteil_id |
flexnow_modul | Performance | Asc | flexnow_modul |
modul_id | Performance | Asc | modul_id |
Diagram producer might be missing
No diagrams were produced please see application output for any errors