marc_field

391 rows


Description

This table stores a list of MARC fields recognized by the Evergreen instance. Note that we’re not aiming for completely generic ISO2709 support: we’re assuming things like three characters for a tag, one-character subfield labels, two indicators per variable data field, and the like, all of which are technically specializations of ISO2709.

Of particular significance is the owner column; if it’s set to a null value, the field definition is assumed to come from a national standards body; if it’s set to a non-null value, the field 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_field_id_seq'::regclass)
marc_format int4 10 null
marc_format.id marc_field_marc_format_fkey R
marc_record_type "config"."marc_record_type" 2147483647 null
tag bpchar 3 null
name text 2147483647 √ null
description text 2147483647 √ null
fixed_field bool 1 √ null
repeatable bool 1 √ null
mandatory bool 1 √ null
hidden bool 1 √ null
owner int4 10 √ null
org_unit.id config_marc_field_owner_fkey R

Indexes

Constraint Name Type Sort Column(s)
marc_field_pkey Primary key Asc id
config_marc_field_owner_idx Performance Asc owner
config_marc_field_tag_idx Performance Asc tag
config_standard_marc_tags_are_unique Must be unique Asc/Asc/Asc marc_format + marc_record_type + tag

Check Constraints

Constraint Name Constraint
config_standard_marc_tags_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