Table studip23.archiv 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
seminar_id varchar 32
admission_seminar_studiengang.seminar_id Implied Constraint R
admission_seminar_user.seminar_id Implied Constraint R
archiv_user.seminar_id Implied Constraint R
dokumente.seminar_id Implied Constraint R
px_topics.Seminar_id Implied Constraint R
resources_requests.seminar_id Implied Constraint R
resources_temporary_events.seminar_id Implied Constraint R
schedule_seminare.seminar_id Implied Constraint R
seminar_cycle_dates.seminar_id Implied Constraint R
seminar_inst.seminar_id Implied Constraint R
seminar_sem_tree.seminar_id Implied Constraint R
seminar_user.Seminar_id Implied Constraint R
seminar_userdomains.seminar_id Implied Constraint R
seminare.Seminar_id Implied Constraint R
themen.seminar_id Implied Constraint R
name varchar 255
untertitel varchar 255
beschreibung text 65535
start_time int 10 0
semester varchar 16
heimat_inst_id varchar 32
institute varchar 255
dozenten varchar 255
fakultaet varchar 255
dump mediumtext 16777215
archiv_file_id varchar 32
mkdate int 10 0
forumdump longtext 2147483647
wikidump longtext 2147483647  √  null
studienbereiche text 65535
VeranstaltungsNummer varchar 32

Table contained 0 rows at Do Aug 02 14:36 GMT+01:00 2018

Indexes:
Column(s) Type Sort Constraint Name
seminar_id Primary key Asc PRIMARY
heimat_inst_id Performance Asc heimat_inst_id

Close relationships: