gebyrer_pr_rate


Columns

Column Type Size Nulls Auto Default Children Parents Comments
gbra_id int8 19 null
gbty_id int8 19 √ null
gebyrtyper.gbty_id gbra_gbty_fk R
belob numeric 10,2 √ null
rate int2 5 √ null
opdmod varchar 4 √ null
opdinit varchar 30 √ null
opdtid timestamp 22 √ null
ebog_id int8 19 √ null
ekstern_booking_opkrevningsgru.ebog_id gbra_ebog_fk R
fogr_id int8 19 √ null
forlobsgrupper.fogr_id gbra_fogr_fk R
osek_id int8 19 √ null
eksamensresultater_ea.id Implied Constraint R
osek_start int8 19 √ null
osek_streng varchar 35 √ null
autd_id int8 19 √ null
au_telledatoer.autd_id gbra_autd_fk R
debitortype varchar 1 √ null
forfaldsdato timestamp 22 √ null
akti_id int8 19 √ null
aktiviteter.akti_id gbra_akti_fk R
a_fakturalinje varchar 60 √ null
materiale_sekvens int8 19 √ null
okonomisystem varchar 2 √ null
skph_id int8 19 √ null
skolefag_pa_hold.skph_id gbra_skph_fk R
debi_id int8 19 √ null
debitorer.debi_id gbra_debi_fk R
finansaar varchar 6 √ null

Indexes

Constraint Name Type Sort Column(s)
gbra_pk Primary key Asc gbra_id
gbra_akti_fk_i Performance Asc akti_id
gbra_autd_fk_i Performance Asc autd_id
gbra_debi_fk_i Performance Asc debi_id
gbra_ebog_fk_i Performance Asc ebog_id
gbra_fogr_fk_i Performance Asc fogr_id
gbra_gbra1_uk Must be unique Asc/Asc/Asc/Asc/Asc/Asc/Asc gbty_id + rate + ebog_id + fogr_id + akti_id + materiale_sekvens + skph_id
gbra_gbty_fk_i Performance Asc gbty_id
gbra_skph_fk_i Performance Asc skph_id

Check Constraints

Constraint Name Constraint
gebyrer_pr_rate_check1 (('GBRA_ID' IS NOT NULL))
gebyrer_pr_rate_check5 (('OPDINIT' IS NOT NULL))
gebyrer_pr_rate_check6 (('OPDMOD' IS NOT NULL))
gebyrer_pr_rate_okonomisystem_check (((okonomisystem)::text = ANY ((ARRAY['EØ'::character varying, 'NS'::character varying])::text[])))
gebyrer_pr_rate_check3 (('MATERIALE_SEKVENS' IS NOT NULL))
gebyrer_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[])))
gebyrer_pr_rate_check2 (('GBTY_ID' IS NOT NULL))
gebyrer_pr_rate_check (('BELOB' IS NOT NULL))
gebyrer_pr_rate_check8 (('RATE' IS NOT NULL))
gebyrer_pr_rate_check4 (('OKONOMISYSTEM' IS NOT NULL))
gebyrer_pr_rate_check7 (('OPDTID' IS NOT NULL))

Relationships

Close relationships within degrees of separation