asset.uri_call_number_map

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`bigint`	No	nextval('asset.uri_call_number_map_id_seq'::regclass)
uri FK	`integer`	No		→ asset.uri(id)
call_number FK	`integer`	No		→ asset.call_number(id)

id PK

bigint

nextval('asset.uri_call_number_map_id_seq'::regclass)

uri FK

integer

call_number FK

integer

(id)

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`call_number`	asset.call_number(id)	NO ACTION	NO ACTION	No	`uri_call_number_map_call_number_fkey`
`uri`	asset.uri(id)	NO ACTION	NO ACTION	No	`uri_call_number_map_uri_fkey`

call_number

NO ACTION

uri_call_number_map_call_number_fkey

uri

NO ACTION

uri_call_number_map_uri_fkey

Index Method Definition

Index	Method	Definition
`uri_call_number_map_pkey` PK	btree	`CREATE UNIQUE INDEX uri_call_number_map_pkey ON asset.uri_call_number_map USING btree (id)`
`uri_cn_once` UNIQUE	btree	`CREATE UNIQUE INDEX uri_cn_once ON asset.uri_call_number_map USING btree (uri, call_number)`
`asset_uri_call_number_map_cn_idx`	btree	`CREATE INDEX asset_uri_call_number_map_cn_idx ON asset.uri_call_number_map USING btree (call_number)`

uri_call_number_map_pkey PK

btree

CREATE UNIQUE INDEX uri_call_number_map_pkey ON asset.uri_call_number_map USING btree (id)

uri_cn_once UNIQUE

btree

CREATE UNIQUE INDEX uri_cn_once ON asset.uri_call_number_map USING btree (uri, call_number)

asset_uri_call_number_map_cn_idx

btree

CREATE INDEX asset_uri_call_number_map_cn_idx ON asset.uri_call_number_map USING btree (call_number)