config.circ_matrix_matchpoint

↑ config schema

Deferrable Constraints: The following FK constraints are deferrable — they are checked at transaction end, not statement end: circ_matrix_matchpoint_circ_modifier_fkey, circ_matrix_matchpoint_copy_circ_lib_fkey, circ_matrix_matchpoint_copy_location_fkey, circ_matrix_matchpoint_copy_owning_lib_fkey, circ_matrix_matchpoint_duration_rule_fkey, circ_matrix_matchpoint_grp_fkey, circ_matrix_matchpoint_hard_due_date_fkey, circ_matrix_matchpoint_max_fine_rule_fkey, circ_matrix_matchpoint_org_unit_fkey, circ_matrix_matchpoint_recurring_fine_rule_fkey, circ_matrix_matchpoint_user_home_ou_fkey.

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`integer`	No	nextval('config.circ_matrix_matchpoint_id_seq'::regclass)
active	`boolean`	No	true
org_unit FK	`integer`	No		→ actor.org_unit(id)
grp FK	`integer`	No		→ permission.grp_tree(id)
circ_modifier FK	`text`	Yes		→ config.circ_modifier(code)
copy_location FK	`integer`	Yes		→ asset.copy_location(id)
marc_type	`text`	Yes
marc_form	`text`	Yes
marc_bib_level	`text`	Yes
marc_vr_format	`text`	Yes
copy_circ_lib FK	`integer`	Yes		→ actor.org_unit(id)
copy_owning_lib FK	`integer`	Yes		→ actor.org_unit(id)
user_home_ou FK	`integer`	Yes		→ actor.org_unit(id)
ref_flag	`boolean`	Yes
juvenile_flag	`boolean`	Yes
is_renewal	`boolean`	Yes
usr_age_lower_bound	`interval`	Yes
usr_age_upper_bound	`interval`	Yes
item_age	`interval`	Yes
circulate	`boolean`	Yes
duration_rule FK	`integer`	Yes		→ config.rule_circ_duration(id)
recurring_fine_rule FK	`integer`	Yes		→ config.rule_recurring_fine(id)
max_fine_rule FK	`integer`	Yes		→ config.rule_max_fine(id)
hard_due_date FK	`integer`	Yes		→ config.hard_due_date(id)
renewals	`integer`	Yes
grace_period	`interval`	Yes
script_test	`text`	Yes
total_copy_hold_ratio	`double precision`	Yes
available_copy_hold_ratio	`double precision`	Yes
description	`text`	Yes
renew_extends_due_date	`boolean`	No	false
renew_extend_min_interval	`interval`	Yes

id PK

integer

nextval('config.circ_matrix_matchpoint_id_seq'::regclass)

active

boolean

true

org_unit FK

integer

→ actor.org_unit(id)

grp FK

integer

→ permission.grp_tree(id)

circ_modifier FK

text

Yes

→ config.circ_modifier(code)

copy_location FK

integer

Yes

→ asset.copy_location(id)

marc_type

text

Yes

marc_form

text

Yes

marc_bib_level

text

Yes

marc_vr_format

text

Yes

copy_circ_lib FK

integer

Yes

→ actor.org_unit(id)

copy_owning_lib FK

integer

Yes

→ actor.org_unit(id)

user_home_ou FK

integer

Yes

→ actor.org_unit(id)

ref_flag

boolean

Yes

juvenile_flag

boolean

Yes

is_renewal

boolean

Yes

usr_age_lower_bound

interval

Yes

usr_age_upper_bound

interval

Yes

item_age

interval

Yes

circulate

boolean

Yes

duration_rule FK

integer

Yes

→ config.rule_circ_duration(id)

recurring_fine_rule FK

integer

Yes

→ config.rule_recurring_fine(id)

max_fine_rule FK

integer

Yes

→ config.rule_max_fine(id)

hard_due_date FK

integer

Yes

→ config.hard_due_date(id)

renewals

integer

Yes

grace_period

interval

Yes

script_test

text

Yes

total_copy_hold_ratio

double precision

Yes

available_copy_hold_ratio

double precision

Yes

description

text

Yes

renew_extends_due_date

boolean

false

renew_extend_min_interval

interval

Yes

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`circ_modifier`	config.circ_modifier(code)	NO ACTION	NO ACTION	DEFERRED	`circ_matrix_matchpoint_circ_modifier_fkey`
`copy_circ_lib`	actor.org_unit(id)	NO ACTION	NO ACTION	DEFERRED	`circ_matrix_matchpoint_copy_circ_lib_fkey`
`copy_location`	asset.copy_location(id)	NO ACTION	NO ACTION	DEFERRED	`circ_matrix_matchpoint_copy_location_fkey`
`copy_owning_lib`	actor.org_unit(id)	NO ACTION	NO ACTION	DEFERRED	`circ_matrix_matchpoint_copy_owning_lib_fkey`
`duration_rule`	config.rule_circ_duration(id)	NO ACTION	NO ACTION	DEFERRED	`circ_matrix_matchpoint_duration_rule_fkey`
`grp`	permission.grp_tree(id)	NO ACTION	NO ACTION	DEFERRED	`circ_matrix_matchpoint_grp_fkey`
`hard_due_date`	config.hard_due_date(id)	NO ACTION	NO ACTION	DEFERRED	`circ_matrix_matchpoint_hard_due_date_fkey`
`max_fine_rule`	config.rule_max_fine(id)	NO ACTION	NO ACTION	DEFERRED	`circ_matrix_matchpoint_max_fine_rule_fkey`
`org_unit`	actor.org_unit(id)	NO ACTION	NO ACTION	DEFERRED	`circ_matrix_matchpoint_org_unit_fkey`
`recurring_fine_rule`	config.rule_recurring_fine(id)	NO ACTION	NO ACTION	DEFERRED	`circ_matrix_matchpoint_recurring_fine_rule_fkey`
`user_home_ou`	actor.org_unit(id)	NO ACTION	NO ACTION	DEFERRED	`circ_matrix_matchpoint_user_home_ou_fkey`

circ_modifier

config.circ_modifier(code)

NO ACTION

DEFERRED

circ_matrix_matchpoint_circ_modifier_fkey

copy_circ_lib

actor.org_unit(id)

NO ACTION

DEFERRED

circ_matrix_matchpoint_copy_circ_lib_fkey

copy_location

asset.copy_location(id)

NO ACTION

DEFERRED

circ_matrix_matchpoint_copy_location_fkey

copy_owning_lib

actor.org_unit(id)

NO ACTION

DEFERRED

circ_matrix_matchpoint_copy_owning_lib_fkey

duration_rule

config.rule_circ_duration(id)

NO ACTION

DEFERRED

circ_matrix_matchpoint_duration_rule_fkey

grp

permission.grp_tree(id)

NO ACTION

DEFERRED

circ_matrix_matchpoint_grp_fkey

hard_due_date

config.hard_due_date(id)

NO ACTION

DEFERRED

circ_matrix_matchpoint_hard_due_date_fkey

max_fine_rule

config.rule_max_fine(id)

NO ACTION

DEFERRED

circ_matrix_matchpoint_max_fine_rule_fkey

org_unit

actor.org_unit(id)

NO ACTION

DEFERRED

circ_matrix_matchpoint_org_unit_fkey

recurring_fine_rule

config.rule_recurring_fine(id)

NO ACTION

DEFERRED

circ_matrix_matchpoint_recurring_fine_rule_fkey

user_home_ou

actor.org_unit(id)

NO ACTION

DEFERRED

circ_matrix_matchpoint_user_home_ou_fkey

Indexes

Index Method Definition

Index	Method	Definition
`circ_matrix_matchpoint_pkey` PK	btree	`CREATE UNIQUE INDEX circ_matrix_matchpoint_pkey ON config.circ_matrix_matchpoint USING btree (id)`
`ccmm_once_per_paramset` UNIQUE	btree	CREATE UNIQUE INDEX ccmm_once_per_paramset ON config.circ_matrix_matchpoint USING btree (org_unit, grp, COALESCE(circ_modifier, ''::text), COALESCEcopy_location)::text, ''::text), COALESCE(marc_type, ''::text), COALESCE(marc_form, ''::text), COALESCE(marc_bib_level, ''::text), COALESCE(marc_vr_format, ''::text), COALESCE((copy_circ_lib)::text, ''::text), COALESCE((copy_owning_lib)::text, ''::text), COALESCE((user_home_ou)::text, ''::text), COALESCE((ref_flag)::text, ''::text), COALESCE((juvenile_flag)::text, ''::text), COALESCE((is_renewal)::text, ''::text), COALESCE(usr_age_lower_bound, '00:00:00'::interval), COALESCE(usr_age_upper_bound, '00:00:00'::interval), COALESCE(item_age, '00:00:00'::interval WHERE active

circ_matrix_matchpoint_pkey PK

btree

CREATE UNIQUE INDEX circ_matrix_matchpoint_pkey ON config.circ_matrix_matchpoint USING btree (id)

ccmm_once_per_paramset UNIQUE

btree

CREATE UNIQUE INDEX ccmm_once_per_paramset ON config.circ_matrix_matchpoint USING btree (org_unit, grp, COALESCE(circ_modifier, ''::text), COALESCEcopy_location)::text, ''::text), COALESCE(marc_type, ''::text), COALESCE(marc_form, ''::text), COALESCE(marc_bib_level, ''::text), COALESCE(marc_vr_format, ''::text), COALESCE((copy_circ_lib)::text, ''::text), COALESCE((copy_owning_lib)::text, ''::text), COALESCE((user_home_ou)::text, ''::text), COALESCE((ref_flag)::text, ''::text), COALESCE((juvenile_flag)::text, ''::text), COALESCE((is_renewal)::text, ''::text), COALESCE(usr_age_lower_bound, '00:00:00'::interval), COALESCE(usr_age_upper_bound, '00:00:00'::interval), COALESCE(item_age, '00:00:00'::interval WHERE active

Referenced By

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

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

Table	Referencing Column(s)	Referenced Column(s)	Constraint
config.circ_matrix_limit_set_map	`matchpoint`	`id`	`circ_matrix_limit_set_map_matchpoint_fkey`

config.circ_matrix_limit_set_map

matchpoint

id

circ_matrix_limit_set_map_matchpoint_fkey