url_verify.url_verification

↑ url_verify schema

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

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

Columns

Column Type Nullable Default Notes

id PK

integer

No

nextval('url_verify.url_verification_id_seq'::regclass)

url FK

integer

No

→ url_verify.url(id)

attempt FK

integer

No

→ url_verify.verification_attempt(id)

req_time

timestamp with time zone

No

now()

res_time

timestamp with time zone

Yes

res_code

integer

Yes

res_text

text

Yes

redirect_to FK

integer

Yes

→ url_verify.url(id)

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

attempt

url_verify.verification_attempt(id)

NO ACTION

NO ACTION

DEFERRED

url_verification_attempt_fkey

redirect_to

url_verify.url(id)

NO ACTION

NO ACTION

DEFERRED

url_verification_redirect_to_fkey

url

url_verify.url(id)

CASCADE

CASCADE

DEFERRED

url_verification_url_fkey

Check Constraints

  • url_verification_res_code_check: CHECK

Indexes

Index Method Definition

url_verification_pkey PK

btree

CREATE UNIQUE INDEX url_verification_pkey ON url_verify.url_verification USING btree (id)
Previous
Next