config.marc21_physical_characteristic_subfield_map

Cascading Deletes: Deleting rows from this table will cascade to: config.marc21_physical_characteristic_type_map.

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`integer`	No	nextval('config.marc21_physical_characteristic_subfield_map_id_seq'::regclass)
ptype_key FK	`text`	No		→ config.marc21_physical_characteristic_type_map(ptype_key)
subfield	`text`	No
start_pos	`integer`	No
length	`integer`	No
label	`text`	No

id PK

integer

nextval('config.marc21_physical_characteristic_subfield_map_id_seq'::regclass)

ptype_key FK

text

subfield

text

start_pos

integer

length

integer

label

text

(id)

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`ptype_key`	config.marc21_physical_characteristic_type_map(ptype_key)	CASCADE	CASCADE	No	`marc21_physical_characteristic_subfield_map_ptype_key_fkey`

ptype_key

CASCADE

marc21_physical_characteristic_subfield_map_ptype_key_fkey

Index Method Definition

Index	Method	Definition
`marc21_physical_characteristic_subfield_map_pkey` PK	btree	`CREATE UNIQUE INDEX marc21_physical_characteristic_subfield_map_pkey ON config.marc21_physical_characteristic_subfield_map USING btree (id)`

marc21_physical_characteristic_subfield_map_pkey PK

btree

CREATE UNIQUE INDEX marc21_physical_characteristic_subfield_map_pkey ON config.marc21_physical_characteristic_subfield_map USING btree (id)

The following tables have foreign keys pointing to config.marc21_physical_characteristic_subfield_map (2 referencing table(s)):

Table Referencing Column(s) Referenced Column(s) Constraint

Table	Referencing Column(s)	Referenced Column(s)	Constraint
config.marc21_physical_characteristic_value_map	`ptype_subfield`	`id`	`marc21_physical_characteristic_value_map_ptype_subfield_fkey`
config.record_attr_definition	`phys_char_sf`	`id`	`record_attr_definition_phys_char_sf_fkey`

ptype_subfield

id

marc21_physical_characteristic_value_map_ptype_subfield_fkey

phys_char_sf

id

record_attr_definition_phys_char_sf_fkey