config.marc_subfield

↑ config schema

This table stores the list of subfields recognized by this Evergreen instance. As with config.marc_field, of particular significance is the owner column; if it’s set to a null value, the subfield definition is assumed to come from a national standards body; if it’s set to a non-null value, the subfield definition is an OU-level addition to or override of the standard.

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

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`integer`	No	nextval('config.marc_subfield_id_seq'::regclass)
marc_format FK	`integer`	No		→ config.marc_format(id)
marc_record_type	`config.marc_record_type`	No
tag	`character(3)`	No
code	`character(1)`	No
description	`text`	Yes
repeatable	`boolean`	Yes
mandatory	`boolean`	Yes
hidden	`boolean`	Yes
value_ctype FK	`text`	Yes		→ config.record_attr_definition(name)
owner FK	`integer`	Yes		→ actor.org_unit(id)

id PK

integer

nextval('config.marc_subfield_id_seq'::regclass)

marc_format FK

integer

→ config.marc_format(id)

marc_record_type

config.marc_record_type

tag

character(3)

code

character(1)

description

text

Yes

repeatable

boolean

Yes

mandatory

boolean

Yes

hidden

boolean

Yes

value_ctype FK

text

Yes

→ config.record_attr_definition(name)

owner FK

integer

Yes

→ actor.org_unit(id)

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`owner`	actor.org_unit(id)	NO ACTION	NO ACTION	DEFERRED	`config_marc_subfield_owner_fkey`
`marc_format`	config.marc_format(id)	NO ACTION	NO ACTION	DEFERRED	`marc_subfield_marc_format_fkey`
`value_ctype`	config.record_attr_definition(name)	NO ACTION	NO ACTION	DEFERRED	`marc_subfield_value_ctype_fkey`

owner

actor.org_unit(id)

NO ACTION

DEFERRED

config_marc_subfield_owner_fkey

marc_format

config.marc_format(id)

NO ACTION

DEFERRED

marc_subfield_marc_format_fkey

value_ctype

config.record_attr_definition(name)

NO ACTION

DEFERRED

marc_subfield_value_ctype_fkey

Check Constraints

config_standard_marc_subfields_are_fully_specified: CHECK

Indexes

Index Method Definition

Index	Method	Definition
`marc_subfield_pkey` PK	btree	`CREATE UNIQUE INDEX marc_subfield_pkey ON config.marc_subfield USING btree (id)`
`config_standard_marc_subfields_are_unique` UNIQUE	btree	`CREATE UNIQUE INDEX config_standard_marc_subfields_are_unique ON config.marc_subfield USING btree (marc_format, marc_record_type, tag, code) WHERE (owner IS NULL)`
`config_marc_subfield_tag_code_idx`	btree	`CREATE INDEX config_marc_subfield_tag_code_idx ON config.marc_subfield USING btree (tag, code)`

marc_subfield_pkey PK

btree

CREATE UNIQUE INDEX marc_subfield_pkey ON config.marc_subfield USING btree (id)

config_standard_marc_subfields_are_unique UNIQUE

btree

CREATE UNIQUE INDEX config_standard_marc_subfields_are_unique ON config.marc_subfield USING btree (marc_format, marc_record_type, tag, code) WHERE (owner IS NULL)

config_marc_subfield_tag_code_idx

btree

CREATE INDEX config_marc_subfield_tag_code_idx ON config.marc_subfield USING btree (tag, code)