holdidenter


Columns

Column Type Size Nulls Auto Default Children Parents Comments
holdi_id int8 19 null
amu_bidrag.holdi_id ambi_holdi_fk R
elev_i_skoleforlob.holdi_id elis_holdi_fk R
elev_i_skolepraktik.holdi_id eisp_holdi_fk R
holdplaceringer.holdi_id hopl_holdi_fk R
skolefag_pa_holdplaceringer.holdi_id skph_holdi_fk R
varighedsuafh_tilskud_au_amu.holdi_id vaufaa_holdi_fk R
varighedsuafhengige_tilskud_fu.holdi_id vautft_holdi_fk R
elev_id int8 19 √ null
elever.elev_id holdi_elev_fk R
aere_id int8 19 √ null
ae_rekvirenter.aere_id holdi_aere_fk R
holdident varchar 8 √ null
startdato timestamp 22 √ null
slutdato timestamp 22 √ null
skoleophold varchar 1 √ null
skolepraktik varchar 1 √ null
au varchar 1 √ null
opdmod varchar 4 √ null
opdinit varchar 30 √ null
opdtid timestamp 22 √ null

Indexes

Constraint Name Type Sort Column(s)
holdi_pk Primary key Asc holdi_id
holdi_aere_fk_i Performance Asc aere_id
holdi_elev_fk_i Performance Asc elev_id
holdi_holdi1_uk Must be unique Asc/Asc holdident + elev_id

Check Constraints

Constraint Name Constraint
holdidenter_check8 (('SKOLEOPHOLD' IS NOT NULL))
holdidenter_au_check (((au)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
holdidenter_check2 (('ELEV_ID' IS NOT NULL))
holdidenter_check11 (('STARTDATO' IS NOT NULL))
holdidenter_check (('AERE_ID' IS NOT NULL))
holdidenter_check9 (('SKOLEPRAKTIK' IS NOT NULL))
holdidenter_check1 (('AU' IS NOT NULL))
holdidenter_skolepraktik_check (((skolepraktik)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
holdidenter_check4 (('HOLDI_ID' IS NOT NULL))
holdidenter_check7 (('OPDTID' IS NOT NULL))
holdidenter_skoleophold_check (((skoleophold)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
holdidenter_check3 (('HOLDIDENT' IS NOT NULL))
holdidenter_check10 (('SLUTDATO' IS NOT NULL))
holdidenter_check6 (('OPDMOD' IS NOT NULL))
holdidenter_check5 (('OPDINIT' IS NOT NULL))

Relationships

Close relationships within degrees of separation