config.standing

Patron Standings

This table contains the values that can be applied to a patron by a staff member. These values should not be changed, other than for translation, as the ID column is currently a "magic number" in the source. :(

Columns

Column Type Nullable Default Notes

id PK

integer

No

nextval('config.standing_id_seq'::regclass)

value

text

No

Primary Key

(id)

Unique Constraints

  • standing_value_key: (value)

Indexes

Index Method Definition

standing_pkey PK

btree

CREATE UNIQUE INDEX standing_pkey ON config.standing USING btree (id)

standing_value_key UNIQUE

btree

CREATE UNIQUE INDEX standing_value_key ON config.standing USING btree (value)

Referenced By

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

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

actor.usr

standing

id

usr_standing_fkey