okayapi_jeewms_jform_resume_exp_info - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_jeewms_jform_resume_exp_info：/tablelist/okayapi_jeewms_jform_resume_exp_info.html


-- MySQL Table okayapi_jeewms_jform_resume_exp_info
-- From: OkayAPI.com
CREATE TABLE `okayapi_jeewms_jform_resume_exp_info` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `resume_id` varchar(36) NULL COMMENT '简历信息表ID',
    `begin_date` datetime NULL COMMENT '开始日期',
    `end_date` datetime NULL COMMENT '结束日期',
    `company_name` varchar(200) NULL COMMENT '公司名称',
    `depart_name` varchar(100) NULL COMMENT '部门名称',
    `post` varchar(50) NULL COMMENT '职位',
    `experience` varchar(2000) NULL COMMENT '工作描述',
    KEY `resume_id` (`resume_id`),
    KEY `begin_date` (`begin_date`),
    KEY `end_date` (`end_date`),
    KEY `company_name` (`company_name`),
    KEY `depart_name` (`depart_name`),
    KEY `post` (`post`),
    KEY `experience` (`experience`),
    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-7 of 7 results.

Field Name	Field Type	IS NULL	Field Comment
resume_id	varchar(36)	是	简历信息表ID
begin_date	datetime	是	开始日期
end_date	datetime	是	结束日期
company_name	varchar(200)	否	公司名称
depart_name	varchar(100)	是	部门名称
post	varchar(50)	是	职位
experience	varchar(2000)	是	工作描述