okayapi_opms_pms_resumes - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_opms_pms_resumes：/tablelist/okayapi_opms_pms_resumes.html


-- MySQL Table okayapi_opms_pms_resumes
-- From: OkayAPI.com
CREATE TABLE `okayapi_opms_pms_resumes` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `realname` varchar(20) NULL COMMENT '',
    `sex` tinyint(1) NULL COMMENT '',
    `birth` int(10) NULL COMMENT '',
    `edu` tinyint(1) NULL COMMENT '',
    `okayapi_opms_pms_resumes_work` tinyint(1) NULL COMMENT '',
    `attachment` varchar(255) NULL COMMENT '',
    `created` int(10) NULL COMMENT '',
    `okayapi_opms_pms_resumes_status` tinyint(1) NULL DEFAULT '1' COMMENT '1入档2通知面试3违约4录用5不录用',
    `note` varchar(255) NULL COMMENT '',
    `phone` varchar(11) NULL COMMENT '',
    KEY `realname` (`realname`),
    KEY `sex` (`sex`),
    KEY `birth` (`birth`),
    KEY `edu` (`edu`),
    KEY `okayapi_opms_pms_resumes_work` (`okayapi_opms_pms_resumes_work`),
    KEY `attachment` (`attachment`),
    KEY `created` (`created`),
    KEY `okayapi_opms_pms_resumes_status` (`okayapi_opms_pms_resumes_status`),
    KEY `note` (`note`),
    KEY `phone` (`phone`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'OPMS和OA管理-简历表';

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 Name	Field Type	Default	IS NULL	Field Comment	Demo Data
realname	varchar(20)		是
sex	tinyint(1)		是
birth	int(10)		是
edu	tinyint(1)		是
okayapi_opms_pms_resumes_work	tinyint(1)		是
attachment	varchar(255)		是
created	int(10)		是
okayapi_opms_pms_resumes_status	tinyint(1)	1	是	1入档2通知面试3违约4录用5不录用	1
note	varchar(255)		是
phone	varchar(11)		是