acq.distribution_formula_application

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

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

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`bigint`	No	nextval('acq.distribution_formula_application_id_seq'::regclass)
creator FK	`integer`	No		→ actor.usr(id)
create_time	`timestamp with time zone`	No	now()
formula FK	`integer`	No		→ acq.distribution_formula(id)
lineitem FK	`integer`	No		→ acq.lineitem(id)

id PK

bigint

nextval('acq.distribution_formula_application_id_seq'::regclass)

creator FK

integer

→ actor.usr(id)

create_time

timestamp with time zone

now()

formula FK

integer

→ acq.distribution_formula(id)

lineitem FK

integer

→ acq.lineitem(id)

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`creator`	actor.usr(id)	NO ACTION	NO ACTION	DEFERRED	`distribution_formula_application_creator_fkey`
`formula`	acq.distribution_formula(id)	NO ACTION	NO ACTION	DEFERRED	`distribution_formula_application_formula_fkey`
`lineitem`	acq.lineitem(id)	CASCADE	NO ACTION	DEFERRED	`distribution_formula_application_lineitem_fkey`

creator

actor.usr(id)

NO ACTION

DEFERRED

distribution_formula_application_creator_fkey

formula

acq.distribution_formula(id)

NO ACTION

DEFERRED

distribution_formula_application_formula_fkey

lineitem

acq.lineitem(id)

CASCADE

NO ACTION

DEFERRED

distribution_formula_application_lineitem_fkey

Indexes

Index Method Definition

Index	Method	Definition
`distribution_formula_application_pkey` PK	btree	`CREATE UNIQUE INDEX distribution_formula_application_pkey ON acq.distribution_formula_application USING btree (id)`
`acqdfa_creator_idx`	btree	`CREATE INDEX acqdfa_creator_idx ON acq.distribution_formula_application USING btree (creator)`
`acqdfa_df_idx`	btree	`CREATE INDEX acqdfa_df_idx ON acq.distribution_formula_application USING btree (formula)`
`acqdfa_li_idx`	btree	`CREATE INDEX acqdfa_li_idx ON acq.distribution_formula_application USING btree (lineitem)`

distribution_formula_application_pkey PK

btree

CREATE UNIQUE INDEX distribution_formula_application_pkey ON acq.distribution_formula_application USING btree (id)

acqdfa_creator_idx

btree

CREATE INDEX acqdfa_creator_idx ON acq.distribution_formula_application USING btree (creator)

acqdfa_df_idx

btree

CREATE INDEX acqdfa_df_idx ON acq.distribution_formula_application USING btree (formula)

acqdfa_li_idx

btree

CREATE INDEX acqdfa_li_idx ON acq.distribution_formula_application USING btree (lineitem)