Table studip20.termine 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
termin_id varchar 32
ex_termine.termin_id Implied Constraint R
range_id varchar 32
autor_id varchar 32
content varchar 255
description text 65535  √  null
date int 10 0
end_time int 10 0
mkdate int 10 0
chdate int 10 0
date_typ tinyint 3 0
topic_id varchar 32  √  null
px_topics.topic_id Implied Constraint R
raum varchar 255  √  null
metadate_id varchar 32  √  null
seminar_cycle_dates.metadate_id Implied Constraint R

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

Indexes:
Column(s) Type Sort Constraint Name
termin_id Primary key Asc PRIMARY
metadate_id + date Performance Asc/Asc metadate_id
range_id + date Performance Asc/Asc range_id

Close relationships: