mysql> show create table corp_rec_his;
+--------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
+--------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| corp_rec_his | CREATE TABLE `corp_rec_his` (
`t_date` datetime DEFAULT NULL COMMENT '变更日期',
`rec_id` int(11) NOT NULL DEFAULT '0' COMMENT '招聘id',
`corp_id` bigint(20) DEFAULT NULL COMMENT '企业id',
`corp_name` varchar(100) DEFAULT NULL COMMENT '企业名称',
`industry` varchar(200) DEFAULT NULL COMMENT '行业',
`corp_size` varchar(20) DEFAULT NULL COMMENT '企业规模',
`res_data` varchar(100) DEFAULT NULL COMMENT '渠道来源',
`num` int(11) DEFAULT NULL COMMENT '待招人数',
`position` varchar(50) DEFAULT NULL COMMENT '职位',
`pub_date` date DEFAULT NULL,
`position_id` varchar(100) DEFAULT NULL COMMENT '拉勾网岗位id',
`education` varchar(50) DEFAULT NULL COMMENT '学历',
`salary` varchar(50) DEFAULT NULL COMMENT '薪酬'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 |
+--------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set
mysql>