MySQL Create Table SQL
Table Structure: okayapi_xbinstore_tb_manage_user:/tablelist/okayapi_xbinstore_tb_manage_user.html
-- MySQL Table okayapi_xbinstore_tb_manage_user
-- From: OkayAPI.com
CREATE TABLE `okayapi_xbinstore_tb_manage_user` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`username` varchar(50) NOT NULL COMMENT '用户名',
`okayapi_xbinstore_tb_manage_user_name` varchar(50) NOT NULL COMMENT '姓名',
`okayapi_xbinstore_tb_manage_user_password` varchar(32) NOT NULL COMMENT '密码,加密存储',
`phone` varchar(20) NOT NULL COMMENT '注册手机号',
`email` varchar(50) NOT NULL COMMENT '注册邮箱',
`job` varchar(50) NOT NULL COMMENT '工作',
`created` datetime NOT NULL COMMENT '',
`updated` datetime NOT NULL COMMENT '',
KEY `username` (`username`),
KEY `okayapi_xbinstore_tb_manage_user_name` (`okayapi_xbinstore_tb_manage_user_name`),
KEY `okayapi_xbinstore_tb_manage_user_password` (`okayapi_xbinstore_tb_manage_user_password`),
KEY `phone` (`phone`),
KEY `email` (`email`),
KEY `job` (`job`),
KEY `created` (`created`),
KEY `updated` (`updated`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'B2C商城-后台用户表';
After replication, you can go to the database to create the database table.
MySQL database table structure design
Displaying 1-8 of 8 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
username | varchar(50) | 否 | 用户名 | Unique Index | ||
okayapi_xbinstore_tb_manage_user_name | varchar(50) | 否 | 姓名 | |||
okayapi_xbinstore_tb_manage_user_password | varchar(32) | 否 | 密码,加密存储 | |||
phone | varchar(20) | 是 | 注册手机号 | Unique Index | ||
varchar(50) | 是 | 注册邮箱 | Unique Index | |||
job | varchar(50) | 是 | 工作 | |||
created | datetime | 否 | ||||
updated | datetime | 否 |