config.z3950_source_credentials

↑ config schema

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

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

Columns

Column Type Nullable Default Notes

id PK

integer

No

nextval('config.z3950_source_credentials_id_seq'::regclass)

owner FK

integer

No

→ actor.org_unit(id)

source FK

text

No

→ config.z3950_source(name)

username

text

Yes

password

text

Yes

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

source

config.z3950_source(name)

CASCADE

CASCADE

DEFERRED

z3950_source_credentials_source_fkey

owner

actor.org_unit(id)

CASCADE

NO ACTION

DEFERRED

z3950_source_creds_owner_fkey

Unique Constraints

  • czsc_source_once_per_lib: (source, owner)

Indexes

Index Method Definition

z3950_source_credentials_pkey PK

btree

CREATE UNIQUE INDEX z3950_source_credentials_pkey ON config.z3950_source_credentials USING btree (id)

czsc_source_once_per_lib UNIQUE

btree

CREATE UNIQUE INDEX czsc_source_once_per_lib ON config.z3950_source_credentials USING btree (source, owner)
Previous
Next