okayapi_fie_verification_code - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_fie_verification_code：/tablelist/okayapi_fie_verification_code.html


-- MySQL Table okayapi_fie_verification_code
-- From: OkayAPI.com
CREATE TABLE `okayapi_fie_verification_code` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `count` int(10) NOT NULL DEFAULT '0' COMMENT '当天已经发送成功的次数',
    `send_time` int(10) NOT NULL DEFAULT '0' COMMENT '最后发送成功时间',
    `expire_time` int(10) NOT NULL DEFAULT '0' COMMENT '验证码过期时间',
    `okayapi_fie_verification_code_code` varchar(8) NOT NULL COMMENT '最后发送成功的验证码',
    `okayapi_fie_verification_code_account` varchar(100) NOT NULL COMMENT '手机号或者邮箱',
    KEY `count` (`count`),
    KEY `send_time` (`send_time`),
    KEY `expire_time` (`expire_time`),
    KEY `okayapi_fie_verification_code_code` (`okayapi_fie_verification_code_code`),
    KEY `okayapi_fie_verification_code_account` (`okayapi_fie_verification_code_account`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'fie内容管理-手机邮箱数字验证码表';

After replication, you can go to the database to create the database table.

MySQL database table structure design

Displaying 1-5 of 5 results.

Field Name	Field Type	Default	IS NULL	Field Comment	Demo Data
count	int(10)	0	否	当天已经发送成功的次数	0
send_time	int(10)	0	否	最后发送成功时间	0
expire_time	int(10)	0	否	验证码过期时间	0
okayapi_fie_verification_code_code	varchar(8)		否	最后发送成功的验证码
okayapi_fie_verification_code_account	varchar(100)		否	手机号或者邮箱