+ Use This Table All Design

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 NameField TypeDefaultIS NULLField CommentIndexDemo Data
stuEmailvarchar(100)
comEmailvarchar(40)
jobNamevarchar(40)
stuStatevarchar(40)
applyStatevarchar(40)未处理0 通过1 未通过2 删除3 完成4
applyIdvarchar(40)
applyTimevarchar(100)
stuGradevarchar(40)
stuTextvarchar(255)
comGradevarchar(40)
comTextvarchar(255)

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_company

MySQL Table Design okayapi_ssm_resume

MySQL Table Design okayapi_ssm_stuinfo

MySQL Table Design okayapi_ssm_user

TOP ↑