url_verify.url_selector

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: url_selector_session_fkey.

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`integer`	No	nextval('url_verify.url_selector_id_seq'::regclass)
xpath	`text`	No
session FK	`integer`	No		→ url_verify.session(id)

id PK

integer

nextval('url_verify.url_selector_id_seq'::regclass)

xpath

text

session FK

integer

→ url_verify.session(id)

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	`url_selector_session_fkey`

session

url_verify.session(id)

CASCADE

DEFERRED

url_selector_session_fkey

Unique Constraints

tag_once_per_sess: (xpath, session)

Indexes

Index Method Definition

Index	Method	Definition
`url_selector_pkey` PK	btree	`CREATE UNIQUE INDEX url_selector_pkey ON url_verify.url_selector USING btree (id)`
`tag_once_per_sess` UNIQUE	btree	`CREATE UNIQUE INDEX tag_once_per_sess ON url_verify.url_selector USING btree (xpath, session)`

url_selector_pkey PK

btree

CREATE UNIQUE INDEX url_selector_pkey ON url_verify.url_selector USING btree (id)

tag_once_per_sess UNIQUE

btree

CREATE UNIQUE INDEX tag_once_per_sess ON url_verify.url_selector USING btree (xpath, session)

Referenced By

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

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

Table	Referencing Column(s)	Referenced Column(s)	Constraint
url_verify.url	`url_selector`	`id`	`url_url_selector_fkey`

url_verify.url

url_selector

id

url_url_selector_fkey