config.z3950_attr

↑ config schema

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

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

Columns

Column Type Nullable Default Notes

id PK

integer

No

nextval('config.z3950_attr_id_seq'::regclass)

source FK

text

No

→ config.z3950_source(name)

name

text

No

label

text

No

code

integer

No

format

integer

No

truncation

integer

No

0

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

source

config.z3950_source(name)

CASCADE

CASCADE

DEFERRED

z3950_attr_source_fkey

Unique Constraints

  • z_code_format_once_per_source: (code, format, source)

Indexes

Index Method Definition

z3950_attr_pkey PK

btree

CREATE UNIQUE INDEX z3950_attr_pkey ON config.z3950_attr USING btree (id)

z_code_format_once_per_source UNIQUE

btree

CREATE UNIQUE INDEX z_code_format_once_per_source ON config.z3950_attr USING btree (code, format, source)

Referenced By

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

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

config.z3950_index_field_map

z3950_attr

id

z3950_index_field_map_z3950_attr_fkey
Previous
Next