acq.distribution_formula_entry

↑ acq schema

Cascading Deletes: Deleting rows from this table will cascade to: acq.distribution_formula.

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

Columns

Column Type Nullable Default Notes

id PK

integer

No

nextval('acq.distribution_formula_entry_id_seq'::regclass)

formula FK

integer

No

→ acq.distribution_formula(id)

position

integer

No

item_count

integer

No

owning_lib FK

integer

Yes

→ actor.org_unit(id)

location FK

integer

Yes

→ asset.copy_location(id)

fund FK

integer

Yes

→ acq.fund(id)

circ_modifier FK

text

Yes

→ config.circ_modifier(code)

collection_code

text

Yes

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

circ_modifier

config.circ_modifier(code)

NO ACTION

NO ACTION

No

distribution_formula_entry_circ_modifier_fkey

formula

acq.distribution_formula(id)

CASCADE

NO ACTION

DEFERRED

distribution_formula_entry_formula_fkey

fund

acq.fund(id)

NO ACTION

NO ACTION

No

distribution_formula_entry_fund_fkey

location

asset.copy_location(id)

NO ACTION

NO ACTION

No

distribution_formula_entry_location_fkey

owning_lib

actor.org_unit(id)

NO ACTION

NO ACTION

DEFERRED

distribution_formula_entry_owning_lib_fkey

Unique Constraints

  • acqdfe_lib_once_per_formula: (formula, position)

Check Constraints

  • acqdfe_must_be_somewhere: CHECK

Indexes

Index Method Definition

distribution_formula_entry_pkey PK

btree

CREATE UNIQUE INDEX distribution_formula_entry_pkey ON acq.distribution_formula_entry USING btree (id)

acqdfe_lib_once_per_formula UNIQUE

btree

CREATE UNIQUE INDEX acqdfe_lib_once_per_formula ON acq.distribution_formula_entry USING btree (formula, "position")
Previous
Next