okayapi_tea_user - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_tea_user：/tablelist/okayapi_tea_user.html


-- MySQL Table okayapi_tea_user
-- From: OkayAPI.com
CREATE TABLE `okayapi_tea_user` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `user_identify` varchar(255) NOT NULL COMMENT '用户的唯一标识(openid)',
    `user_wechat` varchar(255) NOT NULL COMMENT '用户微信账号',
    `user_mobile` varchar(20) NOT NULL COMMENT '用户手机',
    `user_nickname` varchar(255) NOT NULL COMMENT '用户名',
    KEY `user_identify` (`user_identify`),
    KEY `user_wechat` (`user_wechat`),
    KEY `user_mobile` (`user_mobile`),
    KEY `user_nickname` (`user_nickname`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT '小程序用户表';

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

MySQL database table structure design

Displaying 1-4 of 4 results.

Field Name	Field Type	IS NULL	Field Comment
user_identify	varchar(255)	是	用户的唯一标识(openid)
user_wechat	varchar(255)	是	用户微信账号
user_mobile	varchar(20)	是	用户手机
user_nickname	varchar(255)	否	用户名