Columns
| 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 |
|
|
|||
| lock_comment | VARCHAR | 255 | √ | null |
|
|
||
| locked_by | VARCHAR | 32 | √ | null |
|
|
||
| visible | enum('global', 'always', 'yes', 'unknown', 'no', 'never') | 7 | unknown |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | user_id |
| k_username | Must be unique | Asc | username |
| perms | Performance | Asc | perms |
Diagram producer might be missing
No diagrams were produced please see application output for any errors