url_verify.session

↑ url_verify schema

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

Columns

Column Type Nullable Default Notes

id PK

integer

No

nextval('url_verify.session_id_seq'::regclass)

name

text

No

owning_lib FK

integer

No

→ actor.org_unit(id)

creator FK

integer

No

→ actor.usr(id)

container FK

integer

No

→ container.biblio_record_entry_bucket(id)

create_time

timestamp with time zone

No

now()

search

text

No

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

container

container.biblio_record_entry_bucket(id)

NO ACTION

NO ACTION

DEFERRED

session_container_fkey

creator

actor.usr(id)

NO ACTION

NO ACTION

DEFERRED

session_creator_fkey

owning_lib

actor.org_unit(id)

NO ACTION

NO ACTION

DEFERRED

session_owning_lib_fkey

Unique Constraints

  • uvs_name_once_per_lib: (name, owning_lib)

Indexes

Index Method Definition

session_pkey PK

btree

CREATE UNIQUE INDEX session_pkey ON url_verify.session USING btree (id)

uvs_name_once_per_lib UNIQUE

btree

CREATE UNIQUE INDEX uvs_name_once_per_lib ON url_verify.session USING btree (name, owning_lib)

Referenced By

The following tables have foreign keys pointing to url_verify.session (3 referencing table(s)):

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

url_verify.url

session

id

url_session_fkey

url_verify.url_selector

session

id

url_selector_session_fkey

url_verify.verification_attempt

session

id

verification_attempt_session_fkey
Previous
Next