config.circ_modifier

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default
code PK	`text`	No
name	`text`	No
description	`text`	No
sip2_media_type	`text`	No
magnetic_media	`boolean`	No	true
avg_wait_time	`interval`	Yes

code PK

text

name

text

description

text

sip2_media_type

text

magnetic_media

boolean

true

avg_wait_time

interval

Yes

(code)

Index Method Definition

Index	Method	Definition
`circ_modifier_pkey` PK	btree	`CREATE UNIQUE INDEX circ_modifier_pkey ON config.circ_modifier USING btree (code)`
`circ_modifier_name_key` UNIQUE	btree	`CREATE UNIQUE INDEX circ_modifier_name_key ON config.circ_modifier USING btree (name)`

circ_modifier_pkey PK

btree

CREATE UNIQUE INDEX circ_modifier_pkey ON config.circ_modifier USING btree (code)

circ_modifier_name_key UNIQUE

btree

CREATE UNIQUE INDEX circ_modifier_name_key ON config.circ_modifier USING btree (name)

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

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

Table	Referencing Column(s)	Referenced Column(s)	Constraint
acq.distribution_formula_entry	`circ_modifier`	`code`	`distribution_formula_entry_circ_modifier_fkey`
acq.lineitem_detail	`circ_modifier`	`code`	`lineitem_detail_circ_modifier_fkey`
actor.org_unit_proximity_adjustment	`circ_mod`	`code`	`actor_org_unit_proximity_adjustment_circ_mod_fkey`
asset.copy	`circ_modifier`	`code`	`circ_mod_fkey`
asset.course_module_course_materials	`original_circ_modifier`	`code`	`original_circ_mod_fkey`
config.circ_limit_set_circ_mod_map	`circ_mod`	`code`	`circ_limit_set_circ_mod_map_circ_mod_fkey`
config.circ_matrix_matchpoint	`circ_modifier`	`code`	`circ_matrix_matchpoint_circ_modifier_fkey`
config.hold_matrix_matchpoint	`circ_modifier`	`code`	`hold_matrix_matchpoint_circ_modifier_fkey`
rating.badge	`circ_mod_filter`	`code`	`badge_circ_mod_filter_fkey`