Table studip30.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
earliest tinyint 3  √  null fr
latest tinyint 3  √  null sp
recommed tinyint 3  √  null empfohlener Zpkt.

Table contained 0 rows at Do Aug 02 15:05 GMT+01:00 2018

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: