kursistlektionsbidrag


Columns

Column Type Size Nulls Auto Default Children Parents Comments
kubi_id int8 19 null
kupl_id int8 19 √ null
kursusplaceringer.kupl_id kubi_kupl_fk R
kkt_id int8 19 √ null
kursustyper_pa_kurser.kkt_id kubi_kkt_fk R
indberetningsdato timestamp 22 √ null
tilskud varchar 1 √ null
amm_id int8 19 √ null
amu_moduler.amm_id kubi_amm_fk R
amutp_id int8 19 √ null
amu_telleperioder.amutp_id kubi_amutp_fk R
beregnet_bidragsstorrelse numeric 6,2 √ null
bidragsstorrelse numeric 6,2 √ null
opdmod varchar 4 √ null
opdinit varchar 30 √ null
opdtid timestamp 22 √ null
godtgorelse varchar 1 √ null
amre_id int8 19 √ null
amu_rekvirenter.amre_id kubi_amre_fk R
antal_arselever numeric 9,5 √ null
aere_id int8 19 √ null
ae_rekvirenter.aere_id kubi_aere_fk R
amho_id int8 19 √ null
amu_holdidenter.amho_id kubi_amho_fk R
uvma_id int8 19 √ null
uvm_afdelinger.uvma_id kubi_uvma_fk R

Indexes

Constraint Name Type Sort Column(s)
kubi_pk Primary key Asc kubi_id
kubi_aere_fk_i Performance Asc aere_id
kubi_amho_fk_i Performance Asc amho_id
kubi_amm_fk_i Performance Asc amm_id
kubi_amre_fk_i Performance Asc amre_id
kubi_amutp_fk_i Performance Asc amutp_id
kubi_indberetningsdato_i Performance Asc indberetningsdato
kubi_kkt_fk_i Performance Asc kkt_id
kubi_kubi1_uk Must be unique Asc/Asc/Asc/Asc/Asc/Asc kupl_id + kkt_id + amm_id + amutp_id + amre_id + godtgorelse
kubi_kupl_fk_i Performance Asc kupl_id
kubi_uvma_fk_i Performance Asc uvma_id

Check Constraints

Constraint Name Constraint
kursistlektionsbidrag_check (('AERE_ID' IS NOT NULL))
kursistlektionsbidrag_check5 (('KUPL_ID' IS NOT NULL))
kursistlektionsbidrag_tilskud_check (((tilskud)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
kursistlektionsbidrag_check2 (('INDBERETNINGSDATO' IS NOT NULL))
kursistlektionsbidrag_check4 (('KUBI_ID' IS NOT NULL))
kursistlektionsbidrag_check7 (('OPDMOD' IS NOT NULL))
kursistlektionsbidrag_check6 (('OPDINIT' IS NOT NULL))
kursistlektionsbidrag_check9 (('TILSKUD' IS NOT NULL))
kursistlektionsbidrag_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[])))
kursistlektionsbidrag_check1 (('AMRE_ID' IS NOT NULL))
kursistlektionsbidrag_check8 (('OPDTID' IS NOT NULL))
kursistlektionsbidrag_check3 (('KKT_ID' IS NOT NULL))

Relationships

Close relationships within degrees of separation