+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_shopxo_s_user:/tablelist/okayapi_shopxo_s_user.html


-- MySQL Table okayapi_shopxo_s_user
-- From: OkayAPI.com
CREATE TABLE `okayapi_shopxo_s_user` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `alipay_openid` char(60) NOT NULL COMMENT '支付宝openid',
    `weixin_openid` char(60) NOT NULL COMMENT '微信openid',
    `weixin_web_openid` char(60) NOT NULL COMMENT '微信web用户openid',
    `baidu_openid` char(60) NOT NULL COMMENT '百度openid',
    `okayapi_shopxo_s_user_status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '状态(0正常, 1禁止发言, 2禁止登录)',
    `salt` char(32) NOT NULL COMMENT '配合密码加密串',
    `pwd` char(32) NOT NULL COMMENT '登录密码',
    `token` char(60) NOT NULL COMMENT 'token',
    `username` char(60) NOT NULL COMMENT '用户名',
    `nickname` char(60) NOT NULL COMMENT '用户昵称',
    `mobile` char(11) NOT NULL COMMENT '手机号码',
    `email` char(60) NOT NULL COMMENT '电子邮箱(最大长度60个字符)',
    `gender` tinyint(1) NOT NULL DEFAULT '0' COMMENT '性别(0保密,1女,2男)',
    `avatar` char(255) NOT NULL COMMENT '用户头像地址',
    `province` char(60) NOT NULL COMMENT '所在省',
    `city` char(60) NOT NULL COMMENT '所在市',
    `birthday` int(11) NOT NULL DEFAULT '0' COMMENT '生日',
    `address` char(150) NOT NULL COMMENT '详细地址',
    `integral` int(10) NOT NULL DEFAULT '0' COMMENT '积分',
    `locking_integral` int(10) NOT NULL DEFAULT '0' COMMENT '锁定积分',
    `referrer` int(11) NOT NULL DEFAULT '0' COMMENT '推荐人用户id',
    `is_delete_time` int(11) NOT NULL DEFAULT '0' COMMENT '是否已删除(0否, 大于0删除时间)',
    `upd_time` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间',
    KEY `alipay_openid` (`alipay_openid`),
    KEY `weixin_openid` (`weixin_openid`),
    KEY `weixin_web_openid` (`weixin_web_openid`),
    KEY `baidu_openid` (`baidu_openid`),
    KEY `okayapi_shopxo_s_user_status` (`okayapi_shopxo_s_user_status`),
    KEY `salt` (`salt`),
    KEY `pwd` (`pwd`),
    KEY `token` (`token`),
    KEY `username` (`username`),
    KEY `nickname` (`nickname`),
    KEY `mobile` (`mobile`),
    KEY `email` (`email`),
    KEY `gender` (`gender`),
    KEY `avatar` (`avatar`),
    KEY `province` (`province`),
    KEY `city` (`city`),
    KEY `birthday` (`birthday`),
    KEY `address` (`address`),
    KEY `integral` (`integral`),
    KEY `locking_integral` (`locking_integral`),
    KEY `referrer` (`referrer`),
    KEY `is_delete_time` (`is_delete_time`),
    KEY `upd_time` (`upd_time`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'ShopXO商城-用户';

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


MySQL database table structure design

Displaying 1-23 of 23 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
alipay_openidchar(60)支付宝openidNormal Index
weixin_openidchar(60)微信openidNormal Index
weixin_web_openidchar(60)微信web用户openid
baidu_openidchar(60)百度openidNormal Index
okayapi_shopxo_s_user_statustinyint(1)0状态(0正常, 1禁止发言, 2禁止登录)0
saltchar(32)配合密码加密串
pwdchar(32)登录密码
tokenchar(60)tokenNormal Index
usernamechar(60)用户名Normal Index
nicknamechar(60)用户昵称
mobilechar(11)手机号码Normal Index
emailchar(60)电子邮箱(最大长度60个字符)
gendertinyint(1)0性别(0保密,1女,2男)0
avatarchar(255)用户头像地址
provincechar(60)所在省
citychar(60)所在市
birthdayint(11)0生日0
addresschar(150)详细地址
integralint(10)0积分0
locking_integralint(10)0锁定积分0
referrerint(11)0推荐人用户id0
is_delete_timeint(11)0是否已删除(0否, 大于0删除时间)0
upd_timeint(11)0更新时间0

Guess You Like

MySQL Table Design okayapi_goods

MySQL Table Design okayapi_goods_comment

MySQL Table Design okayapi_shopxo_s_admin

MySQL Table Design okayapi_shopxo_s_answer

MySQL Table Design okayapi_shopxo_s_app_center_nav

MySQL Table Design okayapi_shopxo_s_app_home_nav

MySQL Table Design okayapi_shopxo_s_article

MySQL Table Design okayapi_shopxo_s_article_category

MySQL Table Design okayapi_shopxo_s_attachment

MySQL Table Design okayapi_shopxo_s_brand

MySQL Table Design okayapi_shopxo_s_brand_category

MySQL Table Design okayapi_shopxo_s_cart

MySQL Table Design okayapi_shopxo_s_config

MySQL Table Design okayapi_shopxo_s_custom_view

MySQL Table Design okayapi_shopxo_s_express

MySQL Table Design okayapi_shopxo_s_goods

MySQL Table Design okayapi_shopxo_s_goods_browse

MySQL Table Design okayapi_shopxo_s_goods_category

MySQL Table Design okayapi_shopxo_s_goods_category_join

MySQL Table Design okayapi_shopxo_s_goods_comments

TOP ↑