gebyrtyper


Columns

Column Type Size Nulls Auto Default Children Parents Comments
gbty_id int8 19 null
bookingopkrevninger.gbty_id boop_gbty_fk R
gebyrer_pr_rate.gbty_id gbra_gbty_fk R
grundlagslinjer.gbty_id grli_gbty_fk R
opkrevninger_pr_rate.gbty_id opra_gbty_fk R
gebyrtype varchar 6 √ null
central_gebyrtype varchar 32 √ null
kort_tekst varchar 21 √ null
fakturatekst varchar 50 √ null
debitortype varchar 1 √ null
belob numeric 10,2 √ null
ophorsdato timestamp 22 √ null
osek_id int8 19 √ null
eksamensresultater_ea.id Implied Constraint R
osek_startdato int8 19 √ null
osek_streng varchar 35 √ null
opdinit varchar 30 √ null
opdmod varchar 4 √ null
opdtid timestamp 22 √ null
konto_forslag varchar 21 √ null
okonomisystem varchar 2 √ null
grty_id int8 19 √ null
grundtyper.grty_id grty_id_fk R
rekvirentgebyr varchar 1 √ null

Indexes

Constraint Name Type Sort Column(s)
gbty_pk Primary key Asc gbty_id
gbty_gbty1_uk Must be unique Asc gebyrtype
grty_id_fk_i Performance Asc grty_id

Check Constraints

Constraint Name Constraint
gebyrtyper_okonomisystem_check (((okonomisystem)::text = ANY ((ARRAY['EØ'::character varying, 'NS'::character varying])::text[])))
gebyrtyper_check7 (('OPDTID' IS NOT NULL))
gebyrtyper_check8 (('REKVIRENTGEBYR' IS NOT NULL))
gebyrtyper_debitortype_check (((debitortype)::text = ANY ((ARRAY['L'::character varying, 'N'::character varying, 'P'::character varying, 'S'::character varying, 'Ø'::character varying, 'E'::character varying])::text[])))
gebyrtyper_check4 (('OKONOMISYSTEM' IS NOT NULL))
gebyrtyper_check6 (('OPDMOD' IS NOT NULL))
gebyrtyper_central_gebyrtype_check (((central_gebyrtype)::text = ANY ((ARRAY['Certifikatgebyr'::character varying, 'Individuelt gebyr'::character varying, 'Kursusgebyr'::character varying, 'Lokalt gebyr'::character varying, 'Låne gebyr'::character varying, 'Materialesalg'::character varying, 'Skolehjemsgebyr - berettiget'::character varying, 'Skolehjemsgebyr - ej berettiget'::character varying])::text[])))
gebyrtyper_check (('CENTRAL_GEBYRTYPE' IS NOT NULL))
gebyrtyper_check2 (('GEBYRTYPE' IS NOT NULL))
gebyrtyper_check3 (('KORT_TEKST' IS NOT NULL))
gebyrtyper_check1 (('GBTY_ID' IS NOT NULL))
gebyrtyper_rekvirentgebyr_check (((rekvirentgebyr)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
gebyrtyper_check5 (('OPDINIT' IS NOT NULL))

Relationships

Close relationships within degrees of separation