rule_recurring_fine

-1 rows


Description

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 Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('config.rule_recurring_fine_id_seq'::regclass)
circ_matrix_matchpoint.recurring_fine_rule circ_matrix_matchpoint_recurring_fine_rule_fkey R
name text 2147483647 null
high numeric 6,2 null
normal numeric 6,2 null
low numeric 6,2 null
recurrence_interval interval 49,6 '1 day'::interval
grace_period interval 49,6 '1 day'::interval

Indexes

Constraint Name Type Sort Column(s)
rule_recurring_fine_pkey Primary key Asc id
rule_recurring_fine_name_key Must be unique Asc name

Check Constraints

Constraint Name Constraint
rule_recurring_fine_name_check ((name ~ '^\w+$'::text))

Relationships

Close relationships within degrees of separation