marc_subfield

3781 rows


Description

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.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('config.marc_subfield_id_seq'::regclass)
marc_format int4 10 null
marc_format.id marc_subfield_marc_format_fkey R
marc_record_type "config"."marc_record_type" 2147483647 null
tag bpchar 3 null
code bpchar 1 null
description text 2147483647 √ null
repeatable bool 1 √ null
mandatory bool 1 √ null
hidden bool 1 √ null
value_ctype text 2147483647 √ null
record_attr_definition.name marc_subfield_value_ctype_fkey R
owner int4 10 √ null
org_unit.id config_marc_subfield_owner_fkey R

Indexes

Constraint Name Type Sort Column(s)
marc_subfield_pkey Primary key Asc id
config_marc_subfield_tag_code_idx Performance Asc/Asc tag + code
config_standard_marc_subfields_are_unique Must be unique Asc/Asc/Asc/Asc marc_format + marc_record_type + tag + code

Check Constraints

Constraint Name Constraint
config_standard_marc_subfields_are_fully_specified (((owner IS NOT NULL) OR ((owner IS NULL) AND (repeatable IS NOT NULL) AND (mandatory IS NOT NULL) AND (hidden IS NOT NULL))))

Relationships

Close relationships within degrees of separation