Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| object_id | CHAR | 32 |
|
|
||||
| user_id | CHAR | 32 |
|
|
||||
| type | enum('vote', 'documents', 'forum', 'literature', 'schedule', 'scm', 'sem', 'wiki', 'news', 'eval', 'inst', 'elearning_interface', 'ilias_interface', 'participants') | 19 | vote |
|
|
|||
| visitdate | INT | 10 | 0 |
|
|
|||
| last_visitdate | INT | 10 | 0 |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc/Asc/Asc | object_id + user_id + type |
| user_id | Performance | Asc | user_id |
Diagram producer might be missing
No diagrams were produced please see application output for any errors