+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_lvyou_jee_user_info:/tablelist/okayapi_lvyou_jee_user_info.html


-- MySQL Table okayapi_lvyou_jee_user_info
-- From: OkayAPI.com
CREATE TABLE `okayapi_lvyou_jee_user_info` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `user_id` int(11) NULL COMMENT '',
    `true_name` varchar(50) NULL COMMENT '',
    `identity_no` varchar(50) NULL COMMENT '',
    `avatar_path` varchar(50) NULL COMMENT '',
    `sex` int(11) NULL COMMENT '',
    `tel` varchar(50) NULL COMMENT '',
    `address` varchar(200) NULL COMMENT '',
    `post_code` varchar(50) NULL COMMENT '',
    `industry` varchar(50) NULL COMMENT '',
    `education` varchar(50) NULL COMMENT '',
    `income` varchar(50) NULL COMMENT '',
    `marital_status` varchar(50) NULL COMMENT '',
    KEY `user_id` (`user_id`),
    KEY `true_name` (`true_name`),
    KEY `identity_no` (`identity_no`),
    KEY `avatar_path` (`avatar_path`),
    KEY `sex` (`sex`),
    KEY `tel` (`tel`),
    KEY `address` (`address`),
    KEY `post_code` (`post_code`),
    KEY `industry` (`industry`),
    KEY `education` (`education`),
    KEY `income` (`income`),
    KEY `marital_status` (`marital_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 NameField TypeDefaultIS NULLField CommentIndexDemo Data
user_idint(11)
true_namevarchar(50)
identity_novarchar(50)
avatar_pathvarchar(50)
sexint(11)
telvarchar(50)
addressvarchar(200)
post_codevarchar(50)
industryvarchar(50)
educationvarchar(50)
incomevarchar(50)
marital_statusvarchar(50)

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_opentrip_travel_user

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

TOP ↑