oai.authority (view)

↑ oai 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

Column	Type	Nullable
rec_id	`bigint`	Yes
datestamp	`timestamp without time zone`	Yes
deleted	`boolean`	Yes

rec_id

bigint

Yes

datestamp

timestamp without time zone

Yes

deleted

boolean

Yes

View Definition

 SELECT are.id AS rec_id,
    (are.edit_date AT TIME ZONE 'UTC'::text) AS datestamp,
    are.deleted
   FROM authority.record_entry are
  ORDER BY are.id;