Evergreen Database Schema

Documentation Interest Group


Table of Contents

1. Schema acq
Tables in acq
acq_lineitem_history
acq_lineitem_lifecycle
acq_purchase_order_history
acq_purchase_order_lifecycle
all_fund_allocation_total
all_fund_combined_balance
all_fund_encumbrance_total
all_fund_spent_balance
all_fund_spent_total
cancel_reason
claim
claim_event
claim_event_type
claim_policy
claim_policy_action
claim_type
currency_type
debit_attribution
distribution_formula
distribution_formula_application
distribution_formula_entry
edi_account
edi_message
exchange_rate
fiscal_calendar
fiscal_year
fund
fund_allocation
fund_allocation_percent
fund_allocation_total
fund_combined_balance
fund_debit
fund_debit_total
fund_encumbrance_total
fund_spent_balance
fund_spent_total
fund_tag
fund_tag_map
fund_transfer
funding_source
funding_source_allocation_total
funding_source_balance
funding_source_credit
funding_source_credit_total
invoice
invoice_entry
invoice_item
invoice_item_type
invoice_method
invoice_payment_method
lineitem
lineitem_alert_text
lineitem_attr
lineitem_attr_definition
lineitem_detail
lineitem_generated_attr_definition
lineitem_local_attr_definition
lineitem_marc_attr_definition
lineitem_note
lineitem_provider_attr_definition
lineitem_summary
lineitem_usr_attr_definition
ordered_funding_source_credit
picklist
po_item
po_note
provider
provider_address
provider_contact
provider_contact_address
provider_holding_subfield_map
provider_note
purchase_order
serial_claim
serial_claim_event
user_request
user_request_type
Functions in acq
2. Schema action
Tables in action
aged_circulation
aged_hold_request
all_circulation
all_hold_request
archive_actor_stat_cat
archive_asset_stat_cat
billable_circulations
circulation
circulation_limit_group_map
fieldset
fieldset_col_val
hold_copy_map
hold_notification
hold_request
hold_request_cancel_cause
hold_request_note
hold_transit_copy
in_house_use
non_cat_in_house_use
non_cataloged_circulation
open_circulation
reservation_transit_copy
survey
survey_answer
survey_question
survey_response
transit_copy
unfulfilled_hold_innermost_loop
unfulfilled_hold_list
unfulfilled_hold_loops
unfulfilled_hold_max_loop
unfulfilled_hold_min_loop
usr_circ_history
Functions in action
3. Schema action_trigger
Tables in action_trigger
cleanup
collector
environment
event
event_definition
event_output
event_params
hook
reactor
validator
4. Schema actor
Tables in actor
address_alert
card
hours_of_operation
org_address
org_lasso
org_lasso_map
org_unit
org_unit_closed
org_unit_custom_tree
org_unit_custom_tree_node
org_unit_proximity
org_unit_proximity_adjustment
org_unit_setting
org_unit_type
passwd
passwd_type
search_filter_group
search_filter_group_entry
search_query
stat_cat
stat_cat_entry
stat_cat_entry_default
stat_cat_entry_usr_map
stat_cat_sip_fields
toolbar
usr
usr_activity
usr_address
usr_message
usr_message_limited
usr_note
usr_org_unit_opt_in
usr_password_reset
usr_saved_search
usr_setting
usr_standing_penalty
workstation
Functions in actor
5. Schema asset
Tables in asset
call_number
call_number_class
call_number_note
call_number_prefix
call_number_suffix
copy
copy_location
copy_location_group
copy_location_group_map
copy_location_order
copy_note
copy_part_map
copy_template
opac_visible_copies
stat_cat
stat_cat_entry
stat_cat_entry_copy_map
stat_cat_entry_transparency_map
stat_cat_sip_fields
uri
uri_call_number_map
Functions in asset
6. Schema auditor
Tables in auditor
acq_invoice_entry_history
acq_invoice_entry_lifecycle
acq_invoice_history
acq_invoice_item_history
acq_invoice_item_lifecycle
acq_invoice_lifecycle
actor_org_unit_history
actor_org_unit_lifecycle
actor_usr_address_history
actor_usr_address_lifecycle
actor_usr_history
actor_usr_lifecycle
asset_call_number_history
asset_call_number_lifecycle
asset_copy_history
asset_copy_lifecycle
biblio_record_entry_history
biblio_record_entry_lifecycle
serial_unit_history
serial_unit_lifecycle
Functions in auditor
7. Schema authority
Tables in authority
authority_linking
bib_linking
browse_axis
browse_axis_authority_field_map
control_set
control_set_auth_field_metabib_field_map_blind_main
control_set_auth_field_metabib_field_map_blind_refs
control_set_auth_field_metabib_field_map_blind_refs_only
control_set_auth_field_metabib_field_map_main
control_set_auth_field_metabib_field_map_refs
control_set_auth_field_metabib_field_map_refs_only
control_set_authority_field
control_set_bib_field
control_set_bib_field_metabib_field_map
full_rec
rec_descriptor
record_entry
record_note
simple_heading
thesaurus
tracing_links
Functions in authority
8. Schema biblio
Tables in biblio
monograph_part
peer_bib_copy_map
peer_type
record_entry
record_note
Functions in biblio
9. Schema booking
Tables in booking
reservation
reservation_attr_value_map
resource
resource_attr
resource_attr_map
resource_attr_value
resource_type
10. Schema config
Tables in config
audience_map
barcode_completion
best_hold_order
bib_level_map
bib_source
biblio_fingerprint
billing_type
circ_limit_group
circ_limit_set
circ_limit_set_circ_mod_map
circ_limit_set_copy_loc_map
circ_limit_set_group_map
circ_matrix_limit_set_map
circ_matrix_matchpoint
circ_matrix_weights
circ_modifier
coded_value_map
composite_attr_entry_definition
copy_status
db_patch_dependencies
filter_dialog_filter_set
filter_dialog_interface
floating_group
floating_group_member
global_flag
hard_due_date
hard_due_date_values
hold_matrix_matchpoint
hold_matrix_weights
i18n_core
i18n_locale
identification_type
idl_field_doc
index_normalizer
internal_flag
item_form_map
item_type_map
language_map
lit_form_map
marc21_ff_pos_map
marc21_physical_characteristic_subfield_map
marc21_physical_characteristic_type_map
marc21_physical_characteristic_value_map
marc21_rec_type_map
marc_field
marc_field_for_ou
marc_format
marc_subfield
marc_subfield_for_ou
metabib_class
metabib_class_ts_map
metabib_field
metabib_field_index_norm_map
metabib_field_ts_map
metabib_search_alias
net_access_level
non_cataloged_type
org_unit_setting_type
org_unit_setting_type_log
record_attr_definition
record_attr_index_norm_map
remote_account
rule_age_hold_protect
rule_circ_duration
rule_max_fine
rule_recurring_fine
settings_group
sms_carrier
standing
standing_penalty
ts_config_list
upgrade_log
usr_activity_type
usr_setting_type
videorecording_format_map
weight_assoc
xml_transform
z3950_attr
z3950_index_field_map
z3950_source
z3950_source_credentials
Functions in config
11. Schema container
Tables in container
biblio_record_entry_bucket
biblio_record_entry_bucket_item
biblio_record_entry_bucket_item_note
biblio_record_entry_bucket_note
biblio_record_entry_bucket_type
call_number_bucket
call_number_bucket_item
call_number_bucket_item_note
call_number_bucket_note
call_number_bucket_type
copy_bucket
copy_bucket_item
copy_bucket_item_note
copy_bucket_note
copy_bucket_type
user_bucket
user_bucket_item
user_bucket_item_note
user_bucket_note
user_bucket_type
Functions in container
12. Schema evergreen
Functions in evergreen
13. Schema extend_reporter
Tables in extend_reporter
full_circ_count
global_bibs_by_holding_update
legacy_circ_count
14. Schema metabib
Tables in metabib
author_field_entry
browse_entry
browse_entry_def_map
browse_entry_simple_heading_map
combined_author_field_entry
combined_identifier_field_entry
combined_keyword_field_entry
combined_series_field_entry
combined_subject_field_entry
combined_title_field_entry
composite_attr_id_map
facet_entry
full_attr_id_map
full_rec
identifier_field_entry
keyword_field_entry
metarecord
metarecord_source_map
real_full_rec
rec_descriptor
record_attr
record_attr_flat
record_attr_id_map
record_attr_vector_list
record_sorter
series_field_entry
subject_field_entry
title_field_entry
uncontrolled_record_attr_value
Functions in metabib
15. Schema money
Tables in money
account_adjustment
billable_xact
billable_xact_summary
billable_xact_summary_location_view
billable_xact_with_void_summary
billing
bnm_desk_payment
bnm_payment
bnm_payment_view
cash_payment
cashdrawer_payment_view
check_payment
collections_tracker
credit_card_payment
credit_payment
desk_payment_view
forgive_payment
goods_payment
grocery
materialized_billable_xact_summary
non_drawer_payment_view
open_billable_xact_summary
open_transaction_billing_summary
open_transaction_billing_type_summary
open_transaction_payment_summary
open_usr_circulation_summary
open_usr_summary
payment
payment_view
transaction_billing_summary
transaction_billing_type_summary
transaction_billing_with_void_summary
transaction_payment_summary
transaction_payment_with_void_summary
usr_circulation_summary
usr_summary
work_payment
Functions in money
16. Schema offline
Tables in offline
script
session
17. Schema permission
Tables in permission
grp_penalty_threshold
grp_perm_map
grp_tree
perm_list
usr_grp_map
usr_object_perm_map
usr_perm_map
usr_work_ou_map
Functions in permission
18. Schema public
Functions in public
19. Schema query
Tables in query
bind_variable
case_branch
datatype
expr_xbet
expr_xbind
expr_xbool
expr_xcase
expr_xcast
expr_xcol
expr_xex
expr_xfunc
expr_xin
expr_xisnull
expr_xnull
expr_xnum
expr_xop
expr_xser
expr_xstr
expr_xsubq
expression
from_relation
function_param_def
function_sig
order_by_item
query_sequence
record_column
select_item
stored_query
subfield
20. Schema reporter
Tables in reporter
circ_type
currently_running
demographic
hold_request_record
materialized_simple_record
old_super_simple_record
output_folder
overdue_circs
overdue_reports
pending_reports
report
report_folder
schedule
simple_record
super_simple_record
template
template_folder
xact_billing_totals
xact_paid_totals
Functions in reporter
21. Schema search
Tables in search
relevance_adjustment
Functions in search
22. Schema serial
Tables in serial
any_summary
basic_summary
caption_and_pattern
distribution
distribution_note
index_summary
issuance
item
item_note
materialized_holding_code
record_entry
routing_list_user
stream
subscription
subscription_note
supplement_summary
unit
Functions in serial
23. Schema staging
Tables in staging
billing_address_stage
card_stage
mailing_address_stage
statcat_stage
user_stage
Functions in staging
24. Schema stats
25. Schema unapi
Tables in unapi
bre_output_layout
Functions in unapi
26. Schema url_verify
Tables in url_verify
session
url
url_selector
url_verification
verification_attempt
Functions in url_verify
27. Schema vandelay
Tables in vandelay
authority_attr_definition
authority_match
authority_queue
bib_attr_definition
bib_match
bib_queue
import_bib_trash_fields
import_bib_trash_group
import_error
import_item
import_item_attr_definition
match_set
match_set_point
match_set_quality
merge_profile
queue
queued_authority_record
queued_authority_record_attr
queued_bib_record
queued_bib_record_attr
queued_record
Functions in vandelay