gyldige_tmk_pa_skoleperiode


Columns

Column Type Size Nulls Auto Default Children Parents Comments
gtms_id int8 19 null
skpe_id int8 19 √ null
skoleperioder.skpe_id gtms_skpe_fk R
tmk_id int8 19 √ null
tilskudsmerkekombinationer.tmk_id gtms_tmk_fk R
cofo_id int8 19 √ null
cosa_formal.cofo_id gtms_cofo_fk R
startdato timestamp 22 √ null
slutdato timestamp 22 √ null
opdmod varchar 4 √ null
opdinit varchar 30 √ null
opdtid timestamp 22 √ null

Indexes

Constraint Name Type Sort Column(s)
gtms_pk Primary key Asc gtms_id
gtms_cofo_fk_i Performance Asc cofo_id
gtms_gtms1_uk Must be unique Asc/Asc/Asc skpe_id + tmk_id + startdato
gtms_skpe_fk_i Performance Asc skpe_id
gtms_tmk_fk_i Performance Asc tmk_id

Check Constraints

Constraint Name Constraint
gyldige_tmk_pa_skoleperiode_check3 (('OPDMOD' IS NOT NULL))
gyldige_tmk_pa_skoleperiode_check4 (('OPDTID' IS NOT NULL))
gyldige_tmk_pa_skoleperiode_check7 (('TMK_ID' IS NOT NULL))
gyldige_tmk_pa_skoleperiode_check1 (('GTMS_ID' IS NOT NULL))
gyldige_tmk_pa_skoleperiode_check2 (('OPDINIT' IS NOT NULL))
gyldige_tmk_pa_skoleperiode_check6 (('STARTDATO' IS NOT NULL))
gyldige_tmk_pa_skoleperiode_check (('COFO_ID' IS NOT NULL))
gyldige_tmk_pa_skoleperiode_check5 (('SKPE_ID' IS NOT NULL))

Relationships

Close relationships within degrees of separation