perioder_for_ds_afdelinger


Columns

Column Type Size Nulls Auto Default Children Parents Comments
pfda_id int8 19 null
startdato timestamp 22 √ null
slutdato timestamp 22 √ null
dsafd_id int8 19 √ null
ds_afdelinger.dsafd_id pfda_dsafd_fk R
skol_id int8 19 √ null
skoler.skol_id pfda_skol_fk R
opdmod varchar 4 √ null
opdinit varchar 30 √ null
opdtid timestamp 22 √ null

Indexes

Constraint Name Type Sort Column(s)
pfda_pk Primary key Asc pfda_id
pfda_dsafd_fk_i Performance Asc dsafd_id
pfda_skol_fk_i Performance Asc skol_id
pfdsafd_uk Must be unique Asc/Asc dsafd_id + startdato

Check Constraints

Constraint Name Constraint
perioder_for_ds_afdelinger_check3 (('OPDTID' IS NOT NULL))
perioder_for_ds_afdelinger_check2 (('OPDMOD' IS NOT NULL))
perioder_for_ds_afdelinger_check (('DSAFD_ID' IS NOT NULL))
perioder_for_ds_afdelinger_check1 (('OPDINIT' IS NOT NULL))
perioder_for_ds_afdelinger_check6 (('STARTDATO' IS NOT NULL))
perioder_for_ds_afdelinger_check4 (('PFDA_ID' IS NOT NULL))
perioder_for_ds_afdelinger_check5 (('SKOL_ID' IS NOT NULL))

Relationships

Close relationships within degrees of separation