+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_ssm_resume:/tablelist/okayapi_ssm_resume.html


-- MySQL Table okayapi_ssm_resume
-- From: OkayAPI.com
CREATE TABLE `okayapi_ssm_resume` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `email` varchar(255) NULL COMMENT '',
    `jobType` varchar(100) NULL COMMENT '',
    `jobName` varchar(100) NULL COMMENT '',
    `department` varchar(100) NULL COMMENT '',
    `okayapi_ssm_resume_number` varchar(100) NULL COMMENT '',
    `deRequest` varchar(1000) NULL COMMENT '',
    `salary` varchar(100) NULL COMMENT '',
    `okayapi_ssm_resume_time` varchar(300) NULL COMMENT '',
    `detail` varchar(1000) NULL COMMENT '',
    `state` varchar(100) NULL COMMENT '',
    KEY `email` (`email`),
    KEY `jobType` (`jobType`),
    KEY `jobName` (`jobName`),
    KEY `department` (`department`),
    KEY `okayapi_ssm_resume_number` (`okayapi_ssm_resume_number`),
    KEY `deRequest` (`deRequest`),
    KEY `salary` (`salary`),
    KEY `okayapi_ssm_resume_time` (`okayapi_ssm_resume_time`),
    KEY `detail` (`detail`),
    KEY `state` (`state`),
    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-10 of 10 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
emailvarchar(255)
jobTypevarchar(100)
jobNamevarchar(100)
departmentvarchar(100)
okayapi_ssm_resume_numbervarchar(100)
deRequestvarchar(1000)
salaryvarchar(100)
okayapi_ssm_resume_timevarchar(300)
detailvarchar(1000)
statevarchar(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_stuinfo

MySQL Table Design okayapi_ssm_user

TOP ↑