skolehjemselever


Columns

Column Type Size Nulls Auto Default Children Parents Comments
shje_id int8 19 null
aub_betalinger.shje_id aubb_fk R
eksterne_verelsesbookinger.shje_id eksv_shje_fk R
elevbookinger.shje_id elbo_shje_fk R
pers_id int8 19 √ null
personer.pers_id shje_pers_fk R
startdato timestamp 22 √ null
slutdato timestamp 22 √ null
uddannelse varchar 4 √ null
version varchar 4 √ null
skoleperiode varchar 4 √ null
gebyrbetaling varchar 1 √ null
skoleforlob varchar 12 √ null
uddannelsesaftale varchar 1 √ null
forsorger varchar 1 √ null
skolehjemsforsog varchar 1 √ null
skolehjemsarselev varchar 1 √ null
skolehjem varchar 1 √ null
afvist varchar 1 √ null
intern varchar 1 √ null
endret_periode varchar 1 √ null
beregningsgrundlag_endret varchar 1 √ null
udmeldt varchar 1 √ null
opdmod varchar 4 √ null
opdinit varchar 30 √ null
opdtid timestamp 22 √ null
ebog_id int8 19 √ null
ekstern_booking_opkrevningsgru.ebog_id shje_ebog_fk R
sdfe_id int8 19 √ null
skoledage_for_eksterne_booking.sdfe_id shje_sdfe_fk R
skol_id int8 19 √ null
skoler.skol_id shje_skol_fk R
skoe_id int8 19 √ null
skoler.skol_id shje_skoe_fk R
elis_id int8 19 √ null
elev_i_skoleforlob.elis_id shje_elis_fk R
lrst_id int8 19 √ null
leresteder.lrst_id shje_lrst_fk R
a259elbo_id int8 19 √ null
eksamensresultater_ea.id Implied Constraint R
speciale varchar 2 √ null
formal varchar 1 √ null
modtaget timestamp 22 √ null
afgangsdato timestamp 22 √ null
bemerkning varchar 200 √ null
ae_rekvirent varchar 4 √ null
holdident varchar 8 √ null
holdident_startdato timestamp 22 √ null
holdident_slutdato timestamp 22 √ null
opbevar_til date 13 √ null
opbevar_aub_til date 13 √ null
opbevar_kar_til date 13 √ null
opbevar_oko_til date 13 √ null
opbevar_su_til date 13 √ null

Indexes

Constraint Name Type Sort Column(s)
shje_pk Primary key Asc shje_id
shje_a259elbo_fk_i Performance Asc a259elbo_id
shje_ebog_fk_i Performance Asc ebog_id
shje_elis_fk_i Performance Asc elis_id
shje_holdident Performance Asc holdident
shje_lrst_fk_i Performance Asc lrst_id
shje_pers_fk_i Performance Asc pers_id
shje_pers_id_idx Performance Asc pers_id
shje_sdfe_fk_i Performance Asc sdfe_id
shje_skol_fk_i Performance Asc skol_id
shje_skol_skolehjem_der_er_b_1 Performance Asc skoe_id
shje_uddannelse_idx Performance Asc uddannelse

Check Constraints

Constraint Name Constraint
skolehjemselever_check17 (('SLUTDATO' IS NOT NULL))
skolehjemselever_check8 (('OPDMOD' IS NOT NULL))
skolehjemselever_skolehjemsforsog_check (((skolehjemsforsog)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
skolehjemselever_check (('AE_REKVIRENT' IS NOT NULL))
skolehjemselever_check10 (('PERS_ID' IS NOT NULL))
skolehjemselever_intern_check (((intern)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
skolehjemselever_check14 (('SKOLEHJEMSARSELEV' IS NOT NULL))
skolehjemselever_check16 (('SKOLEPERIODE' IS NOT NULL))
skolehjemselever_endret_periode_check (((endret_periode)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
skolehjemselever_check12 (('SKOLEFORLOB' IS NOT NULL))
skolehjemselever_formal_check (((formal)::text = ANY ((ARRAY['A'::character varying, 'B'::character varying, 'E'::character varying, 'F'::character varying, 'I'::character varying, 'M'::character varying, 'O'::character varying, 'P'::character varying, 'S'::character varying, 'U'::character varying, 'X'::character varying, 'Å'::character varying])::text[])))
skolehjemselever_skolehjem_check (((skolehjem)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
skolehjemselever_skolehjemsarselev_check (((skolehjemsarselev)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
skolehjemselever_check7 (('OPDINIT' IS NOT NULL))
skolehjemselever_check11 (('SHJE_ID' IS NOT NULL))
skolehjemselever_check19 (('UDDANNELSE' IS NOT NULL))
skolehjemselever_check13 (('SKOLEHJEM' IS NOT NULL))
skolehjemselever_check20 (('UDDANNELSESAFTALE' IS NOT NULL))
skolehjemselever_check3 (('ENDRET_PERIODE' IS NOT NULL))
skolehjemselever_check6 (('INTERN' IS NOT NULL))
skolehjemselever_check5 (('GEBYRBETALING' IS NOT NULL))
skolehjemselever_check22 (('VERSION' IS NOT NULL))
skolehjemselever_check2 (('BEREGNINGSGRUNDLAG_ENDRET' IS NOT NULL))
skolehjemselever_forsorger_check (((forsorger)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
skolehjemselever_beregningsgrundlag_endret_check (((beregningsgrundlag_endret)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
skolehjemselever_udmeldt_check (((udmeldt)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
skolehjemselever_gebyrbetaling_check (((gebyrbetaling)::text = ANY ((ARRAY['B'::character varying, 'F'::character varying])::text[])))
skolehjemselever_check4 (('FORSORGER' IS NOT NULL))
skolehjemselever_check9 (('OPDTID' IS NOT NULL))
skolehjemselever_afvist_check (((afvist)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
skolehjemselever_check15 (('SKOLEHJEMSFORSOG' IS NOT NULL))
skolehjemselever_check21 (('UDMELDT' IS NOT NULL))
skolehjemselever_uddannelsesaftale_check (((uddannelsesaftale)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
skolehjemselever_check18 (('STARTDATO' IS NOT NULL))
skolehjemselever_check1 (('AFVIST' IS NOT NULL))

Relationships

Close relationships within degrees of separation