Schema auditor

Table: acq_invoice_entry_history

Columns: 

field name : datatype -- parameters, contraints and notes
audit_id : bigint -- PRIMARY KEY,
audit_time : timestamp with time zone -- NOT NULL,
audit_action : text -- NOT NULL,
id : integer -- NOT NULL,
invoice : integer -- NOT NULL,
purchase_order : integer --
lineitem : integer --
inv_item_count : integer -- NOT NULL,
phys_item_count : integer --
note : text --
billed_per_item : boolean --
cost_billed : numeric(8,2) --
actual_cost : numeric(8,2) --
amount_paid : numeric(8,2) --

View: acq_invoice_entry_lifecycle

Columns: 

field name : datatype -- parameters, contraints and notes
?column? : bigint --
audit_time : timestamp with time zone --
audit_action : text --
id : integer --
invoice : integer --
purchase_order : integer --
lineitem : integer --
inv_item_count : integer --
phys_item_count : integer --
note : text --
billed_per_item : boolean --
cost_billed : numeric(8,2) --
actual_cost : numeric(8,2) --
amount_paid : numeric(8,2) --

Table: acq_invoice_history

Columns: 

field name : datatype -- parameters, contraints and notes
audit_id : bigint -- PRIMARY KEY,
audit_time : timestamp with time zone -- NOT NULL,
audit_action : text -- NOT NULL,
id : integer -- NOT NULL,
receiver : integer -- NOT NULL,
provider : integer -- NOT NULL,
shipper : integer -- NOT NULL,
recv_date : timestamp with time zone -- NOT NULL,
recv_method : text -- NOT NULL,
inv_type : text --
inv_ident : text -- NOT NULL,
payment_auth : text --
payment_method : text --
note : text --
complete : boolean -- NOT NULL,

Table: acq_invoice_item_history

Columns: 

field name : datatype -- parameters, contraints and notes
audit_id : bigint -- PRIMARY KEY,
audit_time : timestamp with time zone -- NOT NULL,
audit_action : text -- NOT NULL,
id : integer -- NOT NULL,
invoice : integer -- NOT NULL,
purchase_order : integer --
fund_debit : integer --
inv_item_type : text -- NOT NULL,
title : text --
author : text --
note : text --
cost_billed : numeric(8,2) --
actual_cost : numeric(8,2) --
fund : integer --
amount_paid : numeric(8,2) --
po_item : integer --
target : bigint --

View: acq_invoice_item_lifecycle

Columns: 

field name : datatype -- parameters, contraints and notes
?column? : bigint --
audit_time : timestamp with time zone --
audit_action : text --
id : integer --
invoice : integer --
purchase_order : integer --
fund_debit : integer --
inv_item_type : text --
title : text --
author : text --
note : text --
cost_billed : numeric(8,2) --
actual_cost : numeric(8,2) --
fund : integer --
amount_paid : numeric(8,2) --
po_item : integer --
target : bigint --

View: acq_invoice_lifecycle

Columns: 

field name : datatype -- parameters, contraints and notes
?column? : bigint --
audit_time : timestamp with time zone --
audit_action : text --
id : integer --
receiver : integer --
provider : integer --
shipper : integer --
recv_date : timestamp with time zone --
recv_method : text --
inv_type : text --
inv_ident : text --
payment_auth : text --
payment_method : text --
note : text --
complete : boolean --

Table: actor_org_unit_history

Columns: 

field name : datatype -- parameters, contraints and notes
audit_id : bigint -- PRIMARY KEY,
audit_time : timestamp with time zone -- NOT NULL,
audit_action : text -- NOT NULL,
id : integer -- NOT NULL,
parent_ou : integer --
ou_type : integer -- NOT NULL,
ill_address : integer --
holds_address : integer --
mailing_address : integer --
billing_address : integer --
shortname : text -- NOT NULL,
name : text -- NOT NULL,
email : text --
phone : text --
opac_visible : boolean -- NOT NULL,
fiscal_calendar : integer -- NOT NULL,

View: actor_org_unit_lifecycle

Columns: 

field name : datatype -- parameters, contraints and notes
?column? : bigint --
audit_time : timestamp with time zone --
audit_action : text --
id : integer --
parent_ou : integer --
ou_type : integer --
ill_address : integer --
holds_address : integer --
mailing_address : integer --
billing_address : integer --
shortname : text --
name : text --
email : text --
phone : text --
opac_visible : boolean --
fiscal_calendar : integer --

Table: actor_usr_address_history

Columns: 

field name : datatype -- parameters, contraints and notes
audit_id : bigint -- PRIMARY KEY,
audit_time : timestamp with time zone -- NOT NULL,
audit_action : text -- NOT NULL,
id : integer -- NOT NULL,
valid : boolean -- NOT NULL,
within_city_limits : boolean -- NOT NULL,
address_type : text -- NOT NULL,
usr : integer -- NOT NULL,
street1 : text -- NOT NULL,
street2 : text --
city : text -- NOT NULL,
county : text --
state : text -- NOT NULL,
country : text -- NOT NULL,
post_code : text -- NOT NULL,
pending : boolean -- NOT NULL,
replaces : integer --

Indexes: 

aud_actor_usr_address_hist_id_idx : id

View: actor_usr_address_lifecycle

Columns: 

field name : datatype -- parameters, contraints and notes
?column? : bigint --
audit_time : timestamp with time zone --
audit_action : text --
id : integer --
valid : boolean --
within_city_limits : boolean --
address_type : text --
usr : integer --
street1 : text --
street2 : text --
city : text --
county : text --
state : text --
country : text --
post_code : text --
pending : boolean --
replaces : integer --

Table: actor_usr_history

Columns: 

field name : datatype -- parameters, contraints and notes
audit_id : bigint -- PRIMARY KEY,
audit_time : timestamp with time zone -- NOT NULL,
audit_action : text -- NOT NULL,
id : integer -- NOT NULL,
card : integer --
profile : integer -- NOT NULL,
usrname : text -- NOT NULL,
email : text --
passwd : text -- NOT NULL,
standing : integer -- NOT NULL,
ident_type : integer -- NOT NULL,
ident_value : text --
ident_type2 : integer --
ident_value2 : text --
net_access_level : integer -- NOT NULL,
photo_url : text --
prefix : text --
first_given_name : text -- NOT NULL,
second_given_name : text --
family_name : text -- NOT NULL,
suffix : text --
alias : text --
day_phone : text --
evening_phone : text --
other_phone : text --
mailing_address : integer --
billing_address : integer --
home_ou : integer -- NOT NULL,
dob : timestamp with time zone --
active : boolean -- NOT NULL,
master_account : boolean -- NOT NULL,
super_user : boolean -- NOT NULL,
barred : boolean -- NOT NULL,
deleted : boolean -- NOT NULL,
juvenile : boolean -- NOT NULL,
usrgroup : integer -- NOT NULL,
claims_returned_count : integer -- NOT NULL,
credit_forward_balance : numeric(6,2) -- NOT NULL,
last_xact_id : text -- NOT NULL,
alert_message : text --
create_date : timestamp with time zone -- NOT NULL,
expire_date : timestamp with time zone -- NOT NULL,
claims_never_checked_out_count : integer -- NOT NULL,
last_update_time : timestamp with time zone --

Indexes: 

aud_actor_usr_hist_id_idx : id

View: actor_usr_lifecycle

Columns: 

field name : datatype -- parameters, contraints and notes
?column? : bigint --
audit_time : timestamp with time zone --
audit_action : text --
id : integer --
card : integer --
profile : integer --
usrname : text --
email : text --
passwd : text --
standing : integer --
ident_type : integer --
ident_value : text --
ident_type2 : integer --
ident_value2 : text --
net_access_level : integer --
photo_url : text --
prefix : text --
first_given_name : text --
second_given_name : text --
family_name : text --
suffix : text --
alias : text --
day_phone : text --
evening_phone : text --
other_phone : text --
mailing_address : integer --
billing_address : integer --
home_ou : integer --
dob : timestamp with time zone --
active : boolean --
master_account : boolean --
super_user : boolean --
barred : boolean --
deleted : boolean --
juvenile : boolean --
usrgroup : integer --
claims_returned_count : integer --
credit_forward_balance : numeric(6,2) --
last_xact_id : text --
alert_message : text --
create_date : timestamp with time zone --
expire_date : timestamp with time zone --
claims_never_checked_out_count : integer --
last_update_time : timestamp with time zone --

Table: asset_call_number_history

Columns: 

field name : datatype -- parameters, contraints and notes
audit_id : bigint -- PRIMARY KEY,
audit_time : timestamp with time zone -- NOT NULL,
audit_action : text -- NOT NULL,
id : bigint -- NOT NULL,
creator : bigint -- NOT NULL,
create_date : timestamp with time zone --
editor : bigint -- NOT NULL,
edit_date : timestamp with time zone --
record : bigint -- NOT NULL,
owning_lib : integer -- NOT NULL,
label : text -- NOT NULL,
deleted : boolean -- NOT NULL,
prefix : integer -- NOT NULL,
suffix : integer -- NOT NULL,
label_class : bigint -- NOT NULL,
label_sortkey : text --

Indexes: 

aud_asset_cn_hist_creator_idx : creator
aud_asset_cn_hist_editor_idx : editor

View: asset_call_number_lifecycle

Columns: 

field name : datatype -- parameters, contraints and notes
?column? : bigint --
audit_time : timestamp with time zone --
audit_action : text --
id : bigint --
creator : bigint --
create_date : timestamp with time zone --
editor : bigint --
edit_date : timestamp with time zone --
record : bigint --
owning_lib : integer --
label : text --
deleted : boolean --
prefix : integer --
suffix : integer --
label_class : bigint --
label_sortkey : text --

Table: asset_copy_history

Columns: 

field name : datatype -- parameters, contraints and notes
audit_id : bigint -- PRIMARY KEY,
audit_time : timestamp with time zone -- NOT NULL,
audit_action : text -- NOT NULL,
id : bigint -- NOT NULL,
circ_lib : integer -- NOT NULL,
creator : bigint -- NOT NULL,
call_number : bigint -- NOT NULL,
editor : bigint -- NOT NULL,
create_date : timestamp with time zone --
edit_date : timestamp with time zone --
copy_number : integer --
status : integer -- NOT NULL,
location : integer -- NOT NULL,
loan_duration : integer -- NOT NULL,
fine_level : integer -- NOT NULL,
age_protect : integer --
circulate : boolean -- NOT NULL,
deposit : boolean -- NOT NULL,
ref : boolean -- NOT NULL,
holdable : boolean -- NOT NULL,
deposit_amount : numeric(6,2) -- NOT NULL,
price : numeric(8,2) --
barcode : text -- NOT NULL,
circ_modifier : text --
circ_as_type : text --
dummy_title : text --
dummy_author : text --
alert_message : text --
opac_visible : boolean -- NOT NULL,
deleted : boolean -- NOT NULL,
floating : boolean -- NOT NULL,
dummy_isbn : text --
status_changed_time : timestamp with time zone --
active_date : timestamp with time zone --
mint_condition : boolean -- NOT NULL,
cost : numeric(8,2) --

Indexes: 

aud_asset_cp_hist_creator_idx : creator
aud_asset_cp_hist_editor_idx : editor

View: asset_copy_lifecycle

Columns: 

field name : datatype -- parameters, contraints and notes
?column? : bigint --
audit_time : timestamp with time zone --
audit_action : text --
id : bigint --
circ_lib : integer --
creator : bigint --
call_number : bigint --
editor : bigint --
create_date : timestamp with time zone --
edit_date : timestamp with time zone --
copy_number : integer --
status : integer --
location : integer --
loan_duration : integer --
fine_level : integer --
age_protect : integer --
circulate : boolean --
deposit : boolean --
ref : boolean --
holdable : boolean --
deposit_amount : numeric(6,2) --
price : numeric(8,2) --
barcode : text --
circ_modifier : text --
circ_as_type : text --
dummy_title : text --
dummy_author : text --
alert_message : text --
opac_visible : boolean --
deleted : boolean --
floating : boolean --
dummy_isbn : text --
status_changed_time : timestamp with time zone --
active_date : timestamp with time zone --
mint_condition : boolean --
cost : numeric(8,2) --

Table: biblio_record_entry_history

Columns: 

field name : datatype -- parameters, contraints and notes
audit_id : bigint -- PRIMARY KEY,
audit_time : timestamp with time zone -- NOT NULL,
audit_action : text -- NOT NULL,
id : bigint -- NOT NULL,
creator : integer -- NOT NULL,
editor : integer -- NOT NULL,
source : integer --
quality : integer --
create_date : timestamp with time zone -- NOT NULL,
edit_date : timestamp with time zone -- NOT NULL,
active : boolean -- NOT NULL,
deleted : boolean -- NOT NULL,
fingerprint : text --
tcn_source : text -- NOT NULL,
tcn_value : text -- NOT NULL,
marc : text -- NOT NULL,
last_xact_id : text -- NOT NULL,
owner : integer --
share_depth : integer --

Indexes: 

aud_bib_rec_entry_hist_creator_idx : creator
aud_bib_rec_entry_hist_editor_idx : editor

View: biblio_record_entry_lifecycle

Columns: 

field name : datatype -- parameters, contraints and notes
?column? : bigint --
audit_time : timestamp with time zone --
audit_action : text --
id : bigint --
creator : integer --
editor : integer --
source : integer --
quality : integer --
create_date : timestamp with time zone --
edit_date : timestamp with time zone --
active : boolean --
deleted : boolean --
fingerprint : text --
tcn_source : text --
tcn_value : text --
marc : text --
last_xact_id : text --
owner : integer --
share_depth : integer --

Table: serial_unit_history

Columns: 

field name : datatype -- parameters, contraints and notes
audit_id : bigint -- PRIMARY KEY,
audit_time : timestamp with time zone -- NOT NULL,
audit_action : text -- NOT NULL,
id : bigint -- NOT NULL,
circ_lib : integer -- NOT NULL,
creator : bigint -- NOT NULL,
call_number : bigint -- NOT NULL,
editor : bigint -- NOT NULL,
create_date : timestamp with time zone --
edit_date : timestamp with time zone --
copy_number : integer --
status : integer -- NOT NULL,
location : integer -- NOT NULL,
loan_duration : integer -- NOT NULL,
fine_level : integer -- NOT NULL,
age_protect : integer --
circulate : boolean -- NOT NULL,
deposit : boolean -- NOT NULL,
ref : boolean -- NOT NULL,
holdable : boolean -- NOT NULL,
deposit_amount : numeric(6,2) -- NOT NULL,
price : numeric(8,2) --
barcode : text -- NOT NULL,
circ_modifier : text --
circ_as_type : text --
dummy_title : text --
dummy_author : text --
alert_message : text --
opac_visible : boolean -- NOT NULL,
deleted : boolean -- NOT NULL,
floating : boolean -- NOT NULL,
dummy_isbn : text --
status_changed_time : timestamp with time zone --
active_date : timestamp with time zone --
mint_condition : boolean -- NOT NULL,
cost : numeric(8,2) --
sort_key : text --
detailed_contents : text -- NOT NULL,
summary_contents : text -- NOT NULL,

Indexes: 

aud_serial_unit_hist_creator_idx : creator
aud_serial_unit_hist_editor_idx : editor

View: serial_unit_lifecycle

Columns: 

field name : datatype -- parameters, contraints and notes
?column? : bigint --
audit_time : timestamp with time zone --
audit_action : text --
id : bigint --
circ_lib : integer --
creator : bigint --
call_number : bigint --
editor : bigint --
create_date : timestamp with time zone --
edit_date : timestamp with time zone --
copy_number : integer --
status : integer --
location : integer --
loan_duration : integer --
fine_level : integer --
age_protect : integer --
circulate : boolean --
deposit : boolean --
ref : boolean --
holdable : boolean --
deposit_amount : numeric(6,2) --
price : numeric(8,2) --
barcode : text --
circ_modifier : text --
circ_as_type : text --
dummy_title : text --
dummy_author : text --
alert_message : text --
opac_visible : boolean --
deleted : boolean --
floating : boolean --
dummy_isbn : text --
status_changed_time : timestamp with time zone --
active_date : timestamp with time zone --
mint_condition : boolean --
cost : numeric(8,2) --
sort_key : text --
detailed_contents : text --
summary_contents : text --

audit_acq_invoice_entry_func()

Function Properties
Language: PLPGSQL
Return Type: trigger

audit_acq_invoice_func()

Function Properties
Language: PLPGSQL
Return Type: trigger

audit_acq_invoice_item_func()

Function Properties
Language: PLPGSQL
Return Type: trigger

audit_actor_org_unit_func()

Function Properties
Language: PLPGSQL
Return Type: trigger

audit_actor_usr_address_func()

Function Properties
Language: PLPGSQL
Return Type: trigger

audit_actor_usr_func()

Function Properties
Language: PLPGSQL
Return Type: trigger

audit_asset_call_number_func()

Function Properties
Language: PLPGSQL
Return Type: trigger

audit_asset_copy_func()

Function Properties
Language: PLPGSQL
Return Type: trigger

audit_biblio_record_entry_func()

Function Properties
Language: PLPGSQL
Return Type: trigger

audit_serial_unit_func()

Function Properties
Language: PLPGSQL
Return Type: trigger

create_auditor(tbl text, sch text)

Function Properties
Language: PLPGSQL
Return Type: boolean

create_auditor_func(tbl text, sch text)

Function Properties
Language: PLPGSQL
Return Type: boolean

create_auditor_history(tbl text, sch text)

Function Properties
Language: PLPGSQL
Return Type: boolean

create_auditor_lifecycle(tbl text, sch text)

Function Properties
Language: PLPGSQL
Return Type: boolean

create_auditor_seq(tbl text, sch text)

Function Properties
Language: PLPGSQL
Return Type: boolean

create_auditor_update_trigger(tbl text, sch text)

Function Properties
Language: PLPGSQL
Return Type: boolean

Report any errors in this documentation using Launchpad.
Documentation for Evergreen version 2.2
Copyright © 2007-2012, Memebers of the Evergreen Project