authority.browse_axis

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

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

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Notes
code PK	`text`	No
name	`text`	No
sorter FK	`text`	Yes	→ config.record_attr_definition(name)
description	`text`	Yes

code PK

text

name

text

sorter FK

text

Yes

→ config.record_attr_definition(name)

description

text

Yes

Primary Key

(code)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`sorter`	config.record_attr_definition(name)	CASCADE	CASCADE	DEFERRED	`browse_axis_sorter_fkey`

sorter

config.record_attr_definition(name)

CASCADE

DEFERRED

browse_axis_sorter_fkey

Unique Constraints

browse_axis_name_key: (name)

Indexes

Index Method Definition

Index	Method	Definition
`browse_axis_pkey` PK	btree	`CREATE UNIQUE INDEX browse_axis_pkey ON authority.browse_axis USING btree (code)`
`browse_axis_name_key` UNIQUE	btree	`CREATE UNIQUE INDEX browse_axis_name_key ON authority.browse_axis USING btree (name)`

browse_axis_pkey PK

btree

CREATE UNIQUE INDEX browse_axis_pkey ON authority.browse_axis USING btree (code)

browse_axis_name_key UNIQUE

btree

CREATE UNIQUE INDEX browse_axis_name_key ON authority.browse_axis USING btree (name)

Referenced By

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

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

Table	Referencing Column(s)	Referenced Column(s)	Constraint
authority.browse_axis_authority_field_map	`axis`	`code`	`browse_axis_authority_field_map_axis_fkey`

authority.browse_axis_authority_field_map

axis

code

browse_axis_authority_field_map_axis_fkey