text: /*
  Navicat Oracle Data Transfer
  Oracle Client Version : 11.2.0.1.0
  
  Source Server         : local
  Source Server Version : 110200
  Source Host           : 127.0.0.1:1521
  Source Schema         : PERSONPAPER
  
  Target Server Type    : ORACLE
  Target Server Version : 110200
  File Encoding         : 65001
  
  Date: 2019-07-17 17:50:05
  */
  
  
  -- ----------------------------
  -- Table structure for JOBS
  -- ----------------------------
  DROP TABLE "PERSONPAPER"."JOBS";
  CREATE TABLE "PERSONPAPER"."JOBS" (
  "ID" NUMBER(10) NOT NULL ,
  "AMPUTATED" NUMBER(10) NOT NULL ,
  "CREATED_DATE_TIME" TIMESTAMP(6)  NOT NULL ,
  "CREATED_USER_ID" NUMBER(10) NOT NULL ,
  "CREATED_USER_NAME" VARCHAR2(55 CHAR) NOT NULL ,
  "LAST_UPDATE_DATE_TIME" TIMESTAMP(6)  NOT NULL ,
  "LAST_UPDATE_USER_ID" NUMBER(10) NOT NULL ,
  "LAST_UPDATE_USER_NAME" VARCHAR2(55 CHAR) NOT NULL ,
  "NAME" VARCHAR2(55 CHAR) NOT NULL ,
  "RESPONSIBILITIES" VARCHAR2(255 CHAR) NULL 
  )
  LOGGING
  NOCOMPRESS
  NOCACHE
  
  ;
  
  -- ----------------------------
  -- Records of JOBS
  -- ----------------------------
  INSERT INTO "PERSONPAPER"."JOBS" VALUES ('161', '1', TO_TIMESTAMP(' 2018-10-16 22:16:58:226000', 'YYYY-MM-DD HH24:MI:SS:FF6'), '1', 'admin', TO_TIMESTAMP(' 2018-10-22 13:50:30:994000', 'YYYY-MM-DD HH24:MI:SS:FF6'), '1', 'admin', '测试职务1', '测试职务1');
  INSERT INTO "PERSONPAPER"."JOBS" VALUES ('162', '1', TO_TIMESTAMP(' 2018-10-16 22:36:54:621000', 'YYYY-MM-DD HH24:MI:SS:FF6'), '1', 'admin', TO_TIMESTAMP(' 2018-10-22 13:50:29:009000', 'YYYY-MM-DD HH24:MI:SS:FF6'), '1', 'admin', '测试职务11', '测试职务1');
  INSERT INTO "PERSONPAPER"."JOBS" VALUES ('142', '0', TO_TIMESTAMP(' 2018-10-06 15:45:03:201000', 'YYYY-MM-DD HH24:MI:SS:FF6'), '1', 'admin', TO_TIMESTAMP(' 2018-10-06 15:45:03:201000', 'YYYY-MM-DD HH24:MI:SS:FF6'), '1', 'admin', '副科长', '县、县级市或地级市设的区正科级局的副局长、副科级局的局长、乡镇党委副书记和副乡镇长，地级市辖县区、县公安分局大队长、派出所所长、中共县、县级市、市辖区纪委室主任。');
  INSERT INTO "PERSONPAPER"."JOBS" VALUES ('143', '0', TO_TIMESTAMP(' 2018-10-06 15:45:34:658000', 'YYYY-MM-DD HH24:MI:SS:FF6'), '1', 'admin', TO_TIMESTAMP(' 2018-10-06 15:45:34:658000', 'YYYY-MM-DD HH24:MI:SS:FF6'), '1', 'admin', '主任', '机构或部门的主要负责人。');
  INSERT INTO "PERSONPAPER"."JOBS" VALUES ('144', '0', TO_TIMESTAMP(' 2018-10-06 15:46:01:692000', 'YYYY-MM-DD HH24:MI:SS:FF6'), '1', 'admin', TO_TIMESTAMP(' 2018-10-30 14:26:35:821000', 'YYYY-MM-DD HH24:MI:SS:FF6'), '1', 'admin', '副主任', null);
  INSERT INTO "PERSONPAPER"."JOBS" VALUES ('145', '0', TO_TIMESTAMP(' 2018-10-06 15:47:51:753000', 'YYYY-MM-DD HH24:MI:SS:FF6'), '1', 'admin', TO_TIMESTAMP(' 2018-10-30 14:26:53:165000', 'YYYY-MM-DD HH24:MI:SS:FF6'), '1', 'admin', '校长', null);
  INSERT INTO "PERSONPAPER"."JOBS" VALUES ('146', '1', TO_TIMESTAMP(' 2018-10-06 15:48:17:912000', 'YYYY-MM-DD HH24:MI:SS:FF6'), '1', 'admin', TO_TIMESTAMP(' 2018-10-30 14:27:49:759000', 'YYYY-MM-DD HH24:MI:SS:FF6'), '1', 'admin', '办事员', '办事员是机关工作人员的一种职别，在科员之下，升任科员需要3年以上时间。办事员需要负责打印以分会名义发出的重要文件、工作汇报、会长讲话以及其他重要文字材料。');
  INSERT INTO "PERSONPAPER"."JOBS" VALUES ('103', '0', TO_TIMESTAMP(' 2018-09-28 15:35:00:621000', 'YYYY-MM-DD HH24:MI:SS:FF6'), '1', 'admin', TO_TIMESTAMP(' 2018-10-05 22:58:06:779000', 'YYYY-MM-DD HH24:MI:SS:FF6'), '1', 'admin', '科长', '在事业单位和机关单位 一般行使政府给予的职能，属于有责任的部门担任者
  在事业单位和机关单位 一般行使政府给予的职能，属于有责任的部门担任者');
  INSERT INTO "PERSONPAPER"."JOBS" VALUES ('147', '1', TO_TIMESTAMP(' 2018-10-06 15:52:48:445000', 'YYYY-MM-DD HH24:MI:SS:FF6'), '1', 'admin', TO_TIMESTAMP(' 2018-10-30 14:28:02:962000', 'YYYY-MM-DD HH24:MI:SS:FF6'), '1', 'admin', '科员', '科员其实就是一般工作人员');
  INSERT INTO "PERSONPAPER"."JOBS" VALUES ('201', '0', TO_TIMESTAMP(' 2018-10-30 14:27:05:931000', 'YYYY-MM-DD HH24:MI:SS:FF6'), '1', 'admin', TO_TIMESTAMP(' 2018-10-30 14:27:05:931000', 'YYYY-MM-DD HH24:MI:SS:FF6'), '1', 'admin', '副校长', null);
  INSERT INTO "PERSONPAPER"."JOBS" VALUES ('202', '0', TO_TIMESTAMP(' 2018-10-30 14:27:27:665000', 'YYYY-MM-DD HH24:MI:SS:FF6'), '1', 'admin', TO_TIMESTAMP(' 2018-10-30 14:27:27:665000', 'YYYY-MM-DD HH24:MI:SS:FF6'), '1', 'admin', '参谋', null);
  INSERT INTO "PERSONPAPER"."JOBS" VALUES ('203', '0', TO_TIMESTAMP(' 2018-10-30 14:27:43:743000', 'YYYY-MM-DD HH24:MI:SS:FF6'), '1', 'admin', TO_TIMESTAMP(' 2018-10-30 14:27:43:743000', 'YYYY-MM-DD HH24:MI:SS:FF6'), '1', 'admin', '副参谋', null);
  INSERT INTO "PERSONPAPER"."JOBS" VALUES ('204', '0', TO_TIMESTAMP(' 2018-10-30 14:28:23:759000', 'YYYY-MM-DD HH24:MI:SS:FF6'), '1', 'admin', TO_TIMESTAMP(' 2018-10-30 14:28:23:759000', 'YYYY-MM-DD HH24:MI:SS:FF6'), '1', 'admin', '大队长', null);
  INSERT INTO "PERSONPAPER"."JOBS" VALUES ('205', '0', TO_TIMESTAMP(' 2018-10-30 14:28:35:478000', 'YYYY-MM-DD HH24:MI:SS:FF6'), '1', 'admin', TO_TIMESTAMP(' 2018-10-30 14:28:35:509000', 'YYYY-MM-DD HH24:MI:SS:FF6'), '1', 'admin', '副大队长', null);
  INSERT INTO "PERSONPAPER"."JOBS" VALUES ('206', '0', TO_TIMESTAMP(' 2018-10-30 14:28:54:743000', 'YYYY-MM-DD HH24:MI:SS:FF6'), '1', 'admin', TO_TIMESTAMP(' 2018-10-30 14:28:54:759000', 'YYYY-MM-DD HH24:MI:SS:FF6'), '1', 'admin', '窗口工作人员', null);
  INSERT INTO "PERSONPAPER"."JOBS" VALUES ('207', '0', TO_TIMESTAMP(' 2018-10-30 14:29:11:009000', 'YYYY-MM-DD HH24:MI:SS:FF6'), '1', 'admin', TO_TIMESTAMP(' 2018-12-04 14:57:15:633000', 'YYYY-MM-DD HH24:MI:SS:FF6'), '1', 'admin', '后台工作人员', null);
  INSERT INTO "PERSONPAPER"."JOBS" VALUES ('181', '1', TO_TIMESTAMP(' 2018-10-17 17:41:07:408000', 'YYYY-MM-DD HH24:MI:SS:FF6'), '1', 'admin', TO_TIMESTAMP(' 2018-10-22 13:18:15:478000', 'YYYY-MM-DD HH24:MI:SS:FF6'), '1', 'admin', 'ceshi2', 'string');
  INSERT INTO "PERSONPAPER"."JOBS" VALUES ('182', '1', TO_TIMESTAMP(' 2018-10-17 18:00:57:730000', 'YYYY-MM-DD HH24:MI:SS:FF6'), '1', 'admin', TO_TIMESTAMP(' 2018-10-22 13:18:12:822000', 'YYYY-MM-DD HH24:MI:SS:FF6'), '1', 'admin', 'ceshi66', 'string');
  INSERT INTO "PERSONPAPER"."JOBS" VALUES ('221', '0', TO_TIMESTAMP(' 2018-12-04 15:03:45:930000', 'YYYY-MM-DD HH24:MI:SS:FF6'), '511', '10680', TO_TIMESTAMP(' 2018-12-04 15:03:45:930000', 'YYYY-MM-DD HH24:MI:SS:FF6'), '511', '10680', '主任科员', null);
  INSERT INTO "PERSONPAPER"."JOBS" VALUES ('222', '0', TO_TIMESTAMP(' 2018-12-04 15:03:57:227000', 'YYYY-MM-DD HH24:MI:SS:FF6'), '511', '10680', TO_TIMESTAMP(' 2018-12-04 15:03:57:227000', 'YYYY-MM-DD HH24:MI:SS:FF6'), '511', '10680', '副主任科员', null);
  INSERT INTO "PERSONPAPER"."JOBS" VALUES ('223', '0', TO_TIMESTAMP(' 2018-12-04 15:04:11:102000', 'YYYY-MM-DD HH24:MI:SS:FF6'), '511', '10680', TO_TIMESTAMP(' 2018-12-04 15:04:11:102000', 'YYYY-MM-DD HH24:MI:SS:FF6'), '511', '10680', '调研员', null);
  INSERT INTO "PERSONPAPER"."JOBS" VALUES ('224', '0', TO_TIMESTAMP(' 2018-12-04 15:04:20:727000', 'YYYY-MM-DD HH24:MI:SS:FF6'), '511', '10680', TO_TIMESTAMP(' 2018-12-04 15:04:20:727000', 'YYYY-MM-DD HH24:MI:SS:FF6'), '511', '10680', '副调研员', null);
  INSERT INTO "PERSONPAPER"."JOBS" VALUES ('225', '0', TO_TIMESTAMP(' 2018-12-04 15:04:38:070000', 'YYYY-MM-DD HH24:MI:SS:FF6'), '511', '10680', TO_TIMESTAMP(' 2018-12-04 15:04:38:070000', 'YYYY-MM-DD HH24:MI:SS:FF6'), '511', '10680', '中心一般干部', null);
  INSERT INTO "PERSONPAPER"."JOBS" VALUES ('226', '0', TO_TIMESTAMP(' 2018-12-04 15:04:48:961000', 'YYYY-MM-DD HH24:MI:SS:FF6'), '511', '10680', TO_TIMESTAMP(' 2018-12-04 15:04:48:961000', 'YYYY-MM-DD HH24:MI:SS:FF6'), '511', '10680', '辅助岗位', null);
  INSERT INTO "PERSONPAPER"."JOBS" VALUES ('241', '0', TO_TIMESTAMP(' 2018-12-28 14:47:19:011000', 'YYYY-MM-DD HH24:MI:SS:FF6'), '1', 'admin', TO_TIMESTAMP(' 2018-12-28 14:47:19:011000', 'YYYY-MM-DD HH24:MI:SS:FF6'), '1', 'admin', '副局长', null);
  INSERT INTO "PERSONPAPER"."JOBS" VALUES ('242', '0', TO_TIMESTAMP(' 2019-01-16 12:04:31:316000', 'YYYY-MM-DD HH24:MI:SS:FF6'), '1', 'admin', TO_TIMESTAMP(' 2019-01-16 12:04:31:316000', 'YYYY-MM-DD HH24:MI:SS:FF6'), '1', 'admin', '其它', null);
  INSERT INTO "PERSONPAPER"."JOBS" VALUES ('261', '0', TO_TIMESTAMP(' 2019-01-22 13:15:58:664000', 'YYYY-MM-DD HH24:MI:SS:FF6'), '1', 'admin', TO_TIMESTAMP(' 2019-01-22 13:15:58:664000', 'YYYY-MM-DD HH24:MI:SS:FF6'), '1', 'admin', '局长', '局长');
  INSERT INTO "PERSONPAPER"."JOBS" VALUES ('281', '1', TO_TIMESTAMP(' 2019-01-30 16:08:42:929000', 'YYYY-MM-DD HH24:MI:SS:FF6'), '1096', '中心机关', TO_TIMESTAMP(' 2019-06-28 16:40:41:661000', 'YYYY-MM-DD HH24:MI:SS:FF6'), '1096', '中心机关', '副书记1', '副书记');
  INSERT INTO "PERSONPAPER"."JOBS" VALUES ('301', '0', TO_TIMESTAMP(' 2019-06-28 17:12:25:752000', 'YYYY-MM-DD HH24:MI:SS:FF6'), '1096', '中心机关', TO_TIMESTAMP(' 2019-06-28 17:12:25:752000', 'YYYY-MM-DD HH24:MI:SS:FF6'), '1096', '中心机关', '测试职务', null);
  
  -- ----------------------------
  -- Checks structure for table JOBS
  -- ----------------------------
  ALTER TABLE "PERSONPAPER"."JOBS" ADD CHECK ("ID" IS NOT NULL);
  ALTER TABLE "PERSONPAPER"."JOBS" ADD CHECK ("AMPUTATED" IS NOT NULL);
  ALTER TABLE "PERSONPAPER"."JOBS" ADD CHECK ("CREATED_DATE_TIME" IS NOT NULL);
  ALTER TABLE "PERSONPAPER"."JOBS" ADD CHECK ("CREATED_USER_ID" IS NOT NULL);
  ALTER TABLE "PERSONPAPER"."JOBS" ADD CHECK ("CREATED_USER_NAME" IS NOT NULL);
  ALTER TABLE "PERSONPAPER"."JOBS" ADD CHECK ("LAST_UPDATE_DATE_TIME" IS NOT NULL);
  ALTER TABLE "PERSONPAPER"."JOBS" ADD CHECK ("LAST_UPDATE_USER_ID" IS NOT NULL);
  ALTER TABLE "PERSONPAPER"."JOBS" ADD CHECK ("LAST_UPDATE_USER_NAME" IS NOT NULL);
  ALTER TABLE "PERSONPAPER"."JOBS" ADD CHECK ("NAME" IS NOT NULL);
  ALTER TABLE "PERSONPAPER"."JOBS" ADD CHECK ("ID" IS NOT NULL);
  ALTER TABLE "PERSONPAPER"."JOBS" ADD CHECK ("AMPUTATED" IS NOT NULL);
  ALTER TABLE "PERSONPAPER"."JOBS" ADD CHECK ("CREATED_DATE_TIME" IS NOT NULL);
  ALTER TABLE "PERSONPAPER"."JOBS" ADD CHECK ("CREATED_USER_ID" IS NOT NULL);
  ALTER TABLE "PERSONPAPER"."JOBS" ADD CHECK ("CREATED_USER_NAME" IS NOT NULL);
  ALTER TABLE "PERSONPAPER"."JOBS" ADD CHECK ("LAST_UPDATE_DATE_TIME" IS NOT NULL);
  ALTER TABLE "PERSONPAPER"."JOBS" ADD CHECK ("LAST_UPDATE_USER_ID" IS NOT NULL);
  ALTER TABLE "PERSONPAPER"."JOBS" ADD CHECK ("LAST_UPDATE_USER_NAME" IS NOT NULL);
  ALTER TABLE "PERSONPAPER"."JOBS" ADD CHECK ("NAME" IS NOT NULL);
  