Evergreen
HomePrev   Next

Chapter 10. Schema config

Table of Contents

Tables in config
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

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

circ_limit_group

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

Tables referencing via foreign key constraints

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

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_circ_mod_test

  • id serial PRIMARY KEY
  • matchpoint integer NOT NULL REFERENCES config.table.circ-matrix-matchpoint
  • items_out integer NOT NULL

Tables referencing via foreign key constraints

circ_matrix_circ_mod_test_map

  • id serial PRIMARY KEY
  • circ_mod_test integer UNIQUE #1 NOT NULL REFERENCES config.table.circ-matrix-circ-mod-test
  • circ_mod text UNIQUE #1 NOT NULL REFERENCES config.table.circ-modifier

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
  • marc_type text
  • marc_form text
  • marc_vr_format text
  • ref_flag boolean
  • is_renewal boolean
  • usr_age_lower_bound interval
  • usr_age_upper_bound interval
  • juvenile_flag boolean
  • 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
  • script_test text
  • hard_due_date integer REFERENCES config.table.hard-due-date
  • total_copy_hold_ratio double precision
  • available_copy_hold_ratio double precision
  • copy_circ_lib integer REFERENCES actor.table.org-unit
  • copy_owning_lib integer REFERENCES actor.table.org-unit
  • renewals integer
  • user_home_ou integer REFERENCES actor.table.org-unit
  • grace_period interval
  • marc_bib_level text
  • item_age interval
  • copy_location integer REFERENCES asset.table.copy-location

Tables referencing via foreign key constraints

circ_matrix_test

  • matchpoint integer PRIMARY KEY REFERENCES config.table.circ-matrix-matchpoint
  • circulate boolean NOT NULL DEFAULT true
  • max_items_out integer
  • max_overdue integer
  • max_fines numeric(8,2)
  • org_depth integer
  • script_test text

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
  • marc_type numeric(6,2) NOT NULL
  • marc_form 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
  • marc_bib_level numeric(6,2) NOT NULL
  • item_age numeric(6,2) NOT NULL
  • copy_location numeric(6,2) NOT NULL

Tables referencing via foreign key constraints

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

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

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

  • 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

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

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
  • 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_vr_format text
  • ref_flag boolean
  • juvenile_flag boolean
  • age_hold_protect_rule integer REFERENCES config.table.rule-age-hold-protect
  • 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
  • strict_ou_match boolean NOT NULL DEFAULT false
  • marc_bib_level text
  • item_age interval

Tables referencing via foreign key constraints

hold_matrix_test

  • matchpoint integer PRIMARY KEY REFERENCES config.table.hold-matrix-matchpoint
  • 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_vr_format numeric(6,2) NOT NULL
  • juvenile_flag numeric(6,2) NOT NULL
  • ref_flag numeric(6,2) NOT NULL
  • marc_bib_level numeric(6,2) NOT NULL
  • item_age numeric(6,2) NOT NULL

Tables referencing via foreign key constraints

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

identification_type

  • id serial PRIMARY KEY
  • name text UNIQUE NOT NULL

Tables referencing via foreign key constraints

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

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

marc21_physical_characteristic_type_map

  • ptype_key text PRIMARY KEY
  • label text NOT NULL

Tables referencing via foreign key constraints

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
  • restrict boolean NOT NULL DEFAULT false
  • buoyant 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
  • combined boolean NOT NULL DEFAULT false

Tables referencing via foreign key constraints

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
  • xpath text NOT NULL
  • weight integer NOT NULL DEFAULT 1
  • format text NOT NULL DEFAULT 'mods32'::text REFERENCES config.table.xml-transform
  • search_field boolean NOT NULL DEFAULT true
  • facet_field boolean NOT NULL DEFAULT false
  • label text NOT NULL
  • facet_xpath text
  • browse_field boolean NOT NULL DEFAULT true
  • browse_xpath text
  • restrict boolean NOT NULL DEFAULT false

Tables referencing via foreign key constraints

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

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

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

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

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

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

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

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_recuring_fine_name_check CHECK name ~ '^\w+$'::text

Tables referencing via foreign key constraints

settings_group

  • name text PRIMARY KEY
  • label text UNIQUE NOT NULL

Tables referencing via foreign key constraints

sms_carrier

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

Tables referencing via foreign key constraints

standing

  • id serial PRIMARY KEY
  • value text UNIQUE NOT NULL

Tables referencing via foreign key constraints

standing_penalty

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

Tables referencing via foreign key constraints

ts_config_list

  • id text PRIMARY KEY
  • name text NOT NULL

Tables referencing via foreign key constraints

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

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

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

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

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
  • transmission_format text NOT NULL DEFAULT 'usmarc'::text
  • 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

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
Prev   Next
Chapter 9. Schema booking Home Functions in config