debitorer


Columns

Column Type Size Nulls Auto Default Children Parents Comments
debi_id int8 19 null
betalingsgrundlag.debi_id begr_debi_fk R
bookingopkrevninger.debi_id boop_debi_fk R
gebyrer_pr_rate.debi_id gbra_debi_fk R
medarbejdere.debi_id meda_debi_fk R
opkrevninger.debi_id opkr_debi_fk R
opkrevninger_pr_rate.debi_id opra_debi_fk R
debitornr varchar 18 √ null
debitortype varchar 1 √ null
debitorid int8 19 √ null
ose_debitor varchar 1 √ null
opdinit varchar 30 √ null
opdtid timestamp 22 √ null
opdmod varchar 4 √ null
pers_id int8 19 √ null
personer.pers_id debi_pers_fk R
skol_id int8 19 √ null
skoler.skol_id debi_skol_fk R
odeb_id int8 19 √ null
eksamensresultater_ea.id Implied Constraint R
lrst_id int8 19 √ null
leresteder.lrst_id debi_lrst_fk R
debitorgruppe varchar 4 √ null
ns_debitornr varchar 20 √ null
okonomisystem varchar 2 √ null
okotrans_id int8 19 √ null
eksamensresultater_ea.id Implied Constraint R
blokeret varchar 1 √ null
ls_ean_id int8 19 √ null
leresteder_ean.ls_ean_id ls_ean_fk R

Indexes

Constraint Name Type Sort Column(s)
debi_pk Primary key Asc debi_id
debi_debi1_uk Must be unique Asc/Asc debitornr + debitortype
debi_debi2_uk_i Performance Asc ns_debitornr
debi_debitornr_i Performance Asc debitornr
debi_lrst_fk_i Performance Asc lrst_id
debi_odeb_fk_i Performance Asc odeb_id
debi_pers_fk_i Performance Asc pers_id
debi_pers_id_idx Performance Asc pers_id
debi_skol_fk_i Performance Asc skol_id
debi_uk Must be unique Asc/Asc/Asc/Asc ls_ean_id + debitortype + lrst_id + debitornr
ls_ean_fk_i Performance Asc ls_ean_id

Check Constraints

Constraint Name Constraint
debitorer_check5 (('OPDINIT' IS NOT NULL))
debitorer_ose_debitor_check (((ose_debitor)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
debitorer_debitortype_check (((debitortype)::text = ANY ((ARRAY['L'::character varying, 'N'::character varying, 'P'::character varying, 'S'::character varying, 'Ø'::character varying, 'E'::character varying])::text[])))
debitorer_check3 (('DEBI_ID' IS NOT NULL))
debitorer_check7 (('OPDTID' IS NOT NULL))
debitorer_check1 (('DEBITORNR' IS NOT NULL))
debitorer_okonomisystem_check (((okonomisystem)::text = ANY ((ARRAY['EØ'::character varying, 'NS'::character varying])::text[])))
debitorer_check4 (('OKONOMISYSTEM' IS NOT NULL))
debitorer_check2 (('DEBITORTYPE' IS NOT NULL))
debitorer_check (('BLOKERET' IS NOT NULL))
debitorer_check6 (('OPDMOD' IS NOT NULL))
debitorer_blokeret_check (((blokeret)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
debitorer_check8 (('OSE_DEBITOR' IS NOT NULL))

Relationships

Close relationships within degrees of separation