holdplaceringer


Columns

Column Type Size Nulls Auto Default Children Parents Comments
hopl_id int8 19 null
aktivitetsplaceringer.hopl_id akpl_hopl_fk R
amu_bidrag.hopl_id ambi_hopl_fk R
skolefag_pa_holdplaceringer.hopl_id skph_hopl_fk R
elev_id int8 19 √ null
elever.elev_id hopl_elev_fk R
akti_id int8 19 √ null
aktiviteter.akti_id hopl_akti_fk R
startdato timestamp 22 √ null
slutdato timestamp 22 √ null
elis_id int8 19 √ null
elev_i_skoleforlob.elis_id hopl_elis_fk R
rate int2 5 √ null
eisp_id int8 19 √ null
elev_i_skolepraktik.eisp_id hopl_eisp_fk R
opdtid timestamp 22 √ null
opdinit varchar 30 √ null
opdmod varchar 4 √ null
aere_id int8 19 √ null
ae_rekvirenter.aere_id hopl_aere_fk R
ose_art varchar 10 √ null
ose_formal varchar 10 √ null
ose_ansvar varchar 10 √ null
ose_projekt varchar 10 √ null
oprettet_i_elevplan varchar 1 √ null
holdi_id int8 19 √ null
holdidenter.holdi_id hopl_holdi_fk R
oprindelse varchar 1 √ null
fritekst varchar 200 √ null
placeringstype varchar 1 √ null
tilskud varchar 1 √ null
gennemfort varchar 1 √ null
kursiststatus varchar 1 √ null
logi varchar 1 √ null
lrst_id int8 19 √ null
leresteder.lrst_id hopl_lrst_fk R
info_id int8 19 √ null
eksamensresultater_ea.id Implied Constraint R
afho_id int8 19 √ null
afholdelsesformer.afho_id hopl_afho_fk R
akasse varchar 1 √ null
betaler varchar 3 √ null
lrst_id_betal int8 19 √ null
leresteder.lrst_id hopl_lrst_fk2 R
transportbesver varchar 1 √ null
uddannelse_efter_skolegang varchar 1 √ null
uddannelsesbaggrund varchar 200 √ null
uddannelse_anvendt_5_ar varchar 1 √ null
lon_under_kursus varchar 1 √ null
information_sendes_til varchar 20 √ null
informationskanal varchar 10 √ null
sms_onskes varchar 1 √ null
mobilnr varchar 16 √ null
email varchar 100 √ null
hjelpemidler varchar 4000 √ null
navngiven varchar 1 √ null
reserveret_af varchar 100 √ null
opkrevet varchar 1 √ null
hopl_guid varchar 32 √ null
ls_ean_id int8 19 √ null
leresteder_ean.ls_ean_id hold_ls_ean_fk R
kunde_person_ref varchar 35 √ null
kunde_ordrenr varchar 10 √ null
afsluttet_uddannelse varchar 50 √ null
ankomstdato timestamp 22 √ null
tilmeldingstype varchar 12 √ null
uddannelse_afsluttet_5_aar varchar 1 √ null
kontrakt_udd varchar 1 √ null

Indexes

Constraint Name Type Sort Column(s)
hopl_pk Primary key Asc hopl_id
hold_ls_ean_fk_i Performance Asc ls_ean_id
hopl_aere_fk_i Performance Asc aere_id
hopl_afho_fk_i Performance Asc afho_id
hopl_akti_fk_i Performance Asc akti_id
hopl_akti_id_idx Performance Asc akti_id
hopl_eisp_fk_i Performance Asc eisp_id
hopl_eisp_id_cosa_formal_idx Performance Asc eisp_id
hopl_elev_fk_i Performance Asc elev_id
hopl_elev_id_idx Performance Asc elev_id
hopl_elis_fk_i Performance Asc elis_id
hopl_guid_uk Must be unique Asc hopl_guid
hopl_holdi_fk_i Performance Asc holdi_id
hopl_hopl1_uk Must be unique Asc/Asc/Asc elev_id + akti_id + startdato
hopl_info_fk_i Performance Asc info_id
hopl_lrst_fk2_i Performance Asc lrst_id_betal
hopl_lrst_fk_i Performance Asc lrst_id
hopl_lrst_id_idx Performance Asc lrst_id
hopl_startdato_idx Performance Asc startdato

Check Constraints

Constraint Name Constraint
holdplaceringer_akasse_check (((akasse)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
holdplaceringer_check2 (('ELEV_ID' IS NOT NULL))
holdplaceringer_check3 (('HOPL_GUID' IS NOT NULL))
holdplaceringer_informationskanal_check (((informationskanal)::text = ANY ((ARRAY['Post'::character varying, 'E-mail'::character varying])::text[])))
holdplaceringer_check (('AKASSE' IS NOT NULL))
holdplaceringer_check9 (('OPDTID' IS NOT NULL))
holdplaceringer_check10 (('OPRETTET_I_ELEVPLAN' IS NOT NULL))
holdplaceringer_betaler_check (((betaler)::text = ANY ((ARRAY['P'::character varying, 'L'::character varying, 'GVU'::character varying, 'N'::character varying])::text[])))
holdplaceringer_kursiststatus_check (((kursiststatus)::text = ANY ((ARRAY['1'::character varying, '2'::character varying, '4'::character varying, '6'::character varying, '7'::character varying])::text[])))
holdplaceringer_check5 (('KONTRAKT_UDD' IS NOT NULL))
holdplaceringer_check8 (('OPDMOD' IS NOT NULL))
holdplaceringer_logi_check (((logi)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
holdplaceringer_check6 (('LOGI' IS NOT NULL))
holdplaceringer_check7 (('OPDINIT' IS NOT NULL))
holdplaceringer_check13 (('STARTDATO' IS NOT NULL))
holdplaceringer_afsluttet_uddannelse_check (((afsluttet_uddannelse)::text = ANY ((ARRAY['Videregående uddannelse'::character varying, 'Andre uddannelser på videregående niveau'::character varying, 'Anden uddannelse'::character varying, 'Erhvervsuddannelse'::character varying, 'Faglært'::character varying])::text[])))
holdplaceringer_tilmeldingstype_check (((tilmeldingstype)::text = ANY ((ARRAY['PRIVATPERSON'::character varying, 'MEDARBEJDER'::character varying, 'SELVSTENDIG'::character varying, 'LEDIG'::character varying, 'VIRKSOMHED'::character varying])::text[])))
holdplaceringer_oprettet_i_elevplan_check (((oprettet_i_elevplan)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
holdplaceringer_check12 (('SLUTDATO' IS NOT NULL))
holdplaceringer_check4 (('HOPL_ID' IS NOT NULL))
holdplaceringer_navngiven_check (((navngiven)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
holdplaceringer_sms_onskes_check (((sms_onskes)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
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[])))
holdplaceringer_transportbesver_check (((transportbesver)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
holdplaceringer_kontrakt_udd_check (((kontrakt_udd)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
holdplaceringer_uddannelse_anvendt_5_ar_check (((uddannelse_anvendt_5_ar)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
holdplaceringer_uddannelse_efter_skolegang_check (((uddannelse_efter_skolegang)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
holdplaceringer_check1 (('AKTI_ID' IS NOT NULL))
holdplaceringer_information_sendes_til_check (((information_sendes_til)::text = ANY ((ARRAY['Kursist'::character varying, 'Arbejdsgiver'::character varying])::text[])))
holdplaceringer_lon_under_kursus_check (((lon_under_kursus)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
holdplaceringer_gennemfort_check (((gennemfort)::text = ANY ((ARRAY['1'::character varying, '2'::character varying, '3'::character varying])::text[])))
holdplaceringer_opkrevet_check (((opkrevet)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
holdplaceringer_check11 (('OPRINDELSE' IS NOT NULL))
holdplaceringer_oprindelse_check (((oprindelse)::text = ANY ((ARRAY['A'::character varying, 'E'::character varying, 'W'::character varying])::text[])))
holdplaceringer_tilskud_check (((tilskud)::text = ANY ((ARRAY['-'::character varying, 'J'::character varying, 'N'::character varying])::text[])))
holdplaceringer_uddannelse_afsluttet_5_aar_check (((uddannelse_afsluttet_5_aar)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))

Relationships

Close relationships within degrees of separation