acq.acq_purchase_order_history

Columns

Column Type Nullable Default Notes

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

Primary Key

(audit_id)

Indexes

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)