rule_age_hold_protect

-1 rows


Description

Hold Item Age Protection rules

A hold request can only capture new(ish) items when they are within a particular proximity of the pickup_lib of the request. The proximity (‘prox’ column) is calculated by counting the number of tree edges between the pickup_lib and either the owning_lib or circ_lib of the copy that could fulfill the hold, as determined by the distance_is_from_owner value of the hold matrix rule controlling the hold request.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('config.rule_age_hold_protect_id_seq'::regclass)
hold_matrix_matchpoint.age_hold_protect_rule hold_matrix_matchpoint_age_hold_protect_rule_fkey R
name text 2147483647 null
age interval 49,6 null
prox int4 10 null

Indexes

Constraint Name Type Sort Column(s)
rule_age_hold_protect_pkey Primary key Asc id
rule_age_hold_protect_name_key Must be unique Asc name

Check Constraints

Constraint Name Constraint
rule_age_hold_protect_name_check ((name ~ '^\w+$'::text))

Relationships

Close relationships within degrees of separation