auth.sessions
| # | Name | Type | Nullable | Default | PK |
|---|---|---|---|---|---|
| 1 | id | uuid | NO | — | PK |
| 2 | user_id | uuid | NO | — | |
| 3 | created_at | timestamp with time zone | YES | — | |
| 4 | updated_at | timestamp with time zone | YES | — | |
| 5 | factor_id | uuid | YES | — | |
| 6 | aal | USER-DEFINED | YES | — | |
| 7 | not_after | timestamp with time zone | YES | — | |
| 8 | refreshed_at | timestamp without time zone | YES | — | |
| 9 | user_agent | text | YES | — | |
| 10 | ip | inet | YES | — | |
| 11 | tag | text | YES | — |
Indexes
| Name | Definition | Unique | Primary | Size |
|---|---|---|---|---|
| sessions_not_after_idx | CREATE INDEX sessions_not_after_idx ON auth.sessions USING btree (not_after DESC) | 8192 bytes | ||
| sessions_pkey | CREATE UNIQUE INDEX sessions_pkey ON auth.sessions USING btree (id) | ✓ | ✓ | 8192 bytes |
| sessions_user_id_idx | CREATE INDEX sessions_user_id_idx ON auth.sessions USING btree (user_id) | 8192 bytes | ||
| user_id_created_at_idx | CREATE INDEX user_id_created_at_idx ON auth.sessions USING btree (user_id, created_at) | 8192 bytes |
Constraints
| Name | Type | Definition |
|---|---|---|
| sessions_user_id_fkey | FOREIGN KEY | FOREIGN KEY (user_id) REFERENCES auth.users(id) ON DELETE CASCADE |
| sessions_pkey | PRIMARY KEY | PRIMARY KEY (id) |