Database Schema
This is the schema for the Evergreen database.
Schema acq
currency_type
Field
Data Type
Constraints and References
code
text
PRIMARY KEY
label
text
Tables referencing acq.exchange_rate via Foreign Key Constraints
distribution_formula
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
owner
integer
UNIQUE#1
;
NOT NULL;
name
text
UNIQUE#1
;
NOT NULL;
skip_count
integer
NOT NULL;
Tables referencing acq.distribution_formula_entry via Foreign Key Constraints
distribution_formula_entry
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
formula
integer
UNIQUE#1
;
NOT NULL;
position
integer
UNIQUE#1
;
NOT NULL;
item_count
integer
NOT NULL;
owning_lib
integer
location
integer
Constraints on distribution_formula_entry
acqdfe_must_be_somewhere
CHECK (((owning_lib IS NOT NULL) OR (location IS NOT NULL)))
exchange_rate
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
from_currency
text
UNIQUE#1
;
NOT NULL;
to_currency
text
UNIQUE#1
;
NOT NULL;
ratio
numeric
NOT NULL;
fiscal_calendar
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
name
text
NOT NULL;
Tables referencing acq.fiscal_year via Foreign Key Constraints
fiscal_year
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
calendar
integer
UNIQUE#1
;
UNIQUE#2
;
NOT NULL;
year
integer
UNIQUE#1
;
NOT NULL;
year_begin
timestamp with time zone
UNIQUE#2
;
NOT NULL;
year_end
timestamp with time zone
NOT NULL;
fund
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
org
integer
UNIQUE#2
;
UNIQUE#1
;
NOT NULL;
name
text
UNIQUE#1
;
NOT NULL;
year
integer
UNIQUE#2
;
UNIQUE#1
;
NOT NULL;
DEFAULT date_part('year'::text, now());
currency_type
text
NOT NULL;
code
text
UNIQUE#2
;
Tables referencing acq.fund_allocation via Foreign Key Constraints
fund_allocation
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
funding_source
integer
NOT NULL;
fund
integer
NOT NULL;
amount
numeric
percent
numeric
allocator
integer
NOT NULL;
note
text
create_time
timestamp with time zone
NOT NULL;
DEFAULT now();
Constraints on fund_allocation
allocation_amount_or_percent
CHECK ((((percent IS NULL) AND (amount IS NOT NULL)) OR ((percent IS NOT NULL) AND (amount IS NULL))))
fund_allocation_percent_check
CHECK (((percent IS NULL) OR ((percent >= 0.0) AND (percent <= 100.0))))
fund_allocation_total
Field
Data Type
Constraints and References
fund
integer
amount
numeric(100,2)
fund_combined_balance
Field
Data Type
Constraints and References
fund
integer
amount
numeric
fund_debit
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
fund
integer
NOT NULL;
origin_amount
numeric
NOT NULL;
origin_currency_type
text
NOT NULL;
amount
numeric
NOT NULL;
encumbrance
boolean
NOT NULL;
DEFAULT true;
debit_type
text
NOT NULL;
xfer_destination
integer
create_time
timestamp with time zone
NOT NULL;
DEFAULT now();
Tables referencing acq.lineitem_detail via Foreign Key Constraints
fund_debit_total
Field
Data Type
Constraints and References
fund
integer
encumbrance
boolean
amount
numeric
fund_encumbrance_total
Field
Data Type
Constraints and References
fund
integer
amount
numeric
fund_spent_balance
Field
Data Type
Constraints and References
fund
integer
amount
numeric
fund_spent_total
Field
Data Type
Constraints and References
fund
integer
amount
numeric
fund_tag
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
owner
integer
UNIQUE#1
;
NOT NULL;
name
text
UNIQUE#1
;
NOT NULL;
Tables referencing acq.fund_tag_map via Foreign Key Constraints
fund_tag_map
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
fund
integer
UNIQUE#1
;
NOT NULL;
tag
integer
UNIQUE#1
;
funding_source
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
name
text
UNIQUE#1
;
NOT NULL;
owner
integer
UNIQUE#1
;
NOT NULL;
currency_type
text
NOT NULL;
code
text
UNIQUE;
Tables referencing acq.fund_allocation via Foreign Key Constraints
funding_source_allocation_total
Field
Data Type
Constraints and References
funding_source
integer
amount
numeric(100,2)
funding_source_balance
Field
Data Type
Constraints and References
funding_source
integer
amount
numeric(100,2)
funding_source_credit
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
funding_source
integer
NOT NULL;
amount
numeric
NOT NULL;
note
text
funding_source_credit_total
Field
Data Type
Constraints and References
funding_source
integer
amount
numeric
lineitem
Field
Data Type
Constraints and References
id
bigserial
PRIMARY KEY
creator
integer
NOT NULL;
editor
integer
NOT NULL;
selector
integer
NOT NULL;
provider
integer
purchase_order
integer
picklist
integer
expected_recv_time
timestamp with time zone
create_time
timestamp with time zone
NOT NULL;
DEFAULT now();
edit_time
timestamp with time zone
NOT NULL;
DEFAULT now();
marc
text
NOT NULL;
eg_bib_id
integer
source_label
text
item_count
integer
NOT NULL;
state
text
NOT NULL;
DEFAULT 'new'::text;
Constraints on lineitem
picklist_or_po
CHECK (((picklist IS NOT NULL) OR (purchase_order IS NOT NULL)))
Tables referencing acq.lineitem_attr via Foreign Key Constraints
lineitem_attr
Field
Data Type
Constraints and References
id
bigserial
PRIMARY KEY
definition
bigint
NOT NULL;
lineitem
bigint
NOT NULL;
attr_type
text
NOT NULL;
attr_name
text
NOT NULL;
attr_value
text
NOT NULL;
lineitem_attr_definition
Field
Data Type
Constraints and References
id
bigserial
PRIMARY KEY
code
text
NOT NULL;
description
text
NOT NULL;
remove
text
NOT NULL;
DEFAULT ''::text;
ident
boolean
NOT NULL;
DEFAULT false;
lineitem_detail
Field
Data Type
Constraints and References
id
bigserial
PRIMARY KEY
lineitem
integer
NOT NULL;
fund
integer
fund_debit
integer
eg_copy_id
bigint
barcode
text
cn_label
text
note
text
collection_code
text
circ_modifier
text
owning_lib
integer
location
integer
recv_time
timestamp with time zone
lineitem_generated_attr_definition
Field
Data Type
Constraints and References
id
bigint
PRIMARY KEY
DEFAULT nextval('acq.lineitem_attr_definition_id_seq'::regclass);
code
text
NOT NULL;
description
text
NOT NULL;
remove
text
NOT NULL;
DEFAULT ''::text;
ident
boolean
NOT NULL;
DEFAULT false;
xpath
text
NOT NULL;
lineitem_local_attr_definition
Field
Data Type
Constraints and References
id
bigint
PRIMARY KEY
DEFAULT nextval('acq.lineitem_attr_definition_id_seq'::regclass);
code
text
NOT NULL;
description
text
NOT NULL;
remove
text
NOT NULL;
DEFAULT ''::text;
ident
boolean
NOT NULL;
DEFAULT false;
lineitem_marc_attr_definition
Field
Data Type
Constraints and References
id
bigint
PRIMARY KEY
DEFAULT nextval('acq.lineitem_attr_definition_id_seq'::regclass);
code
text
NOT NULL;
description
text
NOT NULL;
remove
text
NOT NULL;
DEFAULT ''::text;
ident
boolean
NOT NULL;
DEFAULT false;
xpath
text
NOT NULL;
lineitem_note
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
lineitem
integer
NOT NULL;
creator
integer
NOT NULL;
editor
integer
NOT NULL;
create_time
timestamp with time zone
NOT NULL;
DEFAULT now();
edit_time
timestamp with time zone
NOT NULL;
DEFAULT now();
value
text
NOT NULL;
lineitem_provider_attr_definition
Field
Data Type
Constraints and References
id
bigint
PRIMARY KEY
DEFAULT nextval('acq.lineitem_attr_definition_id_seq'::regclass);
code
text
NOT NULL;
description
text
NOT NULL;
remove
text
NOT NULL;
DEFAULT ''::text;
ident
boolean
NOT NULL;
DEFAULT false;
xpath
text
NOT NULL;
provider
integer
NOT NULL;
lineitem_usr_attr_definition
Field
Data Type
Constraints and References
id
bigint
PRIMARY KEY
DEFAULT nextval('acq.lineitem_attr_definition_id_seq'::regclass);
code
text
NOT NULL;
description
text
NOT NULL;
remove
text
NOT NULL;
DEFAULT ''::text;
ident
boolean
NOT NULL;
DEFAULT false;
usr
integer
NOT NULL;
picklist
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
owner
integer
UNIQUE#1
;
NOT NULL;
creator
integer
NOT NULL;
editor
integer
NOT NULL;
org_unit
integer
NOT NULL;
name
text
UNIQUE#1
;
NOT NULL;
create_time
timestamp with time zone
NOT NULL;
DEFAULT now();
edit_time
timestamp with time zone
NOT NULL;
DEFAULT now();
Tables referencing acq.lineitem via Foreign Key Constraints
po_note
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
purchase_order
integer
NOT NULL;
creator
integer
NOT NULL;
editor
integer
NOT NULL;
create_time
timestamp with time zone
NOT NULL;
DEFAULT now();
edit_time
timestamp with time zone
NOT NULL;
DEFAULT now();
value
text
NOT NULL;
provider
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
name
text
UNIQUE#1
;
NOT NULL;
owner
integer
UNIQUE#2
;
UNIQUE#1
;
NOT NULL;
currency_type
text
NOT NULL;
code
text
UNIQUE#2
;
NOT NULL;
holding_tag
text
Tables referencing acq.lineitem via Foreign Key Constraints
provider_address
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
valid
boolean
NOT NULL;
DEFAULT true;
address_type
text
provider
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;
provider_contact
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
provider
integer
NOT NULL;
name
text
role
text
email
text
phone
text
Tables referencing acq.provider_contact_address via Foreign Key Constraints
provider_contact_address
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
valid
boolean
NOT NULL;
DEFAULT true;
address_type
text
contact
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;
provider_holding_subfield_map
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
provider
integer
UNIQUE#1
;
NOT NULL;
name
text
UNIQUE#1
;
NOT NULL;
subfield
text
NOT NULL;
purchase_order
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
owner
integer
NOT NULL;
creator
integer
NOT NULL;
editor
integer
NOT NULL;
ordering_agency
integer
NOT NULL;
create_time
timestamp with time zone
NOT NULL;
DEFAULT now();
edit_time
timestamp with time zone
NOT NULL;
DEFAULT now();
provider
integer
NOT NULL;
state
text
NOT NULL;
DEFAULT 'new'::text;
order_date
timestamp with time zone
name
text
NOT NULL;
Tables referencing acq.lineitem via Foreign Key Constraints
Schema action
aged_circulation
Field
Data Type
Constraints and References
usr_post_code
text
usr_home_ou
integer
NOT NULL;
usr_profile
integer
NOT NULL;
usr_birth_year
integer
copy_call_number
integer
NOT NULL;
copy_location
integer
NOT NULL;
copy_owning_lib
integer
NOT NULL;
copy_circ_lib
integer
NOT NULL;
copy_bib_record
bigint
NOT NULL;
id
bigint
PRIMARY KEY
xact_start
timestamp with time zone
NOT NULL;
xact_finish
timestamp with time zone
unrecovered
boolean
target_copy
bigint
NOT NULL;
circ_lib
integer
NOT NULL;
circ_staff
integer
NOT NULL;
checkin_staff
integer
checkin_lib
integer
renewal_remaining
integer
NOT NULL;
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
NOT NULL;
duration
interval
fine_interval
interval
NOT NULL;
recuring_fine
numeric(6,2)
max_fine
numeric(6,2)
phone_renewal
boolean
NOT NULL;
desk_renewal
boolean
NOT NULL;
opac_renewal
boolean
NOT NULL;
duration_rule
text
NOT NULL;
recuring_fine_rule
text
NOT NULL;
max_fine_rule
text
NOT NULL;
stop_fines
text
all_circulation
Field
Data Type
Constraints and References
id
bigint
usr_post_code
text
usr_home_ou
integer
usr_profile
integer
usr_birth_year
integer
copy_call_number
bigint
copy_location
integer
copy_owning_lib
integer
copy_circ_lib
integer
copy_bib_record
bigint
xact_start
timestamp with time zone
xact_finish
timestamp with time zone
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
recuring_fine
numeric(6,2)
max_fine
numeric(6,2)
phone_renewal
boolean
desk_renewal
boolean
opac_renewal
boolean
duration_rule
text
recuring_fine_rule
text
max_fine_rule
text
stop_fines
text
billable_circulations
Field
Data Type
Constraints and References
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
recuring_fine
numeric(6,2)
max_fine
numeric(6,2)
phone_renewal
boolean
desk_renewal
boolean
opac_renewal
boolean
duration_rule
text
recuring_fine_rule
text
max_fine_rule
text
stop_fines
text
circulation
Field
Data Type
Constraints and References
id
bigint
PRIMARY KEY
DEFAULT nextval('money.billable_xact_id_seq'::regclass);
usr
integer
NOT NULL;
xact_start
timestamp with time zone
NOT NULL;
DEFAULT now();
xact_finish
timestamp with time zone
unrecovered
boolean
target_copy
bigint
NOT NULL;
circ_lib
integer
NOT NULL;
circ_staff
integer
NOT NULL;
checkin_staff
integer
checkin_lib
integer
renewal_remaining
integer
NOT NULL;
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
NOT NULL;
DEFAULT now();
duration
interval
fine_interval
interval
NOT NULL;
DEFAULT '1 day'::interval;
recuring_fine
numeric(6,2)
max_fine
numeric(6,2)
phone_renewal
boolean
NOT NULL;
DEFAULT false;
desk_renewal
boolean
NOT NULL;
DEFAULT false;
opac_renewal
boolean
NOT NULL;
DEFAULT false;
duration_rule
text
NOT NULL;
recuring_fine_rule
text
NOT NULL;
max_fine_rule
text
NOT NULL;
stop_fines
text
Constraints on circulation
circulation_stop_fines_check
CHECK ((stop_fines = ANY (ARRAY['CHECKIN'::text, 'CLAIMSRETURNED'::text, 'LOST'::text, 'MAXFINES'::text, 'RENEW'::text, 'LONGOVERDUE'::text])))
hold_copy_map
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
hold
integer
UNIQUE#1
;
NOT NULL;
target_copy
bigint
UNIQUE#1
;
NOT NULL;
hold_notification
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
hold
integer
NOT NULL;
notify_staff
integer
notify_time
timestamp with time zone
NOT NULL;
DEFAULT now();
method
text
NOT NULL;
note
text
hold_request
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
request_time
timestamp with time zone
NOT NULL;
DEFAULT now();
capture_time
timestamp with time zone
fulfillment_time
timestamp with time zone
checkin_time
timestamp with time zone
return_time
timestamp with time zone
prev_check_time
timestamp with time zone
expire_time
timestamp with time zone
cancel_time
timestamp with time zone
cancel_cause
integer
cancel_note
text
target
bigint
NOT NULL;
current_copy
bigint
fulfillment_staff
integer
fulfillment_lib
integer
request_lib
integer
NOT NULL;
requestor
integer
NOT NULL;
usr
integer
NOT NULL;
selection_ou
integer
NOT NULL;
selection_depth
integer
NOT NULL;
pickup_lib
integer
NOT NULL;
hold_type
text
NOT NULL;
holdable_formats
text
phone_notify
text
email_notify
boolean
NOT NULL;
DEFAULT true;
frozen
boolean
NOT NULL;
DEFAULT false;
thaw_date
timestamp with time zone
shelf_time
timestamp with time zone
Constraints on hold_request
hold_request_hold_type_check
CHECK ((hold_type = ANY (ARRAY['M'::text, 'T'::text, 'V'::text, 'C'::text])))
Tables referencing action.hold_copy_map via Foreign Key Constraints
hold_request_cancel_cause
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
label
text
UNIQUE;
Tables referencing action.hold_request via Foreign Key Constraints
hold_transit_copy
Field
Data Type
Constraints and References
id
integer
PRIMARY KEY
DEFAULT nextval('action.transit_copy_id_seq'::regclass);
source_send_time
timestamp with time zone
dest_recv_time
timestamp with time zone
target_copy
bigint
NOT NULL;
source
integer
NOT NULL;
dest
integer
NOT NULL;
prev_hop
integer
copy_status
integer
NOT NULL;
persistant_transfer
boolean
NOT NULL;
DEFAULT false;
hold
integer
in_house_use
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
item
bigint
NOT NULL;
staff
integer
NOT NULL;
org_unit
integer
NOT NULL;
use_time
timestamp with time zone
NOT NULL;
DEFAULT now();
non_cat_in_house_use
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
item_type
bigint
NOT NULL;
staff
integer
NOT NULL;
org_unit
integer
NOT NULL;
use_time
timestamp with time zone
NOT NULL;
DEFAULT now();
non_cataloged_circulation
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
patron
integer
NOT NULL;
staff
integer
NOT NULL;
circ_lib
integer
NOT NULL;
item_type
integer
NOT NULL;
circ_time
timestamp with time zone
NOT NULL;
DEFAULT now();
open_circulation
Field
Data Type
Constraints and References
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
recuring_fine
numeric(6,2)
max_fine
numeric(6,2)
phone_renewal
boolean
desk_renewal
boolean
opac_renewal
boolean
duration_rule
text
recuring_fine_rule
text
max_fine_rule
text
stop_fines
text
reservation_transit_copy
Field
Data Type
Constraints and References
id
integer
PRIMARY KEY
DEFAULT nextval('action.transit_copy_id_seq'::regclass);
source_send_time
timestamp with time zone
dest_recv_time
timestamp with time zone
target_copy
bigint
NOT NULL;
source
integer
NOT NULL;
dest
integer
NOT NULL;
prev_hop
integer
copy_status
integer
NOT NULL;
persistant_transfer
boolean
NOT NULL;
DEFAULT false;
reservation
integer
survey
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
owner
integer
NOT NULL;
start_date
timestamp with time zone
NOT NULL;
DEFAULT now();
end_date
timestamp with time zone
NOT NULL;
DEFAULT (now() + '10 years'::interval);
usr_summary
boolean
NOT NULL;
DEFAULT false;
opac
boolean
NOT NULL;
DEFAULT false;
poll
boolean
NOT NULL;
DEFAULT false;
required
boolean
NOT NULL;
DEFAULT false;
name
text
NOT NULL;
description
text
NOT NULL;
Tables referencing action.survey_question via Foreign Key Constraints
survey_answer
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
question
integer
NOT NULL;
answer
text
NOT NULL;
Tables referencing action.survey_response via Foreign Key Constraints
survey_question
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
survey
integer
NOT NULL;
question
text
NOT NULL;
Tables referencing action.survey_answer via Foreign Key Constraints
survey_response
Field
Data Type
Constraints and References
id
bigserial
PRIMARY KEY
response_group_id
integer
usr
integer
survey
integer
NOT NULL;
question
integer
NOT NULL;
answer
integer
NOT NULL;
answer_date
timestamp with time zone
effective_date
timestamp with time zone
NOT NULL;
DEFAULT now();
transit_copy
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
source_send_time
timestamp with time zone
dest_recv_time
timestamp with time zone
target_copy
bigint
NOT NULL;
source
integer
NOT NULL;
dest
integer
NOT NULL;
prev_hop
integer
copy_status
integer
NOT NULL;
persistant_transfer
boolean
NOT NULL;
DEFAULT false;
Tables referencing action.transit_copy via Foreign Key Constraints
unfulfilled_hold_list
Field
Data Type
Constraints and References
id
bigserial
PRIMARY KEY
current_copy
bigint
NOT NULL;
hold
integer
NOT NULL;
circ_lib
integer
NOT NULL;
fail_time
timestamp with time zone
NOT NULL;
DEFAULT now();
Schema action_trigger
cleanup
Field
Data Type
Constraints and References
module
text
PRIMARY KEY
description
text
Tables referencing action_trigger.event_definition via Foreign Key Constraints
collector
Field
Data Type
Constraints and References
module
text
PRIMARY KEY
description
text
Tables referencing action_trigger.environment via Foreign Key Constraints
environment
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
event_def
integer
UNIQUE#1
;
NOT NULL;
path
text
collector
text
label
text
UNIQUE#1
;
Constraints on environment
environment_label_check
CHECK ((label <> ALL (ARRAY['result'::text, 'target'::text, 'event'::text])))
event
Field
Data Type
Constraints and References
id
bigserial
PRIMARY KEY
target
bigint
NOT NULL;
event_def
integer
add_time
timestamp with time zone
NOT NULL;
DEFAULT now();
run_time
timestamp with time zone
NOT NULL;
start_time
timestamp with time zone
update_time
timestamp with time zone
complete_time
timestamp with time zone
update_process
integer
state
text
NOT NULL;
DEFAULT 'pending'::text;
template_output
bigint
error_output
bigint
Constraints on event
event_state_check
CHECK ((state = ANY (ARRAY['pending'::text, 'invalid'::text, 'found'::text, 'collecting'::text, 'collected'::text, 'validating'::text, 'valid'::text, 'reacting'::text, 'reacted'::text, 'cleaning'::text, 'complete'::text, 'error'::text])))
event_definition
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
active
boolean
NOT NULL;
DEFAULT true;
owner
integer
UNIQUE#2
;
UNIQUE#1
;
NOT NULL;
name
text
UNIQUE#2
;
NOT NULL;
hook
text
UNIQUE#1
;
NOT NULL;
validator
text
UNIQUE#1
;
NOT NULL;
reactor
text
UNIQUE#1
;
NOT NULL;
cleanup_success
text
cleanup_failure
text
delay
interval
UNIQUE#1
;
NOT NULL;
DEFAULT '00:05:00'::interval;
max_delay
interval
delay_field
text
UNIQUE#1
;
group_field
text
template
text
Tables referencing action_trigger.environment via Foreign Key Constraints
event_output
Field
Data Type
Constraints and References
id
bigserial
PRIMARY KEY
create_time
timestamp with time zone
NOT NULL;
DEFAULT now();
is_error
boolean
NOT NULL;
DEFAULT false;
data
text
NOT NULL;
Tables referencing action_trigger.event via Foreign Key Constraints
event_params
Field
Data Type
Constraints and References
id
bigserial
PRIMARY KEY
event_def
integer
UNIQUE#1
;
NOT NULL;
param
text
UNIQUE#1
;
NOT NULL;
value
text
NOT NULL;
hook
Field
Data Type
Constraints and References
key
text
PRIMARY KEY
core_type
text
NOT NULL;
description
text
passive
boolean
NOT NULL;
DEFAULT false;
Tables referencing action_trigger.event_definition via Foreign Key Constraints
reactor
Field
Data Type
Constraints and References
module
text
PRIMARY KEY
description
text
Tables referencing action_trigger.event_definition via Foreign Key Constraints
validator
Field
Data Type
Constraints and References
module
text
PRIMARY KEY
description
text
Tables referencing action_trigger.event_definition via Foreign Key Constraints
Schema actor
card
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
usr
integer
NOT NULL;
barcode
text
UNIQUE;
NOT NULL;
active
boolean
NOT NULL;
DEFAULT true;
hours_of_operation
Field
Data Type
Constraints and References
id
integer
PRIMARY KEY
dow_0_open
time without time zone
NOT NULL;
DEFAULT '09:00:00'::time without time zone;
dow_0_close
time without time zone
NOT NULL;
DEFAULT '17:00:00'::time without time zone;
dow_1_open
time without time zone
NOT NULL;
DEFAULT '09:00:00'::time without time zone;
dow_1_close
time without time zone
NOT NULL;
DEFAULT '17:00:00'::time without time zone;
dow_2_open
time without time zone
NOT NULL;
DEFAULT '09:00:00'::time without time zone;
dow_2_close
time without time zone
NOT NULL;
DEFAULT '17:00:00'::time without time zone;
dow_3_open
time without time zone
NOT NULL;
DEFAULT '09:00:00'::time without time zone;
dow_3_close
time without time zone
NOT NULL;
DEFAULT '17:00:00'::time without time zone;
dow_4_open
time without time zone
NOT NULL;
DEFAULT '09:00:00'::time without time zone;
dow_4_close
time without time zone
NOT NULL;
DEFAULT '17:00:00'::time without time zone;
dow_5_open
time without time zone
NOT NULL;
DEFAULT '09:00:00'::time without time zone;
dow_5_close
time without time zone
NOT NULL;
DEFAULT '17:00:00'::time without time zone;
dow_6_open
time without time zone
NOT NULL;
DEFAULT '09:00:00'::time without time zone;
dow_6_close
time without time zone
NOT NULL;
DEFAULT '17:00:00'::time without time zone;
org_address
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
valid
boolean
NOT NULL;
DEFAULT true;
address_type
text
NOT NULL;
DEFAULT 'MAILING'::text;
org_unit
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;
Tables referencing actor.org_unit via Foreign Key Constraints
org_lasso
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
name
text
UNIQUE;
Tables referencing actor.org_lasso_map via Foreign Key Constraints
org_lasso_map
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
lasso
integer
NOT NULL;
org_unit
integer
NOT NULL;
org_unit
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
parent_ou
integer
ou_type
integer
NOT NULL;
ill_address
integer
holds_address
integer
mailing_address
integer
billing_address
integer
shortname
text
UNIQUE;
NOT NULL;
name
text
UNIQUE;
NOT NULL;
email
text
phone
text
opac_visible
boolean
NOT NULL;
DEFAULT true;
Tables referencing acq.distribution_formula via Foreign Key Constraints
org_unit_closed
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
org_unit
integer
NOT NULL;
close_start
timestamp with time zone
NOT NULL;
close_end
timestamp with time zone
NOT NULL;
reason
text
org_unit_proximity
Field
Data Type
Constraints and References
id
bigserial
PRIMARY KEY
from_org
integer
to_org
integer
prox
integer
org_unit_setting
Field
Data Type
Constraints and References
id
bigserial
PRIMARY KEY
org_unit
integer
UNIQUE#1
;
NOT NULL;
name
text
UNIQUE#1
;
NOT NULL;
value
text
NOT NULL;
org_unit_type
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
name
text
NOT NULL;
opac_label
text
NOT NULL;
depth
integer
NOT NULL;
parent
integer
can_have_vols
boolean
NOT NULL;
DEFAULT true;
can_have_users
boolean
NOT NULL;
DEFAULT true;
Tables referencing actor.org_unit via Foreign Key Constraints
stat_cat
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
owner
integer
UNIQUE#1
;
NOT NULL;
name
text
UNIQUE#1
;
NOT NULL;
opac_visible
boolean
NOT NULL;
DEFAULT false;
Tables referencing actor.stat_cat_entry via Foreign Key Constraints
stat_cat_entry
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
stat_cat
integer
UNIQUE#1
;
NOT NULL;
owner
integer
UNIQUE#1
;
NOT NULL;
value
text
UNIQUE#1
;
NOT NULL;
stat_cat_entry_usr_map
Field
Data Type
Constraints and References
id
bigserial
PRIMARY KEY
stat_cat_entry
text
NOT NULL;
stat_cat
integer
UNIQUE#1
;
NOT NULL;
target_usr
integer
UNIQUE#1
;
NOT NULL;
usr
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
card
integer
UNIQUE;
profile
integer
NOT NULL;
usrname
text
UNIQUE;
NOT NULL;
email
text
passwd
text
NOT NULL;
standing
integer
NOT NULL;
DEFAULT 1;
ident_type
integer
NOT NULL;
ident_value
text
ident_type2
integer
ident_value2
text
net_access_level
integer
NOT NULL;
DEFAULT 1;
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;
DEFAULT true;
master_account
boolean
NOT NULL;
DEFAULT false;
super_user
boolean
NOT NULL;
DEFAULT false;
barred
boolean
NOT NULL;
DEFAULT false;
deleted
boolean
NOT NULL;
DEFAULT false;
juvenile
boolean
NOT NULL;
DEFAULT false;
usrgroup
serial
NOT NULL;
claims_returned_count
integer
NOT NULL;
credit_forward_balance
numeric(6,2)
NOT NULL;
DEFAULT 0.00;
last_xact_id
text
NOT NULL;
DEFAULT 'none'::text;
alert_message
text
create_date
timestamp with time zone
NOT NULL;
DEFAULT now();
expire_date
timestamp with time zone
NOT NULL;
DEFAULT (now() + '3 years'::interval);
Tables referencing acq.fund_allocation via Foreign Key Constraints
usr_address
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
valid
boolean
NOT NULL;
DEFAULT true;
within_city_limits
boolean
NOT NULL;
DEFAULT true;
address_type
text
NOT NULL;
DEFAULT 'MAILING'::text;
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;
DEFAULT false;
replaces
integer
Tables referencing actor.usr via Foreign Key Constraints
usr_note
Field
Data Type
Constraints and References
id
bigserial
PRIMARY KEY
usr
bigint
NOT NULL;
creator
bigint
NOT NULL;
create_date
timestamp with time zone
DEFAULT now();
pub
boolean
NOT NULL;
DEFAULT false;
title
text
NOT NULL;
value
text
NOT NULL;
usr_org_unit_opt_in
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
org_unit
integer
UNIQUE#1
;
NOT NULL;
usr
integer
UNIQUE#1
;
NOT NULL;
staff
integer
NOT NULL;
opt_in_ts
timestamp with time zone
NOT NULL;
DEFAULT now();
opt_in_ws
integer
NOT NULL;
usr_password_reset
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
uuid
text
NOT NULL;
usr
bigint
NOT NULL;
request_time
timestamp with time zone
NOT NULL;
DEFAULT now();
has_been_reset
boolean
NOT NULL;
DEFAULT false;
usr_setting
Field
Data Type
Constraints and References
id
bigserial
PRIMARY KEY
usr
integer
UNIQUE#1
;
NOT NULL;
name
text
UNIQUE#1
;
NOT NULL;
value
text
NOT NULL;
usr_standing_penalty
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
org_unit
integer
NOT NULL;
usr
integer
NOT NULL;
standing_penalty
integer
NOT NULL;
staff
integer
set_date
timestamp with time zone
DEFAULT now();
stop_date
timestamp with time zone
note
text
workstation
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
name
text
UNIQUE;
NOT NULL;
owning_lib
integer
NOT NULL;
Tables referencing actor.usr_org_unit_opt_in via Foreign Key Constraints
Schema asset
call_number
Field
Data Type
Constraints and References
id
bigserial
PRIMARY KEY
creator
bigint
NOT NULL;
create_date
timestamp with time zone
DEFAULT now();
editor
bigint
NOT NULL;
edit_date
timestamp with time zone
DEFAULT now();
record
bigint
NOT NULL;
owning_lib
integer
NOT NULL;
label
text
NOT NULL;
deleted
boolean
NOT NULL;
DEFAULT false;
Tables referencing asset.call_number_note via Foreign Key Constraints
call_number_note
Field
Data Type
Constraints and References
id
bigserial
PRIMARY KEY
call_number
bigint
NOT NULL;
creator
bigint
NOT NULL;
create_date
timestamp with time zone
DEFAULT now();
pub
boolean
NOT NULL;
DEFAULT false;
title
text
NOT NULL;
value
text
NOT NULL;
copy
Field
Data Type
Constraints and References
id
bigserial
PRIMARY KEY
circ_lib
integer
NOT NULL;
creator
bigint
NOT NULL;
call_number
bigint
NOT NULL;
editor
bigint
NOT NULL;
create_date
timestamp with time zone
DEFAULT now();
edit_date
timestamp with time zone
DEFAULT now();
copy_number
integer
status
integer
NOT NULL;
location
integer
NOT NULL;
DEFAULT 1;
loan_duration
integer
NOT NULL;
fine_level
integer
NOT NULL;
age_protect
integer
circulate
boolean
NOT NULL;
DEFAULT true;
deposit
boolean
NOT NULL;
DEFAULT false;
ref
boolean
NOT NULL;
DEFAULT false;
holdable
boolean
NOT NULL;
DEFAULT true;
deposit_amount
numeric(6,2)
NOT NULL;
DEFAULT 0.00;
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;
DEFAULT true;
deleted
boolean
NOT NULL;
DEFAULT false;
Constraints on copy
copy_fine_level_check
CHECK ((fine_level = ANY (ARRAY[1, 2, 3])))
copy_loan_duration_check
CHECK ((loan_duration = ANY (ARRAY[1, 2, 3])))
Tables referencing acq.lineitem_detail via Foreign Key Constraints
copy_location
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
name
text
UNIQUE#1
;
NOT NULL;
owning_lib
integer
UNIQUE#1
;
NOT NULL;
holdable
boolean
NOT NULL;
DEFAULT true;
hold_verify
boolean
NOT NULL;
DEFAULT false;
opac_visible
boolean
NOT NULL;
DEFAULT true;
circulate
boolean
NOT NULL;
DEFAULT true;
Tables referencing acq.distribution_formula_entry via Foreign Key Constraints
copy_note
Field
Data Type
Constraints and References
id
bigserial
PRIMARY KEY
owning_copy
bigint
NOT NULL;
creator
bigint
NOT NULL;
create_date
timestamp with time zone
DEFAULT now();
pub
boolean
NOT NULL;
DEFAULT false;
title
text
NOT NULL;
value
text
NOT NULL;
copy_transparency
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
deposit_amount
numeric(6,2)
owner
integer
UNIQUE#1
;
NOT NULL;
circ_lib
integer
loan_duration
integer
fine_level
integer
holdable
boolean
circulate
boolean
deposit
boolean
ref
boolean
opac_visible
boolean
circ_modifier
text
circ_as_type
text
name
text
UNIQUE#1
;
NOT NULL;
Constraints on copy_transparency
copy_transparency_fine_level_check
CHECK ((fine_level = ANY (ARRAY[1, 2, 3])))
copy_transparency_loan_duration_check
CHECK ((loan_duration = ANY (ARRAY[1, 2, 3])))
Tables referencing asset.copy_transparency_map via Foreign Key Constraints
copy_transparency_map
Field
Data Type
Constraints and References
id
bigserial
PRIMARY KEY
transparency
integer
NOT NULL;
target_copy
integer
UNIQUE;
NOT NULL;
stat_cat
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
owner
integer
UNIQUE#1
;
NOT NULL;
opac_visible
boolean
NOT NULL;
DEFAULT false;
name
text
UNIQUE#1
;
NOT NULL;
Tables referencing asset.stat_cat_entry via Foreign Key Constraints
stat_cat_entry
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
stat_cat
integer
UNIQUE#1
;
NOT NULL;
owner
integer
UNIQUE#1
;
NOT NULL;
value
text
UNIQUE#1
;
NOT NULL;
Tables referencing asset.stat_cat_entry_copy_map via Foreign Key Constraints
stat_cat_entry_copy_map
Field
Data Type
Constraints and References
id
bigserial
PRIMARY KEY
stat_cat
integer
UNIQUE#1
;
NOT NULL;
stat_cat_entry
integer
NOT NULL;
owning_copy
bigint
UNIQUE#1
;
NOT NULL;
stat_cat_entry_transparency_map
Field
Data Type
Constraints and References
id
bigserial
PRIMARY KEY
stat_cat
integer
UNIQUE#1
;
NOT NULL;
stat_cat_entry
integer
NOT NULL;
owning_transparency
integer
UNIQUE#1
;
NOT NULL;
uri
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
href
text
NOT NULL;
label
text
use_restriction
text
active
boolean
NOT NULL;
DEFAULT true;
Tables referencing asset.uri_call_number_map via Foreign Key Constraints
uri_call_number_map
Field
Data Type
Constraints and References
id
bigserial
PRIMARY KEY
uri
integer
UNIQUE#1
;
NOT NULL;
call_number
integer
UNIQUE#1
;
NOT NULL;
Schema auditor
actor_org_unit_history
Field
Data Type
Constraints and References
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;
actor_org_unit_lifecycle
Field
Data Type
Constraints and References
?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
actor_usr_address_history
Field
Data Type
Constraints and References
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
actor_usr_address_lifecycle
Field
Data Type
Constraints and References
?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
actor_usr_history
Field
Data Type
Constraints and References
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;
actor_usr_lifecycle
Field
Data Type
Constraints and References
?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
asset_call_number_history
Field
Data Type
Constraints and References
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;
asset_call_number_lifecycle
Field
Data Type
Constraints and References
?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
asset_copy_history
Field
Data Type
Constraints and References
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;
asset_copy_lifecycle
Field
Data Type
Constraints and References
?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
biblio_record_entry_history
Field
Data Type
Constraints and References
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;
biblio_record_entry_lifecycle
Field
Data Type
Constraints and References
?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
Schema authority
full_rec
Field
Data Type
Constraints and References
id
bigserial
PRIMARY KEY
record
bigint
NOT NULL;
tag
character(3)
NOT NULL;
ind1
text
ind2
text
subfield
text
value
text
NOT NULL;
index_vector
tsvector
NOT NULL;
rec_descriptor
Field
Data Type
Constraints and References
id
bigserial
PRIMARY KEY
record
bigint
record_status
text
char_encoding
text
record_entry
Field
Data Type
Constraints and References
id
bigserial
PRIMARY KEY
arn_source
text
NOT NULL;
DEFAULT 'AUTOGEN'::text;
arn_value
text
NOT NULL;
creator
integer
NOT NULL;
DEFAULT 1;
editor
integer
NOT NULL;
DEFAULT 1;
create_date
timestamp with time zone
NOT NULL;
DEFAULT now();
edit_date
timestamp with time zone
NOT NULL;
DEFAULT now();
active
boolean
NOT NULL;
DEFAULT true;
deleted
boolean
NOT NULL;
DEFAULT false;
source
integer
marc
text
NOT NULL;
last_xact_id
text
NOT NULL;
Tables referencing authority.record_note via Foreign Key Constraints
record_note
Field
Data Type
Constraints and References
id
bigserial
PRIMARY KEY
record
bigint
NOT NULL;
value
text
NOT NULL;
creator
integer
NOT NULL;
DEFAULT 1;
editor
integer
NOT NULL;
DEFAULT 1;
create_date
timestamp with time zone
NOT NULL;
DEFAULT now();
edit_date
timestamp with time zone
NOT NULL;
DEFAULT now();
tracing_links
Field
Data Type
Constraints and References
record
bigint
main_id
bigint
main_tag
character(3)
main_value
text
relationship
text
use_restriction
text
deprecation
text
display_restriction
text
link_id
bigint
link_tag
character(3)
link_value
text
Schema biblio
record_entry
Field
Data Type
Constraints and References
id
bigserial
PRIMARY KEY
creator
integer
NOT NULL;
DEFAULT 1;
editor
integer
NOT NULL;
DEFAULT 1;
source
integer
quality
integer
create_date
timestamp with time zone
NOT NULL;
DEFAULT now();
edit_date
timestamp with time zone
NOT NULL;
DEFAULT now();
active
boolean
NOT NULL;
DEFAULT true;
deleted
boolean
NOT NULL;
DEFAULT false;
fingerprint
text
tcn_source
text
NOT NULL;
DEFAULT 'AUTOGEN'::text;
tcn_value
text
NOT NULL;
DEFAULT biblio.next_autogen_tcn_value();
marc
text
NOT NULL;
last_xact_id
text
NOT NULL;
Tables referencing acq.lineitem via Foreign Key Constraints
record_note
Field
Data Type
Constraints and References
id
bigserial
PRIMARY KEY
record
bigint
NOT NULL;
value
text
NOT NULL;
creator
integer
NOT NULL;
DEFAULT 1;
editor
integer
NOT NULL;
DEFAULT 1;
pub
boolean
NOT NULL;
DEFAULT false;
create_date
timestamp with time zone
NOT NULL;
DEFAULT now();
edit_date
timestamp with time zone
NOT NULL;
DEFAULT now();
Schema booking
reservation
Field
Data Type
Constraints and References
id
bigint
PRIMARY KEY
DEFAULT nextval('money.billable_xact_id_seq'::regclass);
usr
integer
NOT NULL;
xact_start
timestamp with time zone
NOT NULL;
DEFAULT now();
xact_finish
timestamp with time zone
unrecovered
boolean
request_time
timestamp with time zone
NOT NULL;
DEFAULT now();
start_time
timestamp with time zone
end_time
timestamp with time zone
capture_time
timestamp with time zone
cancel_time
timestamp with time zone
pickup_time
timestamp with time zone
return_time
timestamp with time zone
booking_interval
interval
fine_interval
interval
fine_amount
numeric(8,2)
max_fine
numeric(8,2)
target_resource_type
integer
NOT NULL;
target_resource
integer
current_resource
integer
request_lib
integer
NOT NULL;
pickup_lib
integer
capture_staff
integer
Tables referencing action.reservation_transit_copy via Foreign Key Constraints
reservation_attr_value_map
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
reservation
integer
UNIQUE#1
;
NOT NULL;
attr_value
integer
UNIQUE#1
;
NOT NULL;
resource
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
owner
integer
UNIQUE#1
;
NOT NULL;
type
integer
NOT NULL;
overbook
boolean
NOT NULL;
DEFAULT false;
barcode
text
UNIQUE#1
;
NOT NULL;
deposit
boolean
NOT NULL;
DEFAULT false;
deposit_amount
numeric(8,2)
NOT NULL;
DEFAULT 0.00;
user_fee
numeric(8,2)
NOT NULL;
DEFAULT 0.00;
Tables referencing action.reservation_transit_copy via Foreign Key Constraints
resource_attr
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
owner
integer
NOT NULL;
name
text
UNIQUE#1
;
NOT NULL;
resource_type
integer
UNIQUE#1
;
NOT NULL;
required
boolean
NOT NULL;
DEFAULT false;
Tables referencing booking.resource_attr_map via Foreign Key Constraints
resource_attr_map
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
resource
integer
UNIQUE#1
;
NOT NULL;
resource_attr
integer
UNIQUE#1
;
NOT NULL;
value
integer
NOT NULL;
resource_attr_value
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
owner
integer
UNIQUE#1
;
NOT NULL;
attr
integer
UNIQUE#1
;
NOT NULL;
valid_value
text
UNIQUE#1
;
NOT NULL;
Tables referencing booking.reservation_attr_value_map via Foreign Key Constraints
resource_type
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
name
text
UNIQUE#1
;
NOT NULL;
elbow_room
interval
fine_interval
interval
fine_amount
numeric(8,2)
NOT NULL;
max_fine
numeric(8,2)
owner
integer
UNIQUE#1
;
NOT NULL;
catalog_item
boolean
NOT NULL;
DEFAULT false;
transferable
boolean
NOT NULL;
DEFAULT false;
record
integer
UNIQUE#1
;
Tables referencing booking.reservation via Foreign Key Constraints
Schema config
audience_map
Field
Data Type
Constraints and References
code
text
PRIMARY KEY
value
text
NOT NULL;
description
text
bib_level_map
Field
Data Type
Constraints and References
code
text
PRIMARY KEY
value
text
NOT NULL;
bib_source
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
quality
integer
source
text
UNIQUE;
NOT NULL;
transcendant
boolean
NOT NULL;
DEFAULT false;
Constraints on bib_source
bib_source_quality_check
CHECK (((quality >= 0) AND (quality <= 100)))
Tables referencing vandelay.queued_bib_record via Foreign Key Constraints
billing_type
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
name
text
UNIQUE#1
;
NOT NULL;
owner
integer
UNIQUE#1
;
NOT NULL;
default_price
numeric(6,2)
Tables referencing money.billing via Foreign Key Constraints
circ_matrix_circ_mod_test
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
matchpoint
integer
NOT NULL;
items_out
integer
NOT NULL;
Tables referencing config.circ_matrix_circ_mod_test_map via Foreign Key Constraints
circ_matrix_circ_mod_test_map
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
circ_mod_test
integer
UNIQUE#1
;
NOT NULL;
circ_mod
text
UNIQUE#1
;
NOT NULL;
circ_matrix_matchpoint
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
active
boolean
NOT NULL;
DEFAULT true;
org_unit
integer
UNIQUE#1
;
NOT NULL;
grp
integer
UNIQUE#1
;
NOT NULL;
circ_modifier
text
UNIQUE#1
;
marc_type
text
UNIQUE#1
;
marc_form
text
UNIQUE#1
;
marc_vr_format
text
UNIQUE#1
;
ref_flag
boolean
UNIQUE#1
;
juvenile_flag
boolean
UNIQUE#1
;
is_renewal
boolean
UNIQUE#1
;
usr_age_lower_bound
interval
UNIQUE#1
;
usr_age_upper_bound
interval
UNIQUE#1
;
circulate
boolean
NOT NULL;
DEFAULT true;
duration_rule
integer
NOT NULL;
recurring_fine_rule
integer
NOT NULL;
max_fine_rule
integer
NOT NULL;
script_test
text
Tables referencing config.circ_matrix_circ_mod_test via Foreign Key Constraints
circ_modifier
Field
Data Type
Constraints and References
code
text
PRIMARY KEY
name
text
UNIQUE;
NOT NULL;
description
text
NOT NULL;
sip2_media_type
text
NOT NULL;
magnetic_media
boolean
NOT NULL;
DEFAULT true;
Tables referencing acq.lineitem_detail via Foreign Key Constraints
copy_status
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
name
text
UNIQUE;
NOT NULL;
holdable
boolean
NOT NULL;
DEFAULT false;
opac_visible
boolean
NOT NULL;
DEFAULT false;
Tables referencing action.transit_copy via Foreign Key Constraints
hold_matrix_matchpoint
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
active
boolean
NOT NULL;
DEFAULT true;
user_home_ou
integer
UNIQUE#1
;
request_ou
integer
UNIQUE#1
;
pickup_ou
integer
UNIQUE#1
;
item_owning_ou
integer
UNIQUE#1
;
item_circ_ou
integer
UNIQUE#1
;
usr_grp
integer
UNIQUE#1
;
requestor_grp
integer
UNIQUE#1
;
NOT NULL;
circ_modifier
text
UNIQUE#1
;
marc_type
text
UNIQUE#1
;
marc_form
text
UNIQUE#1
;
marc_vr_format
text
UNIQUE#1
;
juvenile_flag
boolean
UNIQUE#1
;
ref_flag
boolean
UNIQUE#1
;
holdable
boolean
NOT NULL;
DEFAULT true;
distance_is_from_owner
boolean
NOT NULL;
DEFAULT false;
transit_range
integer
max_holds
integer
include_frozen_holds
boolean
NOT NULL;
DEFAULT true;
stop_blocked_user
boolean
NOT NULL;
DEFAULT false;
age_hold_protect_rule
integer
i18n_core
Field
Data Type
Constraints and References
id
bigserial
PRIMARY KEY
fq_field
text
NOT NULL;
identity_value
text
NOT NULL;
translation
text
NOT NULL;
string
text
NOT NULL;
i18n_locale
Field
Data Type
Constraints and References
code
text
PRIMARY KEY
marc_code
text
NOT NULL;
name
text
UNIQUE;
NOT NULL;
description
text
Tables referencing config.i18n_core via Foreign Key Constraints
identification_type
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
name
text
UNIQUE;
NOT NULL;
Tables referencing actor.usr via Foreign Key Constraints
idl_field_doc
Field
Data Type
Constraints and References
id
bigserial
PRIMARY KEY
fm_class
text
NOT NULL;
field
text
NOT NULL;
owner
integer
NOT NULL;
string
text
NOT NULL;
item_form_map
Field
Data Type
Constraints and References
code
text
PRIMARY KEY
value
text
NOT NULL;
Tables referencing config.circ_matrix_matchpoint via Foreign Key Constraints
item_type_map
Field
Data Type
Constraints and References
code
text
PRIMARY KEY
value
text
NOT NULL;
Tables referencing config.circ_matrix_matchpoint via Foreign Key Constraints
language_map
Field
Data Type
Constraints and References
code
text
PRIMARY KEY
value
text
NOT NULL;
Tables referencing config.i18n_locale via Foreign Key Constraints
lit_form_map
Field
Data Type
Constraints and References
code
text
PRIMARY KEY
value
text
NOT NULL;
description
text
metabib_field
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
field_class
text
NOT NULL;
name
text
NOT NULL;
xpath
text
NOT NULL;
weight
integer
NOT NULL;
DEFAULT 1;
format
text
NOT NULL;
DEFAULT 'mods33'::text;
search_field
boolean
NOT NULL;
DEFAULT true;
facet_field
boolean
NOT NULL;
DEFAULT false;
Constraints on metabib_field
metabib_field_field_class_check
CHECK ((lower(field_class) = ANY (ARRAY['title'::text, 'author'::text, 'subject'::text, 'keyword'::text, 'series'::text])))
Tables referencing metabib.author_field_entry via Foreign Key Constraints
net_access_level
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
name
text
UNIQUE;
NOT NULL;
Tables referencing actor.usr via Foreign Key Constraints
non_cataloged_type
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
owning_lib
integer
UNIQUE#1
;
NOT NULL;
name
text
UNIQUE#1
;
NOT NULL;
circ_duration
interval
NOT NULL;
DEFAULT '14 days'::interval;
in_house
boolean
NOT NULL;
DEFAULT false;
Tables referencing action.non_cat_in_house_use via Foreign Key Constraints
rule_age_hold_protect
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
name
text
UNIQUE;
NOT NULL;
age
interval
NOT NULL;
prox
integer
NOT NULL;
Constraints on rule_age_hold_protect
rule_age_hold_ protect_name_check
CHECK ((name ~ '^\\w+$'::text))
Tables referencing config.hold_matrix_matchpoint via Foreign Key Constraints
rule_circ_duration
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
name
text
UNIQUE;
NOT NULL;
extended
interval
NOT NULL;
normal
interval
NOT NULL;
shrt
interval
NOT NULL;
max_renewals
integer
NOT NULL;
Constraints on rule_circ_duration
rule_circ_duration_name_check
CHECK ((name ~ '^\\w+$'::text))
Tables referencing config.circ_matrix_matchpoint via Foreign Key Constraints
rule_max_fine
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
name
text
UNIQUE;
NOT NULL;
amount
numeric(6,2)
NOT NULL;
is_percent
boolean
NOT NULL;
DEFAULT false;
Constraints on rule_max_fine
rule_max_fine_name_check
CHECK ((name ~ '^\\w+$'::text))
Tables referencing config.circ_matrix_matchpoint via Foreign Key Constraints
rule_recuring_fine
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
name
text
UNIQUE;
NOT NULL;
high
numeric(6,2)
NOT NULL;
normal
numeric(6,2)
NOT NULL;
low
numeric(6,2)
NOT NULL;
recurance_interval
interval
NOT NULL;
DEFAULT '1 day'::interval;
Constraints on rule_recuring_fine
rule_recuring_fine_name_check
CHECK ((name ~ '^\\w+$'::text))
Tables referencing config.circ_matrix_matchpoint via Foreign Key Constraints
standing
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
value
text
UNIQUE;
NOT NULL;
Tables referencing actor.usr via Foreign Key Constraints
standing_penalty
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
name
text
UNIQUE;
NOT NULL;
label
text
NOT NULL;
block_list
text
Tables referencing actor.usr_standing_penalty via Foreign Key Constraints
upgrade_log
Field
Data Type
Constraints and References
version
text
PRIMARY KEY
install_date
timestamp with time zone
NOT NULL;
DEFAULT now();
videorecording_format_map
Field
Data Type
Constraints and References
code
text
PRIMARY KEY
value
text
NOT NULL;
Tables referencing config.circ_matrix_matchpoint via Foreign Key Constraints
xml_transform
Field
Data Type
Constraints and References
name
text
PRIMARY KEY
namespace_uri
text
NOT NULL;
prefix
text
NOT NULL;
xslt
text
NOT NULL;
z3950_attr
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
source
text
UNIQUE#1
;
NOT NULL;
name
text
NOT NULL;
label
text
NOT NULL;
code
integer
UNIQUE#1
;
NOT NULL;
format
integer
UNIQUE#1
;
NOT NULL;
truncation
integer
NOT NULL;
z3950_source
Field
Data Type
Constraints and References
name
text
PRIMARY KEY
label
text
UNIQUE;
NOT NULL;
host
text
NOT NULL;
port
integer
NOT NULL;
db
text
NOT NULL;
record_format
text
NOT NULL;
DEFAULT 'FI'::text;
transmission_format
text
NOT NULL;
DEFAULT 'usmarc'::text;
auth
boolean
NOT NULL;
DEFAULT true;
Tables referencing config.z3950_attr via Foreign Key Constraints
Schema container
biblio_record_entry_bucket
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
owner
integer
UNIQUE#1
;
NOT NULL;
name
text
UNIQUE#1
;
NOT NULL;
btype
text
UNIQUE#1
;
NOT NULL;
DEFAULT 'misc'::text;
pub
boolean
NOT NULL;
DEFAULT false;
create_time
timestamp with time zone
NOT NULL;
DEFAULT now();
Tables referencing container.biblio_record_entry_bucket_item via Foreign Key Constraints
biblio_record_entry_bucket_item
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
bucket
integer
NOT NULL;
target_biblio_record_entry
integer
NOT NULL;
pos
integer
create_time
timestamp with time zone
NOT NULL;
DEFAULT now();
Tables referencing container.biblio_record_entry_bucket_item_note via Foreign Key Constraints
biblio_record_entry_bucket_item_note
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
item
integer
NOT NULL;
note
text
NOT NULL;
biblio_record_entry_bucket_note
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
bucket
integer
NOT NULL;
note
text
NOT NULL;
biblio_record_entry_bucket_type
Field
Data Type
Constraints and References
code
text
PRIMARY KEY
label
text
UNIQUE;
NOT NULL;
Tables referencing container.biblio_record_entry_bucket via Foreign Key Constraints
call_number_bucket
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
owner
integer
UNIQUE#1
;
NOT NULL;
name
text
UNIQUE#1
;
NOT NULL;
btype
text
UNIQUE#1
;
NOT NULL;
DEFAULT 'misc'::text;
pub
boolean
NOT NULL;
DEFAULT false;
create_time
timestamp with time zone
NOT NULL;
DEFAULT now();
Tables referencing container.call_number_bucket_item via Foreign Key Constraints
call_number_bucket_item
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
bucket
integer
NOT NULL;
target_call_number
integer
NOT NULL;
pos
integer
create_time
timestamp with time zone
NOT NULL;
DEFAULT now();
Tables referencing container.call_number_bucket_item_note via Foreign Key Constraints
call_number_bucket_item_note
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
item
integer
NOT NULL;
note
text
NOT NULL;
call_number_bucket_note
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
bucket
integer
NOT NULL;
note
text
NOT NULL;
call_number_bucket_type
Field
Data Type
Constraints and References
code
text
PRIMARY KEY
label
text
UNIQUE;
NOT NULL;
Tables referencing container.call_number_bucket via Foreign Key Constraints
copy_bucket
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
owner
integer
UNIQUE#1
;
NOT NULL;
name
text
UNIQUE#1
;
NOT NULL;
btype
text
UNIQUE#1
;
NOT NULL;
DEFAULT 'misc'::text;
pub
boolean
NOT NULL;
DEFAULT false;
create_time
timestamp with time zone
NOT NULL;
DEFAULT now();
Tables referencing container.copy_bucket_item via Foreign Key Constraints
copy_bucket_item
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
bucket
integer
NOT NULL;
target_copy
integer
NOT NULL;
pos
integer
create_time
timestamp with time zone
NOT NULL;
DEFAULT now();
Tables referencing container.copy_bucket_item_note via Foreign Key Constraints
copy_bucket_item_note
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
item
integer
NOT NULL;
note
text
NOT NULL;
copy_bucket_note
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
bucket
integer
NOT NULL;
note
text
NOT NULL;
copy_bucket_type
Field
Data Type
Constraints and References
code
text
PRIMARY KEY
label
text
UNIQUE;
NOT NULL;
Tables referencing container.copy_bucket via Foreign Key Constraints
user_bucket
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
owner
integer
UNIQUE#1
;
NOT NULL;
name
text
UNIQUE#1
;
NOT NULL;
btype
text
UNIQUE#1
;
NOT NULL;
DEFAULT 'misc'::text;
pub
boolean
NOT NULL;
DEFAULT false;
create_time
timestamp with time zone
NOT NULL;
DEFAULT now();
Tables referencing container.user_bucket_item via Foreign Key Constraints
user_bucket_item
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
bucket
integer
NOT NULL;
target_user
integer
NOT NULL;
pos
integer
create_time
timestamp with time zone
NOT NULL;
DEFAULT now();
Tables referencing container.user_bucket_item_note via Foreign Key Constraints
user_bucket_item_note
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
item
integer
NOT NULL;
note
text
NOT NULL;
user_bucket_note
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
bucket
integer
NOT NULL;
note
text
NOT NULL;
user_bucket_type
Field
Data Type
Constraints and References
code
text
PRIMARY KEY
label
text
UNIQUE;
NOT NULL;
Tables referencing container.user_bucket via Foreign Key Constraints
Schema extend_reporter
full_circ_count
Field
Data Type
Constraints and References
id
bigint
circ_count
bigint
global_bibs_by_holding_update
Field
Data Type
Constraints and References
id
bigint
holding_update
timestamp with time zone
update_type
text
legacy_circ_count
Field
Data Type
Constraints and References
id
bigint
PRIMARY KEY
circ_count
integer
NOT NULL;
Schema money
billable_xact
Field
Data Type
Constraints and References
id
bigserial
PRIMARY KEY
usr
integer
NOT NULL;
xact_start
timestamp with time zone
NOT NULL;
DEFAULT now();
xact_finish
timestamp with time zone
unrecovered
boolean
billable_xact_summary
Field
Data Type
Constraints and References
id
bigint
usr
integer
xact_start
timestamp with time zone
xact_finish
timestamp with time zone
total_paid
numeric
last_payment_ts
timestamp with time zone
last_payment_note
text
last_payment_type
name
total_owed
numeric
last_billing_ts
timestamp with time zone
last_billing_note
text
last_billing_type
text
balance_owed
numeric
xact_type
name
billable_xact_with_void_summary
Field
Data Type
Constraints and References
id
bigint
usr
integer
xact_start
timestamp with time zone
xact_finish
timestamp with time zone
total_paid
numeric
last_payment_ts
timestamp with time zone
last_payment_note
text
last_payment_type
name
total_owed
numeric
last_billing_ts
timestamp with time zone
last_billing_note
text
last_billing_type
text
balance_owed
numeric
xact_type
name
billing
Field
Data Type
Constraints and References
id
bigserial
PRIMARY KEY
xact
bigint
NOT NULL;
billing_ts
timestamp with time zone
NOT NULL;
DEFAULT now();
voided
boolean
NOT NULL;
DEFAULT false;
voider
integer
void_time
timestamp with time zone
amount
numeric(6,2)
NOT NULL;
billing_type
text
NOT NULL;
btype
integer
NOT NULL;
note
text
bnm_desk_payment
Field
Data Type
Constraints and References
id
bigint
PRIMARY KEY
DEFAULT nextval('money.payment_id_seq'::regclass);
xact
bigint
NOT NULL;
payment_ts
timestamp with time zone
NOT NULL;
DEFAULT now();
voided
boolean
NOT NULL;
DEFAULT false;
amount
numeric(6,2)
NOT NULL;
note
text
amount_collected
numeric(6,2)
NOT NULL;
accepting_usr
integer
NOT NULL;
cash_drawer
integer
bnm_payment
Field
Data Type
Constraints and References
id
bigint
PRIMARY KEY
DEFAULT nextval('money.payment_id_seq'::regclass);
xact
bigint
NOT NULL;
payment_ts
timestamp with time zone
NOT NULL;
DEFAULT now();
voided
boolean
NOT NULL;
DEFAULT false;
amount
numeric(6,2)
NOT NULL;
note
text
amount_collected
numeric(6,2)
NOT NULL;
accepting_usr
integer
NOT NULL;
bnm_payment_view
Field
Data Type
Constraints and References
id
bigint
xact
bigint
payment_ts
timestamp with time zone
voided
boolean
amount
numeric(6,2)
note
text
amount_collected
numeric(6,2)
accepting_usr
integer
payment_type
name
cash_payment
Field
Data Type
Constraints and References
id
bigint
PRIMARY KEY
DEFAULT nextval('money.payment_id_seq'::regclass);
xact
bigint
NOT NULL;
payment_ts
timestamp with time zone
NOT NULL;
DEFAULT now();
voided
boolean
NOT NULL;
DEFAULT false;
amount
numeric(6,2)
NOT NULL;
note
text
amount_collected
numeric(6,2)
NOT NULL;
accepting_usr
integer
NOT NULL;
cash_drawer
integer
cashdrawer_payment_view
Field
Data Type
Constraints and References
org_unit
integer
cashdrawer
integer
payment_type
name
payment_ts
timestamp with time zone
amount
numeric(6,2)
voided
boolean
note
text
check_payment
Field
Data Type
Constraints and References
id
bigint
PRIMARY KEY
DEFAULT nextval('money.payment_id_seq'::regclass);
xact
bigint
NOT NULL;
payment_ts
timestamp with time zone
NOT NULL;
DEFAULT now();
voided
boolean
NOT NULL;
DEFAULT false;
amount
numeric(6,2)
NOT NULL;
note
text
amount_collected
numeric(6,2)
NOT NULL;
accepting_usr
integer
NOT NULL;
cash_drawer
integer
check_number
text
NOT NULL;
collections_tracker
Field
Data Type
Constraints and References
id
bigserial
PRIMARY KEY
usr
integer
NOT NULL;
collector
integer
NOT NULL;
location
integer
NOT NULL;
enter_time
timestamp with time zone
credit_card_payment
Field
Data Type
Constraints and References
id
bigint
PRIMARY KEY
DEFAULT nextval('money.payment_id_seq'::regclass);
xact
bigint
NOT NULL;
payment_ts
timestamp with time zone
NOT NULL;
DEFAULT now();
voided
boolean
NOT NULL;
DEFAULT false;
amount
numeric(6,2)
NOT NULL;
note
text
amount_collected
numeric(6,2)
NOT NULL;
accepting_usr
integer
NOT NULL;
cash_drawer
integer
cc_type
text
cc_number
text
expire_month
integer
expire_year
integer
approval_code
text
credit_payment
Field
Data Type
Constraints and References
id
bigint
PRIMARY KEY
DEFAULT nextval('money.payment_id_seq'::regclass);
xact
bigint
NOT NULL;
payment_ts
timestamp with time zone
NOT NULL;
DEFAULT now();
voided
boolean
NOT NULL;
DEFAULT false;
amount
numeric(6,2)
NOT NULL;
note
text
amount_collected
numeric(6,2)
NOT NULL;
accepting_usr
integer
NOT NULL;
desk_payment_view
Field
Data Type
Constraints and References
id
bigint
xact
bigint
payment_ts
timestamp with time zone
voided
boolean
amount
numeric(6,2)
note
text
amount_collected
numeric(6,2)
accepting_usr
integer
cash_drawer
integer
payment_type
name
forgive_payment
Field
Data Type
Constraints and References
id
bigint
PRIMARY KEY
DEFAULT nextval('money.payment_id_seq'::regclass);
xact
bigint
NOT NULL;
payment_ts
timestamp with time zone
NOT NULL;
DEFAULT now();
voided
boolean
NOT NULL;
DEFAULT false;
amount
numeric(6,2)
NOT NULL;
note
text
amount_collected
numeric(6,2)
NOT NULL;
accepting_usr
integer
NOT NULL;
goods_payment
Field
Data Type
Constraints and References
id
bigint
PRIMARY KEY
DEFAULT nextval('money.payment_id_seq'::regclass);
xact
bigint
NOT NULL;
payment_ts
timestamp with time zone
NOT NULL;
DEFAULT now();
voided
boolean
NOT NULL;
DEFAULT false;
amount
numeric(6,2)
NOT NULL;
note
text
amount_collected
numeric(6,2)
NOT NULL;
accepting_usr
integer
NOT NULL;
grocery
Field
Data Type
Constraints and References
id
bigint
PRIMARY KEY
DEFAULT nextval('money.billable_xact_id_seq'::regclass);
usr
integer
NOT NULL;
xact_start
timestamp with time zone
NOT NULL;
DEFAULT now();
xact_finish
timestamp with time zone
unrecovered
boolean
billing_location
integer
NOT NULL;
note
text
materialized_billable_xact_summary
Field
Data Type
Constraints and References
id
bigint
usr
integer
xact_start
timestamp with time zone
xact_finish
timestamp with time zone
total_paid
numeric
last_payment_ts
timestamp with time zone
last_payment_note
text
last_payment_type
name
total_owed
numeric
last_billing_ts
timestamp with time zone
last_billing_note
text
last_billing_type
text
balance_owed
numeric
xact_type
name
non_drawer_payment_view
Field
Data Type
Constraints and References
id
bigint
xact
bigint
payment_ts
timestamp with time zone
voided
boolean
amount
numeric(6,2)
note
text
amount_collected
numeric(6,2)
accepting_usr
integer
payment_type
name
open_billable_xact_summary
Field
Data Type
Constraints and References
id
bigint
usr
integer
billing_location
integer
xact_start
timestamp with time zone
xact_finish
timestamp with time zone
total_paid
numeric
last_payment_ts
timestamp with time zone
last_payment_note
text
last_payment_type
name
total_owed
numeric
last_billing_ts
timestamp with time zone
last_billing_note
text
last_billing_type
text
balance_owed
numeric
xact_type
name
open_transaction_billing_summary
Field
Data Type
Constraints and References
xact
bigint
last_billing_type
text
last_billing_note
text
last_billing_ts
timestamp with time zone
total_owed
numeric
open_transaction_billing_type_summary
Field
Data Type
Constraints and References
xact
bigint
last_billing_type
text
last_billing_note
text
last_billing_ts
timestamp with time zone
total_owed
numeric
open_transaction_payment_summary
Field
Data Type
Constraints and References
xact
bigint
last_payment_type
name
last_payment_note
text
last_payment_ts
timestamp with time zone
total_paid
numeric
open_usr_circulation_summary
Field
Data Type
Constraints and References
usr
integer
total_paid
numeric
total_owed
numeric
balance_owed
numeric
open_usr_summary
Field
Data Type
Constraints and References
usr
integer
total_paid
numeric
total_owed
numeric
balance_owed
numeric
payment
Field
Data Type
Constraints and References
id
bigserial
PRIMARY KEY
xact
bigint
NOT NULL;
payment_ts
timestamp with time zone
NOT NULL;
DEFAULT now();
voided
boolean
NOT NULL;
DEFAULT false;
amount
numeric(6,2)
NOT NULL;
note
text
payment_view
Field
Data Type
Constraints and References
id
bigint
xact
bigint
payment_ts
timestamp with time zone
voided
boolean
amount
numeric(6,2)
note
text
payment_type
name
transaction_billing_summary
Field
Data Type
Constraints and References
xact
bigint
last_billing_type
text
last_billing_note
text
last_billing_ts
timestamp with time zone
total_owed
numeric
transaction_billing_type_summary
Field
Data Type
Constraints and References
xact
bigint
last_billing_type
text
last_billing_note
text
last_billing_ts
timestamp with time zone
total_owed
numeric
transaction_billing_with_void_summary
Field
Data Type
Constraints and References
xact
bigint
last_billing_type
text
last_billing_note
text
last_billing_ts
timestamp with time zone
total_owed
numeric
transaction_payment_summary
Field
Data Type
Constraints and References
xact
bigint
last_payment_type
name
last_payment_note
text
last_payment_ts
timestamp with time zone
total_paid
numeric
transaction_payment_with_void_summary
Field
Data Type
Constraints and References
xact
bigint
last_payment_type
name
last_payment_note
text
last_payment_ts
timestamp with time zone
total_paid
numeric
usr_circulation_summary
Field
Data Type
Constraints and References
usr
integer
total_paid
numeric
total_owed
numeric
balance_owed
numeric
usr_summary
Field
Data Type
Constraints and References
usr
integer
total_paid
numeric
total_owed
numeric
balance_owed
numeric
work_payment
Field
Data Type
Constraints and References
id
bigint
PRIMARY KEY
DEFAULT nextval('money.payment_id_seq'::regclass);
xact
bigint
NOT NULL;
payment_ts
timestamp with time zone
NOT NULL;
DEFAULT now();
voided
boolean
NOT NULL;
DEFAULT false;
amount
numeric(6,2)
NOT NULL;
note
text
amount_collected
numeric(6,2)
NOT NULL;
accepting_usr
integer
NOT NULL;
Schema offline
script
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
session
text
NOT NULL;
requestor
integer
NOT NULL;
create_time
integer
NOT NULL;
workstation
text
NOT NULL;
logfile
text
NOT NULL;
time_delta
integer
NOT NULL;
count
integer
NOT NULL;
session
Field
Data Type
Constraints and References
key
text
PRIMARY KEY
org
integer
NOT NULL;
description
text
creator
integer
NOT NULL;
create_time
integer
NOT NULL;
in_process
integer
NOT NULL;
start_time
integer
end_time
integer
num_complete
integer
NOT NULL;
Schema permission
grp_penalty_threshold
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
grp
integer
UNIQUE#1
;
NOT NULL;
org_unit
integer
UNIQUE#1
;
NOT NULL;
penalty
integer
UNIQUE#1
;
NOT NULL;
threshold
numeric(8,2)
NOT NULL;
grp_perm_map
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
grp
integer
UNIQUE#1
;
NOT NULL;
perm
integer
UNIQUE#1
;
NOT NULL;
depth
integer
NOT NULL;
grantable
boolean
NOT NULL;
DEFAULT false;
grp_tree
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
name
text
UNIQUE;
NOT NULL;
parent
integer
usergroup
boolean
NOT NULL;
DEFAULT true;
perm_interval
interval
NOT NULL;
DEFAULT '3 years'::interval;
description
text
application_perm
text
Tables referencing actor.usr via Foreign Key Constraints
perm_list
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
code
text
UNIQUE;
NOT NULL;
description
text
Tables referencing permission.grp_perm_map via Foreign Key Constraints
usr_grp_map
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
usr
integer
UNIQUE#1
;
NOT NULL;
grp
integer
UNIQUE#1
;
NOT NULL;
usr_object_perm_map
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
usr
integer
UNIQUE#1
;
NOT NULL;
perm
integer
UNIQUE#1
;
NOT NULL;
object_type
text
UNIQUE#1
;
NOT NULL;
object_id
text
UNIQUE#1
;
NOT NULL;
grantable
boolean
NOT NULL;
DEFAULT false;
usr_perm_map
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
usr
integer
UNIQUE#1
;
NOT NULL;
perm
integer
UNIQUE#1
;
NOT NULL;
depth
integer
NOT NULL;
grantable
boolean
NOT NULL;
DEFAULT false;
usr_work_ou_map
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
usr
integer
UNIQUE#1
;
NOT NULL;
work_ou
integer
UNIQUE#1
;
NOT NULL;
Schema reporter
circ_type
Field
Data Type
Constraints and References
id
bigint
type
text
currently_running
Field
Data Type
Constraints and References
id
integer
runner_barcode
text
name
text
run_time
timestamp with time zone
scheduled_wait_time
interval
demographic
Field
Data Type
Constraints and References
id
integer
dob
timestamp with time zone
general_division
text
hold_request_record
Field
Data Type
Constraints and References
id
integer
target
bigint
hold_type
text
bib_record
bigint
materialized_simple_record
Field
Data Type
Constraints and References
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
Field
Data Type
Constraints and References
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
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
parent
integer
owner
integer
NOT NULL;
create_time
timestamp with time zone
NOT NULL;
DEFAULT now();
name
text
NOT NULL;
shared
boolean
NOT NULL;
DEFAULT false;
share_with
integer
Tables referencing reporter.output_folder via Foreign Key Constraints
overdue_circs
Field
Data Type
Constraints and References
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
recuring_fine
numeric(6,2)
max_fine
numeric(6,2)
phone_renewal
boolean
desk_renewal
boolean
opac_renewal
boolean
duration_rule
text
recuring_fine_rule
text
max_fine_rule
text
stop_fines
text
overdue_reports
Field
Data Type
Constraints and References
id
integer
runner_barcode
text
name
text
run_time
timestamp with time zone
scheduled_wait_time
interval
pending_reports
Field
Data Type
Constraints and References
id
integer
runner_barcode
text
name
text
run_time
timestamp with time zone
scheduled_wait_time
interval
report
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
owner
integer
NOT NULL;
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;
data
text
NOT NULL;
folder
integer
NOT NULL;
recur
boolean
NOT NULL;
DEFAULT false;
recurance
interval
Tables referencing reporter.schedule via Foreign Key Constraints
report_folder
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
parent
integer
owner
integer
NOT NULL;
create_time
timestamp with time zone
NOT NULL;
DEFAULT now();
name
text
NOT NULL;
shared
boolean
NOT NULL;
DEFAULT false;
share_with
integer
Tables referencing reporter.report via Foreign Key Constraints
schedule
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
report
integer
NOT NULL;
folder
integer
NOT NULL;
runner
integer
NOT NULL;
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
simple_record
Field
Data Type
Constraints and References
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
Field
Data Type
Constraints and References
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
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
owner
integer
NOT NULL;
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;
Tables referencing reporter.report via Foreign Key Constraints
template_folder
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
parent
integer
owner
integer
NOT NULL;
create_time
timestamp with time zone
NOT NULL;
DEFAULT now();
name
text
NOT NULL;
shared
boolean
NOT NULL;
DEFAULT false;
share_with
integer
Tables referencing reporter.template via Foreign Key Constraints
xact_billing_totals
Field
Data Type
Constraints and References
xact
bigint
unvoided
numeric
voided
numeric
total
numeric
xact_paid_totals
Field
Data Type
Constraints and References
xact
bigint
unvoided
numeric
voided
numeric
total
numeric
Schema search
relevance_adjustment
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
active
boolean
NOT NULL;
DEFAULT true;
field
integer
NOT NULL;
bump_type
text
NOT NULL;
multiplier
numeric
NOT NULL;
DEFAULT 1.0;
Constraints on relevance_adjustment
relevance_adjustment _bump_type_check
CHECK ((bump_type = ANY (ARRAY['word_order'::text, 'first_word'::text, 'full_match'::text])))
Schema serial
bib_summary
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
subscription
integer
UNIQUE;
NOT NULL;
generated_coverage
text
NOT NULL;
textual_holdings
text
binding_unit
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
subscription
integer
UNIQUE#1
;
NOT NULL;
label
text
UNIQUE#1
;
NOT NULL;
Tables referencing serial.issuance via Foreign Key Constraints
index_summary
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
subscription
integer
UNIQUE;
NOT NULL;
generated_coverage
text
NOT NULL;
textual_holdings
text
issuance
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
subscription
integer
NOT NULL;
target_copy
bigint
location
bigint
binding_unit
integer
label
text
record_entry
Field
Data Type
Constraints and References
id
bigserial
PRIMARY KEY
record
bigint
owning_lib
integer
NOT NULL;
DEFAULT 1;
creator
integer
NOT NULL;
DEFAULT 1;
editor
integer
NOT NULL;
DEFAULT 1;
source
integer
create_date
timestamp with time zone
NOT NULL;
DEFAULT now();
edit_date
timestamp with time zone
NOT NULL;
DEFAULT now();
active
boolean
NOT NULL;
DEFAULT true;
deleted
boolean
NOT NULL;
DEFAULT false;
marc
text
NOT NULL;
last_xact_id
text
NOT NULL;
subscription
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
callnumber
bigint
uri
integer
start_date
date
NOT NULL;
end_date
date
Tables referencing serial.bib_summary via Foreign Key Constraints
sup_summary
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
subscription
integer
UNIQUE;
NOT NULL;
generated_coverage
text
NOT NULL;
textual_holdings
text
Schema stats
fleshed_call_number
Field
Data Type
Constraints and References
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
create_date_day
date
edit_date_day
date
create_date_hour
timestamp with time zone
edit_date_hour
timestamp with time zone
item_lang
text
item_type
text
item_form
text
fleshed_circulation
Field
Data Type
Constraints and References
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
recuring_fine
numeric(6,2)
max_fine
numeric(6,2)
phone_renewal
boolean
desk_renewal
boolean
opac_renewal
boolean
duration_rule
text
recuring_fine_rule
text
max_fine_rule
text
stop_fines
text
start_date_day
date
finish_date_day
date
start_date_hour
timestamp with time zone
finish_date_hour
timestamp with time zone
call_number_label
text
owning_lib
integer
item_lang
text
item_type
text
item_form
text
fleshed_copy
Field
Data Type
Constraints and References
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
create_date_day
date
edit_date_day
date
create_date_hour
timestamp with time zone
edit_date_hour
timestamp with time zone
call_number_label
text
owning_lib
integer
item_lang
text
item_type
text
item_form
text
Schema vandelay
authority_attr_definition
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
code
text
UNIQUE;
NOT NULL;
description
text
xpath
text
NOT NULL;
remove
text
NOT NULL;
DEFAULT ''::text;
ident
boolean
NOT NULL;
DEFAULT false;
Tables referencing vandelay.queued_authority_record_attr via Foreign Key Constraints
authority_match
Field
Data Type
Constraints and References
id
bigserial
PRIMARY KEY
matched_attr
integer
queued_record
bigint
eg_record
bigint
authority_queue
Field
Data Type
Constraints and References
id
bigint
PRIMARY KEY
DEFAULT nextval('vandelay.queue_id_seq'::regclass);
owner
integer
UNIQUE#1
;
NOT NULL;
name
text
UNIQUE#1
;
NOT NULL;
complete
boolean
NOT NULL;
DEFAULT false;
queue_type
text
UNIQUE#1
;
NOT NULL;
DEFAULT 'authority'::text;
Constraints on authority_queue
authority_queue_ queue_type_check
CHECK ((queue_type = 'authority'::text))
queue_queue_type_check
CHECK ((queue_type = ANY (ARRAY['bib'::text, 'authority'::text])))
Tables referencing vandelay.queued_authority_record via Foreign Key Constraints
bib_attr_definition
Field
Data Type
Constraints and References
id
serial
PRIMARY KEY
code
text
UNIQUE;
NOT NULL;
description
text
xpath
text
NOT NULL;
remove
text
NOT NULL;
DEFAULT ''::text;
ident
boolean
NOT NULL;
DEFAULT false;
Tables referencing vandelay.queued_bib_record_attr via Foreign Key Constraints
bib_match
Field
Data Type
Constraints and References
id
bigserial
PRIMARY KEY
field_type
text
NOT NULL;
matched_attr
integer
queued_record
bigint
eg_record
bigint
Constraints on bib_match
bib_match_field_type_check
CHECK ((field_type = ANY (ARRAY['isbn'::text, 'tcn_value'::text, 'id'::text])))
bib_queue
Field
Data Type
Constraints and References
id
bigint
PRIMARY KEY
DEFAULT nextval('vandelay.queue_id_seq'::regclass);
owner
integer
UNIQUE#1
;
NOT NULL;
name
text
UNIQUE#1
;
NOT NULL;
complete
boolean
NOT NULL;
DEFAULT false;
queue_type
text
UNIQUE#1
;
NOT NULL;
DEFAULT 'bib'::text;
item_attr_def
bigint
Constraints on bib_queue
bib_queue_queue_type_check
CHECK ((queue_type = 'bib'::text))
queue_queue_type_check
CHECK ((queue_type = ANY (ARRAY['bib'::text, 'authority'::text])))
Tables referencing vandelay.queued_bib_record via Foreign Key Constraints
import_bib_trash_fields
Field
Data Type
Constraints and References
id
bigserial
PRIMARY KEY
owner
integer
UNIQUE#1
;
NOT NULL;
field
text
UNIQUE#1
;
NOT NULL;
import_item
Field
Data Type
Constraints and References
id
bigserial
PRIMARY KEY
record
bigint
NOT NULL;
definition
bigint
NOT NULL;
owning_lib
integer
circ_lib
integer
call_number
text
copy_number
integer
status
integer
location
integer
circulate
boolean
deposit
boolean
deposit_amount
numeric(8,2)
ref
boolean
holdable
boolean
price
numeric(8,2)
barcode
text
circ_modifier
text
circ_as_type
text
alert_message
text
pub_note
text
priv_note
text
opac_visible
boolean
import_item_attr_definition
Field
Data Type
Constraints and References
id
bigserial
PRIMARY KEY
owner
integer
UNIQUE#1
;
NOT NULL;
name
text
UNIQUE#1
;
NOT NULL;
tag
text
NOT NULL;
keep
boolean
NOT NULL;
DEFAULT false;
owning_lib
text
circ_lib
text
call_number
text
copy_number
text
status
text
location
text
circulate
text
deposit
text
deposit_amount
text
ref
text
holdable
text
price
text
barcode
text
circ_modifier
text
circ_as_type
text
alert_message
text
opac_visible
text
pub_note_title
text
pub_note
text
priv_note_title
text
priv_note
text
Tables referencing vandelay.bib_queue via Foreign Key Constraints
queue
Field
Data Type
Constraints and References
id
bigserial
PRIMARY KEY
owner
integer
UNIQUE#1
;
NOT NULL;
name
text
UNIQUE#1
;
NOT NULL;
complete
boolean
NOT NULL;
DEFAULT false;
queue_type
text
UNIQUE#1
;
NOT NULL;
DEFAULT 'bib'::text;
Constraints on queue
queue_queue_type_check
CHECK ((queue_type = ANY (ARRAY['bib'::text, 'authority'::text])))
queued_authority_record
Field
Data Type
Constraints and References
id
bigint
PRIMARY KEY
DEFAULT nextval('vandelay.queued_record_id_seq'::regclass);
create_time
timestamp with time zone
NOT NULL;
DEFAULT now();
import_time
timestamp with time zone
purpose
text
NOT NULL;
DEFAULT 'import'::text;
marc
text
NOT NULL;
queue
integer
NOT NULL;
imported_as
integer
Constraints on queued_authority_record
queued_record_purpose_check
CHECK ((purpose = ANY (ARRAY['import'::text, 'overlay'::text])))
Tables referencing vandelay.authority_match via Foreign Key Constraints
queued_authority_record_attr
Field
Data Type
Constraints and References
id
bigserial
PRIMARY KEY
record
bigint
NOT NULL;
field
integer
NOT NULL;
attr_value
text
NOT NULL;
Tables referencing vandelay.authority_match via Foreign Key Constraints
queued_bib_record
Field
Data Type
Constraints and References
id
bigint
PRIMARY KEY
DEFAULT nextval('vandelay.queued_record_id_seq'::regclass);
create_time
timestamp with time zone
NOT NULL;
DEFAULT now();
import_time
timestamp with time zone
purpose
text
NOT NULL;
DEFAULT 'import'::text;
marc
text
NOT NULL;
queue
integer
NOT NULL;
bib_source
integer
imported_as
integer
Constraints on queued_bib_record
queued_record_purpose_check
CHECK ((purpose = ANY (ARRAY['import'::text, 'overlay'::text])))
Tables referencing vandelay.bib_match via Foreign Key Constraints
queued_bib_record_attr
Field
Data Type
Constraints and References
id
bigserial
PRIMARY KEY
record
bigint
NOT NULL;
field
integer
NOT NULL;
attr_value
text
NOT NULL;
Tables referencing vandelay.bib_match via Foreign Key Constraints
queued_record
Field
Data Type
Constraints and References
id
bigserial
PRIMARY KEY
create_time
timestamp with time zone
NOT NULL;
DEFAULT now();
import_time
timestamp with time zone
purpose
text
NOT NULL;
DEFAULT 'import'::text;
marc
text
NOT NULL;
Constraints on queued_record
queued_record_purpose_check
CHECK ((purpose = ANY (ARRAY['import'::text, 'overlay'::text])))