MySQL Create Table SQL
Table Structure: okayapi_ssm_stuinfo:/tablelist/okayapi_ssm_stuinfo.html
-- MySQL Table okayapi_ssm_stuinfo
-- From: OkayAPI.com
CREATE TABLE `okayapi_ssm_stuinfo` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`email` varchar(100) NULL COMMENT '',
`okayapi_ssm_stuinfo_name` varchar(100) NULL COMMENT '',
`sex` varchar(100) NULL COMMENT '',
`age` varchar(100) NULL COMMENT '',
`height` varchar(100) NULL COMMENT '',
`weight` varchar(100) NULL COMMENT '',
`school` varchar(40) NULL COMMENT '',
`rank` varchar(100) NULL COMMENT '',
`phone` varchar(100) NULL COMMENT '',
`freeTime` varchar(100) NULL COMMENT '',
`exJob` varchar(40) NULL COMMENT '',
`beginYear` int(11) NULL COMMENT '',
`endYear` int(11) NULL COMMENT '',
`exSite` varchar(40) NULL COMMENT '',
`introduce` varchar(1000) NULL COMMENT '',
`upTime` varchar(100) NULL COMMENT '',
KEY `email` (`email`),
KEY `okayapi_ssm_stuinfo_name` (`okayapi_ssm_stuinfo_name`),
KEY `sex` (`sex`),
KEY `age` (`age`),
KEY `height` (`height`),
KEY `weight` (`weight`),
KEY `school` (`school`),
KEY `rank` (`rank`),
KEY `phone` (`phone`),
KEY `freeTime` (`freeTime`),
KEY `exJob` (`exJob`),
KEY `beginYear` (`beginYear`),
KEY `endYear` (`endYear`),
KEY `exSite` (`exSite`),
KEY `introduce` (`introduce`),
KEY `upTime` (`upTime`),
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-16 of 16 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
varchar(100) | 否 | |||||
okayapi_ssm_stuinfo_name | varchar(100) | 是 | ||||
sex | varchar(100) | 是 | ||||
age | varchar(100) | 是 | ||||
height | varchar(100) | 是 | ||||
weight | varchar(100) | 是 | ||||
school | varchar(40) | 是 | ||||
rank | varchar(100) | 是 | ||||
phone | varchar(100) | 是 | ||||
freeTime | varchar(100) | 是 | ||||
exJob | varchar(40) | 是 | ||||
beginYear | int(11) | 是 | ||||
endYear | int(11) | 是 | ||||
exSite | varchar(40) | 是 | ||||
introduce | varchar(1000) | 是 | ||||
upTime | varchar(100) | 是 |