staff_password_reset_tokens
Колонки
| Колонка |
Тип |
Nullable |
Default |
Описание |
| id 🔑 |
uuid |
NOT NULL |
|
|
| staff_user_id |
uuid |
NOT NULL |
|
→ staff_users(id) |
| token |
character varying(255) |
NOT NULL |
|
|
| expires_at |
timestamp without time zone |
NOT NULL |
|
|
| used_at |
timestamp without time zone |
NULL |
|
|
| created_at |
timestamp without time zone |
NULL |
now() |
|
🔑 = Primary Key, → = Foreign Key
Индексы
| Имя |
Определение |
| ix_staff_password_reset_tokens_expires_at |
CREATE INDEX ix_staff_password_reset_tokens_expires_at ON public.staff_passwo... |
| ix_staff_password_reset_tokens_staff_user_id |
CREATE INDEX ix_staff_password_reset_tokens_staff_user_id ON public.staff_pas... |
| ix_staff_password_reset_tokens_token |
CREATE UNIQUE INDEX ix_staff_password_reset_tokens_token ON public.staff_pass... |
| staff_password_reset_tokens_pkey |
CREATE UNIQUE INDEX staff_password_reset_tokens_pkey ON public.staff_password... |
Foreign Keys