serial.materialized_holding_code

Cascading Deletes: Rows in this table will be automatically deleted when rows are deleted from: serial.issuance.

Written by External Triggers: This table can receive writes triggered by operations on other tables:

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`bigint`	No	nextval('serial.materialized_holding_code_id_seq'::regclass)
issuance FK	`integer`	No		→ serial.issuance(id)
subfield	`character(1)`	Yes
value	`text`	Yes

id PK

bigint

nextval('serial.materialized_holding_code_id_seq'::regclass)

issuance FK

integer

subfield

character(1)

Yes

value

text

Yes

(id)

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`issuance`	serial.issuance(id)	CASCADE	NO ACTION	No	`materialized_holding_code_issuance_fkey`

issuance

CASCADE

NO ACTION

materialized_holding_code_issuance_fkey

Index Method Definition

Index	Method	Definition
`materialized_holding_code_pkey` PK	btree	`CREATE UNIQUE INDEX materialized_holding_code_pkey ON serial.materialized_holding_code USING btree (id)`
`assist_holdings_display`	btree	`CREATE INDEX assist_holdings_display ON serial.materialized_holding_code USING btree (issuance, subfield)`

materialized_holding_code_pkey PK

btree

CREATE UNIQUE INDEX materialized_holding_code_pkey ON serial.materialized_holding_code USING btree (id)

assist_holdings_display

btree

CREATE INDEX assist_holdings_display ON serial.materialized_holding_code USING btree (issuance, subfield)