Chapter 20. Schema reporter


Home Prev		Next

Below are the tables, views and functions for reporter

Tables in reporter

circ_type

id bigint
type text

currently_running

id integer
runner_barcode text
name text
run_time timestamp with time zone
scheduled_wait_time interval

demographic

id integer
dob timestamp with time zone
general_division text

hold_request_record

id integer
target bigint
hold_type text
bib_record bigint

materialized_simple_record

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[]

old_super_simple_record

id bigint
fingerprint text
quality integer
tcn_source text
tcn_value text
title text
author text
publisher text
pubdate text
isbn text[]
issn text[]

output_folder

id serial PRIMARY KEY
parent integer REFERENCES reporter.table.output-folder
owner integer NOT NULL REFERENCES actor.table.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.table.org-unit

Indexes on output_folder

rpt_output_fldr_owner_idx owner

Tables referencing via foreign key constraints

reporter.table.output-folder
reporter.table.schedule

overdue_circs

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
grace_period interval
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
copy_location integer
checkin_scan_time timestamp with time zone
parent_circ bigint

overdue_reports

id integer
runner_barcode text
name text
run_time timestamp with time zone
scheduled_wait_time interval

pending_reports

id integer
runner_barcode text
name text
run_time timestamp with time zone
scheduled_wait_time interval

report

id serial PRIMARY KEY
owner integer NOT NULL REFERENCES actor.table.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.table.template
data text NOT NULL
folder integer NOT NULL REFERENCES reporter.table.report-folder
recur boolean NOT NULL DEFAULT false
recurrence interval

Indexes on report

rpt_rpt_fldr_idx folder
rpt_rpt_owner_idx owner

Tables referencing via foreign key constraints

reporter.table.schedule

report_folder

id serial PRIMARY KEY
parent integer REFERENCES reporter.table.report-folder
owner integer NOT NULL REFERENCES actor.table.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.table.org-unit

Indexes on report_folder

rpt_rpt_fldr_owner_idx owner

Tables referencing via foreign key constraints

reporter.table.report
reporter.table.report-folder

schedule

id serial PRIMARY KEY
report integer NOT NULL REFERENCES reporter.table.report
folder integer NOT NULL REFERENCES reporter.table.output-folder
runner integer NOT NULL REFERENCES actor.table.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 on schedule

rpt_sched_folder_idx folder
rpt_sched_runner_idx runner

simple_record

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[]

super_simple_record

id bigint
fingerprint text
quality integer
tcn_source text
tcn_value text
title text
author text
publisher text
pubdate text
isbn text[]
issn text[]

template

id serial PRIMARY KEY
owner integer NOT NULL REFERENCES actor.table.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.table.template-folder

Indexes on template

rpt_tmpl_fldr_idx folder
rpt_tmpl_owner_idx owner

Tables referencing via foreign key constraints

reporter.table.report

template_folder

id serial PRIMARY KEY
parent integer REFERENCES reporter.table.template-folder
owner integer NOT NULL REFERENCES actor.table.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.table.org-unit

Indexes on template_folder

rpt_tmpl_fldr_owner_idx owner

Tables referencing via foreign key constraints

reporter.table.template
reporter.table.template-folder

xact_billing_totals

xact bigint
unvoided numeric
voided numeric
total numeric

xact_paid_totals

xact bigint
unvoided numeric
voided numeric
total numeric