auth.one_time_tokens

#NameTypeNullableDefaultPK
1iduuidNOPK
2user_iduuidNO
3token_typeUSER-DEFINEDNO
4token_hashtextNO
5relates_totextNO
6created_attimestamp without time zoneNOnow()
7updated_attimestamp without time zoneNOnow()

Indexes

NameDefinitionUniquePrimarySize
one_time_tokens_pkeyCREATE UNIQUE INDEX one_time_tokens_pkey ON auth.one_time_tokens USING btree (id)8192 bytes
one_time_tokens_relates_to_hash_idxCREATE INDEX one_time_tokens_relates_to_hash_idx ON auth.one_time_tokens USING hash (relates_to)32 kB
one_time_tokens_token_hash_hash_idxCREATE INDEX one_time_tokens_token_hash_hash_idx ON auth.one_time_tokens USING hash (token_hash)32 kB
one_time_tokens_user_id_token_type_keyCREATE UNIQUE INDEX one_time_tokens_user_id_token_type_key ON auth.one_time_tokens USING btree (user_id, token_type)8192 bytes

Constraints

NameTypeDefinition
one_time_tokens_token_hash_checkCHECKCHECK ((char_length(token_hash) > 0))
one_time_tokens_user_id_fkeyFOREIGN KEYFOREIGN KEY (user_id) REFERENCES auth.users(id) ON DELETE CASCADE
one_time_tokens_pkeyPRIMARY KEYPRIMARY KEY (id)