config.rule_circ_duration

Circulation Duration rules

Each circulation is given a duration based on one of these rules.

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default
id PK	`integer`	No	nextval('config.rule_circ_duration_id_seq'::regclass)
name	`text`	No
extended	`interval`	No
normal	`interval`	No
shrt	`interval`	No
max_renewals	`integer`	No
max_auto_renewals	`integer`	Yes

id PK

integer

nextval('config.rule_circ_duration_id_seq'::regclass)

name

text

extended

interval

normal

interval

shrt

interval

max_renewals

integer

max_auto_renewals

integer

Yes

(id)

Index Method Definition

Index	Method	Definition
`rule_circ_duration_pkey` PK	btree	`CREATE UNIQUE INDEX rule_circ_duration_pkey ON config.rule_circ_duration USING btree (id)`
`rule_circ_duration_name_key` UNIQUE	btree	`CREATE UNIQUE INDEX rule_circ_duration_name_key ON config.rule_circ_duration USING btree (name)`

rule_circ_duration_pkey PK

btree

CREATE UNIQUE INDEX rule_circ_duration_pkey ON config.rule_circ_duration USING btree (id)

rule_circ_duration_name_key UNIQUE

btree

CREATE UNIQUE INDEX rule_circ_duration_name_key ON config.rule_circ_duration USING btree (name)

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

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

Table	Referencing Column(s)	Referenced Column(s)	Constraint
config.circ_matrix_matchpoint	`duration_rule`	`id`	`circ_matrix_matchpoint_duration_rule_fkey`

duration_rule

id

circ_matrix_matchpoint_duration_rule_fkey