grundlagslinjer


Columns

Column Type Size Nulls Auto Default Children Parents Comments
grli_id int8 19 null
opkrevningslinier.grli_id opkl_grli_fk R
linjenr int2 5 √ null
rate int2 5 √ null
forfaldsdato timestamp 22 √ null
osek_id int8 19 √ null
eksamensresultater_ea.id Implied Constraint R
osek_streng varchar 35 √ null
osek_start int4 10 √ null
a_fakturalinje varchar 2000 √ null
o_fakturalinje varchar 30 √ null
oprindelse varchar 3 √ null
belob numeric 10,2 √ null
opkrevet_belob numeric 10,2 √ null
begr_id int8 19 √ null
betalingsgrundlag.begr_id grli_begr_fk R
opkl_id int8 19 √ null
gbty_id int8 19 √ null
gebyrtyper.gbty_id grli_gbty_fk R
opdmod varchar 4 √ null
opdinit varchar 30 √ null
opdtid timestamp 22 √ 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

Indexes

Constraint Name Type Sort Column(s)
grli_pk_1 Primary key Asc grli_id
grli_begr_fk_i Performance Asc begr_id
grli_gbty_fk_i Performance Asc gbty_id
grli_grli_uk_1_uk Must be unique Asc/Asc begr_id + linjenr
grli_opkl_fk_i Performance Asc opkl_id

Check Constraints

Constraint Name Constraint
grundlagslinjer_oprindelse_check (((oprindelse)::text = ANY ((ARRAY['BEV'::character varying, 'MAN'::character varying, 'MAT'::character varying, 'REK'::character varying])::text[])))
grundlagslinjer_check11 (('RATE' IS NOT NULL))
grundlagslinjer_check3 (('GBTY_ID' IS NOT NULL))
grundlagslinjer_check (('A_FAKTURALINJE' IS NOT NULL))
grundlagslinjer_check7 (('OPDINIT' IS NOT NULL))
grundlagslinjer_check4 (('GRLI_ID' IS NOT NULL))
grundlagslinjer_check6 (('OKONOMISYSTEM' IS NOT NULL))
grundlagslinjer_check8 (('OPDMOD' IS NOT NULL))
grundlagslinjer_check10 (('OPRINDELSE' IS NOT NULL))
grundlagslinjer_check2 (('BELOB' IS NOT NULL))
grundlagslinjer_check1 (('BEGR_ID' IS NOT NULL))
grundlagslinjer_check9 (('OPDTID' IS NOT NULL))
grundlagslinjer_check5 (('LINJENR' IS NOT NULL))
grundlagslinjer_okonomisystem_check (((okonomisystem)::text = ANY ((ARRAY['EØ'::character varying, 'NS'::character varying])::text[])))

Relationships

Close relationships within degrees of separation