tblSdNote

136 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
lngSdSeminarID int4 10 null
tblBdStudentXLeistung.lngSdSeminarID rel_tblSdNotetblBdStudentXLeistR
tblBdStudentXLeistungArchiv.lngSdSeminarID rel_tblSdNotetblBdStudentArchivR
tblBdStudentXMedWFTrackTeil.lngSdSeminarID rel_WFTrackXNoteR
tblBdStudentXPruefung.lngSdSeminarID rel_tblSdNotetblBdStudentXPruefR
tblBdStudentXPruefungArchiv.lngSdSeminarID rel_tblArchiventXPruefR
tblSdSeminar.lngSeminarID rel_tblSdSeminartblSdNoteR
intNoteID int4 10 null
tblBdStudentXLeistung.intNoteID rel_tblSdNotetblBdStudentXLeistR
tblBdStudentXLeistungArchiv.intNoteID rel_tblSdNotetblBdStudentArchivR
tblBdStudentXMedWFTrackTeil.intNoteID rel_WFTrackXNoteR
tblBdStudentXPruefung.intNoteID rel_tblSdNotetblBdStudentXPruefR
tblBdStudentXPruefungArchiv.intNoteID rel_tblArchiventXPruefR
strNoteNameDE varchar 50 null
sngNoteWertDE float8 17,17 null
strNoteECTSGrade varchar 50 ''::character varying
strNoteECTSDefinition varchar 50 ''::character varying
sngNoteECTSCalc float8 17,17 0
blnNoteBestanden bool 1 null
strNoteCustom1 text 2147483647 ''::text
strNoteCustom2 text 2147483647 ''::text
strNoteCustom3 text 2147483647 ''::text

Indexes

Constraint Name Type Sort Column(s)
pkey_tblsdnote Primary key Asc/Asc lngSdSeminarID + intNoteID
idx_149_lngNoteID Performance Asc intNoteID
idx_150_lngSdSeminarID Performance Asc lngSdSeminarID
idx_151_tblSdSeminartblSdNote Performance Asc lngSdSeminarID

Relationships