varighedsuafh_tilskud_au_amu


Columns

Column Type Size Nulls Auto Default Children Parents Comments
vaufaa_id int8 19 null
tmk_id int8 19 √ null
tilskudsmerkekombinationer.tmk_id vaufaa_tmk_fk R
skhp_id int8 19 √ null
skolefag_pa_holdplaceringer.skhp_id vaufaa_skhp_fk R
elev_id int8 19 √ null
elever.elev_id vaufaa_elev_fk R
aere_id int8 19 √ null
ae_rekvirenter.aere_id vaufaa_aere_fk R
holdi_id int8 19 √ null
holdidenter.holdi_id vaufaa_holdi_fk R
skfa_id int8 19 √ null
skolefag.skfa_id vaufaa_skfa_fk R
udda_id int8 19 √ null
uddannelser.udda_id vaufaa_udda_fk R
uvma_id int8 19 √ null
uvm_afdelinger.uvma_id vaufaa_uvma_fk R
tilskud numeric 10,2 √ null
indberetningsdato timestamp 22 √ null
indberettes varchar 1 √ null
ose_art varchar 10 √ null
ose_formal varchar 10 √ null
ose_ansvar varchar 10 √ null
ose_projekt varchar 10 √ null
opdmod varchar 4 √ null
opdinit varchar 30 √ null
opdtid timestamp 22 √ null

Indexes

Constraint Name Type Sort Column(s)
vaufaa_pk Primary key Asc vaufaa_id
vaufaa_aere_fk_i Performance Asc aere_id
vaufaa_elev_fk_i Performance Asc elev_id
vaufaa_holdi_fk_i Performance Asc holdi_id
vaufaa_pers_id_idx Performance Asc/Asc skhp_id + elev_id
vaufaa_skfa_fk_i Performance Asc skfa_id
vaufaa_skhp_fk_i Performance Asc skhp_id
vaufaa_tmk_fk_i Performance Asc tmk_id
vaufaa_udda_fk_i Performance Asc udda_id
vaufaa_uvma_fk_i Performance Asc uvma_id
vaufaa_vaufaa_uk_uk Must be unique Asc/Asc/Asc/Asc/Asc skhp_id + skfa_id + elev_id + indberetningsdato + tmk_id

Check Constraints

Constraint Name Constraint
varighedsuafh_tilskud_au_amu_check4 (('OPDINIT' IS NOT NULL))
varighedsuafh_tilskud_au_amu_check2 (('INDBERETNINGSDATO' IS NOT NULL))
varighedsuafh_tilskud_au_amu_check10 (('UVMA_ID' IS NOT NULL))
varighedsuafh_tilskud_au_amu_check11 (('VAUFAA_ID' IS NOT NULL))
varighedsuafh_tilskud_au_amu_check9 (('TMK_ID' IS NOT NULL))
varighedsuafh_tilskud_au_amu_check8 (('TILSKUD' IS NOT NULL))
varighedsuafh_tilskud_au_amu_check6 (('OPDTID' IS NOT NULL))
varighedsuafh_tilskud_au_amu_indberettes_check (((indberettes)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
varighedsuafh_tilskud_au_amu_check1 (('ELEV_ID' IS NOT NULL))
varighedsuafh_tilskud_au_amu_check7 (('SKFA_ID' IS NOT NULL))
varighedsuafh_tilskud_au_amu_check3 (('INDBERETTES' IS NOT NULL))
varighedsuafh_tilskud_au_amu_check (('AERE_ID' IS NOT NULL))
varighedsuafh_tilskud_au_amu_check5 (('OPDMOD' IS NOT NULL))

Relationships

Close relationships within degrees of separation