kursusplaceringer


Columns

Column Type Size Nulls Auto Default Children Parents Comments
kupl_id int8 19 null
aktivitetsplaceringer.kupl_id akpl_kupl_fk R
amu_tilstededage.kupl_id amut_kupl_fk R
kursistlektionsbidrag.kupl_id kubi_kupl_fk R
amkr_id int8 19 √ null
amu_kursister.amkr_id kupl_amkr_fk R
kkt_id int8 19 √ null
kursustyper_pa_kurser.kkt_id kupl_kkt_fk R
startdato timestamp 22 √ null
slutdato timestamp 22 √ null
tilskud varchar 1 √ null
tillegstakst varchar 1 √ null
certifikatbelob_tilbagebetalt varchar 1 √ null
logi varchar 1 √ null
certifikatprove varchar 1 √ null
certifikat_udstedt varchar 1 √ null
kursistlektioner numeric 6,2 √ null
rate int2 5 √ null
skolehjemsbelob numeric 10,2 √ null
gennemfort varchar 1 √ null
skoleuddannelse varchar 1 √ null
erhvervsuddannelse varchar 1 √ null
uddannelsesar varchar 4 √ null
seneste_stilling varchar 3 √ null
ledighed varchar 1 √ null
a_kasse varchar 2 √ null
am_status_inden varchar 2 √ null
am_status_efter varchar 1 √ null
statsborger varchar 1 √ null
tilskyndelse varchar 1 √ null
godtgorelse varchar 1 √ null
amre_id int8 19 √ null
amu_rekvirenter.amre_id kupl_amre_fk R
opdmod varchar 4 √ null
opdinit varchar 30 √ null
opdtid timestamp 22 √ null
indkaldelsesbrev timestamp 22 √ null
udeblivelsesbrev timestamp 22 √ null
kategori varchar 1 √ null
afbudsbrev timestamp 22 √ null
ventelistebrev 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
placeringstype varchar 1 √ null
akas_id int8 19 √ null
a_kasser.akas_id a_kasser R
betalingsstatus varchar 1 √ null
lrst_id int8 19 √ null
leresteder.lrst_id kupl_lrst_fk R
fritekst varchar 30 √ null
kost_logi varchar 1 √ null
aere_id int8 19 √ null
ae_rekvirenter.aere_id kupl_aere_fk R
amho_id int8 19 √ null
amu_holdidenter.amho_id kupl_amho_fk R

Indexes

Constraint Name Type Sort Column(s)
kupl_pk Primary key Asc kupl_id
a_kasser_i Performance Asc akas_id
kupl_aere_fk_i Performance Asc aere_id
kupl_amho_fk_i Performance Asc amho_id
kupl_amkr_fk_i Performance Asc amkr_id
kupl_amre_fk_i Performance Asc amre_id
kupl_dato_i Performance Asc/Asc startdato + slutdato
kupl_gennemfort_amkr_id_idx Performance Asc/Asc gennemfort + amkr_id
kupl_kkt_fk_i Performance Asc kkt_id
kupl_kupl1_uk Must be unique Asc/Asc/Asc amkr_id + kkt_id + startdato
kupl_lrst_fk_i Performance Asc lrst_id

Check Constraints

Constraint Name Constraint
kursusplaceringer_check11 (('OPDMOD' IS NOT NULL))
kursusplaceringer_check12 (('OPDTID' IS NOT NULL))
kursusplaceringer_check15 (('STARTDATO' IS NOT NULL))
kursusplaceringer_logi_check (((logi)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
kursusplaceringer_am_status_inden_check (((am_status_inden)::text = ANY ((ARRAY['1'::character varying, '3'::character varying, '4'::character varying, '5'::character varying, '99'::character varying, '2'::character varying])::text[])))
kursusplaceringer_check (('AERE_ID' IS NOT NULL))
kursusplaceringer_ledighed_check (((ledighed)::text = ANY ((ARRAY['1'::character varying, '2'::character varying, '6'::character varying, '4'::character varying, '7'::character varying, '9'::character varying, '3'::character varying, '5'::character varying])::text[])))
kursusplaceringer_check9 (('LOGI' IS NOT NULL))
kursusplaceringer_tilskud_check (((tilskud)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
kursusplaceringer_certifikat_udstedt_check (((certifikat_udstedt)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
kursusplaceringer_check3 (('CERTIFIKATBELOB_TILBAGEBETALT' IS NOT NULL))
kursusplaceringer_statsborger_check (((statsborger)::text = ANY ((ARRAY['2'::character varying, '3'::character varying, '9'::character varying, '1'::character varying])::text[])))
kursusplaceringer_check1 (('AMKR_ID' IS NOT NULL))
kursusplaceringer_check16 (('TILLEGSTAKST' IS NOT NULL))
kursusplaceringer_placeringstype_check (((placeringstype)::text = ANY ((ARRAY['P'::character varying, 'U'::character varying, 'R'::character varying, 'S'::character varying, 'V'::character varying, 'A'::character varying, 'L'::character varying])::text[])))
kursusplaceringer_tillegstakst_check (((tillegstakst)::text = ANY ((ARRAY['N'::character varying, 'J'::character varying, '1'::character varying, '2'::character varying, '3'::character varying, '4'::character varying, '5'::character varying])::text[])))
kursusplaceringer_check17 (('TILSKUD' IS NOT NULL))
kursusplaceringer_godtgorelse_check (((godtgorelse)::text = ANY ((ARRAY['1'::character varying, '6'::character varying, '7'::character varying, '5'::character varying, '9'::character varying, '2'::character varying, '3'::character varying, '4'::character varying])::text[])))
kursusplaceringer_check8 (('KUPL_ID' IS NOT NULL))
kursusplaceringer_gennemfort_check (((gennemfort)::text = ANY ((ARRAY['1'::character varying, '2'::character varying, '3'::character varying])::text[])))
kursusplaceringer_certifikatbelob_tilbagebetalt_check (((certifikatbelob_tilbagebetalt)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
kursusplaceringer_check5 (('CERTIFIKAT_UDSTEDT' IS NOT NULL))
kursusplaceringer_check13 (('PLACERINGSTYPE' IS NOT NULL))
kursusplaceringer_check10 (('OPDINIT' IS NOT NULL))
kursusplaceringer_check7 (('KOST_LOGI' IS NOT NULL))
kursusplaceringer_certifikatprove_check (((certifikatprove)::text = ANY ((ARRAY['J'::character varying, 'U'::character varying, 'N'::character varying])::text[])))
kursusplaceringer_check4 (('CERTIFIKATPROVE' IS NOT NULL))
kursusplaceringer_kost_logi_check (((kost_logi)::text = ANY ((ARRAY['0'::character varying, '1'::character varying, '2'::character varying, '3'::character varying, '9'::character varying])::text[])))
kursusplaceringer_seneste_stilling_check (((seneste_stilling)::text = ANY ((ARRAY['100'::character varying, '101'::character varying, '102'::character varying, '104'::character varying, '105'::character varying, '106'::character varying, '107'::character varying, '108'::character varying, '999'::character varying, '103'::character varying])::text[])))
kursusplaceringer_check6 (('KKT_ID' IS NOT NULL))
kursusplaceringer_am_status_efter_check (((am_status_efter)::text = ANY ((ARRAY['1'::character varying, '2'::character varying, '3'::character varying, '6'::character varying, '4'::character varying, '9'::character varying, '5'::character varying])::text[])))
kursusplaceringer_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[])))
kursusplaceringer_check2 (('AMRE_ID' IS NOT NULL))
kursusplaceringer_tilskyndelse_check (((tilskyndelse)::text = ANY ((ARRAY['1'::character varying, '5'::character varying, '2'::character varying, '6'::character varying, '3'::character varying, '4'::character varying, '7'::character varying, '9'::character varying])::text[])))
kursusplaceringer_check14 (('SLUTDATO' IS NOT NULL))
kursusplaceringer_erhvervsuddannelse_check (((erhvervsuddannelse)::text = ANY ((ARRAY['1'::character varying, '4'::character varying, '3'::character varying, '5'::character varying, '9'::character varying, '6'::character varying, '2'::character varying])::text[])))
kursusplaceringer_skoleuddannelse_check (((skoleuddannelse)::text = ANY ((ARRAY['1'::character varying, '2'::character varying, '9'::character varying, '4'::character varying, '3'::character varying])::text[])))

Relationships

Close relationships within degrees of separation