auth.sessions

#NameTypeNullableDefaultPK
1iduuidNOPK
2user_iduuidNO
3created_attimestamp with time zoneYES
4updated_attimestamp with time zoneYES
5factor_iduuidYES
6aalUSER-DEFINEDYES
7not_aftertimestamp with time zoneYES
8refreshed_attimestamp without time zoneYES
9user_agenttextYES
10ipinetYES
11tagtextYES

Indexes

NameDefinitionUniquePrimarySize
sessions_not_after_idxCREATE INDEX sessions_not_after_idx ON auth.sessions USING btree (not_after DESC)8192 bytes
sessions_pkeyCREATE UNIQUE INDEX sessions_pkey ON auth.sessions USING btree (id)8192 bytes
sessions_user_id_idxCREATE INDEX sessions_user_id_idx ON auth.sessions USING btree (user_id)8192 bytes
user_id_created_at_idxCREATE INDEX user_id_created_at_idx ON auth.sessions USING btree (user_id, created_at)8192 bytes

Constraints

NameTypeDefinition
sessions_user_id_fkeyFOREIGN KEYFOREIGN KEY (user_id) REFERENCES auth.users(id) ON DELETE CASCADE
sessions_pkeyPRIMARY KEYPRIMARY KEY (id)