au_bidrag


Columns

Column Type Size Nulls Auto Default Children Parents Comments
aubi_id int8 19 null
autd_id int8 19 √ null
au_telledatoer.autd_id aubi_autd_fk R
skhp_id int8 19 √ null
skolefag_pa_holdplaceringer.skhp_id aubi_skhp_fk R
forventet_bidrag numeric 9,5 √ null
faktisk_bidrag numeric 9,5 √ null
alternativ_betaler varchar 1 √ null
tvunget_bidrag varchar 1 √ null
minus_bidrag varchar 1 √ null
opra_id int8 19 √ null
opdmod varchar 4 √ null
opdinit varchar 30 √ null
opdtid timestamp 22 √ null
uvma_id int8 19 √ null
uvm_afdelinger.uvma_id aubi_uvma_fk R

Indexes

Constraint Name Type Sort Column(s)
aubi_pk Primary key Asc aubi_id
aubi_aubi1_uk Must be unique Asc/Asc autd_id + skhp_id
aubi_autd_fk_i Performance Asc autd_id
aubi_skhp_fk_i Performance Asc skhp_id
aubi_skhp_id_idx Performance Asc skhp_id
aubi_uvfa_fk_i Performance Asc uvma_id

Check Constraints

Constraint Name Constraint
au_bidrag_check5 (('MINUS_BIDRAG' IS NOT NULL))
au_bidrag_check6 (('OPDINIT' IS NOT NULL))
au_bidrag_check1 (('AUBI_ID' IS NOT NULL))
au_bidrag_minus_bidrag_check (((minus_bidrag)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
au_bidrag_check9 (('SKHP_ID' IS NOT NULL))
au_bidrag_tvunget_bidrag_check (((tvunget_bidrag)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
au_bidrag_check (('ALTERNATIV_BETALER' IS NOT NULL))
au_bidrag_check2 (('AUTD_ID' IS NOT NULL))
au_bidrag_check10 (('TVUNGET_BIDRAG' IS NOT NULL))
au_bidrag_check3 (('FAKTISK_BIDRAG' IS NOT NULL))
au_bidrag_check7 (('OPDMOD' IS NOT NULL))
au_bidrag_check8 (('OPDTID' IS NOT NULL))
au_bidrag_alternativ_betaler_check (((alternativ_betaler)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
au_bidrag_check4 (('FORVENTET_BIDRAG' IS NOT NULL))

Relationships

Close relationships within degrees of separation