auditor.actor_org_unit_history

Written by External Triggers: This table can receive writes triggered by operations on other tables:

  • audit_actor_org_unit_update_trigger on actor.org_unit → INSERT into this table

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

integer

No

parent_ou

integer

Yes

ou_type

integer

No

ill_address

integer

Yes

holds_address

integer

Yes

mailing_address

integer

Yes

billing_address

integer

Yes

shortname

text

No

name

text

No

email

text

Yes

phone

text

Yes

opac_visible

boolean

No

staff_catalog_visible

boolean

No

fiscal_calendar

integer

No

Primary Key

(audit_id)

Indexes

Index Method Definition

actor_org_unit_history_pkey PK

btree

CREATE UNIQUE INDEX actor_org_unit_history_pkey ON auditor.actor_org_unit_history USING btree (audit_id)