tblBdStudentBemerkung

14905 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
lngStudentBemerkungID serial 10 nextval(('"tblBdStudentB_lngStudentBem_seq"'::text)::regclass)
lngSdSeminarID int4 10 null
tblSdDozent.lngSdSeminarID rel_rel_DozentXStudentBemerkungR
strMatrikelnummer varchar 8 null
tblBdStudent.strMatrikelnummer rel_rel_StudentXStudentBemerkunR
lngDozentID int4 10 null
tblSdDozent.lngDozentID rel_rel_DozentXStudentBemerkungR
strStudentBemerkungTag varchar 50 null
strStudentBemerkungText text 2147483647 ''::text
dtmStudentBemerkungDatum date 13 null
dtmStudentBemerkungWvDatum date 13 null
blnStudentBemerkungWvAktiv bool 1 null
blnStudentBemerkungIsInternal bool 1 false

Indexes

Constraint Name Type Sort Column(s)
pkey_tblbdstudentbemerkung Primary key Asc lngStudentBemerkungID
idx_57_idx_fDozentXStudentBemer Performance Asc/Asc lngSdSeminarID + lngDozentID
idx_58_idx_fStudentXStudentBeme Performance Asc strMatrikelnummer

Relationships