RuoYi-Vue-Plus/script/sql/oracle/powerjob.sql

-- ----------------------------
-- Table structure for PJ_APP_INFO
-- ----------------------------
CREATE TABLE "PJ_APP_INFO" (
  "ID" NUMBER(19) VISIBLE NOT NULL ,
  "APP_NAME" VARCHAR2(255 CHAR) VISIBLE ,
  "CURRENT_SERVER" VARCHAR2(255 CHAR) VISIBLE ,
  "GMT_CREATE" TIMESTAMP(6) VISIBLE ,
  "GMT_MODIFIED" TIMESTAMP(6) VISIBLE ,
  "PASSWORD" VARCHAR2(255 CHAR) VISIBLE
)
TABLESPACE "ROOT"
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536
  NEXT 1048576
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Records of "PJ_APP_INFO"
-- ----------------------------
INSERT INTO "PJ_APP_INFO" VALUES ('1', 'ruoyi-worker', '127.0.0.1:10010', NULL, NULL, '123456');

-- ----------------------------
-- Table structure for PJ_CONTAINER_INFO
-- ----------------------------
CREATE TABLE "PJ_CONTAINER_INFO" (
  "ID" NUMBER(19) VISIBLE NOT NULL ,
  "APP_ID" NUMBER(19) VISIBLE ,
  "CONTAINER_NAME" VARCHAR2(255 CHAR) VISIBLE ,
  "GMT_CREATE" TIMESTAMP(6) VISIBLE ,
  "GMT_MODIFIED" TIMESTAMP(6) VISIBLE ,
  "LAST_DEPLOY_TIME" TIMESTAMP(6) VISIBLE ,
  "SOURCE_INFO" VARCHAR2(255 CHAR) VISIBLE ,
  "SOURCE_TYPE" NUMBER(10) VISIBLE ,
  "STATUS" NUMBER(10) VISIBLE ,
  "VERSION" VARCHAR2(255 CHAR) VISIBLE
)
TABLESPACE "ROOT"
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536
  NEXT 1048576
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Table structure for PJ_INSTANCE_INFO
-- ----------------------------
CREATE TABLE "PJ_INSTANCE_INFO" (
  "ID" NUMBER(19) VISIBLE NOT NULL ,
  "ACTUAL_TRIGGER_TIME" NUMBER(19) VISIBLE ,
  "APP_ID" NUMBER(19) VISIBLE ,
  "EXPECTED_TRIGGER_TIME" NUMBER(19) VISIBLE ,
  "FINISHED_TIME" NUMBER(19) VISIBLE ,
  "GMT_CREATE" TIMESTAMP(6) VISIBLE ,
  "GMT_MODIFIED" TIMESTAMP(6) VISIBLE ,
  "INSTANCE_ID" NUMBER(19) VISIBLE ,
  "INSTANCE_PARAMS" CLOB VISIBLE ,
  "JOB_ID" NUMBER(19) VISIBLE ,
  "JOB_PARAMS" CLOB VISIBLE ,
  "LAST_REPORT_TIME" NUMBER(19) VISIBLE ,
  "RESULT" CLOB VISIBLE ,
  "RUNNING_TIMES" NUMBER(19) VISIBLE ,
  "STATUS" NUMBER(10) VISIBLE ,
  "TASK_TRACKER_ADDRESS" VARCHAR2(255 CHAR) VISIBLE ,
  "TYPE" NUMBER(10) VISIBLE ,
  "WF_INSTANCE_ID" NUMBER(19) VISIBLE
)
TABLESPACE "ROOT"
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536
  NEXT 1048576
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Table structure for PJ_JOB_INFO
-- ----------------------------
CREATE TABLE "PJ_JOB_INFO" (
  "ID" NUMBER(19) VISIBLE NOT NULL ,
  "ALARM_CONFIG" VARCHAR2(255 CHAR) VISIBLE ,
  "APP_ID" NUMBER(19) VISIBLE ,
  "CONCURRENCY" NUMBER(10) VISIBLE ,
  "DESIGNATED_WORKERS" VARCHAR2(255 CHAR) VISIBLE ,
  "DISPATCH_STRATEGY" NUMBER(10) VISIBLE ,
  "EXECUTE_TYPE" NUMBER(10) VISIBLE ,
  "EXTRA" VARCHAR2(255 CHAR) VISIBLE ,
  "GMT_CREATE" TIMESTAMP(6) VISIBLE ,
  "GMT_MODIFIED" TIMESTAMP(6) VISIBLE ,
  "INSTANCE_RETRY_NUM" NUMBER(10) VISIBLE ,
  "INSTANCE_TIME_LIMIT" NUMBER(19) VISIBLE ,
  "JOB_DESCRIPTION" VARCHAR2(255 CHAR) VISIBLE ,
  "JOB_NAME" VARCHAR2(255 CHAR) VISIBLE ,
  "JOB_PARAMS" CLOB VISIBLE ,
  "LIFECYCLE" VARCHAR2(255 CHAR) VISIBLE ,
  "LOG_CONFIG" VARCHAR2(255 CHAR) VISIBLE ,
  "MAX_INSTANCE_NUM" NUMBER(10) VISIBLE ,
  "MAX_WORKER_COUNT" NUMBER(10) VISIBLE ,
  "MIN_CPU_CORES" FLOAT(126) VISIBLE NOT NULL ,
  "MIN_DISK_SPACE" FLOAT(126) VISIBLE NOT NULL ,
  "MIN_MEMORY_SPACE" FLOAT(126) VISIBLE NOT NULL ,
  "NEXT_TRIGGER_TIME" NUMBER(19) VISIBLE ,
  "NOTIFY_USER_IDS" VARCHAR2(255 CHAR) VISIBLE ,
  "PROCESSOR_INFO" VARCHAR2(255 CHAR) VISIBLE ,
  "PROCESSOR_TYPE" NUMBER(10) VISIBLE ,
  "STATUS" NUMBER(10) VISIBLE ,
  "TAG" VARCHAR2(255 CHAR) VISIBLE ,
  "TASK_RETRY_NUM" NUMBER(10) VISIBLE ,
  "TIME_EXPRESSION" VARCHAR2(255 CHAR) VISIBLE ,
  "TIME_EXPRESSION_TYPE" NUMBER(10) VISIBLE
)
TABLESPACE "ROOT"
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536
  NEXT 1048576
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Records of "PJ_JOB_INFO"
-- ----------------------------
INSERT INTO "PJ_JOB_INFO" VALUES ('1', '{"alertThreshold":0,"silenceWindowLen":0,"statisticWindowLen":0}', '1', '5', NULL, '2', '1', NULL, NULL, NULL, '1', '0', NULL, '单机处理器执行测试', NULL, '{}', '{"type":1}', '0', '0', '0.0000000000000000', '0.0000000000000000', '0.0000000000000000', NULL, NULL, 'org.dromara.job.processors.StandaloneProcessorDemo', '1', '2', NULL, '1', '30000', '3');
INSERT INTO "PJ_JOB_INFO" VALUES ('2', '{"alertThreshold":0,"silenceWindowLen":0,"statisticWindowLen":0}', '1', '5', NULL, '1', '2', NULL, NULL, NULL, '0', '0', NULL, '广播处理器测试', NULL, '{}', '{"type":1}', '0', '0', '0.0000000000000000', '0.0000000000000000', '0.0000000000000000', NULL, NULL, 'org.dromara.job.processors.BroadcastProcessorDemo', '1', '2', NULL, '1', '30000', '3');
INSERT INTO "PJ_JOB_INFO" VALUES ('3', '{"alertThreshold":0,"silenceWindowLen":0,"statisticWindowLen":0}', '1', '5', NULL, '1', '4', NULL, NULL, NULL, '0', '0', NULL, 'Map处理器测试', NULL, '{}', '{"type":1}', '0', '0', '0.0000000000000000', '0.0000000000000000', '0.0000000000000000', NULL, NULL, 'org.dromara.job.processors.MapProcessorDemo', '1', '2', NULL, '1', '1000', '3');
INSERT INTO "PJ_JOB_INFO" VALUES ('4', '{"alertThreshold":0,"silenceWindowLen":0,"statisticWindowLen":0}', '1', '5', NULL, '1', '3', NULL, NULL, NULL, '0', '0', NULL, 'MapReduce处理器测试', NULL, '{}', '{"type":1}', '0', '0', '0.0000000000000000', '0.0000000000000000', '0.0000000000000000', NULL, NULL, 'org.dromara.job.processors.MapReduceProcessorDemo', '1', '2', NULL, '1', '1000', '3');

-- ----------------------------
-- Table structure for PJ_OMS_LOCK
-- ----------------------------
CREATE TABLE "PJ_OMS_LOCK" (
  "ID" NUMBER(19) VISIBLE NOT NULL ,
  "GMT_CREATE" TIMESTAMP(6) VISIBLE ,
  "GMT_MODIFIED" TIMESTAMP(6) VISIBLE ,
  "LOCK_NAME" VARCHAR2(255 CHAR) VISIBLE ,
  "MAX_LOCK_TIME" NUMBER(19) VISIBLE ,
  "OWNERIP" VARCHAR2(255 CHAR) VISIBLE
)
TABLESPACE "ROOT"
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536
  NEXT 1048576
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Table structure for PJ_SERVER_INFO
-- ----------------------------
CREATE TABLE "PJ_SERVER_INFO" (
  "ID" NUMBER(19) VISIBLE NOT NULL ,
  "GMT_CREATE" TIMESTAMP(6) VISIBLE ,
  "GMT_MODIFIED" TIMESTAMP(6) VISIBLE ,
  "IP" VARCHAR2(255 CHAR) VISIBLE
)
TABLESPACE "ROOT"
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536
  NEXT 1048576
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Table structure for PJ_USER_INFO
-- ----------------------------
CREATE TABLE "PJ_USER_INFO" (
  "ID" NUMBER(19) VISIBLE NOT NULL ,
  "EMAIL" VARCHAR2(255 CHAR) VISIBLE ,
  "EXTRA" VARCHAR2(255 CHAR) VISIBLE ,
  "GMT_CREATE" TIMESTAMP(6) VISIBLE ,
  "GMT_MODIFIED" TIMESTAMP(6) VISIBLE ,
  "PASSWORD" VARCHAR2(255 CHAR) VISIBLE ,
  "PHONE" VARCHAR2(255 CHAR) VISIBLE ,
  "USERNAME" VARCHAR2(255 CHAR) VISIBLE ,
  "WEB_HOOK" VARCHAR2(255 CHAR) VISIBLE
)
TABLESPACE "ROOT"
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536
  NEXT 1048576
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Table structure for PJ_WORKFLOW_INFO
-- ----------------------------
CREATE TABLE "PJ_WORKFLOW_INFO" (
  "ID" NUMBER(19) VISIBLE NOT NULL ,
  "APP_ID" NUMBER(19) VISIBLE ,
  "EXTRA" VARCHAR2(255 CHAR) VISIBLE ,
  "GMT_CREATE" TIMESTAMP(6) VISIBLE ,
  "GMT_MODIFIED" TIMESTAMP(6) VISIBLE ,
  "LIFECYCLE" VARCHAR2(255 CHAR) VISIBLE ,
  "MAX_WF_INSTANCE_NUM" NUMBER(10) VISIBLE ,
  "NEXT_TRIGGER_TIME" NUMBER(19) VISIBLE ,
  "NOTIFY_USER_IDS" VARCHAR2(255 CHAR) VISIBLE ,
  "PEDAG" CLOB VISIBLE ,
  "STATUS" NUMBER(10) VISIBLE ,
  "TIME_EXPRESSION" VARCHAR2(255 CHAR) VISIBLE ,
  "TIME_EXPRESSION_TYPE" NUMBER(10) VISIBLE ,
  "WF_DESCRIPTION" VARCHAR2(255 CHAR) VISIBLE ,
  "WF_NAME" VARCHAR2(255 CHAR) VISIBLE
)
TABLESPACE "ROOT"
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536
  NEXT 1048576
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Table structure for PJ_WORKFLOW_INSTANCE_INFO
-- ----------------------------
CREATE TABLE "PJ_WORKFLOW_INSTANCE_INFO" (
  "ID" NUMBER(19) VISIBLE NOT NULL ,
  "ACTUAL_TRIGGER_TIME" NUMBER(19) VISIBLE ,
  "APP_ID" NUMBER(19) VISIBLE ,
  "DAG" CLOB VISIBLE ,
  "EXPECTED_TRIGGER_TIME" NUMBER(19) VISIBLE ,
  "FINISHED_TIME" NUMBER(19) VISIBLE ,
  "GMT_CREATE" TIMESTAMP(6) VISIBLE ,
  "GMT_MODIFIED" TIMESTAMP(6) VISIBLE ,
  "PARENT_WF_INSTANCE_ID" NUMBER(19) VISIBLE ,
  "RESULT" CLOB VISIBLE ,
  "STATUS" NUMBER(10) VISIBLE ,
  "WF_CONTEXT" CLOB VISIBLE ,
  "WF_INIT_PARAMS" CLOB VISIBLE ,
  "WF_INSTANCE_ID" NUMBER(19) VISIBLE ,
  "WORKFLOW_ID" NUMBER(19) VISIBLE
)
TABLESPACE "ROOT"
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536
  NEXT 1048576
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Table structure for PJ_WORKFLOW_NODE_INFO
-- ----------------------------
CREATE TABLE "PJ_WORKFLOW_NODE_INFO" (
  "ID" NUMBER(19) VISIBLE NOT NULL ,
  "APP_ID" NUMBER(19) VISIBLE NOT NULL ,
  "ENABLE" NUMBER(1) VISIBLE NOT NULL ,
  "EXTRA" CLOB VISIBLE ,
  "GMT_CREATE" TIMESTAMP(6) VISIBLE NOT NULL ,
  "GMT_MODIFIED" TIMESTAMP(6) VISIBLE NOT NULL ,
  "JOB_ID" NUMBER(19) VISIBLE ,
  "NODE_NAME" VARCHAR2(255 CHAR) VISIBLE ,
  "NODE_PARAMS" CLOB VISIBLE ,
  "SKIP_WHEN_FAILED" NUMBER(1) VISIBLE NOT NULL ,
  "TYPE" NUMBER(10) VISIBLE ,
  "WORKFLOW_ID" NUMBER(19) VISIBLE
)
TABLESPACE "ROOT"
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536
  NEXT 1048576
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Primary Key structure for table PJ_APP_INFO
-- ----------------------------
ALTER TABLE "PJ_APP_INFO" ADD CONSTRAINT "SYS_C0012204" PRIMARY KEY ("ID");

-- ----------------------------
-- Uniques structure for table PJ_APP_INFO
-- ----------------------------
ALTER TABLE "PJ_APP_INFO" ADD CONSTRAINT "UIDX01_APP_INFO" UNIQUE ("APP_NAME") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Checks structure for table PJ_APP_INFO
-- ----------------------------
ALTER TABLE "PJ_APP_INFO" ADD CONSTRAINT "SYS_C0012203" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table PJ_CONTAINER_INFO
-- ----------------------------
ALTER TABLE "PJ_CONTAINER_INFO" ADD CONSTRAINT "SYS_C0012206" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table PJ_CONTAINER_INFO
-- ----------------------------
ALTER TABLE "PJ_CONTAINER_INFO" ADD CONSTRAINT "SYS_C0012205" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Indexes structure for table PJ_CONTAINER_INFO
-- ----------------------------
CREATE INDEX "IDX01_CONTAINER_INFO"
  ON "PJ_CONTAINER_INFO" ("APP_ID" ASC)
  LOGGING
  TABLESPACE "ROOT"
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536
  NEXT 1048576
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
  FLASH_CACHE DEFAULT
)
   USABLE;

-- ----------------------------
-- Primary Key structure for table PJ_INSTANCE_INFO
-- ----------------------------
ALTER TABLE "PJ_INSTANCE_INFO" ADD CONSTRAINT "SYS_C0012208" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table PJ_INSTANCE_INFO
-- ----------------------------
ALTER TABLE "PJ_INSTANCE_INFO" ADD CONSTRAINT "SYS_C0012207" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Indexes structure for table PJ_INSTANCE_INFO
-- ----------------------------
CREATE INDEX "IDX01_INSTANCE_INFO"
  ON "PJ_INSTANCE_INFO" ("JOB_ID" ASC, "STATUS" ASC)
  LOGGING
  TABLESPACE "ROOT"
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536
  NEXT 1048576
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
  FLASH_CACHE DEFAULT
)
   USABLE;
CREATE INDEX "IDX02_INSTANCE_INFO"
  ON "PJ_INSTANCE_INFO" ("APP_ID" ASC, "STATUS" ASC)
  LOGGING
  TABLESPACE "ROOT"
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536
  NEXT 1048576
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
  FLASH_CACHE DEFAULT
)
   USABLE;
CREATE INDEX "IDX03_INSTANCE_INFO"
  ON "PJ_INSTANCE_INFO" ("INSTANCE_ID" ASC, "STATUS" ASC)
  LOGGING
  TABLESPACE "ROOT"
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536
  NEXT 1048576
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
  FLASH_CACHE DEFAULT
)
   USABLE;

-- ----------------------------
-- Primary Key structure for table PJ_JOB_INFO
-- ----------------------------
ALTER TABLE "PJ_JOB_INFO" ADD CONSTRAINT "SYS_C0012213" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table PJ_JOB_INFO
-- ----------------------------
ALTER TABLE "PJ_JOB_INFO" ADD CONSTRAINT "SYS_C0012209" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "PJ_JOB_INFO" ADD CONSTRAINT "SYS_C0012210" CHECK ("MIN_CPU_CORES" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "PJ_JOB_INFO" ADD CONSTRAINT "SYS_C0012211" CHECK ("MIN_DISK_SPACE" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "PJ_JOB_INFO" ADD CONSTRAINT "SYS_C0012212" CHECK ("MIN_MEMORY_SPACE" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Indexes structure for table PJ_JOB_INFO
-- ----------------------------
CREATE INDEX "IDX01_JOB_INFO"
  ON "PJ_JOB_INFO" ("APP_ID" ASC, "NEXT_TRIGGER_TIME" ASC, "TIME_EXPRESSION_TYPE" ASC, "STATUS" ASC)
  LOGGING
  TABLESPACE "ROOT"
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536
  NEXT 1048576
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
  FLASH_CACHE DEFAULT
)
   USABLE;

-- ----------------------------
-- Primary Key structure for table PJ_OMS_LOCK
-- ----------------------------
ALTER TABLE "PJ_OMS_LOCK" ADD CONSTRAINT "SYS_C0012215" PRIMARY KEY ("ID");

-- ----------------------------
-- Uniques structure for table PJ_OMS_LOCK
-- ----------------------------
ALTER TABLE "PJ_OMS_LOCK" ADD CONSTRAINT "UIDX01_OMS_LOCK" UNIQUE ("LOCK_NAME") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Checks structure for table PJ_OMS_LOCK
-- ----------------------------
ALTER TABLE "PJ_OMS_LOCK" ADD CONSTRAINT "SYS_C0012214" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table PJ_SERVER_INFO
-- ----------------------------
ALTER TABLE "PJ_SERVER_INFO" ADD CONSTRAINT "SYS_C0012217" PRIMARY KEY ("ID");

-- ----------------------------
-- Uniques structure for table PJ_SERVER_INFO
-- ----------------------------
ALTER TABLE "PJ_SERVER_INFO" ADD CONSTRAINT "UIDX01_SERVER_INFO" UNIQUE ("IP") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Checks structure for table PJ_SERVER_INFO
-- ----------------------------
ALTER TABLE "PJ_SERVER_INFO" ADD CONSTRAINT "SYS_C0012216" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Indexes structure for table PJ_SERVER_INFO
-- ----------------------------
CREATE INDEX "IDX01_SERVER_INFO"
  ON "PJ_SERVER_INFO" ("GMT_MODIFIED" ASC)
  LOGGING
  TABLESPACE "ROOT"
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536
  NEXT 1048576
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
  FLASH_CACHE DEFAULT
)
   USABLE;

-- ----------------------------
-- Primary Key structure for table PJ_USER_INFO
-- ----------------------------
ALTER TABLE "PJ_USER_INFO" ADD CONSTRAINT "SYS_C0012219" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table PJ_USER_INFO
-- ----------------------------
ALTER TABLE "PJ_USER_INFO" ADD CONSTRAINT "SYS_C0012218" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Indexes structure for table PJ_USER_INFO
-- ----------------------------
CREATE INDEX "UIDX01_USER_INFO"
  ON "PJ_USER_INFO" ("USERNAME" ASC)
  LOGGING
  TABLESPACE "ROOT"
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536
  NEXT 1048576
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
  FLASH_CACHE DEFAULT
)
   USABLE;
CREATE INDEX "UIDX02_USER_INFO"
  ON "PJ_USER_INFO" ("EMAIL" ASC)
  LOGGING
  TABLESPACE "ROOT"
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536
  NEXT 1048576
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
  FLASH_CACHE DEFAULT
)
   USABLE;

-- ----------------------------
-- Primary Key structure for table PJ_WORKFLOW_INFO
-- ----------------------------
ALTER TABLE "PJ_WORKFLOW_INFO" ADD CONSTRAINT "SYS_C0012221" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table PJ_WORKFLOW_INFO
-- ----------------------------
ALTER TABLE "PJ_WORKFLOW_INFO" ADD CONSTRAINT "SYS_C0012220" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Indexes structure for table PJ_WORKFLOW_INFO
-- ----------------------------
CREATE INDEX "IDX01_WORKFLOW_INFO"
  ON "PJ_WORKFLOW_INFO" ("APP_ID" ASC, "NEXT_TRIGGER_TIME" ASC, "TIME_EXPRESSION_TYPE" ASC, "STATUS" ASC)
  LOGGING
  TABLESPACE "ROOT"
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536
  NEXT 1048576
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
  FLASH_CACHE DEFAULT
)
   USABLE;

-- ----------------------------
-- Primary Key structure for table PJ_WORKFLOW_INSTANCE_INFO
-- ----------------------------
ALTER TABLE "PJ_WORKFLOW_INSTANCE_INFO" ADD CONSTRAINT "SYS_C0012223" PRIMARY KEY ("ID");

-- ----------------------------
-- Uniques structure for table PJ_WORKFLOW_INSTANCE_INFO
-- ----------------------------
ALTER TABLE "PJ_WORKFLOW_INSTANCE_INFO" ADD CONSTRAINT "UIDX01_WF_INSTANCE" UNIQUE ("WF_INSTANCE_ID") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Checks structure for table PJ_WORKFLOW_INSTANCE_INFO
-- ----------------------------
ALTER TABLE "PJ_WORKFLOW_INSTANCE_INFO" ADD CONSTRAINT "SYS_C0012222" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Indexes structure for table PJ_WORKFLOW_INSTANCE_INFO
-- ----------------------------
CREATE INDEX "IDX01_WF_INSTANCE"
  ON "PJ_WORKFLOW_INSTANCE_INFO" ("WORKFLOW_ID" ASC, "EXPECTED_TRIGGER_TIME" ASC, "APP_ID" ASC, "STATUS" ASC)
  LOGGING
  TABLESPACE "ROOT"
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536
  NEXT 1048576
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
  FLASH_CACHE DEFAULT
)
   USABLE;

-- ----------------------------
-- Primary Key structure for table PJ_WORKFLOW_NODE_INFO
-- ----------------------------
ALTER TABLE "PJ_WORKFLOW_NODE_INFO" ADD CONSTRAINT "SYS_C0012230" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table PJ_WORKFLOW_NODE_INFO
-- ----------------------------
ALTER TABLE "PJ_WORKFLOW_NODE_INFO" ADD CONSTRAINT "SYS_C0012224" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "PJ_WORKFLOW_NODE_INFO" ADD CONSTRAINT "SYS_C0012225" CHECK ("APP_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "PJ_WORKFLOW_NODE_INFO" ADD CONSTRAINT "SYS_C0012226" CHECK ("ENABLE" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "PJ_WORKFLOW_NODE_INFO" ADD CONSTRAINT "SYS_C0012227" CHECK ("GMT_CREATE" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "PJ_WORKFLOW_NODE_INFO" ADD CONSTRAINT "SYS_C0012228" CHECK ("GMT_MODIFIED" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "PJ_WORKFLOW_NODE_INFO" ADD CONSTRAINT "SYS_C0012229" CHECK ("SKIP_WHEN_FAILED" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Indexes structure for table PJ_WORKFLOW_NODE_INFO
-- ----------------------------
CREATE INDEX "IDX01_WORKFLOW_NODE_INFO"
  ON "PJ_WORKFLOW_NODE_INFO" ("GMT_CREATE" ASC, "WORKFLOW_ID" ASC)
  LOGGING
  TABLESPACE "ROOT"
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536
  NEXT 1048576
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
  FLASH_CACHE DEFAULT
)
   USABLE;