acq.po_item

↑ acq schema

Deferrable Constraints: The following FK constraints are deferrable — they are checked at transaction end, not statement end: po_item_fund_debit_fkey, po_item_fund_fkey, po_item_inv_item_type_fkey, po_item_purchase_order_fkey.

Columns

Column Type Nullable Default Notes

id PK

integer

No

nextval('acq.po_item_id_seq'::regclass)

purchase_order FK

integer

Yes

→ acq.purchase_order(id)

fund_debit FK

integer

Yes

→ acq.fund_debit(id)

inv_item_type FK

text

No

→ acq.invoice_item_type(code)

title

text

Yes

author

text

Yes

note

text

Yes

estimated_cost

numeric(8,2)

Yes

fund FK

integer

Yes

→ acq.fund(id)

target

bigint

Yes

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

fund_debit

acq.fund_debit(id)

NO ACTION

NO ACTION

DEFERRED

po_item_fund_debit_fkey

fund

acq.fund(id)

NO ACTION

NO ACTION

DEFERRED

po_item_fund_fkey

inv_item_type

acq.invoice_item_type(code)

NO ACTION

NO ACTION

DEFERRED

po_item_inv_item_type_fkey

purchase_order

acq.purchase_order(id)

SET NULL

CASCADE

DEFERRED

po_item_purchase_order_fkey

Indexes

Index Method Definition

po_item_pkey PK

btree

CREATE UNIQUE INDEX po_item_pkey ON acq.po_item USING btree (id)

poi_fund_debit_idx

btree

CREATE INDEX poi_fund_debit_idx ON acq.po_item USING btree (fund_debit)

poi_po_idx

btree

CREATE INDEX poi_po_idx ON acq.po_item USING btree (purchase_order)

Referenced By

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

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

acq.invoice_item

po_item

id

invoice_item_po_item_fkey
Previous
Next