auditor.asset_call_number_history

↑ auditor schema

Soft Deletes: This table uses a deleted boolean flag rather than physical row deletion. Ad-hoc queries must include WHERE deleted = false to exclude logically-deleted rows. The application layer enforces this automatically; direct SQL does not.

Columns

Column Type Nullable Default Notes

audit_id PK

bigint

No

audit_time

timestamp with time zone

No

audit_action

text

No

audit_user

integer

Yes

audit_ws

integer

Yes

id

bigint

No

creator

bigint

No

create_date

timestamp with time zone

Yes

editor

bigint

No

edit_date

timestamp with time zone

Yes

record

bigint

No

owning_lib

integer

No

label

text

No

deleted SOFT-DEL

boolean

No

prefix

integer

No

suffix

integer

No

label_class

bigint

No

label_sortkey

text

Yes

Primary Key

(audit_id)

Indexes

Index Method Definition

asset_call_number_history_pkey PK

btree

CREATE UNIQUE INDEX asset_call_number_history_pkey ON auditor.asset_call_number_history USING btree (audit_id)

aud_asset_cn_hist_creator_idx

btree

CREATE INDEX aud_asset_cn_hist_creator_idx ON auditor.asset_call_number_history USING btree (creator)

aud_asset_cn_hist_editor_idx

btree

CREATE INDEX aud_asset_cn_hist_editor_idx ON auditor.asset_call_number_history USING btree (editor)
Previous
Next