config.rule_recurring_fine

↑ config schema

Circulation Recurring Fine rules

Each circulation is given a recurring fine amount based on one of these rules. Note that it is recommended to run the fine generator (from cron) at least as frequently as the lowest recurrence interval used by your circulation rules so that accrued fines will be up to date.

Columns

Column Type Nullable Default Notes

id PK

integer

No

nextval('config.rule_recurring_fine_id_seq'::regclass)

name

text

No

high

numeric(6,2)

No

normal

numeric(6,2)

No

low

numeric(6,2)

No

recurrence_interval

interval

No

'1 day'::interval

grace_period

interval

No

'1 day'::interval

Primary Key

(id)

Unique Constraints

  • rule_recurring_fine_name_key: (name)

Check Constraints

  • rule_recurring_fine_name_check: CHECK name ~ '^\w+$'::text

Indexes

Index Method Definition

rule_recurring_fine_pkey PK

btree

CREATE UNIQUE INDEX rule_recurring_fine_pkey ON config.rule_recurring_fine USING btree (id)

rule_recurring_fine_name_key UNIQUE

btree

CREATE UNIQUE INDEX rule_recurring_fine_name_key ON config.rule_recurring_fine USING btree (name)

Referenced By

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

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

config.circ_matrix_matchpoint

recurring_fine_rule

id

circ_matrix_matchpoint_recurring_fine_rule_fkey
Previous
Next