auditor.biblio_record_entry_lifecycle (view)

↑ auditor schema

This is a database view, not a base table. It has no triggers, indexes, or FK constraints of its own. Querying this view may be more efficient than joining the underlying tables directly.

Columns

Column Type Nullable Notes

audit_id

bigint

Yes

audit_time

timestamp with time zone

Yes

audit_action

text

Yes

audit_user

integer

Yes

audit_ws

integer

Yes

id

bigint

Yes

creator

integer

Yes

editor

integer

Yes

source

integer

Yes

quality

integer

Yes

create_date

timestamp with time zone

Yes

edit_date

timestamp with time zone

Yes

active

boolean

Yes

deleted

boolean

Yes

fingerprint

text

Yes

tcn_source

text

Yes

tcn_value

text

Yes

marc

text

Yes

last_xact_id

text

Yes

vis_attr_vector

integer[]

Yes

owner

integer

Yes

share_depth

integer

Yes

merge_date

timestamp with time zone

Yes

merged_to

bigint

Yes

View Definition

 SELECT '-1'::integer AS audit_id,
    now() AS audit_time,
    '-'::text AS audit_action,
    '-1'::integer AS audit_user,
    '-1'::integer AS audit_ws,
    record_entry.id,
    record_entry.creator,
    record_entry.editor,
    record_entry.source,
    record_entry.quality,
    record_entry.create_date,
    record_entry.edit_date,
    record_entry.active,
    record_entry.deleted,
    record_entry.fingerprint,
    record_entry.tcn_source,
    record_entry.tcn_value,
    record_entry.marc,
    record_entry.last_xact_id,
    record_entry.vis_attr_vector,
    record_entry.owner,
    record_entry.share_depth,
    record_entry.merge_date,
    record_entry.merged_to
   FROM biblio.record_entry
UNION ALL
 SELECT biblio_record_entry_history.audit_id,
    biblio_record_entry_history.audit_time,
    biblio_record_entry_history.audit_action,
    biblio_record_entry_history.audit_user,
    biblio_record_entry_history.audit_ws,
    biblio_record_entry_history.id,
    biblio_record_entry_history.creator,
    biblio_record_entry_history.editor,
    biblio_record_entry_history.source,
    biblio_record_entry_history.quality,
    biblio_record_entry_history.create_date,
    biblio_record_entry_history.edit_date,
    biblio_record_entry_history.active,
    biblio_record_entry_history.deleted,
    biblio_record_entry_history.fingerprint,
    biblio_record_entry_history.tcn_source,
    biblio_record_entry_history.tcn_value,
    biblio_record_entry_history.marc,
    biblio_record_entry_history.last_xact_id,
    biblio_record_entry_history.vis_attr_vector,
    biblio_record_entry_history.owner,
    biblio_record_entry_history.share_depth,
    biblio_record_entry_history.merge_date,
    biblio_record_entry_history.merged_to
   FROM auditor.biblio_record_entry_history;
Previous
Next