password_reset_tokens
Password reset tokens with 1-hour expiration
Записей: ~1
Колонки
| Колонка | Тип | Nullable | Default | Описание |
|---|---|---|---|---|
| id 🔑 | uuid | NOT NULL | uuid_generate_v4() | |
| user_id | uuid | NOT NULL | → organization_users(id) | |
| token | character varying(255) | NOT NULL | ||
| expires_at | timestamp without time zone | NOT NULL | ||
| used_at | timestamp without time zone | NULL | Timestamp when token was used, NULL if not used | |
| created_at | timestamp without time zone | NULL | CURRENT_TIMESTAMP |
🔑 = Primary Key, → = Foreign Key
Индексы
| Имя | Определение |
|---|---|
| idx_password_reset_tokens_expires_at | CREATE INDEX idx_password_reset_tokens_expires_at ON public.password_reset_to... |
| idx_password_reset_tokens_token | CREATE INDEX idx_password_reset_tokens_token ON public.password_reset_tokens ... |
| idx_password_reset_tokens_user_id | CREATE INDEX idx_password_reset_tokens_user_id ON public.password_reset_token... |
| password_reset_tokens_pkey | CREATE UNIQUE INDEX password_reset_tokens_pkey ON public.password_reset_token... |
| password_reset_tokens_token_key | CREATE UNIQUE INDEX password_reset_tokens_token_key ON public.password_reset_... |
Foreign Keys
| Колонка | Ссылка на |
|---|---|
| user_id | organization_users(id) |