auth.refresh_tokens

#NameTypeNullableDefaultPK
1instance_iduuidYES
2idbigintNOnextval('auth.refresh_tokens_id_seq'::regclass)PK
3tokencharacter varyingYES
4user_idcharacter varyingYES
5revokedbooleanYES
6created_attimestamp with time zoneYES
7updated_attimestamp with time zoneYES
8parentcharacter varyingYES
9session_iduuidYES

Indexes

NameDefinitionUniquePrimarySize
refresh_tokens_instance_id_idxCREATE INDEX refresh_tokens_instance_id_idx ON auth.refresh_tokens USING btree (instance_id)8192 bytes
refresh_tokens_instance_id_user_id_idxCREATE INDEX refresh_tokens_instance_id_user_id_idx ON auth.refresh_tokens USING btree (instance_id, user_id)8192 bytes
refresh_tokens_parent_idxCREATE INDEX refresh_tokens_parent_idx ON auth.refresh_tokens USING btree (parent)8192 bytes
refresh_tokens_pkeyCREATE UNIQUE INDEX refresh_tokens_pkey ON auth.refresh_tokens USING btree (id)8192 bytes
refresh_tokens_session_id_revoked_idxCREATE INDEX refresh_tokens_session_id_revoked_idx ON auth.refresh_tokens USING btree (session_id, revoked)8192 bytes
refresh_tokens_token_uniqueCREATE UNIQUE INDEX refresh_tokens_token_unique ON auth.refresh_tokens USING btree (token)8192 bytes
refresh_tokens_updated_at_idxCREATE INDEX refresh_tokens_updated_at_idx ON auth.refresh_tokens USING btree (updated_at DESC)8192 bytes

Constraints

NameTypeDefinition
refresh_tokens_session_id_fkeyFOREIGN KEYFOREIGN KEY (session_id) REFERENCES auth.sessions(id) ON DELETE CASCADE
refresh_tokens_pkeyPRIMARY KEYPRIMARY KEY (id)
refresh_tokens_token_uniqueUNIQUEUNIQUE (token)