config.circ_matrix_limit_set_map

↑ config schema

Cascading Deletes: Deleting rows from this table will cascade to: config.circ_limit_set, config.circ_matrix_matchpoint.

Deferrable Constraints: The following FK constraints are deferrable — they are checked at transaction end, not statement end: circ_matrix_limit_set_map_limit_set_fkey, circ_matrix_limit_set_map_matchpoint_fkey.

Columns

Column Type Nullable Default Notes

id PK

integer

No

nextval('config.circ_matrix_limit_set_map_id_seq'::regclass)

matchpoint FK

integer

No

→ config.circ_matrix_matchpoint(id)

limit_set FK

integer

No

→ config.circ_limit_set(id)

fallthrough

boolean

No

false

active

boolean

No

true

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

limit_set

config.circ_limit_set(id)

CASCADE

NO ACTION

DEFERRED

circ_matrix_limit_set_map_limit_set_fkey

matchpoint

config.circ_matrix_matchpoint(id)

CASCADE

NO ACTION

DEFERRED

circ_matrix_limit_set_map_matchpoint_fkey

Unique Constraints

  • circ_limit_set_once_per_matchpoint: (matchpoint, limit_set)

Indexes

Index Method Definition

circ_matrix_limit_set_map_pkey PK

btree

CREATE UNIQUE INDEX circ_matrix_limit_set_map_pkey ON config.circ_matrix_limit_set_map USING btree (id)

circ_limit_set_once_per_matchpoint UNIQUE

btree

CREATE UNIQUE INDEX circ_limit_set_once_per_matchpoint ON config.circ_matrix_limit_set_map USING btree (matchpoint, limit_set)
Previous
Next