metabib.browse_entry_def_map

↑ metabib schema

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

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`bigint`	No	nextval('metabib.browse_entry_def_map_id_seq'::regclass)
entry FK	`bigint`	Yes		→ metabib.browse_entry(id)
def FK	`integer`	Yes		→ config.metabib_field(id)
source FK	`bigint`	Yes		→ biblio.record_entry(id)
authority FK	`bigint`	Yes		→ authority.record_entry(id)

id PK

bigint

nextval('metabib.browse_entry_def_map_id_seq'::regclass)

entry FK

bigint

Yes

→ metabib.browse_entry(id)

def FK

integer

Yes

→ config.metabib_field(id)

source FK

bigint

Yes

→ biblio.record_entry(id)

authority FK

bigint

Yes

→ authority.record_entry(id)

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`authority`	authority.record_entry(id)	SET NULL	NO ACTION	No	`browse_entry_def_map_authority_fkey`
`def`	config.metabib_field(id)	NO ACTION	CASCADE	DEFERRED	`browse_entry_def_map_def_fkey`
`entry`	metabib.browse_entry(id)	NO ACTION	NO ACTION	No	`browse_entry_def_map_entry_fkey`
`source`	biblio.record_entry(id)	NO ACTION	NO ACTION	No	`browse_entry_def_map_source_fkey`

authority

authority.record_entry(id)

SET NULL

NO ACTION

browse_entry_def_map_authority_fkey

def

config.metabib_field(id)

NO ACTION

CASCADE

DEFERRED

browse_entry_def_map_def_fkey

entry

metabib.browse_entry(id)

NO ACTION

browse_entry_def_map_entry_fkey

source

biblio.record_entry(id)

NO ACTION

browse_entry_def_map_source_fkey

Indexes

Index Method Definition

Index	Method	Definition
`browse_entry_def_map_pkey` PK	btree	`CREATE UNIQUE INDEX browse_entry_def_map_pkey ON metabib.browse_entry_def_map USING btree (id)`
`browse_entry_def_map_def_idx`	btree	`CREATE INDEX browse_entry_def_map_def_idx ON metabib.browse_entry_def_map USING btree (def)`
`browse_entry_def_map_entry_idx`	btree	`CREATE INDEX browse_entry_def_map_entry_idx ON metabib.browse_entry_def_map USING btree (entry)`
`browse_entry_def_map_source_idx`	btree	`CREATE INDEX browse_entry_def_map_source_idx ON metabib.browse_entry_def_map USING btree (source)`

browse_entry_def_map_pkey PK

btree

CREATE UNIQUE INDEX browse_entry_def_map_pkey ON metabib.browse_entry_def_map USING btree (id)

browse_entry_def_map_def_idx

btree

CREATE INDEX browse_entry_def_map_def_idx ON metabib.browse_entry_def_map USING btree (def)

browse_entry_def_map_entry_idx

btree

CREATE INDEX browse_entry_def_map_entry_idx ON metabib.browse_entry_def_map USING btree (entry)

browse_entry_def_map_source_idx

btree

CREATE INDEX browse_entry_def_map_source_idx ON metabib.browse_entry_def_map USING btree (source)