Chapter 10. Schema config


Home Prev		Next

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

Tables referencing via foreign key constraints

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

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

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
metabib.table.record-sorter
metabib.table.uncontrolled-record-attr-value
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