config.record_attr_definition

Cascading Deletes: Deleting rows from this table will cascade to: config.xml_transform.

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

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
name PK	`text`	No
label	`text`	No
description	`text`	Yes
multi	`boolean`	No	true
filter	`boolean`	No	true
sorter	`boolean`	No	false
composite	`boolean`	No	false
tag	`text`	Yes
sf_list	`text`	Yes
joiner	`text`	Yes
xpath	`text`	Yes
format FK	`text`	Yes		→ config.xml_transform(name)
start_pos	`integer`	Yes
string_len	`integer`	Yes
fixed_field	`text`	Yes
phys_char_sf FK	`integer`	Yes		→ config.marc21_physical_characteristic_subfield_map(id)
vocabulary	`text`	Yes

name PK

text

label

text

description

text

Yes

multi

boolean

true

filter

boolean

true

sorter

boolean

false

composite

boolean

false

tag

text

Yes

sf_list

text

Yes

joiner

text

Yes

xpath

text

Yes

format FK

text

Yes

→ config.xml_transform(name)

start_pos

integer

Yes

string_len

integer

Yes

fixed_field

text

Yes

phys_char_sf FK

integer

Yes

→ config.marc21_physical_characteristic_subfield_map(id)

vocabulary

text

Yes

Primary Key

(name)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`format`	config.xml_transform(name)	CASCADE	NO ACTION	DEFERRED	`record_attr_definition_format_fkey`
`phys_char_sf`	config.marc21_physical_characteristic_subfield_map(id)	NO ACTION	NO ACTION	No	`record_attr_definition_phys_char_sf_fkey`

format

config.xml_transform(name)

CASCADE

NO ACTION

DEFERRED

record_attr_definition_format_fkey

phys_char_sf

config.marc21_physical_characteristic_subfield_map(id)

NO ACTION

record_attr_definition_phys_char_sf_fkey

Indexes

Index Method Definition

Index	Method	Definition
`record_attr_definition_pkey` PK	btree	`CREATE UNIQUE INDEX record_attr_definition_pkey ON config.record_attr_definition USING btree (name)`

record_attr_definition_pkey PK

btree

CREATE UNIQUE INDEX record_attr_definition_pkey ON config.record_attr_definition USING btree (name)

Referenced By

The following tables have foreign keys pointing to config.record_attr_definition (9 referencing table(s)):

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

Table	Referencing Column(s)	Referenced Column(s)	Constraint
authority.browse_axis	`sorter`	`name`	`browse_axis_sorter_fkey`
config.coded_value_map	`ctype`	`name`	`coded_value_map_ctype_fkey`
config.marc_subfield	`value_ctype`	`name`	`marc_subfield_value_ctype_fkey`
config.record_attr_index_norm_map	`attr`	`name`	`record_attr_index_norm_map_attr_fkey`
config.z3950_index_field_map	`record_attr`	`name`	`z3950_index_field_map_record_attr_fkey`
metabib.record_sorter	`attr`	`name`	`record_sorter_attr_fkey`
metabib.uncontrolled_record_attr_value	`attr`	`name`	`uncontrolled_record_attr_value_attr_fkey`
vandelay.match_set_point	`svf`	`name`	`match_set_point_svf_fkey`
vandelay.match_set_quality	`svf`	`name`	`match_set_quality_svf_fkey`