okayapi_fie_user_token - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_fie_user_token：/tablelist/okayapi_fie_user_token.html


-- MySQL Table okayapi_fie_user_token
-- From: OkayAPI.com
CREATE TABLE `okayapi_fie_user_token` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `user_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '用户id',
    `expire_time` int(10) NOT NULL DEFAULT '0' COMMENT ' 过期时间',
    `create_time` int(10) NOT NULL DEFAULT '0' COMMENT '创建时间',
    `token` varchar(64) NOT NULL COMMENT 'token',
    `device_type` varchar(10) NOT NULL COMMENT '设备类型;mobile,android,iphone,ipad,web,pc,mac,wxapp',
    KEY `user_id` (`user_id`),
    KEY `expire_time` (`expire_time`),
    KEY `create_time` (`create_time`),
    KEY `token` (`token`),
    KEY `device_type` (`device_type`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'fie内容管理-用户客户端登录 token 表';

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
user_id	bigint(20)	0	否	用户id	0
expire_time	int(10)	0	否	过期时间	0
create_time	int(10)	0	否	创建时间	0
token	varchar(64)		否	token
device_type	varchar(10)		否	设备类型;mobile,android,iphone,ipad,web,pc,mac,wxapp