sip.session

Cascading Deletes: Deleting rows from this table will cascade to: sip.account.

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

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
key PK	`text`	No
ils_token	`text`	No
account FK	`integer`	No		→ sip.account(id)
create_time	`timestamp with time zone`	No	now()

key PK

text

ils_token

text

account FK

integer

→ sip.account(id)

create_time

timestamp with time zone

now()

Primary Key

(key)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`account`	sip.account(id)	CASCADE	NO ACTION	DEFERRED	`session_account_fkey`

account

sip.account(id)

CASCADE

NO ACTION

DEFERRED

session_account_fkey

Unique Constraints

session_ils_token_key: (ils_token)

Indexes

Index Method Definition

Index	Method	Definition
`session_pkey` PK	btree	`CREATE UNIQUE INDEX session_pkey ON sip.session USING btree (key)`
`session_ils_token_key` UNIQUE	btree	`CREATE UNIQUE INDEX session_ils_token_key ON sip.session USING btree (ils_token)`

session_pkey PK

btree

CREATE UNIQUE INDEX session_pkey ON sip.session USING btree (key)

session_ils_token_key UNIQUE

btree

CREATE UNIQUE INDEX session_ils_token_key ON sip.session USING btree (ils_token)