+ Use This Table All Design

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 NameField TypeDefaultIS NULLField CommentIndexDemo Data
emailvarchar(100)
okayapi_ssm_stuinfo_namevarchar(100)
sexvarchar(100)
agevarchar(100)
heightvarchar(100)
weightvarchar(100)
schoolvarchar(40)
rankvarchar(100)
phonevarchar(100)
freeTimevarchar(100)
exJobvarchar(40)
beginYearint(11)
endYearint(11)
exSitevarchar(40)
introducevarchar(1000)
upTimevarchar(100)

Guess You Like

MySQL Table Design okayapi_pt_tab_position

MySQL Table Design okayapi_pt_tab_receiveorders

MySQL Table Design okayapi_pt_tab_releaseorders

MySQL Table Design okayapi_pt_tab_school

MySQL Table Design okayapi_pt_tab_user

MySQL Table Design okayapi_ssm_allege

MySQL Table Design okayapi_ssm_apply

MySQL Table Design okayapi_ssm_company

MySQL Table Design okayapi_ssm_resume

MySQL Table Design okayapi_ssm_user

TOP ↑