opkrevninger_pr_rate


Columns

Column Type Size Nulls Auto Default Children Parents Comments
opra_id int8 19 null
opkrevningslinier.opra_id opkl_opra_fk R
belob numeric 10,2 √ null
opkrevet_belob numeric 10,2 √ null
rate int2 5 √ null
forfaldsdato timestamp 22 √ null
automatisk_arvning varchar 1 √ null
opdinit varchar 30 √ null
debitortype varchar 1 √ null
opdtid timestamp 22 √ null
opdmod varchar 4 √ null
debi_id int8 19 √ null
debitorer.debi_id opra_debi_fk R
elis_id int8 19 √ null
akpl_id int8 19 √ null
osek_id int8 19 √ null
eksamensresultater_ea.id Implied Constraint R
osek_start int8 19 √ null
osek_streng varchar 35 √ null
shje_id int8 19 √ null
gbty_id int8 19 √ null
gebyrtyper.gbty_id opra_gbty_fk R
opkl_id int8 19 √ null
a_fakturalinje varchar 60 √ null
materiale_sekvens int8 19 √ null
ean_nr varchar 13 √ null
kunde_person_ref varchar 35 √ null
kunde_ordrenr varchar 10 √ null
kunde_kontostreng varchar 35 √ null
okonomisystem varchar 2 √ null
skhp_id int8 19 √ null
finansaar varchar 6 √ null

Indexes

Constraint Name Type Sort Column(s)
opra_pk Primary key Asc opra_id
opra_akpl_fk_i Performance Asc akpl_id
opra_debi_fk_i Performance Asc debi_id
opra_elis_fk_i Performance Asc elis_id
opra_elis_id_idx Performance Asc elis_id
opra_forfaldsdato_idx Performance Asc forfaldsdato
opra_gbty_fk_i Performance Asc gbty_id
opra_opkl_fk_i Performance Asc opkl_id
opra_opra1_uk Must be unique Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc gbty_id + rate + elis_id + akpl_id + shje_id + forfaldsdato + materiale_sekvens + skhp_id
opra_opra_id_idx Performance Asc opra_id
opra_shje_fk_i Performance Asc shje_id
opra_skhp_id_idx Performance Asc skhp_id

Check Constraints

Constraint Name Constraint
opkrevninger_pr_rate_check7 (('OPDTID' IS NOT NULL))
opkrevninger_pr_rate_check (('AUTOMATISK_ARVNING' IS NOT NULL))
opkrevninger_pr_rate_check8 (('OPRA_ID' IS NOT NULL))
opkrevninger_pr_rate_debitortype_check (((debitortype)::text = ANY ((ARRAY['L'::character varying, 'N'::character varying, 'P'::character varying, 'S'::character varying, 'Ø'::character varying, 'E'::character varying])::text[])))
opkrevninger_pr_rate_check4 (('OKONOMISYSTEM' IS NOT NULL))
opkrevninger_pr_rate_check6 (('OPDMOD' IS NOT NULL))
opkrevninger_pr_rate_automatisk_arvning_check (((automatisk_arvning)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
opkrevninger_pr_rate_check5 (('OPDINIT' IS NOT NULL))
opkrevninger_pr_rate_check3 (('MATERIALE_SEKVENS' IS NOT NULL))
opkrevninger_pr_rate_check1 (('BELOB' IS NOT NULL))
opkrevninger_pr_rate_check9 (('RATE' IS NOT NULL))
opkrevninger_pr_rate_check2 (('GBTY_ID' IS NOT NULL))
opkrevninger_pr_rate_okonomisystem_check (((okonomisystem)::text = ANY ((ARRAY['EØ'::character varying, 'NS'::character varying])::text[])))

Relationships

Close relationships within degrees of separation