config.hold_matrix_weights

Columns

Column Type Nullable Default Notes

id PK

integer

No

nextval('config.hold_matrix_weights_id_seq'::regclass)

name

text

No

user_home_ou

numeric(6,2)

No

request_ou

numeric(6,2)

No

pickup_ou

numeric(6,2)

No

item_owning_ou

numeric(6,2)

No

item_circ_ou

numeric(6,2)

No

copy_location

numeric(6,2)

No

usr_grp

numeric(6,2)

No

requestor_grp

numeric(6,2)

No

circ_modifier

numeric(6,2)

No

marc_type

numeric(6,2)

No

marc_form

numeric(6,2)

No

marc_bib_level

numeric(6,2)

No

marc_vr_format

numeric(6,2)

No

juvenile_flag

numeric(6,2)

No

ref_flag

numeric(6,2)

No

item_age

numeric(6,2)

No

Primary Key

(id)

Unique Constraints

  • hold_matrix_weights_name_key: (name)

Indexes

Index Method Definition

hold_matrix_weights_pkey PK

btree

CREATE UNIQUE INDEX hold_matrix_weights_pkey ON config.hold_matrix_weights USING btree (id)

hold_matrix_weights_name_key UNIQUE

btree

CREATE UNIQUE INDEX hold_matrix_weights_name_key ON config.hold_matrix_weights USING btree (name)

Referenced By

The following tables have foreign keys pointing to config.hold_matrix_weights (1 referencing table(s)):

Table Referencing Column(s) Referenced Column(s) Constraint

config.weight_assoc

hold_weights

id

weight_assoc_hold_weights_fkey