okayapi_eduwind_ew_user - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_eduwind_ew_user：/tablelist/okayapi_eduwind_ew_user.html


-- MySQL Table okayapi_eduwind_ew_user
-- From: OkayAPI.com
CREATE TABLE `okayapi_eduwind_ew_user` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `email` char(64) NOT NULL COMMENT '用户email',
    `okayapi_eduwind_ew_user_password` char(32) NOT NULL COMMENT '密码密文',
    `salt` char(32) NOT NULL COMMENT '与明文密码一起生成passwd',
    `resetPassword` char(64) NOT NULL COMMENT '重设密码用',
    `deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '',
    `deleteTime` int(11) NOT NULL DEFAULT '0' COMMENT '',
    KEY `email` (`email`),
    KEY `okayapi_eduwind_ew_user_password` (`okayapi_eduwind_ew_user_password`),
    KEY `salt` (`salt`),
    KEY `resetPassword` (`resetPassword`),
    KEY `deleted` (`deleted`),
    KEY `deleteTime` (`deleteTime`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'EW在线教育-用户表';

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 Name	Field Type	Default	IS NULL	Field Comment	Index	Demo Data
email	char(64)		否	用户email	Unique Index
okayapi_eduwind_ew_user_password	char(32)		否	密码密文
salt	char(32)		否	与明文密码一起生成passwd
resetPassword	char(64)		否	重设密码用
deleted	tinyint(1)	0	否			0
deleteTime	int(11)	0	否			0