Table studip20.news 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
news_id varchar 32
news_range.news_id Implied Constraint R
topic varchar 255
body text 65535
author varchar 255
date int 10 0
user_id varchar 32
auth_user_md5.user_id Implied Constraint R
expire int 10 0
allow_comments bit 0 0
chdate int unsigned 10 0
chdate_uid varchar 32
mkdate int unsigned 10 0

Table contained 1 rows at Mon Aug 25 21:10 CEST 2014

Indexes:
Column(s) Type Sort Constraint Name
news_id Primary key Asc PRIMARY
chdate Performance Asc chdate
date Performance Asc date

Close relationships: