okayapi_lvyou_jee_user - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_lvyou_jee_user：/tablelist/okayapi_lvyou_jee_user.html


-- MySQL Table okayapi_lvyou_jee_user
-- From: OkayAPI.com
CREATE TABLE `okayapi_lvyou_jee_user` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `username` varchar(50) NULL COMMENT '',
    `okayapi_lvyou_jee_user_password` varchar(50) NULL COMMENT '',
    `pay_password` varchar(50) NULL COMMENT '支付密码',
    `email` varchar(100) NULL COMMENT '',
    `phone` varchar(50) NULL COMMENT '',
    `amount` decimal(20,2) NULL DEFAULT '0.00' COMMENT '账户余额',
    `award` decimal(13,2) NULL DEFAULT '0.00' COMMENT '',
    `create_time` int(11) NULL COMMENT '',
    `login_time` int(11) NULL COMMENT '',
    `login_ip` varchar(15) NULL COMMENT '',
    `hits` int(11) NULL COMMENT '',
    `okayapi_lvyou_jee_user_status` int(11) NULL DEFAULT '0' COMMENT '',
    KEY `username` (`username`),
    KEY `okayapi_lvyou_jee_user_password` (`okayapi_lvyou_jee_user_password`),
    KEY `pay_password` (`pay_password`),
    KEY `email` (`email`),
    KEY `phone` (`phone`),
    KEY `amount` (`amount`),
    KEY `award` (`award`),
    KEY `create_time` (`create_time`),
    KEY `login_time` (`login_time`),
    KEY `login_ip` (`login_ip`),
    KEY `hits` (`hits`),
    KEY `okayapi_lvyou_jee_user_status` (`okayapi_lvyou_jee_user_status`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'lvyou旅游-用户';

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

MySQL database table structure design

Displaying 1-12 of 12 results.

Field Name	Field Type	Default	IS NULL	Field Comment	Demo Data
username	varchar(50)		是
okayapi_lvyou_jee_user_password	varchar(50)		是
pay_password	varchar(50)		是	支付密码
email	varchar(100)		是
phone	varchar(50)		是
amount	decimal(20,2)	0.00	是	账户余额	0.00
award	decimal(13,2)	0.00	否		0.00
create_time	int(11)		是
login_time	int(11)		是
login_ip	varchar(15)		是
hits	int(11)		是
okayapi_lvyou_jee_user_status	int(11)	0	是		0