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

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 (((((((((pprox IS NOT NULL) OR (hprox IS NOT NULL)) OR (aprox IS NOT NULL)) OR (priority IS NOT NULL)) OR (cut IS NOT NULL)) OR (depth IS NOT NULL)) OR (htime IS NOT NULL)) OR (rtime IS NOT NULL)))

bib_level_map

  • code text
  • value text

bib_source

  • 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

  • vandelay.table.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.table.billing

circ_limit_group

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

Tables referencing via foreign key constraints

  • action.table.circulation-limit-group-map
  • config.table.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.table.circ-limit-set-circ-mod-map
  • config.table.circ-limit-set-copy-loc-map
  • config.table.circ-limit-set-group-map
  • config.table.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.table.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.table.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.table.distribution-formula-entry
  • acq.table.lineitem-detail
  • actor.table.org-unit-proximity-adjustment
  • asset.table.copy
  • config.table.circ-limit-set-circ-mod-map
  • config.table.circ-matrix-matchpoint
  • config.table.hold-matrix-matchpoint

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

copy_status

  • 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

Tables referencing via foreign key constraints

  • action.table.transit-copy
  • asset.table.copy
  • asset.table.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.table.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.table.copy
  • asset.table.copy-template
  • config.table.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.table.circ-matrix-matchpoint
  • config.table.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.table.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.table.i18n-core

identification_type

  • id serial PRIMARY KEY
  • name text UNIQUE NOT NULL

Tables referencing via foreign key constraints

  • actor.table.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.table.metabib-field-index-norm-map
  • config.table.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.table.marc21-physical-characteristic-value-map
  • config.table.record-attr-definition

marc21_physical_characteristic_type_map

  • ptype_key text PRIMARY KEY
  • label text NOT NULL

Tables referencing via foreign key constraints

  • config.table.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

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.table.metabib-class-ts-map
  • config.table.metabib-field
  • config.table.metabib-search-alias

metabib_class_ts_map

  • 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

  • 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.table.control-set-bib-field-metabib-field-map
  • config.table.metabib-field-index-norm-map
  • config.table.metabib-field-ts-map
  • config.table.metabib-search-alias
  • config.table.z3950-index-field-map
  • metabib.table.author-field-entry
  • metabib.table.browse-entry-def-map
  • metabib.table.identifier-field-entry
  • metabib.table.keyword-field-entry
  • metabib.table.series-field-entry
  • metabib.table.subject-field-entry
  • metabib.table.title-field-entry
  • search.table.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

  • 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

  • id serial PRIMARY KEY
  • name text UNIQUE NOT NULL

Tables referencing via foreign key constraints

  • actor.table.usr

non_cataloged_type

  • 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.table.non-cat-in-house-use
  • action.table.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.table.org-unit-setting
  • config.table.org-unit-setting-type-log

org_unit_setting_type_log

  • 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
  • filter boolean NOT NULL DEFAULT true
  • sorter 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

Tables referencing via foreign key constraints

  • authority.table.browse-axis
  • config.table.coded-value-map
  • config.table.record-attr-index-norm-map
  • config.table.z3950-index-field-map
  • vandelay.table.match-set-point
  • vandelay.table.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

  • 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.table.hold-matrix-matchpoint

rule_circ_duration

  • 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.table.circ-matrix-matchpoint

rule_max_fine

  • 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.table.circ-matrix-matchpoint

rule_recurring_fine

  • 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.table.circ-matrix-matchpoint

settings_group

  • name text PRIMARY KEY
  • label text UNIQUE NOT NULL

Tables referencing via foreign key constraints

  • config.table.org-unit-setting-type
  • config.table.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.table.hold-request

standing

  • id serial PRIMARY KEY
  • value text UNIQUE NOT NULL

Tables referencing via foreign key constraints

  • actor.table.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

Tables referencing via foreign key constraints

  • actor.table.usr-standing-penalty
  • permission.table.grp-penalty-threshold

ts_config_list

  • id text PRIMARY KEY
  • name text NOT NULL

Tables referencing via foreign key constraints

  • config.table.metabib-class-ts-map
  • config.table.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 false Constraints on usr_activity_type * one_of_wwh CHECK COALESCE(ewho

Tables referencing via foreign key constraints

  • actor.table.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.table.event-definition
  • actor.table.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.table.metabib-field
  • config.table.record-attr-definition
  • unapi.table.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.table.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
  • valid_z3950_attr_type CHECK

z3950_source

  • 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.table.z3950-attr
  • config.table.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