inb_tilskud_amu_end


Columns

Column Type Size Nulls Auto Default Children Parents Comments
itamue_id int8 19 null
inb_tilskud_amu_cpr_end.itamue_id itamuce_itamue_fk R
uddannelse varchar 4 √ null
version varchar 4 √ null
uvm_fag varchar 5 √ null
niveau varchar 1 √ null
varighed numeric 4,1 √ null
tmk varchar 5 √ null
betalingsstatus varchar 1 √ null
ae_rekvirent varchar 4 √ null
uvm_afdeling varchar 10 √ null
afholdende_skole varchar 10 √ null
godkendt_skole varchar 10 √ null
opgorelsesmetode varchar 10 √ null
startdato timestamp 22 √ null
bidrag numeric 12,5 √ null
antal_elever int4 10 √ null
indberettes_til_uvm varchar 1 √ null
grundlag varchar 10 √ null
systemversion varchar 15 √ null
indbendl_id int8 19 √ null
endelige_indberetninger.indbendl_id itamue_indbendl_fk R
ae_rekvirent_type varchar 5 √ null

Indexes

Constraint Name Type Sort Column(s)
itamue_pk_1 Primary key Asc itamue_id
itamue_indbendl_fk_i Performance Asc indbendl_id
itamue_indbendl_id_idx Performance Asc indbendl_id
itamue_itamue_uk1_uk Must be unique Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc indbendl_id + uddannelse + version + uvm_fag + niveau + varighed + tmk + betalingsstatus + ae_rekvirent + uvm_afdeling + afholdende_skole + godkendt_skole + startdato + grundlag + ae_rekvirent_type

Check Constraints

Constraint Name Constraint
inb_tilskud_amu_end_check2 (('ANTAL_ELEVER' IS NOT NULL))
inb_tilskud_amu_end_check1 (('AFHOLDENDE_SKOLE' IS NOT NULL))
inb_tilskud_amu_end_check5 (('GRUNDLAG' IS NOT NULL))
inb_tilskud_amu_end_check16 (('UVM_FAG' IS NOT NULL))
inb_tilskud_amu_end_check18 (('VERSION' IS NOT NULL))
inb_tilskud_amu_end_grundlag_check (((grundlag)::text = ANY ((ARRAY['Faktisk'::character varying, 'Forventet'::character varying])::text[])))
inb_tilskud_amu_end_check13 (('TMK' IS NOT NULL))
inb_tilskud_amu_end_opgorelsesmetode_check (((opgorelsesmetode)::text = ANY ((ARRAY['Antal'::character varying, 'Kroner'::character varying, 'Årselev'::character varying])::text[])))
inb_tilskud_amu_end_check15 (('UVM_AFDELING' IS NOT NULL))
inb_tilskud_amu_end_check17 (('VARIGHED' IS NOT NULL))
inb_tilskud_amu_end_check6 (('INDBENDL_ID' IS NOT NULL))
inb_tilskud_amu_end_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[])))
inb_tilskud_amu_end_indberettes_til_uvm_check (((indberettes_til_uvm)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
inb_tilskud_amu_end_check7 (('INDBERETTES_TIL_UVM' IS NOT NULL))
inb_tilskud_amu_end_check10 (('OPGORELSESMETODE' IS NOT NULL))
inb_tilskud_amu_end_check4 (('BIDRAG' IS NOT NULL))
inb_tilskud_amu_end_check11 (('STARTDATO' IS NOT NULL))
inb_tilskud_amu_end_check12 (('SYSTEMVERSION' IS NOT NULL))
inb_tilskud_amu_end_check3 (('BETALINGSSTATUS' IS NOT NULL))
inb_tilskud_amu_end_check8 (('ITAMUE_ID' IS NOT NULL))
inb_tilskud_amu_end_check (('AE_REKVIRENT_TYPE' IS NOT NULL))
inb_tilskud_amu_end_check9 (('NIVEAU' IS NOT NULL))
inb_tilskud_amu_end_check14 (('UDDANNELSE' IS NOT NULL))

Relationships

Close relationships within degrees of separation