config.z3950_source

↑ config schema

Z39.50 Sources

Each row in this table represents a database searchable via Z39.50.

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

Columns

Column Type Nullable Default Notes

name PK

text

No

label

text

No

host

text

No

port

integer

No

db

text

No

record_format

text

No

'FI'::text

Z39.50 element set.

transmission_format

text

No

'usmarc'::text

Z39.50 preferred record syntax..

auth

boolean

No

true

use_perm FK

integer

Yes

If set, this permission is required for the source to be listed in the staff client Z39.50 interface. Similar to permission.grp_tree.application_perm. → permission.perm_list(id)

Primary Key

(name)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

use_perm

permission.perm_list(id)

RESTRICT

CASCADE

DEFERRED

use_perm_fkey

Unique Constraints

  • z3950_source_label_key: (label)

Indexes

Index Method Definition

z3950_source_pkey PK

btree

CREATE UNIQUE INDEX z3950_source_pkey ON config.z3950_source USING btree (name)

z3950_source_label_key UNIQUE

btree

CREATE UNIQUE INDEX z3950_source_label_key ON config.z3950_source USING btree (label)

Referenced By

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

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

config.z3950_attr

source

name

z3950_attr_source_fkey

config.z3950_source_credentials

source

name

z3950_source_credentials_source_fkey
Previous
Next