serial.supplement_summary

Cascading Deletes: Deleting rows from this table will cascade to: serial.distribution.

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

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`integer`	No	nextval('serial.supplement_summary_id_seq'::regclass)
distribution FK	`integer`	No		→ serial.distribution(id)
generated_coverage	`text`	No
textual_holdings	`text`	Yes
show_generated	`boolean`	No	true

id PK

integer

nextval('serial.supplement_summary_id_seq'::regclass)

distribution FK

integer

→ serial.distribution(id)

generated_coverage

text

textual_holdings

text

Yes

show_generated

boolean

true

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`distribution`	serial.distribution(id)	CASCADE	NO ACTION	DEFERRED	`supplement_summary_distribution_fkey`

distribution

serial.distribution(id)

CASCADE

NO ACTION

DEFERRED

supplement_summary_distribution_fkey

Indexes

Index Method Definition

Index	Method	Definition
`supplement_summary_pkey` PK	btree	`CREATE UNIQUE INDEX supplement_summary_pkey ON serial.supplement_summary USING btree (id)`
`serial_supplement_summary_dist_idx`	btree	`CREATE INDEX serial_supplement_summary_dist_idx ON serial.supplement_summary USING btree (distribution)`

supplement_summary_pkey PK

btree

CREATE UNIQUE INDEX supplement_summary_pkey ON serial.supplement_summary USING btree (id)

serial_supplement_summary_dist_idx

btree

CREATE INDEX serial_supplement_summary_dist_idx ON serial.supplement_summary USING btree (distribution)