authority.control_set_bib_field

Cascading Deletes: Deleting rows from this table will cascade to: authority.control_set_authority_field.

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

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`integer`	No	nextval('authority.control_set_bib_field_id_seq'::regclass)
authority_field FK	`integer`	No		→ authority.control_set_authority_field(id)
tag	`character(3)`	No

id PK

integer

nextval('authority.control_set_bib_field_id_seq'::regclass)

authority_field FK

integer

→ authority.control_set_authority_field(id)

tag

character(3)

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`authority_field`	authority.control_set_authority_field(id)	CASCADE	CASCADE	DEFERRED	`control_set_bib_field_authority_field_fkey`

authority_field

authority.control_set_authority_field(id)

CASCADE

DEFERRED

control_set_bib_field_authority_field_fkey

Indexes

Index Method Definition

Index	Method	Definition
`control_set_bib_field_pkey` PK	btree	`CREATE UNIQUE INDEX control_set_bib_field_pkey ON authority.control_set_bib_field USING btree (id)`

control_set_bib_field_pkey PK

btree

CREATE UNIQUE INDEX control_set_bib_field_pkey ON authority.control_set_bib_field USING btree (id)

Referenced By

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

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

Table	Referencing Column(s)	Referenced Column(s)	Constraint
authority.control_set_bib_field_metabib_field_map	`bib_field`	`id`	`control_set_bib_field_metabib_field_map_bib_field_fkey`

authority.control_set_bib_field_metabib_field_map

bib_field

id

control_set_bib_field_metabib_field_map_bib_field_fkey