url_verify.verification_attempt

Cascading Deletes: Deleting rows from this table will cascade to: url_verify.session.

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

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`integer`	No	nextval('url_verify.verification_attempt_id_seq'::regclass)
usr FK	`integer`	No		→ actor.usr(id)
session FK	`integer`	No		→ url_verify.session(id)
start_time	`timestamp with time zone`	No	now()
finish_time	`timestamp with time zone`	Yes

id PK

integer

nextval('url_verify.verification_attempt_id_seq'::regclass)

usr FK

integer

→ actor.usr(id)

session FK

integer

→ url_verify.session(id)

start_time

timestamp with time zone

now()

finish_time

timestamp with time zone

Yes

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`session`	url_verify.session(id)	CASCADE	CASCADE	DEFERRED	`verification_attempt_session_fkey`
`usr`	actor.usr(id)	NO ACTION	NO ACTION	DEFERRED	`verification_attempt_usr_fkey`

session

url_verify.session(id)

CASCADE

DEFERRED

verification_attempt_session_fkey

usr

actor.usr(id)

NO ACTION

DEFERRED

verification_attempt_usr_fkey

Indexes

Index Method Definition

Index	Method	Definition
`verification_attempt_pkey` PK	btree	`CREATE UNIQUE INDEX verification_attempt_pkey ON url_verify.verification_attempt USING btree (id)`

verification_attempt_pkey PK

btree

CREATE UNIQUE INDEX verification_attempt_pkey ON url_verify.verification_attempt USING btree (id)

Referenced By

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

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

Table	Referencing Column(s)	Referenced Column(s)	Constraint
url_verify.url_verification	`attempt`	`id`	`url_verification_attempt_fkey`

url_verify.url_verification

attempt

id

url_verification_attempt_fkey