Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
---|---|---|---|---|---|---|---|---|---|---|
topic_id | VARCHAR | 32 |
|
|
||||||
parent_id | VARCHAR | 32 |
|
|
||||||
root_id | VARCHAR | 32 |
|
|
||||||
context_type | enum('public', 'private', 'course') | 7 | public |
|
|
|||||
name | VARCHAR | 255 | √ | null |
|
|
||||
description | TEXT | 65535 | √ | null |
|
|
||||
mkdate | INT | 10 | 0 |
|
|
|||||
chdate | INT | 10 | 0 |
|
|
|||||
VARCHAR | 255 | √ | null |
|
|
|||||
Seminar_id | VARCHAR | 32 |
|
|
||||||
user_id | VARCHAR | 32 |
|
|
||||||
external_contact | TINYINT | 3 | 0 |
|
|
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
PRIMARY | Primary key | Asc | topic_id |
chdate | Performance | Asc | chdate |
mkdate | Performance | Asc | mkdate |
parent_id | Performance | Asc | parent_id |
root_id | Performance | Asc/Asc | root_id + mkdate |
Seminar_id | Performance | Asc/Asc | Seminar_id + context_type |
user_id | Performance | Asc/Asc | user_id + Seminar_id |