acq.provider_holding_subfield_map

↑ acq schema

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

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`integer`	No	nextval('acq.provider_holding_subfield_map_id_seq'::regclass)
provider FK	`integer`	No		→ acq.provider(id)
name	`text`	No
subfield	`text`	No

id PK

integer

nextval('acq.provider_holding_subfield_map_id_seq'::regclass)

provider FK

integer

→ acq.provider(id)

name

text

subfield

text

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`provider`	acq.provider(id)	NO ACTION	NO ACTION	DEFERRED	`provider_holding_subfield_map_provider_fkey`

provider

acq.provider(id)

NO ACTION

DEFERRED

provider_holding_subfield_map_provider_fkey

Unique Constraints

name_once_per_provider: (provider, name)

Indexes

Index Method Definition

Index	Method	Definition
`provider_holding_subfield_map_pkey` PK	btree	`CREATE UNIQUE INDEX provider_holding_subfield_map_pkey ON acq.provider_holding_subfield_map USING btree (id)`
`name_once_per_provider` UNIQUE	btree	`CREATE UNIQUE INDEX name_once_per_provider ON acq.provider_holding_subfield_map USING btree (provider, name)`

provider_holding_subfield_map_pkey PK

btree

CREATE UNIQUE INDEX provider_holding_subfield_map_pkey ON acq.provider_holding_subfield_map USING btree (id)

name_once_per_provider UNIQUE

btree

CREATE UNIQUE INDEX name_once_per_provider ON acq.provider_holding_subfield_map USING btree (provider, name)