actor.usr_setting

↑ actor schema

User settings

This table contains any arbitrary settings that a client program would like to save for a user.

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

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

Columns

Column Type Nullable Default Notes

id PK

bigint

No

nextval('actor.usr_setting_id_seq'::regclass)

usr FK

integer

No

→ actor.usr(id)

name FK

text

No

→ config.usr_setting_type(name)

value

text

No

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

name

config.usr_setting_type(name)

CASCADE

CASCADE

DEFERRED

usr_setting_name_fkey

usr

actor.usr(id)

CASCADE

NO ACTION

DEFERRED

usr_setting_usr_fkey

Unique Constraints

  • usr_once_per_key: (usr, name)

Indexes

Index Method Definition

usr_setting_pkey PK

btree

CREATE UNIQUE INDEX usr_setting_pkey ON actor.usr_setting USING btree (id)

usr_once_per_key UNIQUE

btree

CREATE UNIQUE INDEX usr_once_per_key ON actor.usr_setting USING btree (usr, name)

actor_usr_setting_phone_values_idx

btree

CREATE INDEX actor_usr_setting_phone_values_idx ON actor.usr_setting USING btree (lowercase(value)) WHERE (name = ANY (ARRAY['opac.default_phone'::text, 'opac.default_sms_notify'::text]))

actor_usr_setting_phone_values_numeric_idx

btree

CREATE INDEX actor_usr_setting_phone_values_numeric_idx ON actor.usr_setting USING btree (lowercase(regexp_replace(value, '[^0-9]'::text, ''::text, 'g'::text))) WHERE (name = ANY (ARRAY['opac.default_phone'::text, 'opac.default_sms_notify'::text]))

actor_usr_setting_usr_idx

btree

CREATE INDEX actor_usr_setting_usr_idx ON actor.usr_setting USING btree (usr)
Previous
Next