Schema reporter

View: circ_type

Columns: 

field name : datatype -- parameters, contraints and notes
id : bigint --
type : text --

View: currently_running

Columns: 

field name : datatype -- parameters, contraints and notes
id : integer --
runner_barcode : text --
name : text --
run_time : timestamp with time zone --
scheduled_wait_time : interval --

View: demographic

Columns: 

field name : datatype -- parameters, contraints and notes
id : integer --
dob : timestamp with time zone --
general_division : text --

View: hold_request_record

Columns: 

field name : datatype -- parameters, contraints and notes
id : integer --
target : bigint --
hold_type : text --
bib_record : bigint --

Table: materialized_simple_record

Columns: 

field name : datatype -- parameters, contraints and notes
id : bigint -- PRIMARY KEY,
fingerprint : text --
quality : integer --
tcn_source : text --
tcn_value : text --
title : text --
author : text --
publisher : text --
pubdate : text --
isbn : text[] --
issn : text[] --

View: old_super_simple_record

Columns: 

field name : datatype -- parameters, contraints and notes
id : bigint --
fingerprint : text --
quality : integer --
tcn_source : text --
tcn_value : text --
title : text --
author : text --
publisher : text --
pubdate : text --
isbn : text[] --
issn : text[] --

Table: output_folder

Columns: 

field name : datatype -- parameters, contraints and notes
id : serial -- PRIMARY KEY,
parent : integer -- REFERENCES reporter.output_folder.
owner : integer -- NOT NULL, REFERENCES actor.usr.
create_time : timestamp with time zone -- NOT NULL, DEFAULT now(),
name : text -- NOT NULL,
shared : boolean -- NOT NULL, DEFAULT false,
share_with : integer -- REFERENCES actor.org_unit.

Indexes: 

rpt_output_fldr_owner_idx : owner

Tables referencing reporter.output_folder via Foreign Key Constraints: 

reporter.output_folderreporter.schedule

View: overdue_circs

Columns: 

field name : datatype -- parameters, contraints and notes
id : bigint --
usr : integer --
xact_start : timestamp with time zone --
xact_finish : timestamp with time zone --
unrecovered : boolean --
target_copy : bigint --
circ_lib : integer --
circ_staff : integer --
checkin_staff : integer --
checkin_lib : integer --
renewal_remaining : integer --
due_date : timestamp with time zone --
stop_fines_time : timestamp with time zone --
checkin_time : timestamp with time zone --
create_time : timestamp with time zone --
duration : interval --
fine_interval : interval --
recurring_fine : numeric(6,2) --
max_fine : numeric(6,2) --
phone_renewal : boolean --
desk_renewal : boolean --
opac_renewal : boolean --
duration_rule : text --
recurring_fine_rule : text --
max_fine_rule : text --
stop_fines : text --
workstation : integer --
checkin_workstation : integer --
checkin_scan_time : timestamp with time zone --
parent_circ : bigint --

View: overdue_reports

Columns: 

field name : datatype -- parameters, contraints and notes
id : integer --
runner_barcode : text --
name : text --
run_time : timestamp with time zone --
scheduled_wait_time : interval --

View: pending_reports

Columns: 

field name : datatype -- parameters, contraints and notes
id : integer --
runner_barcode : text --
name : text --
run_time : timestamp with time zone --
scheduled_wait_time : interval --

Table: report

Columns: 

field name : datatype -- parameters, contraints and notes
id : serial -- PRIMARY KEY,
owner : integer -- NOT NULL, REFERENCES actor.usr.
create_time : timestamp with time zone -- NOT NULL, DEFAULT now(),
name : text -- NOT NULL, DEFAULT ''::text,
description : text -- NOT NULL, DEFAULT ''::text,
template : integer -- NOT NULL, REFERENCES reporter.template.
data : text -- NOT NULL,
folder : integer -- NOT NULL, REFERENCES reporter.report_folder.
recur : boolean -- NOT NULL, DEFAULT false,
recurrence : interval --

Indexes: 

rpt_rpt_fldr_idx : folder
rpt_rpt_owner_idx : owner

Tables referencing reporter.schedule via Foreign Key Constraints: 

reporter.schedule 

Table: report_folder

Columns: 

field name : datatype -- parameters, contraints and notes
id : serial -- PRIMARY KEY,
parent : integer -- REFERENCES reporter.report_folder.
owner : integer -- NOT NULL, REFERENCES actor.usr.
create_time : timestamp with time zone -- NOT NULL, DEFAULT now(),
name : text -- NOT NULL,
shared : boolean -- NOT NULL, DEFAULT false,
share_with : integer -- REFERENCES actor.org_unit.

Indexes: 

rpt_rpt_fldr_owner_idx : owner

Tables referencing reporter.report via Foreign Key Constraints: 

reporter.reportreporter.report_folder

Table: schedule

Columns: 

field name : datatype -- parameters, contraints and notes
id : serial -- PRIMARY KEY,
report : integer -- NOT NULL, REFERENCES reporter.report.
folder : integer -- NOT NULL, REFERENCES reporter.output_folder.
runner : integer -- NOT NULL, REFERENCES actor.usr.
run_time : timestamp with time zone -- NOT NULL, DEFAULT now(),
start_time : timestamp with time zone --
complete_time : timestamp with time zone --
email : text --
excel_format : boolean -- NOT NULL, DEFAULT true,
html_format : boolean -- NOT NULL, DEFAULT true,
csv_format : boolean -- NOT NULL, DEFAULT true,
chart_pie : boolean -- NOT NULL, DEFAULT false,
chart_bar : boolean -- NOT NULL, DEFAULT false,
chart_line : boolean -- NOT NULL, DEFAULT false,
error_code : integer --
error_text : text --

Indexes: 

rpt_sched_folder_idx : folder
rpt_sched_runner_idx : runner

View: simple_record

Columns: 

field name : datatype -- parameters, contraints and notes
id : bigint --
metarecord : bigint --
fingerprint : text --
quality : integer --
tcn_source : text --
tcn_value : text --
title : text --
uniform_title : text --
author : text --
publisher : text --
pubdate : text --
series_title : text --
series_statement : text --
summary : text --
isbn : text[] --
issn : text[] --
topic_subject : text[] --
geographic_subject : text[] --
genre : text[] --
name_subject : text[] --
corporate_subject : text[] --
external_uri : text[] --

View: super_simple_record

Columns: 

field name : datatype -- parameters, contraints and notes
id : bigint --
fingerprint : text --
quality : integer --
tcn_source : text --
tcn_value : text --
title : text --
author : text --
publisher : text --
pubdate : text --
isbn : text[] --
issn : text[] --

Table: template

Columns: 

field name : datatype -- parameters, contraints and notes
id : serial -- PRIMARY KEY,
owner : integer -- NOT NULL, REFERENCES actor.usr.
create_time : timestamp with time zone -- NOT NULL, DEFAULT now(),
name : text -- NOT NULL,
description : text -- NOT NULL,
data : text -- NOT NULL,
folder : integer -- NOT NULL, REFERENCES reporter.template_folder.

Indexes: 

rpt_tmpl_fldr_idx : folder
rpt_tmpl_owner_idx : owner

Tables referencing reporter.report via Foreign Key Constraints: 

reporter.report 

Table: template_folder

Columns: 

field name : datatype -- parameters, contraints and notes
id : serial -- PRIMARY KEY,
parent : integer -- REFERENCES reporter.template_folder.
owner : integer -- NOT NULL, REFERENCES actor.usr.
create_time : timestamp with time zone -- NOT NULL, DEFAULT now(),
name : text -- NOT NULL,
shared : boolean -- NOT NULL, DEFAULT false,
share_with : integer -- REFERENCES actor.org_unit.

Indexes: 

rpt_tmpl_fldr_owner_idx : owner

Tables referencing reporter.template via Foreign Key Constraints: 

reporter.templatereporter.template_folder

View: xact_billing_totals

Columns: 

field name : datatype -- parameters, contraints and notes
xact : bigint --
unvoided : numeric --
voided : numeric --
total : numeric --

View: xact_paid_totals

Columns: 

field name : datatype -- parameters, contraints and notes
xact : bigint --
unvoided : numeric --
voided : numeric --
total : numeric --

disable_materialized_simple_record_trigger()

Function Properties
Language: SQL
Return Type: void

enable_materialized_simple_record_trigger()

Function Properties
Language: SQL
Return Type: void

refresh_materialized_simple_record()

Function Properties
Language: SQL
Return Type: void

simple_rec_delete(r_id bigint)

Function Properties
Language: SQL
Return Type: boolean

simple_rec_trigger()

Function Properties
Language: PLPGSQL
Return Type: trigger

simple_rec_update(deleted bigint, r_id boolean)

Function Properties
Language: PLPGSQL
Return Type: boolean

simple_rec_update(r_id bigint)

Function Properties
Language: SQL
Return Type: boolean