acq.distribution_formula

↑ acq schema

Deferrable Constraints: The following FK constraints are deferrable — they are checked at transaction end, not statement end: distribution_formula_owner_fkey.

Columns

Column Type Nullable Default Notes

id PK

integer

No

nextval('acq.distribution_formula_id_seq'::regclass)

owner FK

integer

No

→ actor.org_unit(id)

name

text

No

skip_count

integer

No

0

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

owner

actor.org_unit(id)

NO ACTION

NO ACTION

DEFERRED

distribution_formula_owner_fkey

Unique Constraints

  • acqdf_name_once_per_owner: (name, owner)

Indexes

Index Method Definition

distribution_formula_pkey PK

btree

CREATE UNIQUE INDEX distribution_formula_pkey ON acq.distribution_formula USING btree (id)

acqdf_name_once_per_owner UNIQUE

btree

CREATE UNIQUE INDEX acqdf_name_once_per_owner ON acq.distribution_formula USING btree (name, owner)

Referenced By

The following tables have foreign keys pointing to acq.distribution_formula (2 referencing table(s)):

Table Referencing Column(s) Referenced Column(s) Constraint

acq.distribution_formula_application

formula

id

distribution_formula_application_formula_fkey

acq.distribution_formula_entry

formula

id

distribution_formula_entry_formula_fkey
Previous
Next