MySQL Create Table SQL
Table Structure: okayapi_jeewms_jform_resume_info:/tablelist/okayapi_jeewms_jform_resume_info.html
-- MySQL Table okayapi_jeewms_jform_resume_info
-- From: OkayAPI.com
CREATE TABLE `okayapi_jeewms_jform_resume_info` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`okayapi_jeewms_jform_resume_info_name` varchar(50) NULL COMMENT '姓名',
`sex` varchar(10) NULL COMMENT '性别',
`birthday` datetime NULL COMMENT '生日',
`telnum` varchar(30) NULL COMMENT '电话号码',
`email` varchar(50) NULL COMMENT '电子邮箱',
`degree` varchar(50) NULL COMMENT '最高学历',
`workyear` varchar(20) NULL COMMENT '工作年限',
`cardid` varchar(50) NULL COMMENT '身份证号',
`habitation` varchar(100) NULL COMMENT '现居地',
`residence` varchar(100) NULL COMMENT '户口所在地',
`salary` varchar(20) NULL COMMENT '期望薪资',
`work_place` varchar(50) NULL COMMENT '期望工作地点',
`work_type` varchar(50) NULL COMMENT '工作类型',
`arrival_time` datetime NULL COMMENT '到岗时间',
`introduction` varchar(500) NULL COMMENT '自我评价',
KEY `okayapi_jeewms_jform_resume_info_name` (`okayapi_jeewms_jform_resume_info_name`),
KEY `sex` (`sex`),
KEY `birthday` (`birthday`),
KEY `telnum` (`telnum`),
KEY `email` (`email`),
KEY `degree` (`degree`),
KEY `workyear` (`workyear`),
KEY `cardid` (`cardid`),
KEY `habitation` (`habitation`),
KEY `residence` (`residence`),
KEY `salary` (`salary`),
KEY `work_place` (`work_place`),
KEY `work_type` (`work_type`),
KEY `arrival_time` (`arrival_time`),
KEY `introduction` (`introduction`),
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-15 of 15 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
okayapi_jeewms_jform_resume_info_name | varchar(50) | 否 | 姓名 | |||
sex | varchar(10) | 否 | 性别 | |||
birthday | datetime | 是 | 生日 | |||
telnum | varchar(30) | 是 | 电话号码 | |||
varchar(50) | 是 | 电子邮箱 | ||||
degree | varchar(50) | 是 | 最高学历 | |||
workyear | varchar(20) | 是 | 工作年限 | |||
cardid | varchar(50) | 是 | 身份证号 | |||
habitation | varchar(100) | 是 | 现居地 | |||
residence | varchar(100) | 是 | 户口所在地 | |||
salary | varchar(20) | 是 | 期望薪资 | |||
work_place | varchar(50) | 是 | 期望工作地点 | |||
work_type | varchar(50) | 是 | 工作类型 | |||
arrival_time | datetime | 是 | 到岗时间 | |||
introduction | varchar(500) | 是 | 自我评价 |