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

• rpt_output_fldr_owner_idx owner

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

• rpt_rpt_fldr_idx folder
• rpt_rpt_owner_idx owner

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

• rpt_rpt_fldr_owner_idx owner

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

• 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

• rpt_tmpl_fldr_idx folder
• rpt_tmpl_owner_idx owner

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

• rpt_tmpl_fldr_owner_idx owner

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