varighedsuafhengige_tilskud_fu


Columns

Column Type Size Nulls Auto Default Children Parents Comments
vautft_id int8 19 null
holdi_id int8 19 √ null
holdidenter.holdi_id vautft_holdi_fk R
aere_id int8 19 √ null
ae_rekvirenter.aere_id vautft_aere_fk R
tape_id int8 19 √ null
telleperioder.tape_id vautft_tape_fk R
tmk_id int8 19 √ null
tilskudsmerkekombinationer.tmk_id vautft_tmk_fk R
elev_id int8 19 √ null
elever.elev_id vautft_elev_fk R
tilskud numeric 10,2 √ null
indberetningsdato timestamp 22 √ null
uvma_id int8 19 √ null
uvm_afdelinger.uvma_id vautft_uvma_fk R
opdmod varchar 4 √ null
opdinit varchar 30 √ null
opdtid timestamp 22 √ null
ind_ud varchar 1 √ null
varighed varchar 1 √ null
land_id int8 19 √ null
lande.land_id vautft_land_fk R
elis_id int8 19 √ null
elev_i_skoleforlob.elis_id vautft_elis_fk R
ose_art varchar 10 √ null
ose_formal varchar 10 √ null
ose_ansvar varchar 10 √ null
ose_projekt varchar 10 √ null

Indexes

Constraint Name Type Sort Column(s)
vautft_pk Primary key Asc vautft_id
vautft_aere_fk_i Performance Asc aere_id
vautft_elev_fk_i Performance Asc elev_id
vautft_elis_fk_i Performance Asc elis_id
vautft_elis_id_idx Performance Asc elis_id
vautft_holdi_fk_i Performance Asc holdi_id
vautft_land_fk_i Performance Asc land_id
vautft_tape_fk_i Performance Asc tape_id
vautft_tmk_fk_i Performance Asc tmk_id
vautft_uvma_fk_i Performance Asc uvma_id
vautft_vautft_uk_uk Must be unique Asc/Asc/Asc/Asc/Asc elev_id + indberetningsdato + tmk_id + tape_id + aere_id

Check Constraints

Constraint Name Constraint
varighedsuafhengige_tilskud_fu_check1 (('ELEV_ID' IS NOT NULL))
varighedsuafhengige_tilskud_fu_check3 (('OPDINIT' IS NOT NULL))
varighedsuafhengige_tilskud_fu_check8 (('TMK_ID' IS NOT NULL))
varighedsuafhengige_tilskud_fu_check7 (('TILSKUD' IS NOT NULL))
varighedsuafhengige_tilskud_fu_check4 (('OPDMOD' IS NOT NULL))
varighedsuafhengige_tilskud_fu_check6 (('TAPE_ID' IS NOT NULL))
varighedsuafhengige_tilskud_fu_varighed_check (((varighed)::text = ANY ((ARRAY['1'::character varying, '2'::character varying, '3'::character varying, '4'::character varying])::text[])))
varighedsuafhengige_tilskud_fu_check10 (('VAUTFT_ID' IS NOT NULL))
varighedsuafhengige_tilskud_fu_ind_ud_check (((ind_ud)::text = ANY ((ARRAY['1'::character varying, '2'::character varying])::text[])))
varighedsuafhengige_tilskud_fu_check (('AERE_ID' IS NOT NULL))
varighedsuafhengige_tilskud_fu_check5 (('OPDTID' IS NOT NULL))
varighedsuafhengige_tilskud_fu_check2 (('INDBERETNINGSDATO' IS NOT NULL))
varighedsuafhengige_tilskud_fu_check9 (('UVMA_ID' IS NOT NULL))

Relationships

Close relationships within degrees of separation