MySQL Create Table SQL
Table Structure: okayapi_opentrip_travel_user:/tablelist/okayapi_opentrip_travel_user.html
-- MySQL Table okayapi_opentrip_travel_user
-- From: OkayAPI.com
CREATE TABLE `okayapi_opentrip_travel_user` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`username` varchar(20) NOT NULL COMMENT '用户名',
`okayapi_opentrip_travel_user_password` char(32) NOT NULL COMMENT '登录密码',
`salt` char(6) NOT NULL COMMENT '密钥',
`reg_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '注册时间',
`phone` char(11) NOT NULL COMMENT '联系电话',
`email` varchar(30) NOT NULL COMMENT '邮箱',
`consignee` varchar(20) NOT NULL COMMENT '收件人',
`address` varchar(255) NOT NULL COMMENT '收货地址',
KEY `username` (`username`),
KEY `okayapi_opentrip_travel_user_password` (`okayapi_opentrip_travel_user_password`),
KEY `salt` (`salt`),
KEY `reg_time` (`reg_time`),
KEY `phone` (`phone`),
KEY `email` (`email`),
KEY `consignee` (`consignee`),
KEY `address` (`address`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT '轻量旅游电商-用户';
After replication, you can go to the database to create the database table.
MySQL database table structure design
Displaying 1-8 of 8 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
username | varchar(20) | 否 | 用户名 | Unique Index | ||
okayapi_opentrip_travel_user_password | char(32) | 否 | 登录密码 | |||
salt | char(6) | 否 | 密钥 | |||
reg_time | timestamp | CURRENT_TIMESTAMP | 否 | 注册时间 | CURRENT_TIMESTAMP | |
phone | char(11) | 否 | 联系电话 | |||
varchar(30) | 否 | 邮箱 | ||||
consignee | varchar(20) | 否 | 收件人 | |||
address | varchar(255) | 否 | 收货地址 |