amu_bidrag


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ambi_id int8 19 null
startdato timestamp 22 √ null
slutdato timestamp 22 √ null
kursiststatus varchar 1 √ null
tilskud varchar 1 √ null
gennemfort varchar 1 √ null
betalingsstatus varchar 1 √ null
indberetningsdato timestamp 22 √ null
bidrag numeric 9,5 √ null
skhp_id int8 19 √ null
skolefag_pa_holdplaceringer.skhp_id ambi_skhp_fk R
skfa_id int8 19 √ null
skolefag.skfa_id ambi_skfa_fk R
amutp_id int8 19 √ null
amu_telleperioder.amutp_id ambi_amutp_fk R
hopl_id int8 19 √ null
holdplaceringer.hopl_id ambi_hopl_fk R
tmk_id int8 19 √ null
tilskudsmerkekombinationer.tmk_id ambi_tmk_fk R
aere_id int8 19 √ null
ae_rekvirenter.aere_id ambi_aere_fk R
holdi_id int8 19 √ null
holdidenter.holdi_id ambi_holdi_fk R
opdmod varchar 4 √ null
opdinit varchar 30 √ null
opdtid timestamp 22 √ null
uvma_id int8 19 √ null
uvm_afdelinger.uvma_id ambi_uvma_fk R
varighed_dage numeric 4,1 √ null
manuelt_opdateret varchar 1 √ null

Indexes

Constraint Name Type Sort Column(s)
ambi_pk Primary key Asc ambi_id
ambi_aere_fk_i Performance Asc aere_id
ambi_amub_uk Must be unique Asc/Asc/Asc/Asc/Asc hopl_id + skfa_id + skhp_id + startdato + amutp_id
ambi_amutp_fk_i Performance Asc amutp_id
ambi_holdi_fk_i Performance Asc holdi_id
ambi_hopl_fk_i Performance Asc hopl_id
ambi_hopl_id_idx Performance Asc hopl_id
ambi_skfa_fk_i Performance Asc skfa_id
ambi_skhp_fk_i Performance Asc skhp_id
ambi_skhp_id_idx Performance Asc skhp_id
ambi_tmk_fk_i Performance Asc tmk_id
ambi_uvma_fk_i Performance Asc uvma_id

Check Constraints

Constraint Name Constraint
amu_bidrag_check6 (('OPDINIT' IS NOT NULL))
amu_bidrag_check4 (('INDBERETNINGSDATO' IS NOT NULL))
amu_bidrag_check1 (('BIDRAG' IS NOT NULL))
amu_bidrag_check3 (('HOPL_ID' IS NOT NULL))
amu_bidrag_check8 (('OPDTID' IS NOT NULL))
amu_bidrag_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[])))
amu_bidrag_gennemfort_check (((gennemfort)::text = ANY ((ARRAY['1'::character varying, '2'::character varying, '3'::character varying])::text[])))
amu_bidrag_manuelt_opdateret_check (((manuelt_opdateret)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
amu_bidrag_check12 (('TILSKUD' IS NOT NULL))
amu_bidrag_check10 (('SLUTDATO' IS NOT NULL))
amu_bidrag_tilskud_check (((tilskud)::text = ANY ((ARRAY['-'::character varying, 'J'::character varying, 'N'::character varying])::text[])))
amu_bidrag_check (('AMBI_ID' IS NOT NULL))
amu_bidrag_check5 (('MANUELT_OPDATERET' IS NOT NULL))
amu_bidrag_check7 (('OPDMOD' IS NOT NULL))
amu_bidrag_kursiststatus_check (((kursiststatus)::text = ANY ((ARRAY['1'::character varying, '2'::character varying, '4'::character varying, '6'::character varying, '7'::character varying])::text[])))
amu_bidrag_check13 (('VARIGHED_DAGE' IS NOT NULL))
amu_bidrag_check2 (('GENNEMFORT' IS NOT NULL))
amu_bidrag_check11 (('STARTDATO' IS NOT NULL))
amu_bidrag_check9 (('SKFA_ID' IS NOT NULL))

Relationships

Close relationships within degrees of separation