authority.bib_linking

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`bigint`	No	nextval('authority.bib_linking_id_seq'::regclass)
bib FK	`bigint`	No		→ biblio.record_entry(id)
authority FK	`bigint`	No		→ authority.record_entry(id)

id PK

bigint

nextval('authority.bib_linking_id_seq'::regclass)

bib FK

bigint

authority FK

bigint

(id)

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`authority`	authority.record_entry(id)	NO ACTION	NO ACTION	No	`bib_linking_authority_fkey`
`bib`	biblio.record_entry(id)	NO ACTION	NO ACTION	No	`bib_linking_bib_fkey`

authority

NO ACTION

bib_linking_authority_fkey

bib

NO ACTION

bib_linking_bib_fkey

Index Method Definition

Index	Method	Definition
`bib_linking_pkey` PK	btree	`CREATE UNIQUE INDEX bib_linking_pkey ON authority.bib_linking USING btree (id)`
`authority_bl_bib_authority_once_idx` UNIQUE	btree	`CREATE UNIQUE INDEX authority_bl_bib_authority_once_idx ON authority.bib_linking USING btree (authority, bib)`
`authority_bl_bib_idx`	btree	`CREATE INDEX authority_bl_bib_idx ON authority.bib_linking USING btree (bib)`

bib_linking_pkey PK

btree

CREATE UNIQUE INDEX bib_linking_pkey ON authority.bib_linking USING btree (id)

authority_bl_bib_authority_once_idx UNIQUE

btree

CREATE UNIQUE INDEX authority_bl_bib_authority_once_idx ON authority.bib_linking USING btree (authority, bib)

authority_bl_bib_idx

btree

CREATE INDEX authority_bl_bib_idx ON authority.bib_linking USING btree (bib)