Demo entry 6738651

table jobs_51job

   

Submitted by sino_crazy_snail on May 05, 2018 at 06:59
Language: MySQL. Code size: 895 Bytes.

CREATE TABLE `jobs_51job` (
  `job_name` varchar(45) NOT NULL,
  `company` varchar(45) NOT NULL,
  `job_url` varchar(100) DEFAULT NULL,
  `job_description` text,
  `job_class` varchar(100) DEFAULT NULL,
  `job_key` varchar(100) DEFAULT NULL,
  `job_address` varchar(100) DEFAULT NULL,
  `job_require` varchar(100) DEFAULT NULL,
  `company_url` varchar(100) DEFAULT NULL,
  `company_description` text,
  `company_nature` varchar(20) DEFAULT NULL,
  `company_scale` varchar(20) DEFAULT NULL,
  `area` varchar(45) DEFAULT NULL,
  `time` varchar(45) DEFAULT NULL,
  `education` varchar(45) DEFAULT NULL,
  `work_experience` varchar(45) DEFAULT NULL,
  `industry` varchar(45) DEFAULT NULL,
  `recruit` varchar(45) DEFAULT NULL,
  `welfare` varchar(100) DEFAULT NULL,
  `salary` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`job_name`,`company`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

This snippet took 0.00 seconds to highlight.

Back to the Entry List or Home.

Delete this entry (admin only).