skolefag_pa_holdplaceringer


Columns

Column Type Size Nulls Auto Default Children Parents Comments
skhp_id int8 19 null
amu_bidrag.skhp_id ambi_skhp_fk R
au_bidrag.skhp_id aubi_skhp_fk R
eksamensmark_pa_skhp.skhp_id eksmskhp_skhp_fk R
karakterer.skhp_id kara_skhp_fk R
projekttitler.skhp_id prti_skhp_fk R
tilstededage.skhp_id til_skhp_fk R
varighedsuafh_tilskud_au_amu.skhp_id vaufaa_skhp_fk R
hopl_id int8 19 √ null
holdplaceringer.hopl_id skph_hopl_fk R
skph_id int8 19 √ null
skolefag_pa_hold.skph_id skhp_skph_fk R
fagtilknytning varchar 1 √ null
fortsatter varchar 1 √ null
tmk_id int8 19 √ null
tilskudsmerkekombinationer.tmk_id skph_tmk_fk R
udda_id int8 19 √ null
uddannelser.udda_id skph_udda_fk R
projekttitel varchar 200 √ null
opdmod varchar 4 √ null
opdinit varchar 30 √ null
opdtid timestamp 22 √ null
aere_id int8 19 √ null
ae_rekvirenter.aere_id skhp_aere_fk R
oprettet_i_elevplan varchar 1 √ null
vfm_eksamenstermin varchar 8 √ null
holdi_id int8 19 √ null
holdidenter.holdi_id skph_holdi_fk R
startdato timestamp 22 √ null
slutdato timestamp 22 √ null
placeringstype varchar 1 √ null
kursiststatus varchar 1 √ null
tilskud varchar 1 √ null
gennemfort varchar 1 √ null
betalingsstatus varchar 1 √ null
kategori varchar 5 √ null
certifikat_udstedt varchar 1 √ null
varighed_dage numeric 4,1 √ null
indkaldelsesbrev timestamp 22 √ null
tilmeldingsbrev timestamp 22 √ null
afbudsdato timestamp 22 √ null
udeblivelsesdato timestamp 22 √ null
placeringsdato timestamp 22 √ null
ventelistedato timestamp 22 √ null
reservationsdato timestamp 22 √ null
info_id int8 19 √ null
eksamensresultater_ea.id Implied Constraint R
afho_id int8 19 √ null
afholdelsesformer.afho_id skhp_afho_fk R
anfo_id int8 19 √ null
eksamensresultater_ea.id Implied Constraint R
skhp_vno numeric 0 √ null
idv varchar 1 √ null
ledig varchar 1 √ null
fjernundervisning varchar 1 √ null
foregar_undervisning_pa_virk varchar 1 √ null
bosiddende_pa_grl varchar 1 √ null
bosiddende_pa_fer varchar 1 √ null
kontrakt_udd varchar 1 √ null

Indexes

Constraint Name Type Sort Column(s)
skhp_pk_1 Primary key Asc skhp_id
skhp_aere_fk_i Performance Asc aere_id
skhp_aere_id_idx Performance Asc aere_id
skhp_afho_fk_i Performance Asc afho_id
skhp_anfo_fk_i1 Performance Asc anfo_id
skhp_gennemfort_idx Performance Asc gennemfort
skhp_hopl_id_idx Performance Asc hopl_id
skhp_info_fk_i Performance Asc info_id
skhp_skph_id_idx Performance Asc skph_id
skhp_startdato_idx Performance Asc startdato
skhp_tmk_id_idx Performance Asc tmk_id
skolefag_pa_holdplaceringer_i1 Performance Asc hopl_id
skolefag_pa_holdplaceringer_i2 Performance Asc/Asc hopl_id + kontrakt_udd
skolefag_pa_holdplaceringer_i3 Performance Asc skhp_id
skph_holdi_fk_i Performance Asc holdi_id
skph_hopl_fk_i Performance Asc hopl_id
skph_skhp1_uk_1 Must be unique Asc/Asc/Asc startdato + hopl_id + skph_id
skph_skph_fk_i Performance Asc skph_id
skph_tmk_fk_i Performance Asc tmk_id
skph_udda_fk_i Performance Asc udda_id

Check Constraints

Constraint Name Constraint
skolefag_pa_holdplaceringer_check10 (('SKHP_ID' IS NOT NULL))
skolefag_pa_holdplaceringer_idv_check (((idv)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
skolefag_pa_holdplaceringer_ledig_check (((ledig)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
skolefag_pa_holdplaceringer_check2 (('FAGTILKNYTNING' IS NOT NULL))
skolefag_pa_holdplaceringer_gennemfort_check (((gennemfort)::text = ANY ((ARRAY['1'::character varying, '2'::character varying, '3'::character varying])::text[])))
skolefag_pa_holdplaceringer_check (('BOSIDDENDE_PA_FER' IS NOT NULL))
skolefag_pa_holdplaceringer_check12 (('SKPH_ID' IS NOT NULL))
skolefag_pa_holdplaceringer_check11 (('SKHP_VNO' IS NOT NULL))
skolefag_pa_holdplaceringer_check6 (('OPDINIT' IS NOT NULL))
skolefag_pa_holdplaceringer_placeringstype_check (((placeringstype)::text = ANY ((ARRAY['A'::character varying, 'L'::character varying, 'P'::character varying, 'R'::character varying, 'S'::character varying, 'U'::character varying, 'V'::character varying])::text[])))
skolefag_pa_holdplaceringer_check9 (('OPRETTET_I_ELEVPLAN' IS NOT NULL))
skolefag_pa_holdplaceringer_check1 (('BOSIDDENDE_PA_GRL' IS NOT NULL))
skolefag_pa_holdplaceringer_check13 (('SLUTDATO' IS NOT NULL))
skolefag_pa_holdplaceringer_tilskud_check (((tilskud)::text = ANY ((ARRAY['-'::character varying, 'J'::character varying, 'N'::character varying])::text[])))
skolefag_pa_holdplaceringer_betalingsstatus_check (((betalingsstatus)::text = ANY ((ARRAY['0'::character varying, '1'::character varying, '2'::character varying, '3'::character varying, '4'::character varying, '5'::character varying, '6'::character varying])::text[])))
skolefag_pa_holdplaceringer_kontrakt_udd_check (((kontrakt_udd)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
skolefag_pa_holdplaceringer_oprettet_i_elevplan_check (((oprettet_i_elevplan)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
skolefag_pa_holdplaceringer_fjernundervisning_check (((fjernundervisning)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
skolefag_pa_holdplaceringer_check4 (('HOPL_ID' IS NOT NULL))
skolefag_pa_holdplaceringer_check8 (('OPDTID' IS NOT NULL))
skolefag_pa_holdplaceringer_foregar_undervisning_pa_virk_check (((foregar_undervisning_pa_virk)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
skolefag_pa_holdplaceringer_fagtilknytning_check (((fagtilknytning)::text = ANY ((ARRAY['E'::character varying, 'I'::character varying, 'L'::character varying, 'O'::character varying, 'P'::character varying, 'S'::character varying, 'T'::character varying, 'V'::character varying])::text[])))
skolefag_pa_holdplaceringer_fortsatter_check (((fortsatter)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
skolefag_pa_holdplaceringer_kursiststatus_check (((kursiststatus)::text = ANY ((ARRAY['1'::character varying, '2'::character varying, '4'::character varying, '6'::character varying, '7'::character varying])::text[])))
skolefag_pa_holdplaceringer_check3 (('FORTSATTER' IS NOT NULL))
skolefag_pa_holdplaceringer_certifikat_udstedt_check (((certifikat_udstedt)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
skolefag_pa_holdplaceringer_check14 (('STARTDATO' IS NOT NULL))
skolefag_pa_holdplaceringer_check5 (('KONTRAKT_UDD' IS NOT NULL))
skolefag_pa_holdplaceringer_check7 (('OPDMOD' IS NOT NULL))

Relationships

Close relationships within degrees of separation