blubber

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
topic_id VARCHAR 32
parent_id VARCHAR 32
media_cache.id Implied ConstraintR
root_id VARCHAR 32
media_cache.id Implied ConstraintR
context_type enum('public', 'private', 'course') 7 public
name VARCHAR 255 null
description TEXT 65535 null
mkdate INT 10 0
chdate INT 10 0
author_host 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

Relationships