MySQL Create Table SQL
Table Structure: okayapi_ssm_apply:/tablelist/okayapi_ssm_apply.html
-- MySQL Table okayapi_ssm_apply
-- From: OkayAPI.com
CREATE TABLE `okayapi_ssm_apply` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`stuEmail` varchar(100) NULL COMMENT '',
`comEmail` varchar(40) NULL COMMENT '',
`jobName` varchar(40) NULL COMMENT '',
`stuState` varchar(40) NULL COMMENT '',
`applyState` varchar(40) NULL COMMENT '未处理0 通过1 未通过2 删除3 完成4',
`applyId` varchar(40) NULL COMMENT '',
`applyTime` varchar(100) NULL COMMENT '',
`stuGrade` varchar(40) NULL COMMENT '',
`stuText` varchar(255) NULL COMMENT '',
`comGrade` varchar(40) NULL COMMENT '',
`comText` varchar(255) NULL COMMENT '',
KEY `stuEmail` (`stuEmail`),
KEY `comEmail` (`comEmail`),
KEY `jobName` (`jobName`),
KEY `stuState` (`stuState`),
KEY `applyState` (`applyState`),
KEY `applyId` (`applyId`),
KEY `applyTime` (`applyTime`),
KEY `stuGrade` (`stuGrade`),
KEY `stuText` (`stuText`),
KEY `comGrade` (`comGrade`),
KEY `comText` (`comText`),
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-11 of 11 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
stuEmail | varchar(100) | 否 | ||||
comEmail | varchar(40) | 否 | ||||
jobName | varchar(40) | 否 | ||||
stuState | varchar(40) | 是 | ||||
applyState | varchar(40) | 否 | 未处理0 通过1 未通过2 删除3 完成4 | |||
applyId | varchar(40) | 否 | ||||
applyTime | varchar(100) | 否 | ||||
stuGrade | varchar(40) | 是 | ||||
stuText | varchar(255) | 是 | ||||
comGrade | varchar(40) | 是 | ||||
comText | varchar(255) | 是 |