tblBdGruppenHistory

202 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
lngSdSeminarID int4 10 null
tblSdDozent.lngSdSeminarID rel_{ECA0A4F1-362E-4D7C-84D8-87R
strBdSemestername varchar 13 ''::character varying
lngSdDozentID int4 10 null
tblSdDozent.lngDozentID rel_{ECA0A4F1-362E-4D7C-84D8-87R
lngSdGruppenID int4 10 null
tblSdGruppe.lngSdGruppenID rel_{4B0F8659-6AF1-4B5E-BF6E-70R
strDozentBereich varchar 50 ''::character varying
strDozentBemerkung varchar 254 ''::character varying
strDozentDeputat varchar 50 ''::character varying
strDozentMittelherkunft varchar 50 ''::character varying
strGruppenTyp varchar 25 ''::character varying
intLfdNr int4 10 0
txtDozentOD varchar 50 ''::character varying
strBdZusatzInfo varchar 254 ''::character varying
lngCount int4 10 0

Indexes

Constraint Name Type Sort Column(s)
pkey_tblbdgruppenhistory Primary key Asc lngCount
idx_20_{4B0F8659-6AF1-4B5E-BF6E Performance Asc lngSdGruppenID
idx_21_{ECA0A4F1-362E-4D7C-84D8 Performance Asc/Asc lngSdSeminarID + lngSdDozentID
idx_22_lngSeminarID Performance Asc lngSdSeminarID
idx_23_primarykey2_idx Performance Asc/Asc/Asc strBdSemestername + lngSdDozentID + lngSdGruppenID

Relationships