Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| datafield_id | VARCHAR | 32 |
|
|
||||
| name | VARCHAR | 255 | √ | null |
|
|
||
| object_type | enum('sem', 'inst', 'user', 'userinstrole', 'usersemdata', 'roleinstdata', 'moduldeskriptor', 'modulteildeskriptor') | 19 | √ | null |
|
|
||
| object_class | VARCHAR | 255 | √ | null |
|
|
||
| edit_perms | enum('user', 'autor', 'tutor', 'dozent', 'admin', 'root') | 6 | √ | null |
|
|
||
| view_perms | enum('all', 'user', 'autor', 'tutor', 'dozent', 'admin', 'root') | 6 | √ | null |
|
|
||
| priority | TINYINT UNSIGNED | 3 | 0 |
|
|
|||
| mkdate | INT UNSIGNED | 10 | √ | null |
|
|
||
| chdate | INT UNSIGNED | 10 | √ | null |
|
|
||
| type | enum('bool', 'textline', 'textlinei18n', 'textarea', 'textareai18n', 'textmarkup', 'textmarkupi18n', 'selectbox', 'date', 'time', 'email', 'phone', 'radio', 'combo', 'link', 'selectboxmultiple') | 17 | textline |
|
|
|||
| typeparam | TEXT | 65535 | null |
|
|
|||
| is_required | TINYINT | 3 | 0 |
|
|
|||
| default_value | TEXT | 65535 | √ | null |
|
|
||
| is_userfilter | TINYINT UNSIGNED | 3 | 0 |
|
|
|||
| description | TEXT | 65535 | null |
|
|
|||
| system | BIT | 1 | 0 |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | datafield_id |
| object_type | Performance | Asc | object_type |
Diagram producer might be missing
No diagrams were produced please see application output for any errors