tblSdSeminar

9 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
lngUniID int4 10 null
tblSdFakultaet.lngSdUniID rel_{DE58899A-9A16-4EE5-B96D-5AR
lngFakultaetID int4 10 null
tblSdFakultaet.lngSdFakultaetID rel_{DE58899A-9A16-4EE5-B96D-5AR
lngSeminarID int4 10 null
tblBdAktuelles.lngSdSeminarID rel_{D2AA0B40-E20C-442A-8B45-68R
tblBdData.lngSdSeminarID rel_{300EC23C-198E-48D6-B86D-68R
tblBdKursTermin.lngSdSeminarID seminar_kursterminR
tblBdKvvArchiv.lngSdSeminarID rel_{E8BA05DA-E2A0-4458-9706-DAR
tblBdLehrauftrag.lngSdSeminarID rel_tbllehrauftrag_seminarR
tblBdMedWFTrackKurs.lngSdSeminarID rel_{300EC23C-198E-48D6-B86D-68R
tblBdRaumplanExtern.lngSdSeminarID rel_{D881E80F-FEFE-46D5-856F-4FR
tblBdSignUp2HISPruefer.lngSeminarID HISPrueferSemR
tblBdSprechstunde.lngSdSeminarID rel_tblsprechstunde_SeminarR
tblBdStudentPruefungDetail.lngSdSeminarID rel_tblSdSeminartblBdStudentPruR
tblBdStudentPruefungDetailArchiv.lngSdSeminarID rel_arlSdSeminartblBdStudentPruR
tblBdStudentXMedWFTrackTeil.lngSdSeminarID WFTrackTeilXSeminarR
tblBdTermin.lngSeminarID rel_{CC61F9DA-E247-49C5-8866-31R
tblBdZulassungAuflage.lngSdSeminarID rel_tblSdSeminartblBdAuflageR
tblInterestList.lngSdSeminarID rel_{D116284D-86CE-4EF9-9802-85R
tblMafoDefinition.lngMafoRestrictSeminar rel_tblSdSeminartblMafoDefinitiR
tblSdAufgabe.lngSdSeminarID rel_{3EF29F2B-F5E4-499C-911B-EBR
tblSdDozent.lngSdSeminarID rel_{C7C513FD-304D-4BA9-9007-D6R
tblSdKvvInhalt.lngSdSeminarID rel_{40D0FEF4-7337-4E56-B05C-67R
tblSdMedWFTrack.lngSdSeminarID WFTrackXSeminarR
tblSdModul.lngSdSeminarID rel_tblSdSeminartblSdModulR
tblSdModulXLeistung.lngSdSeminarID rel_tblSdSeminartblSdModulXLeisR
tblSdNote.lngSdSeminarID rel_tblSdSeminartblSdNoteR
tblSdPruefung.lngSdSeminarID rel_{FD4127D7-5829-4399-A210-53R
tblSdPruefungXModul.lngSdSeminarID rel_tblSdSeminartblSdPruefungXMR
tblSdRaum.lngSdSeminarID rel_{7EFC5EE8-5CAA-4984-B4C1-32R
tblSdSeminarXFach.lngSeminarID rel_tblSdSeminartblSdSeminarXFaR
tblSdStudGruppe.lngSeminarID rel_tblSdStudGruppeXSeminarR
strSeminarUnivISID varchar 50 ''::character varying
strSeminarName varchar 50 null
strSeminarLink varchar 50 'http://www.'::character varying
strSeminarCustom1 text 2147483647 ''::text
strSeminarCustom2 text 2147483647 ''::text
strSeminarCustom3 text 2147483647 ''::text
strSeminarShort varchar 5 ''::character varying
blnSeminarNoteCboLocal bool 1 null

Indexes

Constraint Name Type Sort Column(s)
pkey_tblsdseminar Primary key Asc/Asc/Asc lngUniID + lngFakultaetID + lngSeminarID
idx_185_{DE58899A-9A16-4EE5-B96 Performance Asc/Asc lngUniID + lngFakultaetID
idx_186_lngFakultaetID Performance Asc lngFakultaetID
idx_187_lngSeminarID Must be unique Asc lngSeminarID
idx_188_lngUniID Performance Asc lngUniID
idx_189_strSeminarUnivISID Performance Asc strSeminarUnivISID
idx_n1_strSeminarShort Must be unique Asc strSeminarShort

Relationships