Table studip20.stm_abstract_assign
Zuordnung abstrakte Module <-> Studienprogramme

 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
stm_abstr_id varchar 32
stm_abstract.stm_abstr_id Implied Constraint R
stm_type_id varchar 32 ID eines Modultyps
abschl char 3 ID eines Studienabschlusses
stg char 3
his_stg.stg Implied Constraint R
ID eines Studienprogramms/-fachs
pversion varchar 8 Version der Prüfungsordnung
earliest tinyint 3  √  null frührester Zeitpunkt (Semester)
latest tinyint 3  √  null spätester Zpkt.
recommed tinyint 3  √  null empfohlener Zpkt.

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

Indexes:
Column(s) Type Sort Constraint Name
stm_abstr_id + abschl + stg + pversion Primary key Asc/Asc/Asc/Asc PRIMARY
abschl + stg Performance Asc/Asc studycourse

Close relationships: