elev_i_skoleforlob


Columns

Column Type Size Nulls Auto Default Children Parents Comments
elis_id int8 19 null
ae_bidrag.elis_id aebi_elis_fk R
elev_i_aer_perioder.elis_id eiap_elis_fk R
holdplaceringer.elis_id hopl_elis_fk R
skolehjemselever.elis_id shje_elis_fk R
sta_bidrag.elis_id stab_elis_fk R
varighedsuafhengige_tilskud_fu.elis_id vautft_elis_fk R
skof_id int8 19 √ null
skoleforlob.skof_id elis_skof_fk R
startdato timestamp 22 √ null
slutdato timestamp 22 √ null
skolehjem varchar 1 √ null
skolehjemsarselev varchar 1 √ null
befordring varchar 1 √ null
elev_id int8 19 √ null
elever.elev_id elis_elev_fk R
forsorger varchar 1 √ null
stmk_id int8 19 √ null
eksamensresultater_ea.id Implied Constraint R
tmk_id int8 19 √ null
tilskudsmerkekombinationer.tmk_id elis_tmk_fk R
rate int2 5 √ null
opdtid timestamp 22 √ null
opdinit varchar 30 √ null
opdmod varchar 4 √ null
aere_id int8 19 √ null
ae_rekvirenter.aere_id elis_aere_fk R
aer_indberetning varchar 1 √ null
holdi_id int8 19 √ null
holdidenter.holdi_id elis_holdi_fk R
info_id int8 19 √ null
eksamensresultater_ea.id Implied Constraint R
saet_id int8 19 √ null
eksamensresultater_ea.id Implied Constraint R
sidste_forlob varchar 1 √ null
omganger varchar 1 √ null
udforb_id int8 19 √ null
uddannelsesforlob.udforb_id elis_udforb_fk R

Indexes

Constraint Name Type Sort Column(s)
elis_pk Primary key Asc elis_id
elev_i_skoleforlob_i01 Performance Asc/Asc skof_id + omganger
elis_aere_fk_i Performance Asc aere_id
elis_elev_fk_i Performance Asc elev_id
elis_elev_id_idx Performance Asc elev_id
elis_elis1_uk Must be unique Asc/Asc/Asc skof_id + elev_id + startdato
elis_holdi_fk_i Performance Asc holdi_id
elis_i01 Performance Asc/Asc startdato + slutdato
elis_info_fk_i Performance Asc info_id
elis_saet_fk_i Performance Asc saet_id
elis_skof_fk_i Performance Asc skof_id
elis_stmk_fk_i Performance Asc stmk_id
elis_tmk_fk_i Performance Asc tmk_id
elis_udforb_fk_i Performance Asc udforb_id

Check Constraints

Constraint Name Constraint
elev_i_skoleforlob_check3 (('ELEV_ID' IS NOT NULL))
elev_i_skoleforlob_check6 (('OMGANGER' IS NOT NULL))
elev_i_skoleforlob_check11 (('SKOF_ID' IS NOT NULL))
elev_i_skoleforlob_sidste_forlob_check (((sidste_forlob)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
elev_i_skoleforlob_forsorger_check (((forsorger)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
elev_i_skoleforlob_check9 (('OPDTID' IS NOT NULL))
elev_i_skoleforlob_befordring_check1 (((befordring)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
elev_i_skoleforlob_check14 (('SLUTDATO' IS NOT NULL))
elev_i_skoleforlob_befordring_check (((befordring)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
elev_i_skoleforlob_check7 (('OPDINIT' IS NOT NULL))
elev_i_skoleforlob_omganger_check (((omganger)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
elev_i_skoleforlob_aer_indberetning_check (((aer_indberetning)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
elev_i_skoleforlob_check12 (('SKOLEHJEM' IS NOT NULL))
elev_i_skoleforlob_skolehjem_check1 (((skolehjem)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
elev_i_skoleforlob_skolehjem_check (((skolehjem)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
elev_i_skoleforlob_check13 (('SKOLEHJEMSARSELEV' IS NOT NULL))
elev_i_skoleforlob_check (('AERE_ID' IS NOT NULL))
elev_i_skoleforlob_check2 (('BEFORDRING' IS NOT NULL))
elev_i_skoleforlob_skolehjemsarselev_check (((skolehjemsarselev)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
elev_i_skoleforlob_check15 (('STARTDATO' IS NOT NULL))
elev_i_skoleforlob_aer_indberetning_check1 (((aer_indberetning)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
elev_i_skoleforlob_check5 (('FORSORGER' IS NOT NULL))
elev_i_skoleforlob_check1 (('AER_INDBERETNING' IS NOT NULL))
elev_i_skoleforlob_forsorger_check1 (((forsorger)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
elev_i_skoleforlob_skolehjemsarselev_check1 (((skolehjemsarselev)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
elev_i_skoleforlob_check10 (('SIDSTE_FORLOB' IS NOT NULL))
elev_i_skoleforlob_check4 (('ELIS_ID' IS NOT NULL))
elev_i_skoleforlob_check8 (('OPDMOD' IS NOT NULL))

Relationships

Close relationships within degrees of separation