+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_xbinstore_tb_user:/tablelist/okayapi_xbinstore_tb_user.html


-- MySQL Table okayapi_xbinstore_tb_user
-- From: OkayAPI.com
CREATE TABLE `okayapi_xbinstore_tb_user` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `username` varchar(50) NOT NULL COMMENT '用户名',
    `okayapi_xbinstore_tb_user_password` varchar(32) NOT NULL COMMENT '密码,加密存储',
    `phone` varchar(20) NOT NULL COMMENT '注册手机号',
    `email` varchar(50) NOT NULL COMMENT '注册邮箱',
    `created` datetime NOT NULL COMMENT '',
    `updated` datetime NOT NULL COMMENT '',
    KEY `username` (`username`),
    KEY `okayapi_xbinstore_tb_user_password` (`okayapi_xbinstore_tb_user_password`),
    KEY `phone` (`phone`),
    KEY `email` (`email`),
    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-6 of 6 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
usernamevarchar(50)用户名Unique Index
okayapi_xbinstore_tb_user_passwordvarchar(32)密码,加密存储
phonevarchar(20)注册手机号Unique Index
emailvarchar(50)注册邮箱Unique Index
createddatetime
updateddatetime

Guess You Like

MySQL Table Design okayapi_xbinstore_tb_category

MySQL Table Design okayapi_xbinstore_tb_category_image

MySQL Table Design okayapi_xbinstore_tb_category_secondary

MySQL Table Design okayapi_xbinstore_tb_hot_words

MySQL Table Design okayapi_xbinstore_tb_index_slide_ad

MySQL Table Design okayapi_xbinstore_tb_item

MySQL Table Design okayapi_xbinstore_tb_item_desc

MySQL Table Design okayapi_xbinstore_tb_item_param

MySQL Table Design okayapi_xbinstore_tb_item_param_item

MySQL Table Design okayapi_xbinstore_tb_manage_user

MySQL Table Design okayapi_xbinstore_tb_order

MySQL Table Design okayapi_xbinstore_tb_order_item

MySQL Table Design okayapi_xbinstore_tb_transaction_message

MySQL Table Design okayapi_xbinstore_tb_user_addr

TOP ↑