Table studip20.Institute 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
Institut_id varchar 32
resources_objects.institut_id Implied Constraint R
seminar_inst.institut_id Implied Constraint R
seminare.Institut_id Implied Constraint R
user_inst.Institut_id Implied Constraint R
Name varchar 255
fakultaets_id varchar 32
Strasse varchar 255
Plz varchar 255
url varchar 255 http://www.studip.de
telefon varchar 32
email varchar 255
fax varchar 32
type tinyint unsigned 3 0
modules int unsigned 10  √  null
mkdate int 10 0
chdate int 10 0
lit_plugin_name varchar 255  √  null
srienabled tinyint 3 0

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

Indexes:
Column(s) Type Sort Constraint Name
Institut_id Primary key Asc PRIMARY
fakultaets_id Performance Asc fakultaets_id

Close relationships: