actor.usr_password_reset

↑ actor schema

Self-serve password reset requests

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

Columns

Column Type Nullable Default Notes

id PK

integer

No

nextval('actor.usr_password_reset_id_seq'::regclass)

uuid

text

No

usr FK

bigint

No

→ actor.usr(id)

request_time

timestamp with time zone

No

now()

has_been_reset

boolean

No

false

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

usr

actor.usr(id)

NO ACTION

NO ACTION

DEFERRED

usr_password_reset_usr_fkey

Indexes

Index Method Definition

usr_password_reset_pkey PK

btree

CREATE UNIQUE INDEX usr_password_reset_pkey ON actor.usr_password_reset USING btree (id)

actor_usr_password_reset_uuid_idx UNIQUE

btree

CREATE UNIQUE INDEX actor_usr_password_reset_uuid_idx ON actor.usr_password_reset USING btree (uuid)

actor_usr_password_reset_has_been_reset_idx

btree

CREATE INDEX actor_usr_password_reset_has_been_reset_idx ON actor.usr_password_reset USING btree (has_been_reset)

actor_usr_password_reset_request_time_idx

btree

CREATE INDEX actor_usr_password_reset_request_time_idx ON actor.usr_password_reset USING btree (request_time)

actor_usr_password_reset_usr_idx

btree

CREATE INDEX actor_usr_password_reset_usr_idx ON actor.usr_password_reset USING btree (usr)
Previous
Next