acq.acq_purchase_order_history

↑ acq schema

Written by External Triggers: This table can receive writes triggered by operations on other tables:

audit_acq_purchase_order_update_trigger on acq.purchase_order → INSERT into this table

Columns

Column Type Nullable Default Notes

Column	Type	Nullable
audit_id PK	`bigint`	No
audit_time	`timestamp with time zone`	No
audit_action	`text`	No
id	`integer`	No
owner	`integer`	No
creator	`integer`	No
editor	`integer`	No
ordering_agency	`integer`	No
create_time	`timestamp with time zone`	No
edit_time	`timestamp with time zone`	No
provider	`integer`	No
state	`text`	No
order_date	`timestamp with time zone`	Yes
name	`text`	No
cancel_reason	`integer`	Yes
prepayment_required	`boolean`	No

audit_id PK

bigint

audit_time

timestamp with time zone

audit_action

text

integer

owner

integer

creator

integer

editor

integer

ordering_agency

integer

create_time

timestamp with time zone

edit_time

timestamp with time zone

provider

integer

state

text

order_date

timestamp with time zone

Yes

name

text

cancel_reason

integer

Yes

prepayment_required

boolean

Primary Key

(audit_id)

Indexes

Index Method Definition

Index	Method	Definition
`acq_purchase_order_history_pkey` PK	btree	`CREATE UNIQUE INDEX acq_purchase_order_history_pkey ON acq.acq_purchase_order_history USING btree (audit_id)`
`acq_po_hist_id_idx`	btree	`CREATE INDEX acq_po_hist_id_idx ON acq.acq_purchase_order_history USING btree (id)`

acq_purchase_order_history_pkey PK

btree

CREATE UNIQUE INDEX acq_purchase_order_history_pkey ON acq.acq_purchase_order_history USING btree (audit_id)

acq_po_hist_id_idx

btree

CREATE INDEX acq_po_hist_id_idx ON acq.acq_purchase_order_history USING btree (id)