acq.acq_lineitem_detail_history

audit_id PK

bigint

No

audit_time

timestamp with time zone

No

audit_action

text

No

id

bigint

No

lineitem

integer

No

fund

integer

Yes

fund_debit

integer

Yes

eg_copy_id

bigint

Yes

barcode

text

Yes

cn_label

text

Yes

note

text

Yes

collection_code

text

Yes

circ_modifier

text

Yes

owning_lib

integer

Yes

location

integer

Yes

recv_time

timestamp with time zone

Yes

receiver

integer

Yes

cancel_reason

integer

Yes

acq_lineitem_detail_history_pkey PK

btree

CREATE UNIQUE INDEX acq_lineitem_detail_history_pkey ON acq.acq_lineitem_detail_history USING btree (audit_id)

acq_lineitem_detail_hist_fund_debit_idx

btree

CREATE INDEX acq_lineitem_detail_hist_fund_debit_idx ON acq.acq_lineitem_detail_history USING btree (fund_debit)

acq_lineitem_detail_hist_id_idx

btree

CREATE INDEX acq_lineitem_detail_hist_id_idx ON acq.acq_lineitem_detail_history USING btree (id)

acq_lineitem_detail_hist_lineitem_idx

btree

CREATE INDEX acq_lineitem_detail_hist_lineitem_idx ON acq.acq_lineitem_detail_history USING btree (lineitem)