authority.control_set_bib_field_metabib_field_map

↑ authority schema

Cascading Deletes: Deleting rows from this table will cascade to: authority.control_set_bib_field, config.metabib_field.

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

Columns

Column Type Nullable Default Notes

id PK

integer

No

nextval('authority.control_set_bib_field_metabib_field_map_id_seq'::regclass)

bib_field FK

integer

No

→ authority.control_set_bib_field(id)

metabib_field FK

integer

No

→ config.metabib_field(id)

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

bib_field

authority.control_set_bib_field(id)

CASCADE

CASCADE

DEFERRED

control_set_bib_field_metabib_field_map_bib_field_fkey

metabib_field

config.metabib_field(id)

CASCADE

CASCADE

DEFERRED

control_set_bib_field_metabib_field_map_metabib_field_fkey

Unique Constraints

  • a_bf_mf_map_once: (bib_field, metabib_field)

Indexes

Index Method Definition

control_set_bib_field_metabib_field_map_pkey PK

btree

CREATE UNIQUE INDEX control_set_bib_field_metabib_field_map_pkey ON authority.control_set_bib_field_metabib_field_map USING btree (id)

a_bf_mf_map_once UNIQUE

btree

CREATE UNIQUE INDEX a_bf_mf_map_once ON authority.control_set_bib_field_metabib_field_map USING btree (bib_field, metabib_field)
Previous
Next