authority.control_set_authority_field

↑ authority schema

Cascading Deletes: Deleting rows from this table will cascade to: authority.control_set, authority.control_set_authority_field.

Deferrable Constraints: The following FK constraints are deferrable — they are checked at transaction end, not statement end: control_set_authority_field_control_set_fkey, control_set_authority_field_main_entry_fkey.

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`integer`	No	nextval('authority.control_set_authority_field_id_seq'::regclass)
main_entry FK	`integer`	Yes		→ authority.control_set_authority_field(id)
control_set FK	`integer`	No		→ authority.control_set(id)
tag	`character(3)`	No
nfi	`character(1)`	Yes
sf_list	`text`	No
display_sf_list	`text`	No
name	`text`	No
description	`text`	Yes
joiner	`text`	Yes
linking_subfield	`character(1)`	Yes
heading_field FK	`integer`	Yes		→ authority.heading_field(id)

id PK

integer

nextval('authority.control_set_authority_field_id_seq'::regclass)

main_entry FK

integer

Yes

→ authority.control_set_authority_field(id)

control_set FK

integer

→ authority.control_set(id)

tag

character(3)

nfi

character(1)

Yes

sf_list

text

display_sf_list

text

name

text

description

text

Yes

joiner

text

Yes

linking_subfield

character(1)

Yes

heading_field FK

integer

Yes

→ authority.heading_field(id)

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`control_set`	authority.control_set(id)	CASCADE	CASCADE	DEFERRED	`control_set_authority_field_control_set_fkey`
`heading_field`	authority.heading_field(id)	NO ACTION	NO ACTION	No	`control_set_authority_field_heading_field_fkey`
`main_entry`	authority.control_set_authority_field(id)	CASCADE	CASCADE	DEFERRED	`control_set_authority_field_main_entry_fkey`

control_set

authority.control_set(id)

CASCADE

DEFERRED

control_set_authority_field_control_set_fkey

heading_field

authority.heading_field(id)

NO ACTION

control_set_authority_field_heading_field_fkey

main_entry

authority.control_set_authority_field(id)

CASCADE

DEFERRED

control_set_authority_field_main_entry_fkey

Indexes

Index Method Definition

Index	Method	Definition
`control_set_authority_field_pkey` PK	btree	`CREATE UNIQUE INDEX control_set_authority_field_pkey ON authority.control_set_authority_field USING btree (id)`

control_set_authority_field_pkey PK

btree

CREATE UNIQUE INDEX control_set_authority_field_pkey ON authority.control_set_authority_field USING btree (id)

Referenced By

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

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

Table	Referencing Column(s)	Referenced Column(s)	Constraint
authority.authority_linking	`field`	`id`	`authority_linking_field_fkey`
authority.browse_axis_authority_field_map	`field`	`id`	`browse_axis_authority_field_map_field_fkey`
authority.control_set_authority_field	`main_entry`	`id`	`control_set_authority_field_main_entry_fkey`
authority.control_set_bib_field	`authority_field`	`id`	`control_set_bib_field_authority_field_fkey`
authority.simple_heading	`atag`	`id`	`simple_heading_atag_fkey`