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

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

• bib_source_quality_check CHECK

• [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)

• [money.table.billing]

circ_limit_group

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

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

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

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

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

• [acq.table.lineitem-detail]
• [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

• [action.table.transit-copy]
• [asset.table.copy]
• [asset.table.copy-template]

db_patch_dependencies

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

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

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

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

• [config.table.i18n-core]

identification_type

• id serial PRIMARY KEY
• name text UNIQUE NOT NULL

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

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

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

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

• [config.table.metabib-field]
• [config.table.metabib-search-alias]

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
• facet_xpath text
• restrict boolean NOT NULL DEFAULT false

• [config.table.metabib-field-index-norm-map]
• [config.table.metabib-search-alias]
• [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_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

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

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

• 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

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

• [authority.table.browse-axis]
• [config.table.coded-value-map]
• [config.table.record-attr-index-norm-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

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

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

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

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

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

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

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

• [config.table.circ-matrix-matchpoint]

settings_group

• name text PRIMARY KEY
• label text UNIQUE NOT NULL

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

• [action.table.hold-request]

standing

• id serial PRIMARY KEY
• value text UNIQUE NOT NULL

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

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

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

• one_of_wwh CHECK COALESCE(ewho

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

• 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

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

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

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.

• [config.table.z3950-attr]