verify_codes
| Column Name | Type | Comment | Default | Null | Remark |
|---|---|---|---|---|---|
| id | bigint UNSIGNED | Primary Key ID | NO | Auto Increment | |
| template_id | tinyint UNSIGNED | Template ID | NO | ||
| type | tinyint UNSIGNED | Type | 1 | NO | 1.Email / 2.SMS |
| account | varchar(128) | Account | NO | Email or phone, phone number with international area code, no plus sign | |
| code | varchar(8) | Verification Code | NO | ||
| is_enabled | tinyint UNSIGNED | Is Valid | 1 | NO | 0.Invalid / 1.Valid |
| expired_at | timestamp | Expiration Time | NO | ||
| created_at | timestamp | Create Time | CURRENT_TIMESTAMP | NO | |
| updated_at | timestamp | Update Time | YES | ||
| deleted_at | timestamp | Delete Time | YES |