+ Use This Table All Design

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 NameField TypeDefaultIS NULLField CommentIndexDemo Data
usernamevarchar(20)用户名Unique Index
okayapi_opentrip_travel_user_passwordchar(32)登录密码
saltchar(6)密钥
reg_timetimestampCURRENT_TIMESTAMP注册时间CURRENT_TIMESTAMP
phonechar(11)联系电话
emailvarchar(30)邮箱
consigneevarchar(20)收件人
addressvarchar(255)收货地址

Guess You Like

MySQL Table Design okayapi_opentrip_travel_admin

MySQL Table Design okayapi_opentrip_travel_category

MySQL Table Design okayapi_opentrip_travel_order

MySQL Table Design okayapi_opentrip_travel_product

MySQL Table Design okayapi_opentrip_travel_shopcart

MySQL Table Design okayapi_travel_agents

MySQL Table Design okayapi_travel_agent_users

MySQL Table Design okayapi_travel_categories

MySQL Table Design okayapi_travel_depots

MySQL Table Design okayapi_travel_depot_annuals

MySQL Table Design okayapi_travel_depot_logs

MySQL Table Design okayapi_travel_depot_staffs

MySQL Table Design okayapi_travel_depot_vouchers

MySQL Table Design okayapi_travel_devices

MySQL Table Design okayapi_travel_exist_statistics

MySQL Table Design okayapi_travel_features

MySQL Table Design okayapi_travel_groups

MySQL Table Design okayapi_travel_orders

MySQL Table Design okayapi_travel_staff_exchanges

MySQL Table Design okayapi_travel_users

TOP ↑