rule_max_fine

-1 rows


Description

Circulation Max Fine rules

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

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 nextval('config.rule_max_fine_id_seq'::regclass)
circ_matrix_matchpoint.max_fine_rule circ_matrix_matchpoint_max_fine_rule_fkey R
name text 2147483647 null
amount numeric 6,2 null
is_percent bool 1 false

Indexes

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

Check Constraints

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

Relationships