metabib.record_sorter

Cascading Deletes: Deleting rows from this table will cascade to: config.record_attr_definition, biblio.record_entry.

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`bigint`	No	nextval('metabib.record_sorter_id_seq'::regclass)
source FK	`bigint`	No		→ biblio.record_entry(id)
attr FK	`text`	No		→ config.record_attr_definition(name)
value	`text`	No

id PK

bigint

nextval('metabib.record_sorter_id_seq'::regclass)

source FK

bigint

attr FK

text

value

text

(id)

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`attr`	config.record_attr_definition(name)	CASCADE	NO ACTION	No	`record_sorter_attr_fkey`
`source`	biblio.record_entry(id)	CASCADE	NO ACTION	No	`record_sorter_source_fkey`

attr

CASCADE

NO ACTION

record_sorter_attr_fkey

source

CASCADE

NO ACTION

record_sorter_source_fkey

Index Method Definition

Index	Method	Definition
`record_sorter_pkey` PK	btree	`CREATE UNIQUE INDEX record_sorter_pkey ON metabib.record_sorter USING btree (id)`
`metabib_sorter_a_v_idx`	btree	`CREATE INDEX metabib_sorter_a_v_idx ON metabib.record_sorter USING btree (attr, value)`
`metabib_sorter_s_a_idx`	btree	`CREATE INDEX metabib_sorter_s_a_idx ON metabib.record_sorter USING btree (source, attr)`
`metabib_sorter_source_idx`	btree	`CREATE INDEX metabib_sorter_source_idx ON metabib.record_sorter USING btree (source)`

record_sorter_pkey PK

btree

CREATE UNIQUE INDEX record_sorter_pkey ON metabib.record_sorter USING btree (id)

metabib_sorter_a_v_idx

btree

CREATE INDEX metabib_sorter_a_v_idx ON metabib.record_sorter USING btree (attr, value)

metabib_sorter_s_a_idx

btree

CREATE INDEX metabib_sorter_s_a_idx ON metabib.record_sorter USING btree (source, attr)

metabib_sorter_source_idx

btree

CREATE INDEX metabib_sorter_source_idx ON metabib.record_sorter USING btree (source)