authority.heading_field

Columns

Column Type Nullable Default Notes

id PK

integer

No

nextval('authority.heading_field_id_seq'::regclass)

heading_type

authority.heading_type

No

heading_purpose

authority.heading_purpose

No

label

text

No

format FK

text

No

'mads21'::text

→ config.xml_transform(name)

heading_xpath

text

No

component_xpath

text

No

type_xpath

text

Yes

thesaurus_xpath

text

Yes

thesaurus_override_xpath

text

Yes

joiner

text

Yes

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

format

config.xml_transform(name)

NO ACTION

NO ACTION

No

heading_field_format_fkey

Indexes

Index Method Definition

heading_field_pkey PK

btree

CREATE UNIQUE INDEX heading_field_pkey ON authority.heading_field USING btree (id)

Referenced By

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

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

authority.control_set_authority_field

heading_field

id

control_set_authority_field_heading_field_fkey

authority.heading_field_norm_map

field

id

heading_field_norm_map_field_fkey
Previous
Next