aerperioder


Columns

Column Type Size Nulls Auto Default Children Parents Comments
aerp_id int8 19 null
elev_i_aer_perioder.aerp_id eiap_aerp_fk R
skof_id int8 19 √ null
skoleforlob.skof_id aerp_skof_fk R
aerperiode varchar 2 √ null
startdato timestamp 22 √ null
slutdato timestamp 22 √ null
opdinit varchar 30 √ null
opdtid timestamp 22 √ null
opdmod varchar 4 √ null

Indexes

Constraint Name Type Sort Column(s)
aerp_pk Primary key Asc aerp_id
aerp_aerp0_uk Must be unique Asc/Asc aerperiode + skof_id
aerp_skof_fk_i Performance Asc skof_id

Check Constraints

Constraint Name Constraint
aerperioder_check5 (('SKOF_ID' IS NOT NULL))
aerperioder_check (('AERPERIODE' IS NOT NULL))
aerperioder_check4 (('OPDTID' IS NOT NULL))
aerperioder_check6 (('SLUTDATO' IS NOT NULL))
aerperioder_check7 (('STARTDATO' IS NOT NULL))
aerperioder_check3 (('OPDMOD' IS NOT NULL))
aerperioder_check2 (('OPDINIT' IS NOT NULL))
aerperioder_check1 (('AERP_ID' IS NOT NULL))

Relationships

Close relationships within degrees of separation