sosu_uddannelsesaftaler


Columns

Column Type Size Nulls Auto Default Children Parents Comments
sosuud_id int8 19 null
elev_id int8 19 √ null
elever.elev_id sur_elev_fk R
lrst_id int8 19 √ null
leresteder.lrst_id sur_lrst_fk R
spec_id int8 19 √ null
specialer.spec_id sur_spec_fk R
startdato timestamp 22 √ null
slutdato timestamp 22 √ null
modtaget timestamp 22 √ null
underskrevet timestamp 22 √ null
ferdigbehandlet timestamp 22 √ null
bemerkning varchar 1000 √ null
easyp_aftaleid int8 19 √ null
opdtid timestamp 22 √ null
opdmod varchar 4 √ null
opdinit varchar 30 √ null

Indexes

Constraint Name Type Sort Column(s)
sur_pk Primary key Asc sosuud_id
sur_elev_fk_i Performance Asc elev_id
sur_lrst_fk_i Performance Asc lrst_id
sur_spec_fk_i Performance Asc spec_id
sur_uk Must be unique Asc/Asc/Asc/Asc spec_id + elev_id + lrst_id + startdato

Check Constraints

Constraint Name Constraint
sosu_uddannelsesaftaler_check (('ELEV_ID' IS NOT NULL))
sosu_uddannelsesaftaler_check4 (('OPDTID' IS NOT NULL))
sosu_uddannelsesaftaler_check7 (('SPEC_ID' IS NOT NULL))
sosu_uddannelsesaftaler_check2 (('OPDINIT' IS NOT NULL))
sosu_uddannelsesaftaler_check5 (('SLUTDATO' IS NOT NULL))
sosu_uddannelsesaftaler_check1 (('LRST_ID' IS NOT NULL))
sosu_uddannelsesaftaler_check3 (('OPDMOD' IS NOT NULL))
sosu_uddannelsesaftaler_check8 (('STARTDATO' IS NOT NULL))
sosu_uddannelsesaftaler_check6 (('SOSUUD_ID' IS NOT NULL))

Relationships

Close relationships within degrees of separation