Table studip30.forum_entries Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
topic_id varchar 32
px_topics.topic_id Implied Constraint R
seminar_id varchar 32
archiv.seminar_id Implied Constraint R
user_id varchar 32
auth_user_md5.user_id Implied Constraint R
name varchar 255
content text 65535
area tinyint 3 0
mkdate int 10
latest_chdate int 10  √  null
chdate int 10
author varchar 255
author_host varchar 255
lft int 10
rgt int 10
depth int 10
anonymous tinyint 3 0
closed bit 0 0
sticky int 10 0

Table contained 0 rows at Do Aug 02 15:05 GMT+01:00 2018

Indexes:
Column(s) Type Sort Constraint Name
topic_id Primary key Asc PRIMARY
seminar_id + lft Performance Asc/Asc seminar_id
seminar_id + rgt Performance Asc/Asc seminar_id_2
user_id Performance Asc user_id

Close relationships: