kvalifikationer_til_hovedforlo


Columns

Column Type Size Nulls Auto Default Children Parents Comments
kvho_id int8 19 null
udda_id int8 19 √ null
uddannelser.udda_id kvho_udda_fk R
pers_id int8 19 √ null
personer.pers_id kvho_pers_fk R
status varchar 1 √ null
meda_id int8 19 √ null
medarbejdere.meda_id kvho_meda_fk R
dato timestamp 22 √ null
genereret_af_bevis varchar 1 √ null
opdmod varchar 4 √ null
opdinit varchar 30 √ null
opdtid timestamp 22 √ null
skol_id int8 19 √ null
skoler.skol_id kvho_skol_fk R
spec_id int8 19 √ null
specialer.spec_id kvho_spec_fk R

Indexes

Constraint Name Type Sort Column(s)
kvho_pk Primary key Asc kvho_id
kvho_kvho1_uk Must be unique Asc/Asc/Asc/Asc udda_id + pers_id + status + spec_id
kvho_meda_fk_i Performance Asc meda_id
kvho_pers_fk_i Performance Asc pers_id
kvho_pers_id_idx Performance Asc pers_id
kvho_skol_fk_i Performance Asc skol_id
kvho_spec_fk_i1 Performance Asc spec_id
kvho_udda_fk_i Performance Asc udda_id

Check Constraints

Constraint Name Constraint
kvalifikationer_til_hovedforlo_check5 (('PERS_ID' IS NOT NULL))
kvalifikationer_til_hovedforlo_check1 (('KVHO_ID' IS NOT NULL))
kvalifikationer_til_hovedforlo_check2 (('OPDINIT' IS NOT NULL))
kvalifikationer_til_hovedforlo_check4 (('OPDTID' IS NOT NULL))
kvalifikationer_til_hovedforlo_check7 (('STATUS' IS NOT NULL))
kvalifikationer_til_hovedforlo_status_check (((status)::text = ANY ((ARRAY['F'::character varying, 'E'::character varying])::text[])))
kvalifikationer_til_hovedforlo_check3 (('OPDMOD' IS NOT NULL))
kvalifikationer_til_hovedforlo_check6 (('SKOL_ID' IS NOT NULL))
kvalifikationer_til_hovedforlo_genereret_af_bevis_check (((genereret_af_bevis)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
kvalifikationer_til_hovedforlo_check (('DATO' IS NOT NULL))
kvalifikationer_til_hovedforlo_check8 (('UDDA_ID' IS NOT NULL))

Relationships

Close relationships within degrees of separation