public.user_otps¶
Columns¶
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| attempts | smallint | false | ||||
| created_at | timestamp with time zone | false | ||||
| delivered_to | varchar(254) | false | ||||
| expires_at | timestamp with time zone | false | ||||
| id | bigint | false | ||||
| is_used | boolean | false | ||||
| last_attempt_at | timestamp with time zone | true | ||||
| purpose | varchar(32) | false | ||||
| secret | varchar(64) | false | ||||
| user_id | bigint | false | public.users |
Constraints¶
| Name | Type | Definition |
|---|---|---|
| user_otps_attempts_check | CHECK | CHECK ((attempts >= 0)) |
| user_otps_pkey | PRIMARY KEY | PRIMARY KEY (id) |
| user_otps_user_id_2bb8312a_fk_users_id | FOREIGN KEY | FOREIGN KEY (user_id) REFERENCES users(id) DEFERRABLE INITIALLY DEFERRED |
Indexes¶
| Name | Definition |
|---|---|
| user_otps_pkey | CREATE UNIQUE INDEX user_otps_pkey ON public.user_otps USING btree (id) |
| user_otps_user_id_2bb8312a | CREATE INDEX user_otps_user_id_2bb8312a ON public.user_otps USING btree (user_id) |
Generated by tbls