Table studip20.ex_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
resources_requests.termin_id Implied Constraint R
resources_temporary_events.termin_id Implied Constraint R
termine.termin_id Implied Constraint R
themen_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
resource_id varchar 32
resources_objects.resource_id Implied Constraint R

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

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

Close relationships: