gyldige_tmk_pa_au


Columns

Column Type Size Nulls Auto Default Children Parents Comments
gtma_id int8 19 null
tmk_id int8 19 √ null
tilskudsmerkekombinationer.tmk_id gtma_tmk_fk R
udda_id int8 19 √ null
uddannelser.udda_id gtma_udda_fk R
cofo_id int8 19 √ null
cosa_formal.cofo_id gtma_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)
gtma_pk Primary key Asc gtma_id
gtma_cofo_fk_i Performance Asc cofo_id
gtma_gtma1_uk Must be unique Asc/Asc/Asc tmk_id + udda_id + startdato
gtma_tmk_fk_i Performance Asc tmk_id
gtma_udda_fk_i Performance Asc udda_id

Check Constraints

Constraint Name Constraint
gyldige_tmk_pa_au_check3 (('OPDMOD' IS NOT NULL))
gyldige_tmk_pa_au_check4 (('OPDTID' IS NOT NULL))
gyldige_tmk_pa_au_check6 (('TMK_ID' IS NOT NULL))
gyldige_tmk_pa_au_check1 (('GTMA_ID' IS NOT NULL))
gyldige_tmk_pa_au_check7 (('UDDA_ID' IS NOT NULL))
gyldige_tmk_pa_au_check (('COFO_ID' IS NOT NULL))
gyldige_tmk_pa_au_check5 (('STARTDATO' IS NOT NULL))
gyldige_tmk_pa_au_check2 (('OPDINIT' IS NOT NULL))

Relationships

Close relationships within degrees of separation