authority.browse_axis_authority_field_map

↑ authority schema

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

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

Columns

Column Type Nullable Default Notes

id PK

integer

No

nextval('authority.browse_axis_authority_field_map_id_seq'::regclass)

axis FK

text

No

→ authority.browse_axis(code)

field FK

integer

No

→ authority.control_set_authority_field(id)

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

axis

authority.browse_axis(code)

CASCADE

CASCADE

DEFERRED

browse_axis_authority_field_map_axis_fkey

field

authority.control_set_authority_field(id)

CASCADE

CASCADE

DEFERRED

browse_axis_authority_field_map_field_fkey

Indexes

Index Method Definition

browse_axis_authority_field_map_pkey PK

btree

CREATE UNIQUE INDEX browse_axis_authority_field_map_pkey ON authority.browse_axis_authority_field_map USING btree (id)
Previous
Next