metabib.browse_entry_simple_heading_map

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

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`bigint`	No	nextval('metabib.browse_entry_simple_heading_map_id_seq'::regclass)
entry FK	`bigint`	Yes		→ metabib.browse_entry(id)
simple_heading FK	`bigint`	Yes		→ authority.simple_heading(id)

id PK

bigint

nextval('metabib.browse_entry_simple_heading_map_id_seq'::regclass)

entry FK

bigint

Yes

simple_heading FK

bigint

Yes

(id)

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`entry`	metabib.browse_entry(id)	NO ACTION	NO ACTION	No	`browse_entry_simple_heading_map_entry_fkey`
`simple_heading`	authority.simple_heading(id)	CASCADE	NO ACTION	No	`browse_entry_simple_heading_map_simple_heading_fkey`

entry

NO ACTION

browse_entry_simple_heading_map_entry_fkey

simple_heading

CASCADE

NO ACTION

browse_entry_simple_heading_map_simple_heading_fkey

Index Method Definition

Index	Method	Definition
`browse_entry_simple_heading_map_pkey` PK	btree	`CREATE UNIQUE INDEX browse_entry_simple_heading_map_pkey ON metabib.browse_entry_simple_heading_map USING btree (id)`
`browse_entry_sh_map_entry_idx`	btree	`CREATE INDEX browse_entry_sh_map_entry_idx ON metabib.browse_entry_simple_heading_map USING btree (entry)`
`browse_entry_sh_map_sh_idx`	btree	`CREATE INDEX browse_entry_sh_map_sh_idx ON metabib.browse_entry_simple_heading_map USING btree (simple_heading)`

browse_entry_simple_heading_map_pkey PK

btree

CREATE UNIQUE INDEX browse_entry_simple_heading_map_pkey ON metabib.browse_entry_simple_heading_map USING btree (id)

browse_entry_sh_map_entry_idx

btree

CREATE INDEX browse_entry_sh_map_entry_idx ON metabib.browse_entry_simple_heading_map USING btree (entry)

browse_entry_sh_map_sh_idx

btree

CREATE INDEX browse_entry_sh_map_sh_idx ON metabib.browse_entry_simple_heading_map USING btree (simple_heading)