Chapter 10. Schema config

Table of Contents

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

The config schema holds static configuration data for the Evergreen installation.

Below are the tables, views and functions for config

Tables in config

audience_map

  • code text
  • value text
  • description text

barcode_completion

  • id serial PRIMARY KEY
  • active boolean NOT NULL DEFAULT true
  • org_unit integer NOT NULL REFERENCES actor.table.org-unit
  • prefix text
  • suffix text
  • length integer NOT NULL
  • padding text
  • padding_end boolean NOT NULL DEFAULT false
  • asset boolean NOT NULL DEFAULT true
  • actor boolean NOT NULL DEFAULT true

best_hold_order

  • id serial PRIMARY KEY
  • name text UNIQUE
  • pprox integer
  • hprox integer
  • aprox integer
  • approx integer
  • priority integer
  • cut integer
  • depth integer
  • htime integer
  • rtime integer
  • shtime integer

Constraints on best_hold_order

  • best_hold_order_check CHECK

bib_level_map

  • code text
  • value text

bib_source

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.

  • id serial PRIMARY KEY
  • quality integer
  • source text UNIQUE NOT NULL
  • transcendant boolean NOT NULL DEFAULT false
  • can_have_copies boolean NOT NULL DEFAULT true

Constraints on bib_source

  • bib_source_quality_check CHECK

Tables referencing via foreign key constraints

  • rating.badge
  • vandelay.queued_bib_record

biblio_fingerprint

  • id serial PRIMARY KEY
  • name text NOT NULL
  • xpath text NOT NULL
  • first_word boolean NOT NULL DEFAULT false
  • format text NOT NULL DEFAULT 'marcxml'::text

billing_type

  • id serial PRIMARY KEY
  • name text UNIQUE #1 NOT NULL
  • owner integer UNIQUE #1 NOT NULL REFERENCES actor.table.org-unit
  • default_price numeric(6,2)

Tables referencing via foreign key constraints

  • money.billing

circ_limit_group

  • id serial PRIMARY KEY
  • name text UNIQUE NOT NULL
  • description text

Tables referencing via foreign key constraints

  • action.circulation_limit_group_map
  • config.circ_limit_set_group_map

circ_limit_set

  • id serial PRIMARY KEY
  • name text UNIQUE NOT NULL
  • owning_lib integer NOT NULL REFERENCES actor.table.org-unit
  • items_out integer NOT NULL
  • depth integer NOT NULL
  • global boolean NOT NULL DEFAULT false
  • description text

Tables referencing via foreign key constraints

  • config.circ_limit_set_circ_mod_map
  • config.circ_limit_set_copy_loc_map
  • config.circ_limit_set_group_map
  • config.circ_matrix_limit_set_map

circ_limit_set_circ_mod_map

  • id serial PRIMARY KEY
  • limit_set integer UNIQUE #1 NOT NULL REFERENCES config.table.circ-limit-set
  • circ_mod text UNIQUE #1 NOT NULL REFERENCES config.table.circ-modifier

circ_limit_set_copy_loc_map

  • id serial PRIMARY KEY
  • limit_set integer UNIQUE #1 NOT NULL REFERENCES config.table.circ-limit-set
  • copy_loc integer UNIQUE #1 NOT NULL REFERENCES asset.table.copy-location

circ_limit_set_group_map

  • id serial PRIMARY KEY
  • limit_set integer UNIQUE #1 NOT NULL REFERENCES config.table.circ-limit-set
  • limit_group integer UNIQUE #1 NOT NULL REFERENCES config.table.circ-limit-group
  • check_only boolean NOT NULL DEFAULT false

circ_matrix_limit_set_map

  • id serial PRIMARY KEY
  • matchpoint integer UNIQUE #1 NOT NULL REFERENCES config.table.circ-matrix-matchpoint
  • limit_set integer UNIQUE #1 NOT NULL REFERENCES config.table.circ-limit-set
  • fallthrough boolean NOT NULL DEFAULT false
  • active boolean NOT NULL DEFAULT true

circ_matrix_matchpoint

  • id serial PRIMARY KEY
  • active boolean NOT NULL DEFAULT true
  • org_unit integer NOT NULL REFERENCES actor.table.org-unit
  • grp integer NOT NULL REFERENCES permission.table.grp-tree
  • circ_modifier text REFERENCES config.table.circ-modifier
  • copy_location integer REFERENCES asset.table.copy-location
  • marc_type text
  • marc_form text
  • marc_bib_level text
  • marc_vr_format text
  • copy_circ_lib integer REFERENCES actor.table.org-unit
  • copy_owning_lib integer REFERENCES actor.table.org-unit
  • user_home_ou integer REFERENCES actor.table.org-unit
  • ref_flag boolean
  • juvenile_flag boolean
  • is_renewal boolean
  • usr_age_lower_bound interval
  • usr_age_upper_bound interval
  • item_age interval
  • circulate boolean
  • duration_rule integer REFERENCES config.table.rule-circ-duration
  • recurring_fine_rule integer REFERENCES config.table.rule-recurring-fine
  • max_fine_rule integer REFERENCES config.table.rule-max-fine
  • hard_due_date integer REFERENCES config.table.hard-due-date
  • renewals integer
  • grace_period interval
  • script_test text
  • total_copy_hold_ratio double precision
  • available_copy_hold_ratio double precision

Tables referencing via foreign key constraints

  • config.circ_matrix_limit_set_map

circ_matrix_weights

  • id serial PRIMARY KEY
  • name text UNIQUE NOT NULL
  • org_unit numeric(6,2) NOT NULL
  • grp numeric(6,2) NOT NULL
  • circ_modifier numeric(6,2) NOT NULL
  • copy_location numeric(6,2) NOT NULL
  • marc_type numeric(6,2) NOT NULL
  • marc_form numeric(6,2) NOT NULL
  • marc_bib_level numeric(6,2) NOT NULL
  • marc_vr_format numeric(6,2) NOT NULL
  • copy_circ_lib numeric(6,2) NOT NULL
  • copy_owning_lib numeric(6,2) NOT NULL
  • user_home_ou numeric(6,2) NOT NULL
  • ref_flag numeric(6,2) NOT NULL
  • juvenile_flag numeric(6,2) NOT NULL
  • is_renewal numeric(6,2) NOT NULL
  • usr_age_lower_bound numeric(6,2) NOT NULL
  • usr_age_upper_bound numeric(6,2) NOT NULL
  • item_age numeric(6,2) NOT NULL

Tables referencing via foreign key constraints

  • config.weight_assoc

circ_modifier

  • 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
  • avg_wait_time interval

Tables referencing via foreign key constraints

  • acq.distribution_formula_entry
  • acq.lineitem_detail
  • actor.org_unit_proximity_adjustment
  • asset.copy
  • config.circ_limit_set_circ_mod_map
  • config.circ_matrix_matchpoint
  • config.hold_matrix_matchpoint
  • rating.badge

coded_value_map

  • id serial PRIMARY KEY
  • ctype text NOT NULL REFERENCES config.table.record-attr-definition
  • code text NOT NULL
  • value text NOT NULL
  • description text
  • opac_visible boolean NOT NULL DEFAULT true
  • search_label text
  • is_simple boolean NOT NULL DEFAULT false
  • concept_uri text

Indexes on coded_value_map

  • config_coded_value_map_ctype_idx ctype

Tables referencing via foreign key constraints

  • config.composite_attr_entry_definition

composite_attr_entry_definition

  • coded_value integer PRIMARY KEY REFERENCES config.table.coded-value-map
  • definition text NOT NULL

copy_status

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.

  • id serial PRIMARY KEY
  • name text UNIQUE NOT NULL
  • holdable boolean NOT NULL DEFAULT false
  • opac_visible boolean NOT NULL DEFAULT false
  • copy_active boolean NOT NULL DEFAULT false
  • restrict_copy_delete boolean NOT NULL DEFAULT false
  • is_available boolean NOT NULL DEFAULT false

Tables referencing via foreign key constraints

  • action.transit_copy
  • asset.copy
  • asset.copy_template

db_patch_dependencies

  • db_patch text PRIMARY KEY
  • supersedes text[]
  • deprecates text[]

filter_dialog_filter_set

  • id serial PRIMARY KEY
  • name text UNIQUE #1 NOT NULL
  • owning_lib integer UNIQUE #1 NOT NULL REFERENCES actor.table.org-unit
  • creator integer NOT NULL REFERENCES actor.table.usr
  • create_time timestamp with time zone NOT NULL DEFAULT now()
  • interface text NOT NULL REFERENCES config.table.filter-dialog-interface
  • filters text NOT NULL

Constraints on filter_dialog_filter_set

  • config_filter_dialog_filter_set_filters_check CHECK (is_json(filters))

filter_dialog_interface

  • key text PRIMARY KEY
  • description text

Tables referencing via foreign key constraints

  • config.filter_dialog_filter_set

floating_group

  • id serial PRIMARY KEY
  • name text UNIQUE NOT NULL
  • manual boolean NOT NULL DEFAULT false

Tables referencing via foreign key constraints

  • asset.copy
  • asset.copy_template
  • config.floating_group_member

floating_group_member

  • id serial PRIMARY KEY
  • floating_group integer NOT NULL REFERENCES config.table.floating-group
  • org_unit integer NOT NULL REFERENCES actor.table.org-unit
  • stop_depth integer NOT NULL
  • max_depth integer
  • exclude boolean NOT NULL DEFAULT false

global_flag

  • name text PRIMARY KEY
  • value text
  • enabled boolean NOT NULL DEFAULT false
  • label text NOT NULL

hard_due_date

  • id serial PRIMARY KEY
  • name text UNIQUE NOT NULL
  • ceiling_date timestamp with time zone NOT NULL
  • forceto boolean NOT NULL
  • owner integer NOT NULL

Tables referencing via foreign key constraints

  • config.circ_matrix_matchpoint
  • config.hard_due_date_values

hard_due_date_values

  • id serial PRIMARY KEY
  • hard_due_date integer NOT NULL REFERENCES config.table.hard-due-date
  • ceiling_date timestamp with time zone NOT NULL
  • active_date timestamp with time zone NOT NULL

hold_matrix_matchpoint

  • id serial PRIMARY KEY
  • active boolean NOT NULL DEFAULT true
  • strict_ou_match boolean NOT NULL DEFAULT false
  • user_home_ou integer REFERENCES actor.table.org-unit
  • request_ou integer REFERENCES actor.table.org-unit
  • pickup_ou integer REFERENCES actor.table.org-unit
  • item_owning_ou integer REFERENCES actor.table.org-unit
  • item_circ_ou integer REFERENCES actor.table.org-unit
  • usr_grp integer REFERENCES permission.table.grp-tree
  • requestor_grp integer NOT NULL REFERENCES permission.table.grp-tree
  • circ_modifier text REFERENCES config.table.circ-modifier
  • marc_type text
  • marc_form text
  • marc_bib_level text
  • marc_vr_format text
  • juvenile_flag boolean
  • ref_flag boolean
  • item_age interval
  • holdable boolean NOT NULL DEFAULT true
  • distance_is_from_owner boolean NOT NULL DEFAULT false
  • transit_range integer REFERENCES actor.table.org-unit-type
  • max_holds integer
  • include_frozen_holds boolean NOT NULL DEFAULT true
  • stop_blocked_user boolean NOT NULL DEFAULT false
  • age_hold_protect_rule integer REFERENCES config.table.rule-age-hold-protect

hold_matrix_weights

  • id serial PRIMARY KEY
  • name text UNIQUE NOT NULL
  • user_home_ou numeric(6,2) NOT NULL
  • request_ou numeric(6,2) NOT NULL
  • pickup_ou numeric(6,2) NOT NULL
  • item_owning_ou numeric(6,2) NOT NULL
  • item_circ_ou numeric(6,2) NOT NULL
  • usr_grp numeric(6,2) NOT NULL
  • requestor_grp numeric(6,2) NOT NULL
  • circ_modifier numeric(6,2) NOT NULL
  • marc_type numeric(6,2) NOT NULL
  • marc_form numeric(6,2) NOT NULL
  • marc_bib_level numeric(6,2) NOT NULL
  • marc_vr_format numeric(6,2) NOT NULL
  • juvenile_flag numeric(6,2) NOT NULL
  • ref_flag numeric(6,2) NOT NULL
  • item_age numeric(6,2) NOT NULL

Tables referencing via foreign key constraints

  • config.weight_assoc

i18n_core

  • id bigserial PRIMARY KEY
  • fq_field text NOT NULL
  • identity_value text NOT NULL
  • translation text NOT NULL REFERENCES config.table.i18n-locale
  • string text NOT NULL

i18n_locale

  • code text PRIMARY KEY
  • marc_code text NOT NULL
  • name text UNIQUE NOT NULL
  • description text

Tables referencing via foreign key constraints

  • config.i18n_core

identification_type

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.

  • id serial PRIMARY KEY
  • name text UNIQUE NOT NULL

Tables referencing via foreign key constraints

  • actor.usr

idl_field_doc

  • id bigserial PRIMARY KEY
  • fm_class text NOT NULL
  • field text NOT NULL
  • owner integer NOT NULL REFERENCES actor.table.org-unit
  • string text NOT NULL

index_normalizer

  • id serial PRIMARY KEY
  • name text UNIQUE NOT NULL
  • description text
  • func text NOT NULL
  • param_count integer NOT NULL

Tables referencing via foreign key constraints

  • config.metabib_field_index_norm_map
  • config.record_attr_index_norm_map

internal_flag

  • name text PRIMARY KEY
  • value text
  • enabled boolean NOT NULL DEFAULT false

item_form_map

  • code text
  • value text

item_type_map

  • code text
  • value text

language_map

  • code text
  • value text

lit_form_map

  • code text
  • value text
  • description text

marc21_ff_pos_map

  • id serial PRIMARY KEY
  • fixed_field text NOT NULL
  • tag text NOT NULL
  • rec_type text NOT NULL
  • start_pos integer NOT NULL
  • length integer NOT NULL
  • default_val text NOT NULL DEFAULT ' '::text

marc21_physical_characteristic_subfield_map

  • id serial PRIMARY KEY
  • ptype_key text NOT NULL REFERENCES config.table.marc21-physical-characteristic-type-map
  • subfield text NOT NULL
  • start_pos integer NOT NULL
  • length integer NOT NULL
  • label text NOT NULL

Tables referencing via foreign key constraints

  • config.marc21_physical_characteristic_value_map
  • config.record_attr_definition

marc21_physical_characteristic_type_map

  • ptype_key text PRIMARY KEY
  • label text NOT NULL

Tables referencing via foreign key constraints

  • config.marc21_physical_characteristic_subfield_map

marc21_physical_characteristic_value_map

  • id serial PRIMARY KEY
  • value text NOT NULL
  • ptype_subfield integer NOT NULL REFERENCES config.table.marc21-physical-characteristic-subfield-map
  • label text NOT NULL

marc21_rec_type_map

  • code text PRIMARY KEY
  • type_val text NOT NULL
  • blvl_val text NOT NULL

marc_field

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.

  • id serial PRIMARY KEY
  • marc_format integer NOT NULL REFERENCES config.table.marc-format
  • marc_record_type config.marc_record_type NOT NULL
  • tag character(3) NOT NULL
  • name text
  • description text
  • fixed_field boolean
  • repeatable boolean
  • mandatory boolean
  • hidden boolean
  • owner integer REFERENCES actor.table.org-unit

Constraints on marc_field

  • config_standard_marc_tags_are_fully_specified CHECK

Indexes on marc_field

  • config_marc_field_owner_idx owner
  • config_marc_field_tag_idx tag

marc_field_for_ou

  • id integer
  • marc_format integer
  • marc_record_type config.marc_record_type
  • tag character(3)
  • name text
  • description text
  • fixed_field boolean
  • repeatable boolean
  • mandatory boolean
  • hidden boolean
  • owner integer
  • depth integer

marc_format

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.

  • id serial PRIMARY KEY
  • code text NOT NULL
  • name text NOT NULL

Tables referencing via foreign key constraints

  • config.marc_field
  • config.marc_subfield

marc_subfield

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.

  • id serial PRIMARY KEY
  • marc_format integer NOT NULL REFERENCES config.table.marc-format
  • marc_record_type config.marc_record_type NOT NULL
  • tag character(3) NOT NULL
  • code character(1) NOT NULL
  • description text
  • repeatable boolean
  • mandatory boolean
  • hidden boolean
  • value_ctype text REFERENCES config.table.record-attr-definition
  • owner integer REFERENCES actor.table.org-unit

Constraints on marc_subfield

  • config_standard_marc_subfields_are_fully_specified CHECK

Indexes on marc_subfield

  • config_marc_subfield_tag_code_idx tag, code

marc_subfield_for_ou

  • id integer
  • marc_format integer
  • marc_record_type config.marc_record_type
  • tag character(3)
  • code character(1)
  • description text
  • repeatable boolean
  • mandatory boolean
  • hidden boolean
  • value_ctype text
  • owner integer
  • depth integer

metabib_class

  • name text PRIMARY KEY
  • label text UNIQUE NOT NULL
  • buoyant boolean NOT NULL DEFAULT false
  • restrict boolean NOT NULL DEFAULT false
  • combined boolean NOT NULL DEFAULT false
  • a_weight numeric NOT NULL DEFAULT 1.0
  • b_weight numeric NOT NULL DEFAULT 0.4
  • c_weight numeric NOT NULL DEFAULT 0.2
  • d_weight numeric NOT NULL DEFAULT 0.1

Tables referencing via foreign key constraints

  • config.metabib_class_ts_map
  • config.metabib_field
  • config.metabib_search_alias

metabib_class_ts_map

Text Search Configs for metabib class indexing

This table contains text search config definitions for storing index_vector values.

  • id serial PRIMARY KEY
  • field_class text NOT NULL REFERENCES config.table.metabib-class
  • ts_config text NOT NULL REFERENCES config.table.ts-config-list
  • active boolean NOT NULL DEFAULT true
  • index_weight character(1) NOT NULL DEFAULT 'C'::bpchar
  • index_lang text
  • search_lang text
  • always boolean NOT NULL DEFAULT true

Constraints on metabib_class_ts_map

  • metabib_class_ts_map_index_weight_check CHECK index_weight = ANY (ARRAY['A'::bpchar

metabib_field

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.

  • id serial PRIMARY KEY
  • field_class text NOT NULL REFERENCES config.table.metabib-class
  • name text NOT NULL
  • label text NOT NULL
  • xpath text NOT NULL
  • weight integer NOT NULL DEFAULT 1
  • format text NOT NULL DEFAULT 'mods33'::text REFERENCES config.table.xml-transform
  • search_field boolean NOT NULL DEFAULT true
  • facet_field boolean NOT NULL DEFAULT false
  • browse_field boolean NOT NULL DEFAULT true
  • browse_xpath text
  • browse_sort_xpath text
  • facet_xpath text
  • authority_xpath text
  • joiner text
  • restrict boolean NOT NULL DEFAULT false

Tables referencing via foreign key constraints

  • authority.control_set_bib_field_metabib_field_map
  • config.metabib_field_index_norm_map
  • config.metabib_field_ts_map
  • config.metabib_search_alias
  • config.z3950_index_field_map
  • metabib.author_field_entry
  • metabib.browse_entry_def_map
  • metabib.identifier_field_entry
  • metabib.keyword_field_entry
  • metabib.series_field_entry
  • metabib.subject_field_entry
  • metabib.title_field_entry
  • search.relevance_adjustment

metabib_field_index_norm_map

  • id serial PRIMARY KEY
  • field integer NOT NULL REFERENCES config.table.metabib-field
  • norm integer NOT NULL REFERENCES config.table.index-normalizer
  • params text
  • pos integer NOT NULL

metabib_field_ts_map

Text Search Configs for metabib field indexing

This table contains text search config definitions for storing index_vector values.

  • id serial PRIMARY KEY
  • metabib_field integer NOT NULL REFERENCES config.table.metabib-field
  • ts_config text NOT NULL REFERENCES config.table.ts-config-list
  • active boolean NOT NULL DEFAULT true
  • index_weight character(1) NOT NULL DEFAULT 'C'::bpchar
  • index_lang text
  • search_lang text

Constraints on metabib_field_ts_map

  • metabib_field_ts_map_index_weight_check CHECK index_weight = ANY (ARRAY['A'::bpchar

metabib_search_alias

  • alias text PRIMARY KEY
  • field_class text NOT NULL REFERENCES config.table.metabib-class
  • field integer REFERENCES config.table.metabib-field

net_access_level

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.

  • id serial PRIMARY KEY
  • name text UNIQUE NOT NULL

Tables referencing via foreign key constraints

  • actor.usr

non_cataloged_type

Types of valid non-cataloged items.

  • 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 via foreign key constraints

  • action.non_cat_in_house_use
  • action.non_cataloged_circulation

org_unit_setting_type

  • name text PRIMARY KEY
  • label text UNIQUE NOT NULL
  • grp text REFERENCES config.table.settings-group
  • description text
  • datatype text NOT NULL DEFAULT 'string'::text
  • fm_class text
  • view_perm integer REFERENCES permission.table.perm-list
  • update_perm integer REFERENCES permission.table.perm-list

Constraints on org_unit_setting_type

  • coust_no_empty_link CHECK ((((datatype = 'link'::text) AND (fm_class IS NOT NULL)) OR datatype <> 'link'::text) AND (fm_class IS NULL))
  • coust_valid_datatype CHECK datatype = ANY (ARRAY['bool'::text

Tables referencing via foreign key constraints

  • actor.org_unit_setting
  • config.org_unit_setting_type_log

org_unit_setting_type_log

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.

  • id bigserial PRIMARY KEY
  • date_applied timestamp with time zone NOT NULL DEFAULT now()
  • org integer REFERENCES actor.table.org-unit
  • original_value text
  • new_value text
  • field_name text REFERENCES config.table.org-unit-setting-type

record_attr_definition

  • name text PRIMARY KEY
  • label text NOT NULL
  • description text
  • multi boolean NOT NULL DEFAULT true
  • filter boolean NOT NULL DEFAULT true
  • sorter boolean NOT NULL DEFAULT false
  • composite boolean NOT NULL DEFAULT false
  • tag text
  • sf_list text
  • joiner text
  • xpath text
  • format text REFERENCES config.table.xml-transform
  • start_pos integer
  • string_len integer
  • fixed_field text
  • phys_char_sf integer REFERENCES config.table.marc21-physical-characteristic-subfield-map
  • vocabulary text

Tables referencing via foreign key constraints

  • authority.browse_axis
  • config.coded_value_map
  • config.marc_subfield
  • config.record_attr_index_norm_map
  • config.z3950_index_field_map
  • metabib.record_sorter
  • metabib.uncontrolled_record_attr_value
  • vandelay.match_set_point
  • vandelay.match_set_quality

record_attr_index_norm_map

  • id serial PRIMARY KEY
  • attr text NOT NULL REFERENCES config.table.record-attr-definition
  • norm integer NOT NULL REFERENCES config.table.index-normalizer
  • params text
  • pos integer NOT NULL

remote_account

  • id serial PRIMARY KEY
  • label text NOT NULL
  • host text NOT NULL
  • username text
  • password text
  • account text
  • path text
  • owner integer NOT NULL REFERENCES actor.table.org-unit
  • last_activity timestamp with time zone

rule_age_hold_protect

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.

  • 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 via foreign key constraints

  • config.hold_matrix_matchpoint

rule_circ_duration

Circulation Duration rules

Each circulation is given a duration based on one of these rules.

  • 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 via foreign key constraints

  • config.circ_matrix_matchpoint

rule_max_fine

Circulation Max Fine rules

Each circulation is given a maximum fine based on one of these rules.

  • 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 via foreign key constraints

  • config.circ_matrix_matchpoint

rule_recurring_fine

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.

  • 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
  • recurrence_interval interval NOT NULL DEFAULT '1 day'::interval
  • grace_period interval NOT NULL DEFAULT '1 day'::interval

Constraints on rule_recurring_fine

  • rule_recurring_fine_name_check CHECK name ~ '^\w+$'::text

Tables referencing via foreign key constraints

  • config.circ_matrix_matchpoint

settings_group

  • name text PRIMARY KEY
  • label text UNIQUE NOT NULL

Tables referencing via foreign key constraints

  • config.org_unit_setting_type
  • config.usr_setting_type

sms_carrier

  • id serial PRIMARY KEY
  • region text
  • name text
  • email_gateway text
  • active boolean DEFAULT true

Tables referencing via foreign key constraints

  • action.hold_request

standing

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. :(

  • id serial PRIMARY KEY
  • value text UNIQUE NOT NULL

Tables referencing via foreign key constraints

  • actor.usr

standing_penalty

  • id serial PRIMARY KEY
  • name text UNIQUE NOT NULL
  • label text NOT NULL
  • block_list text
  • staff_alert boolean NOT NULL DEFAULT false
  • org_depth integer
  • ignore_proximity integer

Tables referencing via foreign key constraints

  • actor.usr_standing_penalty
  • permission.grp_penalty_threshold

ts_config_list

Full Text Configs

A list of full text configs with names and descriptions.

  • id text PRIMARY KEY
  • name text NOT NULL

Tables referencing via foreign key constraints

  • config.metabib_class_ts_map
  • config.metabib_field_ts_map

upgrade_log

  • version text PRIMARY KEY
  • install_date timestamp with time zone NOT NULL DEFAULT now()
  • applied_to text

usr_activity_type

  • id serial PRIMARY KEY
  • ewho text
  • ewhat text
  • ehow text
  • label text NOT NULL
  • egroup config.usr_activity_group NOT NULL
  • enabled boolean NOT NULL DEFAULT true
  • transient boolean NOT NULL DEFAULT true

Constraints on usr_activity_type

  • one_of_wwh CHECK COALESCE(ewho

Tables referencing via foreign key constraints

  • actor.usr_activity

usr_setting_type

  • name text PRIMARY KEY
  • opac_visible boolean NOT NULL DEFAULT false
  • label text UNIQUE NOT NULL
  • description text
  • grp text REFERENCES config.table.settings-group
  • datatype text NOT NULL DEFAULT 'string'::text
  • fm_class text
  • reg_default text

Constraints on usr_setting_type

  • coust_no_empty_link CHECK ((((datatype = 'link'::text) AND (fm_class IS NOT NULL)) OR datatype <> 'link'::text) AND (fm_class IS NULL))
  • coust_valid_datatype CHECK datatype = ANY (ARRAY['bool'::text

Tables referencing via foreign key constraints

  • action_trigger.event_definition
  • actor.usr_setting

videorecording_format_map

  • code text
  • value text

weight_assoc

  • id serial PRIMARY KEY
  • active boolean NOT NULL
  • org_unit integer NOT NULL REFERENCES actor.table.org-unit
  • circ_weights integer REFERENCES config.table.circ-matrix-weights
  • hold_weights integer REFERENCES config.table.hold-matrix-weights

xml_transform

  • name text PRIMARY KEY
  • namespace_uri text NOT NULL
  • prefix text NOT NULL
  • xslt text NOT NULL

Tables referencing via foreign key constraints

  • config.metabib_field
  • config.record_attr_definition
  • unapi.bre_output_layout

z3950_attr

  • id serial PRIMARY KEY
  • source text UNIQUE #1 NOT NULL REFERENCES config.table.z3950-source
  • name text NOT NULL
  • label text NOT NULL
  • code integer UNIQUE #1 NOT NULL
  • format integer UNIQUE #1 NOT NULL
  • truncation integer NOT NULL

Tables referencing via foreign key constraints

  • config.z3950_index_field_map

z3950_index_field_map

  • id serial PRIMARY KEY
  • label text NOT NULL
  • metabib_field integer REFERENCES config.table.metabib-field
  • record_attr text REFERENCES config.table.record-attr-definition
  • z3950_attr integer REFERENCES config.table.z3950-attr
  • z3950_attr_type text

Constraints on z3950_index_field_map

  • attr_or_attr_type CHECK
  • metabib_field_or_record_attr CHECK

z3950_source

Z39.50 Sources

Each row in this table represents a database searchable via Z39.50.

  • 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 Z39.50 element set.
  • transmission_format text NOT NULL DEFAULT 'usmarc'::text Z39.50 preferred record syntax..
  • auth boolean NOT NULL DEFAULT true
  • use_perm integer REFERENCES permission.table.perm-list If set, this permission is required for the source to be listed in the staff client Z39.50 interface. Similar to permission.grp_tree.application_perm.

Tables referencing via foreign key constraints

  • config.z3950_attr
  • config.z3950_source_credentials

z3950_source_credentials

  • id serial PRIMARY KEY
  • owner integer UNIQUE #1 NOT NULL REFERENCES actor.table.org-unit
  • source text UNIQUE #1 NOT NULL REFERENCES config.table.z3950-source
  • username text
  • password text