asset.copy_part_map

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

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`integer`	No	nextval('asset.copy_part_map_id_seq'::regclass)
target_copy	`bigint`	No
part FK	`integer`	No		→ biblio.monograph_part(id)

id PK

integer

nextval('asset.copy_part_map_id_seq'::regclass)

target_copy

bigint

part FK

integer

(id)

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`part`	biblio.monograph_part(id)	CASCADE	NO ACTION	No	`copy_part_map_part_fkey`

part

CASCADE

NO ACTION

copy_part_map_part_fkey

Index Method Definition

Index	Method	Definition
`copy_part_map_pkey` PK	btree	`CREATE UNIQUE INDEX copy_part_map_pkey ON asset.copy_part_map USING btree (id)`
`copy_part_map_cp_part_idx` UNIQUE	btree	`CREATE UNIQUE INDEX copy_part_map_cp_part_idx ON asset.copy_part_map USING btree (target_copy, part)`

copy_part_map_pkey PK

btree

CREATE UNIQUE INDEX copy_part_map_pkey ON asset.copy_part_map USING btree (id)

copy_part_map_cp_part_idx UNIQUE

btree

CREATE UNIQUE INDEX copy_part_map_cp_part_idx ON asset.copy_part_map USING btree (target_copy, part)