eksterneskoleforlob


Columns

Column Type Size Nulls Auto Default Children Parents Comments
exskf_id int8 19 null
delingsperioder.exskf_id depe_exskf_fk R
eksterne_forlobsplaceringer.exskf_id exelis_exskf_fk R
eksterne_holdplaceringer.exskf_id exthopl_exskf_fk R
eksterne_telleperioder.exskf_id ektp_exskf_fk R
eksternt_fraver.exskf_id ekfr_exskf_fk R
elevudlan_afsendtdata.exskf_id eulafd_exskf_fk R
elevudlan_modtagetdata.exskf_id elvudlmod_exskf_fk R
elevudlanfag.exskf_id eludfg_exskf_fk R
elev_id int8 19 √ null
elever.elev_id exskf_elev_fk R
skpe_id int8 19 √ null
skoleperioder.skpe_id exskf_skpe_fk R
skol_id int8 19 √ null
skoler.skol_id exskf_skol_fk R
skol_id_tilskole int8 19 √ null
skoler.skol_id exskf_skol_tilskole_for_dette_ R
skol_id_skole_arselev int8 19 √ null
skoler.skol_id exskf_skol_skole_der_skal_fore R
opdinit varchar 30 √ null
opdtid timestamp 22 √ null
opdmod varchar 4 √ null
status varchar 2 √ null
elis_id int8 19 √ null
antal_aer_dage int2 5 √ null
startdato timestamp 22 √ null
slutdato timestamp 22 √ null
udlan_deling varchar 1 √ null
forste_telleperiode int2 5 √ null
sidste_telleperiode int2 5 √ null

Indexes

Constraint Name Type Sort Column(s)
exskf_pk Primary key Asc exskf_id
exskf_elev_fk_i Performance Asc elev_id
exskf_elis_fk_i Performance Asc elis_id
exskf_exskf1_uk Must be unique Asc/Asc/Asc/Asc/Asc udlan_deling + elev_id + skpe_id + skol_id + skol_id_tilskole
exskf_skol_fk_i Performance Asc skol_id
exskf_skol_skole_der_skal_fo_1 Performance Asc skol_id_skole_arselev
exskf_skol_tilskole_for_dett_1 Performance Asc skol_id_tilskole
exskf_skpe_fk_i Performance Asc skpe_id

Check Constraints

Constraint Name Constraint
eksterneskoleforlob_check9 (('STATUS' IS NOT NULL))
eksterneskoleforlob_udlan_deling_check (((udlan_deling)::text = ANY ((ARRAY['D'::character varying, 'F'::character varying, 'U'::character varying])::text[])))
eksterneskoleforlob_check3 (('OPDMOD' IS NOT NULL))
eksterneskoleforlob_check10 (('UDLAN_DELING' IS NOT NULL))
eksterneskoleforlob_check1 (('EXSKF_ID' IS NOT NULL))
eksterneskoleforlob_check7 (('SKOL_ID_TILSKOLE' IS NOT NULL))
eksterneskoleforlob_check5 (('SKOL_ID' IS NOT NULL))
eksterneskoleforlob_check6 (('SKOL_ID_SKOLE_ARSELEV' IS NOT NULL))
eksterneskoleforlob_check2 (('OPDINIT' IS NOT NULL))
eksterneskoleforlob_check4 (('OPDTID' IS NOT NULL))
eksterneskoleforlob_check8 (('SKPE_ID' IS NOT NULL))
eksterneskoleforlob_check (('ELEV_ID' IS NOT NULL))
eksterneskoleforlob_status_check (((status)::text = ANY ((ARRAY['A'::character varying, 'G'::character varying, 'I'::character varying, 'O'::character varying, 'S'::character varying, 'SA'::character varying, 'V'::character varying])::text[])))

Relationships

Close relationships within degrees of separation