vandelay.match_set

↑ vandelay schema

Cascading Deletes: Deleting rows from this table will cascade to: actor.org_unit.

Columns

Column Type Nullable Default Notes

id PK

integer

No

nextval('vandelay.match_set_id_seq'::regclass)

name

text

No

owner FK

integer

No

→ actor.org_unit(id)

mtype

text

No

'biblio'::text

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

owner

actor.org_unit(id)

CASCADE

NO ACTION

No

match_set_owner_fkey

Unique Constraints

  • name_once_per_owner_mtype: (name, owner, mtype)

Indexes

Index Method Definition

match_set_pkey PK

btree

CREATE UNIQUE INDEX match_set_pkey ON vandelay.match_set USING btree (id)

name_once_per_owner_mtype UNIQUE

btree

CREATE UNIQUE INDEX name_once_per_owner_mtype ON vandelay.match_set USING btree (name, owner, mtype)

Referenced By

The following tables have foreign keys pointing to vandelay.match_set (3 referencing table(s)):

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

vandelay.match_set_point

match_set

id

match_set_point_match_set_fkey

vandelay.match_set_quality

match_set

id

match_set_quality_match_set_fkey

vandelay.queue

match_set

id

queue_match_set_fkey
Previous
Next