config.rule_max_fine

Circulation Max Fine rules

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

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default
id PK	`integer`	No	nextval('config.rule_max_fine_id_seq'::regclass)
name	`text`	No
amount	`numeric(6,2)`	No
is_percent	`boolean`	No	false

id PK

integer

nextval('config.rule_max_fine_id_seq'::regclass)

name

text

amount

numeric(6,2)

is_percent

boolean

false

(id)

Index Method Definition

Index	Method	Definition
`rule_max_fine_pkey` PK	btree	`CREATE UNIQUE INDEX rule_max_fine_pkey ON config.rule_max_fine USING btree (id)`
`rule_max_fine_name_key` UNIQUE	btree	`CREATE UNIQUE INDEX rule_max_fine_name_key ON config.rule_max_fine USING btree (name)`

rule_max_fine_pkey PK

btree

CREATE UNIQUE INDEX rule_max_fine_pkey ON config.rule_max_fine USING btree (id)

rule_max_fine_name_key UNIQUE

btree

CREATE UNIQUE INDEX rule_max_fine_name_key ON config.rule_max_fine USING btree (name)

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

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

Table	Referencing Column(s)	Referenced Column(s)	Constraint
config.circ_matrix_matchpoint	`max_fine_rule`	`id`	`circ_matrix_matchpoint_max_fine_rule_fkey`

max_fine_rule

id

circ_matrix_matchpoint_max_fine_rule_fkey