cosa_formal


Columns

Column Type Size Nulls Auto Default Children Parents Comments
cofo_id int8 19 null
aktiviteter.cofo_id akti_cofo_fk R
amu_konteringer.cofo_id amkon_cofo_fk R
amu_kursister.cofo_id amkr_cofo_fk R
amu_rekvirenter.cofo_id amre_cofo_fk R
grunddata_formal.cofo_id grfo_cofo_fk R
gyldige_tmk_pa_au.cofo_id gtma_cofo_fk R
gyldige_tmk_pa_skoleperiode.cofo_id gtms_cofo_fk R
uddannelser.cofo_id cosa_formal R
uvm_fag_konteringer.cofo_id ufk_cofo_fk R
fgr_id int8 19 √ null
formalsgrupper.fgr_id cofo_fgr_fk R
cosa_formal varchar 4 √ null
betegnelse varchar 50 √ null
kort_betegnelse varchar 10 √ null
central_lokal varchar 1 √ null
opdmod varchar 4 √ null
opdinit varchar 30 √ null
opdtid timestamp 22 √ null
ftu_kode varchar 4 √ null
elafd_id int8 19 √ null
elevafdelinger.elafd_id cofo_elafd_fk R
indenfor_eve varchar 1 √ null
sta_indberetning varchar 1 √ null
optagsindberetning varchar 1 √ null
udva_id int8 19 √ null
udvalg.udva_id cofo_udva_fk R

Indexes

Constraint Name Type Sort Column(s)
cofo_pk Primary key Asc cofo_id
cofo_cofo1_uk Must be unique Asc cosa_formal
cofo_cofo_id_idx Performance Asc cofo_id
cofo_cosa_formal_idx Performance Asc cosa_formal
cofo_elafd_fk_i Performance Asc elafd_id
cofo_fgr_fk_i Performance Asc fgr_id
cofo_fgr_id_idx Performance Asc fgr_id
cofo_udva_fk_i Performance Asc udva_id

Check Constraints

Constraint Name Constraint
cosa_formal_check9 (('OPDTID' IS NOT NULL))
cosa_formal_indenfor_eve_check (((indenfor_eve)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
cosa_formal_check11 (('STA_INDBERETNING' IS NOT NULL))
cosa_formal_check5 (('INDENFOR_EVE' IS NOT NULL))
cosa_formal_check2 (('COFO_ID' IS NOT NULL))
cosa_formal_optagsindberetning_check (((optagsindberetning)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
cosa_formal_central_lokal_check (((central_lokal)::text = ANY ((ARRAY['C'::character varying, 'L'::character varying])::text[])))
cosa_formal_check6 (('KORT_BETEGNELSE' IS NOT NULL))
cosa_formal_sta_indberetning_check (((sta_indberetning)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
cosa_formal_check (('BETEGNELSE' IS NOT NULL))
cosa_formal_check1 (('CENTRAL_LOKAL' IS NOT NULL))
cosa_formal_check8 (('OPDMOD' IS NOT NULL))
cosa_formal_check7 (('OPDINIT' IS NOT NULL))
cosa_formal_check3 (('COSA_FORMAL' IS NOT NULL))
cosa_formal_check10 (('OPTAGSINDBERETNING' IS NOT NULL))
cosa_formal_check4 (('FGR_ID' IS NOT NULL))

Relationships

Close relationships within degrees of separation