Skip to content

H
HLS3.0-UPDATE-SQL
Switch branch/tag
Find file
Normal viewHistoryPermalink
SYS_CODE_B.sql 10.8 KB
Newer Older
EricChen's avatar
inital commit
c6ba21a7
 
EricChen committed
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 
CREATE TABLE "SYS_CODE_B" (
  "CODE_ID" NUMBER(38) NOT NULL ,
  "CODE" VARCHAR2(30) NOT NULL ,
  "DESCRIPTION" VARCHAR2(240) NOT NULL ,
  "OBJECT_VERSION_NUMBER" NUMBER(38) DEFAULT 1 ,
  "REQUEST_ID" NUMBER(38) DEFAULT -1 ,
  "PROGRAM_ID" NUMBER(38) DEFAULT -1 ,
  "CREATED_BY" NUMBER(38) DEFAULT -1 ,
  "CREATION_DATE" TIMESTAMP(6) DEFAULT CURRENT_TIMESTAMP ,
  "LAST_UPDATED_BY" NUMBER(38) DEFAULT -1 ,
  "LAST_UPDATE_DATE" TIMESTAMP(6) DEFAULT CURRENT_TIMESTAMP ,
  "LAST_UPDATE_LOGIN" NUMBER(38) DEFAULT -1 ,
  "ATTRIBUTE_CATEGORY" VARCHAR2(30) ,
  "ATTRIBUTE1" VARCHAR2(240) ,
  "ATTRIBUTE2" VARCHAR2(240) ,
  "ATTRIBUTE3" VARCHAR2(240) ,
  "ATTRIBUTE4" VARCHAR2(240) ,
  "ATTRIBUTE5" VARCHAR2(240) ,
  "ATTRIBUTE6" VARCHAR2(240) ,
  "ATTRIBUTE7" VARCHAR2(240) ,
  "ATTRIBUTE8" VARCHAR2(240) ,
  "ATTRIBUTE9" VARCHAR2(240) ,
  "ATTRIBUTE10" VARCHAR2(240) ,
  "ATTRIBUTE11" VARCHAR2(240) ,
  "ATTRIBUTE12" VARCHAR2(240) ,
  "ATTRIBUTE13" VARCHAR2(240) ,
  "ATTRIBUTE14" VARCHAR2(240) ,
  "ATTRIBUTE15" VARCHAR2(240) ,
  "TYPE" VARCHAR2(10) DEFAULT 'USER' ,
  "ENABLED_FLAG" VARCHAR2(1) DEFAULT 'Y' ,
  "PARENT_CODE_ID" NUMBER(38) 
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "SYS_CODE_B"."CODE_ID" IS '代码ID';
COMMENT ON COLUMN "SYS_CODE_B"."CODE" IS '快码类型';
COMMENT ON COLUMN "SYS_CODE_B"."DESCRIPTION" IS '快码类型描述';
COMMENT ON COLUMN "SYS_CODE_B"."TYPE" IS '代码类型';
COMMENT ON COLUMN "SYS_CODE_B"."ENABLED_FLAG" IS '是否启用';
COMMENT ON COLUMN "SYS_CODE_B"."PARENT_CODE_ID" IS '父级快码';

-- ----------------------------
-- Records of SYS_CODE_B
-- ----------------------------
INSERT INTO "SYS_CODE_B" VALUES ('10001', 'HR.EMPLOYEE_GENDER', '性别', '1', '-1', '-1', '-1', TO_TIMESTAMP('2018-05-18 10:27:04.509000', 'SYYYY-MM-DD HH24:MI:SS:FF6'), '-1', TO_TIMESTAMP('2018-05-18 10:27:04.509000', 'SYYYY-MM-DD HH24:MI:SS:FF6'), '-1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USER', 'Y', NULL);
INSERT INTO "SYS_CODE_B" VALUES ('10002', 'HR.EMPLOYEE_STATUS', '员工状态', '1', '-1', '-1', '-1', TO_TIMESTAMP('2018-05-18 10:27:04.785000', 'SYYYY-MM-DD HH24:MI:SS:FF6'), '-1', TO_TIMESTAMP('2018-05-18 10:27:04.785000', 'SYYYY-MM-DD HH24:MI:SS:FF6'), '-1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USER', 'Y', NULL);
INSERT INTO "SYS_CODE_B" VALUES ('10003', 'SYS.ALIGN_TYPE', '对齐方式', '1', '-1', '-1', '-1', TO_TIMESTAMP('2018-05-18 10:27:05.054000', 'SYYYY-MM-DD HH24:MI:SS:FF6'), '-1', TO_TIMESTAMP('2018-05-18 10:27:05.054000', 'SYYYY-MM-DD HH24:MI:SS:FF6'), '-1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USER', 'Y', NULL);
INSERT INTO "SYS_CODE_B" VALUES ('10004', 'SYS.CAPTCHA_POLICY', '验证码策略', '1', '-1', '-1', '-1', TO_TIMESTAMP('2018-05-18 10:27:05.328000', 'SYYYY-MM-DD HH24:MI:SS:FF6'), '-1', TO_TIMESTAMP('2018-05-18 10:27:05.328000', 'SYYYY-MM-DD HH24:MI:SS:FF6'), '-1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USER', 'Y', NULL);
INSERT INTO "SYS_CODE_B" VALUES ('10005', 'SYS.LOV_EDITOR_TYPE', 'LOV 编辑器类型', '1', '-1', '-1', '-1', TO_TIMESTAMP('2018-05-18 10:27:05.595000', 'SYYYY-MM-DD HH24:MI:SS:FF6'), '-1', TO_TIMESTAMP('2018-05-18 10:27:05.595000', 'SYYYY-MM-DD HH24:MI:SS:FF6'), '-1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USER', 'Y', NULL);
INSERT INTO "SYS_CODE_B" VALUES ('10006', 'SYS.PRIORITY_LEVEL', '模板优先级', '1', '-1', '-1', '-1', TO_TIMESTAMP('2018-05-18 10:27:05.863000', 'SYYYY-MM-DD HH24:MI:SS:FF6'), '-1', TO_TIMESTAMP('2018-05-18 10:27:05.863000', 'SYYYY-MM-DD HH24:MI:SS:FF6'), '-1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USER', 'Y', NULL);
INSERT INTO "SYS_CODE_B" VALUES ('10007', 'SYS.PROFILE_LEVEL_ID', '配置文件级别', '1', '-1', '-1', '-1', TO_TIMESTAMP('2018-05-18 10:27:06.131000', 'SYYYY-MM-DD HH24:MI:SS:FF6'), '-1', TO_TIMESTAMP('2018-05-18 10:27:06.131000', 'SYYYY-MM-DD HH24:MI:SS:FF6'), '-1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USER', 'Y', NULL);
INSERT INTO "SYS_CODE_B" VALUES ('10008', 'SYS.RESOURCE_TYPE', '资源类型', '1', '-1', '-1', '-1', TO_TIMESTAMP('2018-05-18 10:27:06.399000', 'SYYYY-MM-DD HH24:MI:SS:FF6'), '-1', TO_TIMESTAMP('2018-05-18 10:27:06.399000', 'SYYYY-MM-DD HH24:MI:SS:FF6'), '-1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USER', 'Y', NULL);
INSERT INTO "SYS_CODE_B" VALUES ('10009', 'SYS.TIME_ZONE', '时区', '1', '-1', '-1', '-1', TO_TIMESTAMP('2018-05-18 10:27:06.668000', 'SYYYY-MM-DD HH24:MI:SS:FF6'), '-1', TO_TIMESTAMP('2018-05-18 10:27:06.668000', 'SYYYY-MM-DD HH24:MI:SS:FF6'), '-1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USER', 'Y', NULL);
INSERT INTO "SYS_CODE_B" VALUES ('10010', 'SYS.USER_STATUS', '用户状态', '1', '-1', '-1', '-1', TO_TIMESTAMP('2018-05-18 10:27:06.937000', 'SYYYY-MM-DD HH24:MI:SS:FF6'), '-1', TO_TIMESTAMP('2018-05-18 10:27:06.937000', 'SYYYY-MM-DD HH24:MI:SS:FF6'), '-1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USER', 'Y', NULL);
INSERT INTO "SYS_CODE_B" VALUES ('10011', 'SYS.YES_NO', '是否 YN', '1', '-1', '-1', '-1', TO_TIMESTAMP('2018-05-18 10:27:07.206000', 'SYYYY-MM-DD HH24:MI:SS:FF6'), '-1', TO_TIMESTAMP('2018-05-18 10:27:07.206000', 'SYYYY-MM-DD HH24:MI:SS:FF6'), '-1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USER', 'Y', NULL);
INSERT INTO "SYS_CODE_B" VALUES ('10012', 'SYS.PASSWORD_COMPLEXITY', '密码复杂度要求', '1', '-1', '-1', '-1', TO_TIMESTAMP('2018-05-18 10:27:07.475000', 'SYYYY-MM-DD HH24:MI:SS:FF6'), '-1', TO_TIMESTAMP('2018-05-18 10:27:07.475000', 'SYYYY-MM-DD HH24:MI:SS:FF6'), '-1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USER', 'Y', NULL);
INSERT INTO "SYS_CODE_B" VALUES ('10013', 'SYS.IF.REQUEST_STATUS', '接口调用状态', '1', '-1', '-1', '-1', TO_TIMESTAMP('2018-05-18 10:27:07.743000', 'SYYYY-MM-DD HH24:MI:SS:FF6'), '-1', TO_TIMESTAMP('2018-05-18 10:27:07.743000', 'SYYYY-MM-DD HH24:MI:SS:FF6'), '-1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USER', 'Y', NULL);
INSERT INTO "SYS_CODE_B" VALUES ('10014', 'HR.CERTIFICATE_TYPE', '证件类型', '1', '-1', '-1', '-1', TO_TIMESTAMP('2018-05-18 10:27:08.015000', 'SYYYY-MM-DD HH24:MI:SS:FF6'), '-1', TO_TIMESTAMP('2018-05-18 10:27:08.015000', 'SYYYY-MM-DD HH24:MI:SS:FF6'), '-1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USER', 'Y', NULL);
INSERT INTO "SYS_CODE_B" VALUES ('10015', 'SYS.UNIT_CATEGORY', '组织类别', '1', '-1', '-1', '-1', TO_TIMESTAMP('2018-05-18 10:27:08.281000', 'SYYYY-MM-DD HH24:MI:SS:FF6'), '-1', TO_TIMESTAMP('2018-05-18 10:27:08.281000', 'SYYYY-MM-DD HH24:MI:SS:FF6'), '-1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USER', 'Y', NULL);
INSERT INTO "SYS_CODE_B" VALUES ('10016', 'SYS.UNIT_TYPE', '组织分类', '1', '-1', '-1', '-1', TO_TIMESTAMP('2018-05-18 10:27:08.549000', 'SYYYY-MM-DD HH24:MI:SS:FF6'), '-1', TO_TIMESTAMP('2018-05-18 10:27:08.549000', 'SYYYY-MM-DD HH24:MI:SS:FF6'), '-1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USER', 'Y', NULL);
INSERT INTO "SYS_CODE_B" VALUES ('10017', 'FND.COMPANY_TYPE', '公司类型', '1', '-1', '-1', '-1', TO_TIMESTAMP('2018-05-18 10:27:08.815000', 'SYYYY-MM-DD HH24:MI:SS:FF6'), '-1', TO_TIMESTAMP('2018-05-18 10:27:08.815000', 'SYYYY-MM-DD HH24:MI:SS:FF6'), '-1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USER', 'Y', NULL);
INSERT INTO "SYS_CODE_B" VALUES ('10018', 'FND.COMPANY_LEVEL', '公司等级', '1', '-1', '-1', '-1', TO_TIMESTAMP('2018-05-18 10:27:09.080000', 'SYYYY-MM-DD HH24:MI:SS:FF6'), '-1', TO_TIMESTAMP('2018-05-18 10:27:09.080000', 'SYYYY-MM-DD HH24:MI:SS:FF6'), '-1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USER', 'Y', NULL);
INSERT INTO "SYS_CODE_B" VALUES ('10019', 'SYS.TEMPLATE_TYPE', '模板类型', '1', '-1', '-1', '-1', TO_TIMESTAMP('2018-05-18 10:27:09.346000', 'SYYYY-MM-DD HH24:MI:SS:FF6'), '-1', TO_TIMESTAMP('2018-05-18 10:27:09.346000', 'SYYYY-MM-DD HH24:MI:SS:FF6'), '-1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USER', 'Y', NULL);
INSERT INTO "SYS_CODE_B" VALUES ('10020', 'SYS.SEND_TYPE', '发送类型', '1', '-1', '-1', '-1', TO_TIMESTAMP('2018-05-18 10:27:09.611000', 'SYYYY-MM-DD HH24:MI:SS:FF6'), '-1', TO_TIMESTAMP('2018-05-18 10:27:09.611000', 'SYYYY-MM-DD HH24:MI:SS:FF6'), '-1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USER', 'Y', NULL);
INSERT INTO "SYS_CODE_B" VALUES ('10021', 'SYS.CODERULE.FIEDLTYPE', '编码规则段类型', '1', '-1', '-1', '-1', TO_TIMESTAMP('2018-05-18 10:27:09.877000', 'SYYYY-MM-DD HH24:MI:SS:FF6'), '-1', TO_TIMESTAMP('2018-05-18 10:27:09.877000', 'SYYYY-MM-DD HH24:MI:SS:FF6'), '-1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USER', 'Y', NULL);
INSERT INTO "SYS_CODE_B" VALUES ('10022', 'SYS.CODERULE.DATEMASK', '日期掩码', '1', '-1', '-1', '-1', TO_TIMESTAMP('2018-05-18 10:27:10.142000', 'SYYYY-MM-DD HH24:MI:SS:FF6'), '-1', TO_TIMESTAMP('2018-05-18 10:27:10.142000', 'SYYYY-MM-DD HH24:MI:SS:FF6'), '-1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USER', 'Y', NULL);
INSERT INTO "SYS_CODE_B" VALUES ('10023', 'SYS.CODERULE.RESTPERIOD', '重置频率', '1', '-1', '-1', '-1', TO_TIMESTAMP('2018-05-18 10:27:10.406000', 'SYYYY-MM-DD HH24:MI:SS:FF6'), '-1', TO_TIMESTAMP('2018-05-18 10:27:10.406000', 'SYYYY-MM-DD HH24:MI:SS:FF6'), '-1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USER', 'Y', NULL);

-- ----------------------------
-- Primary Key structure for table SYS_CODE_B
-- ----------------------------
ALTER TABLE "SYS_CODE_B" ADD CONSTRAINT "SYS_CODE_B_PK" PRIMARY KEY ("CODE_ID");

-- ----------------------------
-- Uniques structure for table SYS_CODE_B
-- ----------------------------
ALTER TABLE "SYS_CODE_B" ADD CONSTRAINT "SYS_CODE_B_U1" UNIQUE ("CODE") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;


CREATE SEQUENCE  "SYS_CODE_B_S"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 10041 CACHE 20 NOORDER  NOCYCLE