 |  | |
| HomePrev | Chapter 26. Database Schema | Next |
|---|---|---|
Columns:
| field name : datatype -- parameters, contraints and notes |
| id : bigint -- |
| type : text -- |
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 -- |
Columns:
| field name : datatype -- parameters, contraints and notes |
| id : integer -- |
| dob : timestamp with time zone -- |
| general_division : text -- |
Columns:
| field name : datatype -- parameters, contraints and notes |
| id : integer -- |
| target : bigint -- |
| hold_type : text -- |
| bib_record : bigint -- |
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[] -- |
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[] -- |
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_folder | reporter.schedule |
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 -- |
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 -- |
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 -- |
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 |
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.report | reporter.report_folder |
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 |
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[] -- |
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[] -- |
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 |
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.template | reporter.template_folder |
Columns:
| field name : datatype -- parameters, contraints and notes |
| xact : bigint -- |
| unvoided : numeric -- |
| voided : numeric -- |
| total : numeric -- |
Columns:
| field name : datatype -- parameters, contraints and notes |
| xact : bigint -- |
| unvoided : numeric -- |
| voided : numeric -- |
| total : numeric -- |