auth.one_time_tokens
| # | Name | Type | Nullable | Default | PK |
|---|---|---|---|---|---|
| 1 | id | uuid | NO | — | PK |
| 2 | user_id | uuid | NO | — | |
| 3 | token_type | USER-DEFINED | NO | — | |
| 4 | token_hash | text | NO | — | |
| 5 | relates_to | text | NO | — | |
| 6 | created_at | timestamp without time zone | NO | now() | |
| 7 | updated_at | timestamp without time zone | NO | now() |
Indexes
| Name | Definition | Unique | Primary | Size |
|---|---|---|---|---|
| one_time_tokens_pkey | CREATE UNIQUE INDEX one_time_tokens_pkey ON auth.one_time_tokens USING btree (id) | ✓ | ✓ | 8192 bytes |
| one_time_tokens_relates_to_hash_idx | CREATE 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_idx | CREATE 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_key | CREATE UNIQUE INDEX one_time_tokens_user_id_token_type_key ON auth.one_time_tokens USING btree (user_id, token_type) | ✓ | 8192 bytes |
Constraints
| Name | Type | Definition |
|---|---|---|
| one_time_tokens_token_hash_check | CHECK | CHECK ((char_length(token_hash) > 0)) |
| one_time_tokens_user_id_fkey | FOREIGN KEY | FOREIGN KEY (user_id) REFERENCES auth.users(id) ON DELETE CASCADE |
| one_time_tokens_pkey | PRIMARY KEY | PRIMARY KEY (id) |