
		Next

Evergreen Database Schema

Documentation Interest Group

Table of Contents

1. Schema acq

Tables in acq

Functions in acq

2. Schema action

Tables in action

Functions in action

3. Schema action_trigger

Tables in action_trigger

cleanup
collector
environment
event
event_definition
event_output
event_params
hook
reactor
validator

Functions in action_trigger

4. Schema actor

Tables in actor

Functions in actor

5. Schema asset

Tables in asset

active_copy_alert
call_number
call_number_class
call_number_note
call_number_prefix
call_number_suffix
copy
copy_alert
copy_location
copy_location_group
copy_location_group_map
copy_location_order
copy_note
copy_part_map
copy_tag
copy_tag_copy_map
copy_template
copy_vis_attr_cache
latest_inventory
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
heading_field
heading_field_norm_map
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

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

copy_count_per_org
full_circ_count
global_bibs_by_holding_update
legacy_circ_count

14. Schema metabib

Tables in metabib

Functions in metabib

15. Schema money

Tables in money

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
grp_tree_display_entry
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 rating

Tables in rating

badge
badge_with_orgs
popularity_parameter
record_badge_score

Functions in rating

21. 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

22. Schema search

Tables in search

best_tsconfig
relevance_adjustment

Functions in search

23. Schema serial

Tables in serial

any_summary
basic_summary
caption_and_pattern
distribution
distribution_note
index_summary
issuance
item
item_note
materialized_holding_code
pattern_template
record_entry
routing_list_user
stream
subscription
subscription_note
supplement_summary
unit

Functions in serial

24. Schema staging

Tables in staging

billing_address_stage
card_stage
mailing_address_stage
setting_stage
statcat_stage
user_stage

Functions in staging

25. Schema stats

26. Schema unapi

Tables in unapi

bre_output_layout

Functions in unapi

27. Schema url_verify

Tables in url_verify

session
url
url_selector
url_verification
verification_attempt

Functions in url_verify

28. 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
session_tracker

Functions in vandelay

		Next