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 Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
user_id | int(11) | 是 | ||||
true_name | varchar(50) | 是 | ||||
identity_no | varchar(50) | 是 | ||||
avatar_path | varchar(50) | 是 | ||||
sex | int(11) | 是 | ||||
tel | varchar(50) | 是 | ||||
address | varchar(200) | 是 | ||||
post_code | varchar(50) | 是 | ||||
industry | varchar(50) | 是 | ||||
education | varchar(50) | 是 | ||||
income | varchar(50) | 是 | ||||
marital_status | varchar(50) | 是 |