actor.usr_saved_search

↑ actor schema

Cascading Deletes: Deleting rows from this table will cascade to: actor.usr.

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

Columns

Column Type Nullable Default Notes

id PK

integer

No

nextval('actor.usr_saved_search_id_seq'::regclass)

owner FK

integer

No

→ actor.usr(id)

name

text

No

create_date

timestamp with time zone

No

now()

query_text

text

No

query_type

text

No

'URL'::text

target

text

No

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

owner

actor.usr(id)

CASCADE

NO ACTION

DEFERRED

usr_saved_search_owner_fkey

Unique Constraints

  • name_once_per_user: (owner, name)

Check Constraints

  • valid_query_text: CHECK query_type = 'URL'::text

  • valid_target: CHECK target = ANY (ARRAY['record'::text, 'metarecord'::text, 'callnumber'::text])

Indexes

Index Method Definition

usr_saved_search_pkey PK

btree

CREATE UNIQUE INDEX usr_saved_search_pkey ON actor.usr_saved_search USING btree (id)

name_once_per_user UNIQUE

btree

CREATE UNIQUE INDEX name_once_per_user ON actor.usr_saved_search USING btree (owner, name)
Previous
Next