circ_matrix_matchpoint

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('config.circ_matrix_matchpoint_id_seq'::regclass)
circ_matrix_limit_set_map.matchpoint circ_matrix_limit_set_map_matchpoint_fkey C
active bool 1 true
org_unit int4 10 null
org_unit.id circ_matrix_matchpoint_org_unit_fkey R
grp int4 10 null
grp_tree.id circ_matrix_matchpoint_grp_fkey R
circ_modifier text 2147483647 √ null
circ_modifier.code circ_matrix_matchpoint_circ_modifier_fkey R
copy_location int4 10 √ null
copy_location.id circ_matrix_matchpoint_copy_location_fkey R
marc_type text 2147483647 √ null
marc_form text 2147483647 √ null
marc_bib_level text 2147483647 √ null
marc_vr_format text 2147483647 √ null
copy_circ_lib int4 10 √ null
org_unit.id circ_matrix_matchpoint_copy_circ_lib_fkey R
copy_owning_lib int4 10 √ null
org_unit.id circ_matrix_matchpoint_copy_owning_lib_fkey R
user_home_ou int4 10 √ null
org_unit.id circ_matrix_matchpoint_user_home_ou_fkey R
ref_flag bool 1 √ null
juvenile_flag bool 1 √ null
is_renewal bool 1 √ null
usr_age_lower_bound interval 49,6 √ null
usr_age_upper_bound interval 49,6 √ null
item_age interval 49,6 √ null
circulate bool 1 √ null
duration_rule int4 10 √ null
rule_circ_duration.id circ_matrix_matchpoint_duration_rule_fkey R
recurring_fine_rule int4 10 √ null
rule_recurring_fine.id circ_matrix_matchpoint_recurring_fine_rule_fkey R
max_fine_rule int4 10 √ null
rule_max_fine.id circ_matrix_matchpoint_max_fine_rule_fkey R
hard_due_date int4 10 √ null
hard_due_date.id circ_matrix_matchpoint_hard_due_date_fkey R
renewals int4 10 √ null
grace_period interval 49,6 √ null
script_test text 2147483647 √ null
total_copy_hold_ratio float8 17,17 √ null
available_copy_hold_ratio float8 17,17 √ null
description text 2147483647 √ null
renew_extends_due_date bool 1 false
renew_extend_min_interval interval 49,6 √ null

Indexes

Constraint Name Type Sort Column(s)
circ_matrix_matchpoint_pkey Primary key Asc id
ccmm_once_per_paramset Must be unique Asc/Asc org_unit + grp

Relationships

Close relationships within degrees of separation