Database Properties
Database Type: PostgreSQL - 15.10 (Ubuntu 15.10-1.pgdg24.04+1)
Schema config
The config schema holds static configuration data for the Evergreen installation.
Tables
| Table / View | Children | Parents | Columns | Rows | Type | Comments |
|---|---|---|---|---|---|---|
| sms_carrier | 1 | 0 | 5 | 67 | Table | |
| remote_account | 0 | 1 | 9 | -1 | Table | |
| standing_penalty | 2 | 0 | 7 | -1 | Table | |
| index_normalizer | 3 | 0 | 5 | -1 | Table | |
| marc_subfield | 0 | 3 | 11 | 3781 | Table | This table stores the list of subfields recognized by this Evergreen instance. As with config.marc_field, of particular significance is the owner column; if it’s set to a null value, the subfield definition is assumed to come from a national standards body; if it’s set to a non-null value, the subfield definition is an OU-level addition to or override of the standard. |
| circ_matrix_limit_set_map | 0 | 2 | 5 | -1 | Table | |
| rule_max_fine | 1 | 0 | 4 | -1 | Table | Circulation Max Fine rules Each circulation is given a maximum fine based on one of these rules. |
| biblio_fingerprint | 0 | 0 | 5 | -1 | Table | |
| copy_tag_type | 1 | 1 | 3 | -1 | Table | |
| print_template | 0 | 2 | 8 | -1 | Table | |
| barcode_completion | 0 | 1 | 10 | -1 | Table | |
| workstation_setting_type | 1 | 1 | 6 | 352 | Table | |
| carousel_type | 1 | 0 | 6 | -1 | Table | |
| marc_field | 0 | 2 | 11 | 391 | Table | This table stores a list of MARC fields recognized by the Evergreen instance. Note that we’re not aiming for completely generic ISO2709 support: we’re assuming things like three characters for a tag, one-character subfield labels, two indicators per variable data field, and the like, all of which are technically specializations of ISO2709. Of particular significance is the owner column; if it’s set to a null value, the field definition is assumed to come from a national standards body; if it’s set to a non-null value, the field definition is an OU-level addition to or override of the standard. |
| coded_value_map | 1 | 1 | 9 | 3251 | Table | |
| upgrade_log | 0 | 0 | 3 | -1 | Table | |
| hold_matrix_matchpoint | 0 | 10 | 26 | -1 | Table | |
| ui_staff_portal_page_entry_type | 1 | 0 | 2 | -1 | Table | |
| circ_limit_set_circ_mod_map | 0 | 2 | 3 | -1 | Table | |
| billing_type | 1 | 1 | 4 | -1 | Table | |
| identification_type | 2 | 0 | 2 | -1 | Table | Types of valid patron identification. Each patron must display at least one valid form of identification in order to get a library card. This table lists those forms. |
| rule_age_hold_protect | 1 | 0 | 4 | -1 | Table | Hold Item Age Protection rules A hold request can only capture new(ish) items when they are within a particular proximity of the pickup_lib of the request. The proximity (‘prox’ column) is calculated by counting the number of tree edges between the pickup_lib and either the owning_lib or circ_lib of the copy that could fulfill the hold, as determined by the distance_is_from_owner value of the hold matrix rule controlling the hold request. |
| marc21_physical_characteristic_value_map | 0 | 1 | 4 | 626 | Table | |
| marc_format | 2 | 0 | 3 | -1 | Table | List of MARC formats supported by this Evergreen database. This exists primarily as a hook for future support of UNIMARC, though whether that will ever happen remains to be seen. |
| marc21_rec_type_map | 0 | 0 | 3 | -1 | Table | |
| metabib_field_ts_map | 0 | 2 | 7 | -1 | Table | Text Search Configs for metabib field indexing This table contains text search config definitions for storing index_vector values. |
| rule_circ_duration | 1 | 0 | 7 | -1 | Table | Circulation Duration rules Each circulation is given a duration based on one of these rules. |
| metabib_search_alias | 0 | 2 | 3 | -1 | Table | |
| z3950_source_credentials | 0 | 2 | 5 | -1 | Table | |
| circ_matrix_matchpoint | 1 | 11 | 32 | -1 | Table | |
| z3950_source | 2 | 1 | 9 | -1 | Table | Z39.50 Sources Each row in this table represents a database searchable via Z39.50. |
| metabib_class | 3 | 0 | 21 | -1 | Table | |
| standing | 1 | 0 | 2 | -1 | Table | Patron Standings This table contains the values that can be applied to a patron by a staff member. These values should not be changed, other than for translation, as the ID column is currently a “magic number” in the source. :( |
| filter_dialog_interface | 3 | 0 | 2 | -1 | Table | |
| marc21_physical_characteristic_type_map | 1 | 0 | 2 | -1 | Table | |
| best_hold_order | 0 | 0 | 13 | -1 | Table | |
| mfa_factor | 2 | 0 | 3 | -1 | Table | |
| circ_modifier | 9 | 0 | 6 | -1 | Table | |
| usr_setting_type | 2 | 1 | 8 | -1 | Table | |
| marc21_physical_characteristic_subfield_map | 2 | 1 | 6 | 76 | Table | |
| hold_type | 1 | 0 | 3 | -1 | Table | |
| openathens_name_field | 1 | 0 | 2 | -1 | Table | |
| idl_field_doc | 0 | 1 | 5 | -1 | Table | |
| record_attr_index_norm_map | 0 | 2 | 5 | -1 | Table | |
| remoteauth_profile | 0 | 3 | 10 | -1 | Table | |
| filter_dialog_filter_set | 0 | 3 | 7 | -1 | Table | |
| circ_limit_set_group_map | 0 | 2 | 4 | -1 | Table | |
| floating_group_member | 0 | 2 | 6 | -1 | Table | |
| marc21_ff_pos_map | 0 | 0 | 7 | 295 | Table | |
| weight_assoc | 0 | 3 | 5 | -1 | Table | |
| floating_group | 3 | 0 | 3 | -1 | Table | |
| hard_due_date_values | 0 | 1 | 4 | -1 | Table | |
| geolocation_service | 0 | 2 | 6 | -1 | Table | |
| circ_limit_group | 2 | 0 | 3 | -1 | Table | |
| z3950_index_field_map | 0 | 3 | 6 | -1 | Table | |
| i18n_core | 0 | 1 | 5 | -1 | Table | |
| circ_limit_set_copy_loc_map | 0 | 2 | 3 | -1 | Table | |
| non_cataloged_type | 2 | 0 | 5 | -1 | Table | Types of valid non-cataloged items. |
| z3950_attr | 1 | 1 | 7 | -1 | Table | |
| rule_recurring_fine | 1 | 0 | 7 | -1 | Table | Circulation Recurring Fine rules Each circulation is given a recurring fine amount based on one of these rules. Note that it is recommended to run the fine generator (from cron) at least as frequently as the lowest recurrence interval used by your circulation rules so that accrued fines will be up to date. |
| metabib_field | 16 | 2 | 19 | 53 | Table | XPath used for record indexing ingest This table contains the XPath used to chop up MODS into its indexable parts. Each XPath entry is named and assigned to a “class” of either title, subject, author, keyword, series or identifier. |
| ui_staff_portal_page_entry | 0 | 2 | 9 | -1 | Table | |
| usr_activity_type | 2 | 0 | 8 | -1 | Table | |
| settings_group | 3 | 0 | 2 | -1 | Table | |
| record_attr_definition | 9 | 2 | 17 | 820 | Table | |
| global_flag | 0 | 0 | 4 | 95 | Table | |
| i18n_string | 0 | 0 | 3 | -1 | Table | |
| metabib_field_index_norm_map | 0 | 2 | 5 | 115 | Table | |
| hold_matrix_weights | 1 | 0 | 17 | -1 | Table | |
| metabib_field_virtual_map | 0 | 2 | 4 | 40 | Table | Maps between real (physically extracted) index definitions and virtual (target sync, no required extraction of its own) index definitions. The virtual side may not extract any data of its own, but will collect data from all of the real fields. This reduces extraction (ingest) overhead by eliminating duplcated extraction, and allows for searching across novel combinations of fields, such as names used as either subjects or authors. By preserving this mapping rather than defining duplicate extractions, information about the originating, “real” index definitions can be used in interesting ways, such as highlighting in search results. |
| circ_matrix_weights | 1 | 0 | 19 | -1 | Table | |
| net_access_level | 1 | 0 | 2 | -1 | Table | Patron Network Access level This will be used to inform the in-library firewall of how much internet access the using patron should be allowed. |
| org_unit_setting_type | 2 | 3 | 8 | 446 | Table | |
| i18n_locale | 4 | 0 | 5 | -1 | Table | |
| patron_loader_value_map | 0 | 1 | 5 | -1 | Table | |
| bib_source | 2 | 0 | 5 | -1 | Table | This is table is used to set up the relative “quality” of each MARC source, such as OCLC. Also identifies “transcendant” sources, i.e., sources of bib records that should display in the OPAC even if no copies or located URIs are attached. Also indicates if the source is allowed to have actual copies on its bibs. Volumes for targeted URIs are unaffected by this setting. |
| openathens_identity | 0 | 5 | 18 | -1 | Table | |
| patron_loader_header_map | 0 | 1 | 4 | -1 | Table | |
| ts_config_list | 3 | 0 | 2 | -1 | Table | Full Text Configs A list of full text configs with names and descriptions. |
| xml_transform | 4 | 0 | 4 | -1 | Table | |
| internal_flag | 0 | 0 | 3 | -1 | Table | |
| copy_alert_type | 2 | 1 | 11 | -1 | Table | |
| display_field_map | 0 | 1 | 3 | -1 | Table | |
| org_unit_setting_type_log | 0 | 2 | 6 | -1 | Table | Org Unit setting Logs This table contains the most recent changes to each setting in actor.org_unit_setting, allowing for mistakes to be undone. This is NOT meant to be an auditor, but rather an undo/redo. |
| openathens_uid_field | 1 | 0 | 2 | -1 | Table | |
| circ_limit_set | 4 | 1 | 7 | -1 | Table | |
| hard_due_date | 2 | 0 | 5 | -1 | Table | |
| copy_status | 4 | 0 | 8 | -1 | Table | Copy Statuses The available copy statuses, and whether a copy in that status is available for hold request capture. 0 (zero) is the only special number in this set, meaning that the item is available for immediate checkout, and is counted as available in the OPAC. Statuses with an ID below 100 are not removable, and have special meaning in the code. Do not change them except to translate the textual name. You may add and remove statuses above 100, and these can be used to remove items from normal circulation without affecting the rest of the copy’s values or its location. |
| composite_attr_entry_definition | 0 | 1 | 2 | 176 | Table | |
| db_patch_dependencies | 0 | 0 | 3 | -1 | Table | |
| metabib_class_ts_map | 0 | 2 | 8 | -1 | Table | Text Search Configs for metabib class indexing This table contains text search config definitions for storing index_vector values. |
| videorecording_format_map | 0 | 0 | 2 | 0 | View | |
| item_form_map | 0 | 0 | 2 | 0 | View | |
| item_type_map | 0 | 0 | 2 | 0 | View | |
| audience_map | 0 | 0 | 3 | 0 | View | |
| marc_field_for_ou | 0 | 0 | 12 | 0 | View | |
| language_map | 0 | 0 | 2 | 0 | View | |
| bib_level_map | 0 | 0 | 2 | 0 | View | |
| lit_form_map | 0 | 0 | 3 | 0 | View | |
| marc_subfield_for_ou | 0 | 0 | 12 | 0 | View |