hold_matrix_matchpoint

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('config.hold_matrix_matchpoint_id_seq'::regclass)
active bool 1 true
strict_ou_match bool 1 false
user_home_ou int4 10 √ null
org_unit.id hold_matrix_matchpoint_user_home_ou_fkey R
request_ou int4 10 √ null
org_unit.id hold_matrix_matchpoint_request_ou_fkey R
pickup_ou int4 10 √ null
org_unit.id hold_matrix_matchpoint_pickup_ou_fkey R
item_owning_ou int4 10 √ null
org_unit.id hold_matrix_matchpoint_item_owning_ou_fkey R
item_circ_ou int4 10 √ null
org_unit.id hold_matrix_matchpoint_item_circ_ou_fkey R
usr_grp int4 10 √ null
grp_tree.id hold_matrix_matchpoint_usr_grp_fkey R
requestor_grp int4 10 null
grp_tree.id hold_matrix_matchpoint_requestor_grp_fkey R
circ_modifier text 2147483647 √ null
circ_modifier.code hold_matrix_matchpoint_circ_modifier_fkey R
marc_type text 2147483647 √ null
marc_form text 2147483647 √ null
marc_bib_level text 2147483647 √ null
marc_vr_format text 2147483647 √ null
juvenile_flag bool 1 √ null
ref_flag bool 1 √ null
item_age interval 49,6 √ null
holdable bool 1 true
distance_is_from_owner bool 1 false
transit_range int4 10 √ null
org_unit_type.id hold_matrix_matchpoint_transit_range_fkey R
max_holds int4 10 √ null
include_frozen_holds bool 1 true
stop_blocked_user bool 1 false
age_hold_protect_rule int4 10 √ null
rule_age_hold_protect.id hold_matrix_matchpoint_age_hold_protect_rule_fkey R
description text 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
hold_matrix_matchpoint_pkey Primary key Asc id
chmm_once_per_paramset Must be unique

Relationships

Close relationships within degrees of separation