| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| user_id | VARCHAR | 32 |
|
|
||||
| username | VARCHAR | 64 |
|
|
||||
| password | VARBINARY | 64 |
|
|
||||
| perms | enum('user', 'autor', 'tutor', 'dozent', 'admin', 'root') | 6 | user |
|
|
|||
| Vorname | VARCHAR | 64 | √ | null |
|
|
||
| Nachname | VARCHAR | 64 | √ | null |
|
|
||
| VARCHAR | 64 | √ | null |
|
|
|||
| validation_key | VARCHAR | 10 |
|
|
||||
| auth_plugin | VARCHAR | 64 | √ | standard |
|
|
||
| locked | BIT | 1 | 0 |
|
|
Diagram producer might be missing
No diagrams were produced please see application output for any errors