+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_srcms_member:/tablelist/okayapi_srcms_member.html


-- MySQL Table okayapi_srcms_member
-- From: OkayAPI.com
CREATE TABLE `okayapi_srcms_member` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `okayapi_srcms_member_type` tinyint(1) NULL DEFAULT '1' COMMENT '1:前台用户 2:管理员 ',
    `jifen` int(10) NULL DEFAULT '0' COMMENT '用户积分',
    `jinbi` varchar(255) NULL DEFAULT '0' COMMENT '安全币',
    `pid` varchar(255) NULL DEFAULT '0' COMMENT '个人资料ID',
    `username` varchar(20) NULL DEFAULT '路人甲' COMMENT '用户昵称',
    `realname` varchar(100) NULL DEFAULT '暂无' COMMENT '真实姓名',
    `team` varchar(255) NULL DEFAULT '暂无' COMMENT '团队名称',
    `email` varchar(100) NULL DEFAULT '暂无' COMMENT '用户邮箱',
    `salt` varchar(9) NULL DEFAULT '暂无' COMMENT '加密salt',
    `okayapi_srcms_member_password` varchar(32) NULL COMMENT '用户密码',
    `token` varchar(255) NULL DEFAULT '0' COMMENT '防护token',
    `avatar` varchar(255) NULL DEFAULT '暂无' COMMENT '用户头像',
    `address` varchar(255) NULL DEFAULT '暂无' COMMENT '用户住址',
    `description` varchar(255) NULL DEFAULT '暂无' COMMENT '个人简介',
    `bankcode` varchar(255) NULL DEFAULT '暂无' COMMENT '银行账号',
    `idcode` varchar(255) NULL DEFAULT '暂无' COMMENT '身份证号',
    `zipcode` varchar(255) NULL DEFAULT '暂无' COMMENT '邮编',
    `alipay` varchar(255) NULL DEFAULT '暂无' COMMENT '支付宝账号',
    `tel` varchar(255) NULL DEFAULT '暂无' COMMENT '联系电话',
    `website` varchar(255) NULL DEFAULT '暂无' COMMENT '个人网站',
    `qqnumber` varchar(255) NULL DEFAULT '0' COMMENT 'QQ号',
    `create_at` varchar(11) NULL DEFAULT '0' COMMENT '创建时间',
    `update_at` varchar(11) NULL DEFAULT '0' COMMENT '更新时间',
    `login_ip` varchar(20) NULL DEFAULT '0' COMMENT '登录IP',
    `okayapi_srcms_member_status` tinyint(1) NULL DEFAULT '1' COMMENT '0:禁止登陆 1:正常',
    KEY `okayapi_srcms_member_type` (`okayapi_srcms_member_type`),
    KEY `jifen` (`jifen`),
    KEY `jinbi` (`jinbi`),
    KEY `pid` (`pid`),
    KEY `username` (`username`),
    KEY `realname` (`realname`),
    KEY `team` (`team`),
    KEY `email` (`email`),
    KEY `salt` (`salt`),
    KEY `okayapi_srcms_member_password` (`okayapi_srcms_member_password`),
    KEY `token` (`token`),
    KEY `avatar` (`avatar`),
    KEY `address` (`address`),
    KEY `description` (`description`),
    KEY `bankcode` (`bankcode`),
    KEY `idcode` (`idcode`),
    KEY `zipcode` (`zipcode`),
    KEY `alipay` (`alipay`),
    KEY `tel` (`tel`),
    KEY `website` (`website`),
    KEY `qqnumber` (`qqnumber`),
    KEY `create_at` (`create_at`),
    KEY `update_at` (`update_at`),
    KEY `login_ip` (`login_ip`),
    KEY `okayapi_srcms_member_status` (`okayapi_srcms_member_status`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'SRCMS-会员';

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


MySQL database table structure design

Displaying 1-25 of 25 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
okayapi_srcms_member_typetinyint(1)11:前台用户 2:管理员 1
jifenint(10)0用户积分0
jinbivarchar(255)0安全币0
pidvarchar(255)0个人资料ID0
usernamevarchar(20)路人甲用户昵称路人甲
realnamevarchar(100)暂无真实姓名暂无
teamvarchar(255)暂无团队名称暂无
emailvarchar(100)暂无用户邮箱暂无
saltvarchar(9)暂无加密salt暂无
okayapi_srcms_member_passwordvarchar(32)用户密码
tokenvarchar(255)0防护token0
avatarvarchar(255)暂无用户头像暂无
addressvarchar(255)暂无用户住址暂无
descriptionvarchar(255)暂无个人简介暂无
bankcodevarchar(255)暂无银行账号暂无
idcodevarchar(255)暂无身份证号暂无
zipcodevarchar(255)暂无邮编暂无
alipayvarchar(255)暂无支付宝账号暂无
telvarchar(255)暂无联系电话暂无
websitevarchar(255)暂无个人网站暂无
qqnumbervarchar(255)0QQ号0
create_atvarchar(11)0创建时间0
update_atvarchar(11)0更新时间0
login_ipvarchar(20)0登录IP0
okayapi_srcms_member_statustinyint(1)10:禁止登陆 1:正常1

Guess You Like

MySQL Table Design okayapi_srcms_blog

MySQL Table Design okayapi_srcms_category

MySQL Table Design okayapi_srcms_comment

MySQL Table Design okayapi_srcms_hall

MySQL Table Design okayapi_srcms_info

MySQL Table Design okayapi_srcms_links

MySQL Table Design okayapi_srcms_manager

MySQL Table Design okayapi_srcms_notes

MySQL Table Design okayapi_srcms_order

MySQL Table Design okayapi_srcms_page

MySQL Table Design okayapi_srcms_post

MySQL Table Design okayapi_srcms_record

MySQL Table Design okayapi_srcms_setting

TOP ↑