powerjob.sql 21 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694
  1. -- ----------------------------
  2. -- Table structure for PJ_APP_INFO
  3. -- ----------------------------
  4. CREATE TABLE "PJ_APP_INFO" (
  5. "ID" NUMBER(19) VISIBLE NOT NULL ,
  6. "APP_NAME" VARCHAR2(255 CHAR) VISIBLE ,
  7. "CURRENT_SERVER" VARCHAR2(255 CHAR) VISIBLE ,
  8. "GMT_CREATE" TIMESTAMP(6) VISIBLE ,
  9. "GMT_MODIFIED" TIMESTAMP(6) VISIBLE ,
  10. "PASSWORD" VARCHAR2(255 CHAR) VISIBLE
  11. )
  12. TABLESPACE "ROOT"
  13. LOGGING
  14. NOCOMPRESS
  15. PCTFREE 10
  16. INITRANS 1
  17. STORAGE (
  18. INITIAL 65536
  19. NEXT 1048576
  20. MINEXTENTS 1
  21. MAXEXTENTS 2147483645
  22. BUFFER_POOL DEFAULT
  23. )
  24. PARALLEL 1
  25. NOCACHE
  26. DISABLE ROW MOVEMENT
  27. ;
  28. -- ----------------------------
  29. -- Records of "PJ_APP_INFO"
  30. -- ----------------------------
  31. INSERT INTO "PJ_APP_INFO" VALUES ('1', 'ruoyi-worker', '127.0.0.1:10010', NULL, NULL, '123456');
  32. -- ----------------------------
  33. -- Table structure for PJ_CONTAINER_INFO
  34. -- ----------------------------
  35. CREATE TABLE "PJ_CONTAINER_INFO" (
  36. "ID" NUMBER(19) VISIBLE NOT NULL ,
  37. "APP_ID" NUMBER(19) VISIBLE ,
  38. "CONTAINER_NAME" VARCHAR2(255 CHAR) VISIBLE ,
  39. "GMT_CREATE" TIMESTAMP(6) VISIBLE ,
  40. "GMT_MODIFIED" TIMESTAMP(6) VISIBLE ,
  41. "LAST_DEPLOY_TIME" TIMESTAMP(6) VISIBLE ,
  42. "SOURCE_INFO" VARCHAR2(255 CHAR) VISIBLE ,
  43. "SOURCE_TYPE" NUMBER(10) VISIBLE ,
  44. "STATUS" NUMBER(10) VISIBLE ,
  45. "VERSION" VARCHAR2(255 CHAR) VISIBLE
  46. )
  47. TABLESPACE "ROOT"
  48. LOGGING
  49. NOCOMPRESS
  50. PCTFREE 10
  51. INITRANS 1
  52. STORAGE (
  53. INITIAL 65536
  54. NEXT 1048576
  55. MINEXTENTS 1
  56. MAXEXTENTS 2147483645
  57. BUFFER_POOL DEFAULT
  58. )
  59. PARALLEL 1
  60. NOCACHE
  61. DISABLE ROW MOVEMENT
  62. ;
  63. -- ----------------------------
  64. -- Table structure for PJ_INSTANCE_INFO
  65. -- ----------------------------
  66. CREATE TABLE "PJ_INSTANCE_INFO" (
  67. "ID" NUMBER(19) VISIBLE NOT NULL ,
  68. "ACTUAL_TRIGGER_TIME" NUMBER(19) VISIBLE ,
  69. "APP_ID" NUMBER(19) VISIBLE ,
  70. "EXPECTED_TRIGGER_TIME" NUMBER(19) VISIBLE ,
  71. "FINISHED_TIME" NUMBER(19) VISIBLE ,
  72. "GMT_CREATE" TIMESTAMP(6) VISIBLE ,
  73. "GMT_MODIFIED" TIMESTAMP(6) VISIBLE ,
  74. "INSTANCE_ID" NUMBER(19) VISIBLE ,
  75. "INSTANCE_PARAMS" CLOB VISIBLE ,
  76. "JOB_ID" NUMBER(19) VISIBLE ,
  77. "JOB_PARAMS" CLOB VISIBLE ,
  78. "LAST_REPORT_TIME" NUMBER(19) VISIBLE ,
  79. "RESULT" CLOB VISIBLE ,
  80. "RUNNING_TIMES" NUMBER(19) VISIBLE ,
  81. "STATUS" NUMBER(10) VISIBLE ,
  82. "TASK_TRACKER_ADDRESS" VARCHAR2(255 CHAR) VISIBLE ,
  83. "TYPE" NUMBER(10) VISIBLE ,
  84. "WF_INSTANCE_ID" NUMBER(19) VISIBLE
  85. )
  86. TABLESPACE "ROOT"
  87. LOGGING
  88. NOCOMPRESS
  89. PCTFREE 10
  90. INITRANS 1
  91. STORAGE (
  92. INITIAL 65536
  93. NEXT 1048576
  94. MINEXTENTS 1
  95. MAXEXTENTS 2147483645
  96. BUFFER_POOL DEFAULT
  97. )
  98. PARALLEL 1
  99. NOCACHE
  100. DISABLE ROW MOVEMENT
  101. ;
  102. -- ----------------------------
  103. -- Table structure for PJ_JOB_INFO
  104. -- ----------------------------
  105. CREATE TABLE "PJ_JOB_INFO" (
  106. "ID" NUMBER(19) VISIBLE NOT NULL ,
  107. "ALARM_CONFIG" VARCHAR2(255 CHAR) VISIBLE ,
  108. "APP_ID" NUMBER(19) VISIBLE ,
  109. "CONCURRENCY" NUMBER(10) VISIBLE ,
  110. "DESIGNATED_WORKERS" VARCHAR2(255 CHAR) VISIBLE ,
  111. "DISPATCH_STRATEGY" NUMBER(10) VISIBLE ,
  112. "EXECUTE_TYPE" NUMBER(10) VISIBLE ,
  113. "EXTRA" VARCHAR2(255 CHAR) VISIBLE ,
  114. "GMT_CREATE" TIMESTAMP(6) VISIBLE ,
  115. "GMT_MODIFIED" TIMESTAMP(6) VISIBLE ,
  116. "INSTANCE_RETRY_NUM" NUMBER(10) VISIBLE ,
  117. "INSTANCE_TIME_LIMIT" NUMBER(19) VISIBLE ,
  118. "JOB_DESCRIPTION" VARCHAR2(255 CHAR) VISIBLE ,
  119. "JOB_NAME" VARCHAR2(255 CHAR) VISIBLE ,
  120. "JOB_PARAMS" CLOB VISIBLE ,
  121. "LIFECYCLE" VARCHAR2(255 CHAR) VISIBLE ,
  122. "LOG_CONFIG" VARCHAR2(255 CHAR) VISIBLE ,
  123. "MAX_INSTANCE_NUM" NUMBER(10) VISIBLE ,
  124. "MAX_WORKER_COUNT" NUMBER(10) VISIBLE ,
  125. "MIN_CPU_CORES" FLOAT(126) VISIBLE NOT NULL ,
  126. "MIN_DISK_SPACE" FLOAT(126) VISIBLE NOT NULL ,
  127. "MIN_MEMORY_SPACE" FLOAT(126) VISIBLE NOT NULL ,
  128. "NEXT_TRIGGER_TIME" NUMBER(19) VISIBLE ,
  129. "NOTIFY_USER_IDS" VARCHAR2(255 CHAR) VISIBLE ,
  130. "PROCESSOR_INFO" VARCHAR2(255 CHAR) VISIBLE ,
  131. "PROCESSOR_TYPE" NUMBER(10) VISIBLE ,
  132. "STATUS" NUMBER(10) VISIBLE ,
  133. "TAG" VARCHAR2(255 CHAR) VISIBLE ,
  134. "TASK_RETRY_NUM" NUMBER(10) VISIBLE ,
  135. "TIME_EXPRESSION" VARCHAR2(255 CHAR) VISIBLE ,
  136. "TIME_EXPRESSION_TYPE" NUMBER(10) VISIBLE
  137. )
  138. TABLESPACE "ROOT"
  139. LOGGING
  140. NOCOMPRESS
  141. PCTFREE 10
  142. INITRANS 1
  143. STORAGE (
  144. INITIAL 65536
  145. NEXT 1048576
  146. MINEXTENTS 1
  147. MAXEXTENTS 2147483645
  148. BUFFER_POOL DEFAULT
  149. )
  150. PARALLEL 1
  151. NOCACHE
  152. DISABLE ROW MOVEMENT
  153. ;
  154. -- ----------------------------
  155. -- Records of "PJ_JOB_INFO"
  156. -- ----------------------------
  157. 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');
  158. 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');
  159. 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');
  160. 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');
  161. -- ----------------------------
  162. -- Table structure for PJ_OMS_LOCK
  163. -- ----------------------------
  164. CREATE TABLE "PJ_OMS_LOCK" (
  165. "ID" NUMBER(19) VISIBLE NOT NULL ,
  166. "GMT_CREATE" TIMESTAMP(6) VISIBLE ,
  167. "GMT_MODIFIED" TIMESTAMP(6) VISIBLE ,
  168. "LOCK_NAME" VARCHAR2(255 CHAR) VISIBLE ,
  169. "MAX_LOCK_TIME" NUMBER(19) VISIBLE ,
  170. "OWNERIP" VARCHAR2(255 CHAR) VISIBLE
  171. )
  172. TABLESPACE "ROOT"
  173. LOGGING
  174. NOCOMPRESS
  175. PCTFREE 10
  176. INITRANS 1
  177. STORAGE (
  178. INITIAL 65536
  179. NEXT 1048576
  180. MINEXTENTS 1
  181. MAXEXTENTS 2147483645
  182. BUFFER_POOL DEFAULT
  183. )
  184. PARALLEL 1
  185. NOCACHE
  186. DISABLE ROW MOVEMENT
  187. ;
  188. -- ----------------------------
  189. -- Table structure for PJ_SERVER_INFO
  190. -- ----------------------------
  191. CREATE TABLE "PJ_SERVER_INFO" (
  192. "ID" NUMBER(19) VISIBLE NOT NULL ,
  193. "GMT_CREATE" TIMESTAMP(6) VISIBLE ,
  194. "GMT_MODIFIED" TIMESTAMP(6) VISIBLE ,
  195. "IP" VARCHAR2(255 CHAR) VISIBLE
  196. )
  197. TABLESPACE "ROOT"
  198. LOGGING
  199. NOCOMPRESS
  200. PCTFREE 10
  201. INITRANS 1
  202. STORAGE (
  203. INITIAL 65536
  204. NEXT 1048576
  205. MINEXTENTS 1
  206. MAXEXTENTS 2147483645
  207. BUFFER_POOL DEFAULT
  208. )
  209. PARALLEL 1
  210. NOCACHE
  211. DISABLE ROW MOVEMENT
  212. ;
  213. -- ----------------------------
  214. -- Table structure for PJ_USER_INFO
  215. -- ----------------------------
  216. CREATE TABLE "PJ_USER_INFO" (
  217. "ID" NUMBER(19) VISIBLE NOT NULL ,
  218. "EMAIL" VARCHAR2(255 CHAR) VISIBLE ,
  219. "EXTRA" VARCHAR2(255 CHAR) VISIBLE ,
  220. "GMT_CREATE" TIMESTAMP(6) VISIBLE ,
  221. "GMT_MODIFIED" TIMESTAMP(6) VISIBLE ,
  222. "PASSWORD" VARCHAR2(255 CHAR) VISIBLE ,
  223. "PHONE" VARCHAR2(255 CHAR) VISIBLE ,
  224. "USERNAME" VARCHAR2(255 CHAR) VISIBLE ,
  225. "WEB_HOOK" VARCHAR2(255 CHAR) VISIBLE
  226. )
  227. TABLESPACE "ROOT"
  228. LOGGING
  229. NOCOMPRESS
  230. PCTFREE 10
  231. INITRANS 1
  232. STORAGE (
  233. INITIAL 65536
  234. NEXT 1048576
  235. MINEXTENTS 1
  236. MAXEXTENTS 2147483645
  237. BUFFER_POOL DEFAULT
  238. )
  239. PARALLEL 1
  240. NOCACHE
  241. DISABLE ROW MOVEMENT
  242. ;
  243. -- ----------------------------
  244. -- Table structure for PJ_WORKFLOW_INFO
  245. -- ----------------------------
  246. CREATE TABLE "PJ_WORKFLOW_INFO" (
  247. "ID" NUMBER(19) VISIBLE NOT NULL ,
  248. "APP_ID" NUMBER(19) VISIBLE ,
  249. "EXTRA" VARCHAR2(255 CHAR) VISIBLE ,
  250. "GMT_CREATE" TIMESTAMP(6) VISIBLE ,
  251. "GMT_MODIFIED" TIMESTAMP(6) VISIBLE ,
  252. "LIFECYCLE" VARCHAR2(255 CHAR) VISIBLE ,
  253. "MAX_WF_INSTANCE_NUM" NUMBER(10) VISIBLE ,
  254. "NEXT_TRIGGER_TIME" NUMBER(19) VISIBLE ,
  255. "NOTIFY_USER_IDS" VARCHAR2(255 CHAR) VISIBLE ,
  256. "PEDAG" CLOB VISIBLE ,
  257. "STATUS" NUMBER(10) VISIBLE ,
  258. "TIME_EXPRESSION" VARCHAR2(255 CHAR) VISIBLE ,
  259. "TIME_EXPRESSION_TYPE" NUMBER(10) VISIBLE ,
  260. "WF_DESCRIPTION" VARCHAR2(255 CHAR) VISIBLE ,
  261. "WF_NAME" VARCHAR2(255 CHAR) VISIBLE
  262. )
  263. TABLESPACE "ROOT"
  264. LOGGING
  265. NOCOMPRESS
  266. PCTFREE 10
  267. INITRANS 1
  268. STORAGE (
  269. INITIAL 65536
  270. NEXT 1048576
  271. MINEXTENTS 1
  272. MAXEXTENTS 2147483645
  273. BUFFER_POOL DEFAULT
  274. )
  275. PARALLEL 1
  276. NOCACHE
  277. DISABLE ROW MOVEMENT
  278. ;
  279. -- ----------------------------
  280. -- Table structure for PJ_WORKFLOW_INSTANCE_INFO
  281. -- ----------------------------
  282. CREATE TABLE "PJ_WORKFLOW_INSTANCE_INFO" (
  283. "ID" NUMBER(19) VISIBLE NOT NULL ,
  284. "ACTUAL_TRIGGER_TIME" NUMBER(19) VISIBLE ,
  285. "APP_ID" NUMBER(19) VISIBLE ,
  286. "DAG" CLOB VISIBLE ,
  287. "EXPECTED_TRIGGER_TIME" NUMBER(19) VISIBLE ,
  288. "FINISHED_TIME" NUMBER(19) VISIBLE ,
  289. "GMT_CREATE" TIMESTAMP(6) VISIBLE ,
  290. "GMT_MODIFIED" TIMESTAMP(6) VISIBLE ,
  291. "PARENT_WF_INSTANCE_ID" NUMBER(19) VISIBLE ,
  292. "RESULT" CLOB VISIBLE ,
  293. "STATUS" NUMBER(10) VISIBLE ,
  294. "WF_CONTEXT" CLOB VISIBLE ,
  295. "WF_INIT_PARAMS" CLOB VISIBLE ,
  296. "WF_INSTANCE_ID" NUMBER(19) VISIBLE ,
  297. "WORKFLOW_ID" NUMBER(19) VISIBLE
  298. )
  299. TABLESPACE "ROOT"
  300. LOGGING
  301. NOCOMPRESS
  302. PCTFREE 10
  303. INITRANS 1
  304. STORAGE (
  305. INITIAL 65536
  306. NEXT 1048576
  307. MINEXTENTS 1
  308. MAXEXTENTS 2147483645
  309. BUFFER_POOL DEFAULT
  310. )
  311. PARALLEL 1
  312. NOCACHE
  313. DISABLE ROW MOVEMENT
  314. ;
  315. -- ----------------------------
  316. -- Table structure for PJ_WORKFLOW_NODE_INFO
  317. -- ----------------------------
  318. CREATE TABLE "PJ_WORKFLOW_NODE_INFO" (
  319. "ID" NUMBER(19) VISIBLE NOT NULL ,
  320. "APP_ID" NUMBER(19) VISIBLE NOT NULL ,
  321. "ENABLE" NUMBER(1) VISIBLE NOT NULL ,
  322. "EXTRA" CLOB VISIBLE ,
  323. "GMT_CREATE" TIMESTAMP(6) VISIBLE NOT NULL ,
  324. "GMT_MODIFIED" TIMESTAMP(6) VISIBLE NOT NULL ,
  325. "JOB_ID" NUMBER(19) VISIBLE ,
  326. "NODE_NAME" VARCHAR2(255 CHAR) VISIBLE ,
  327. "NODE_PARAMS" CLOB VISIBLE ,
  328. "SKIP_WHEN_FAILED" NUMBER(1) VISIBLE NOT NULL ,
  329. "TYPE" NUMBER(10) VISIBLE ,
  330. "WORKFLOW_ID" NUMBER(19) VISIBLE
  331. )
  332. TABLESPACE "ROOT"
  333. LOGGING
  334. NOCOMPRESS
  335. PCTFREE 10
  336. INITRANS 1
  337. STORAGE (
  338. INITIAL 65536
  339. NEXT 1048576
  340. MINEXTENTS 1
  341. MAXEXTENTS 2147483645
  342. BUFFER_POOL DEFAULT
  343. )
  344. PARALLEL 1
  345. NOCACHE
  346. DISABLE ROW MOVEMENT
  347. ;
  348. -- ----------------------------
  349. -- Primary Key structure for table PJ_APP_INFO
  350. -- ----------------------------
  351. ALTER TABLE "PJ_APP_INFO" ADD CONSTRAINT "SYS_C0012204" PRIMARY KEY ("ID");
  352. -- ----------------------------
  353. -- Uniques structure for table PJ_APP_INFO
  354. -- ----------------------------
  355. ALTER TABLE "PJ_APP_INFO" ADD CONSTRAINT "UIDX01_APP_INFO" UNIQUE ("APP_NAME") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
  356. -- ----------------------------
  357. -- Checks structure for table PJ_APP_INFO
  358. -- ----------------------------
  359. ALTER TABLE "PJ_APP_INFO" ADD CONSTRAINT "SYS_C0012203" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
  360. -- ----------------------------
  361. -- Primary Key structure for table PJ_CONTAINER_INFO
  362. -- ----------------------------
  363. ALTER TABLE "PJ_CONTAINER_INFO" ADD CONSTRAINT "SYS_C0012206" PRIMARY KEY ("ID");
  364. -- ----------------------------
  365. -- Checks structure for table PJ_CONTAINER_INFO
  366. -- ----------------------------
  367. ALTER TABLE "PJ_CONTAINER_INFO" ADD CONSTRAINT "SYS_C0012205" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
  368. -- ----------------------------
  369. -- Indexes structure for table PJ_CONTAINER_INFO
  370. -- ----------------------------
  371. CREATE INDEX "IDX01_CONTAINER_INFO"
  372. ON "PJ_CONTAINER_INFO" ("APP_ID" ASC)
  373. LOGGING
  374. TABLESPACE "ROOT"
  375. VISIBLE
  376. PCTFREE 10
  377. INITRANS 2
  378. STORAGE (
  379. INITIAL 65536
  380. NEXT 1048576
  381. MINEXTENTS 1
  382. MAXEXTENTS 2147483645
  383. BUFFER_POOL DEFAULT
  384. FLASH_CACHE DEFAULT
  385. )
  386. USABLE;
  387. -- ----------------------------
  388. -- Primary Key structure for table PJ_INSTANCE_INFO
  389. -- ----------------------------
  390. ALTER TABLE "PJ_INSTANCE_INFO" ADD CONSTRAINT "SYS_C0012208" PRIMARY KEY ("ID");
  391. -- ----------------------------
  392. -- Checks structure for table PJ_INSTANCE_INFO
  393. -- ----------------------------
  394. ALTER TABLE "PJ_INSTANCE_INFO" ADD CONSTRAINT "SYS_C0012207" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
  395. -- ----------------------------
  396. -- Indexes structure for table PJ_INSTANCE_INFO
  397. -- ----------------------------
  398. CREATE INDEX "IDX01_INSTANCE_INFO"
  399. ON "PJ_INSTANCE_INFO" ("JOB_ID" ASC, "STATUS" ASC)
  400. LOGGING
  401. TABLESPACE "ROOT"
  402. VISIBLE
  403. PCTFREE 10
  404. INITRANS 2
  405. STORAGE (
  406. INITIAL 65536
  407. NEXT 1048576
  408. MINEXTENTS 1
  409. MAXEXTENTS 2147483645
  410. BUFFER_POOL DEFAULT
  411. FLASH_CACHE DEFAULT
  412. )
  413. USABLE;
  414. CREATE INDEX "IDX02_INSTANCE_INFO"
  415. ON "PJ_INSTANCE_INFO" ("APP_ID" ASC, "STATUS" ASC)
  416. LOGGING
  417. TABLESPACE "ROOT"
  418. VISIBLE
  419. PCTFREE 10
  420. INITRANS 2
  421. STORAGE (
  422. INITIAL 65536
  423. NEXT 1048576
  424. MINEXTENTS 1
  425. MAXEXTENTS 2147483645
  426. BUFFER_POOL DEFAULT
  427. FLASH_CACHE DEFAULT
  428. )
  429. USABLE;
  430. CREATE INDEX "IDX03_INSTANCE_INFO"
  431. ON "PJ_INSTANCE_INFO" ("INSTANCE_ID" ASC, "STATUS" ASC)
  432. LOGGING
  433. TABLESPACE "ROOT"
  434. VISIBLE
  435. PCTFREE 10
  436. INITRANS 2
  437. STORAGE (
  438. INITIAL 65536
  439. NEXT 1048576
  440. MINEXTENTS 1
  441. MAXEXTENTS 2147483645
  442. BUFFER_POOL DEFAULT
  443. FLASH_CACHE DEFAULT
  444. )
  445. USABLE;
  446. -- ----------------------------
  447. -- Primary Key structure for table PJ_JOB_INFO
  448. -- ----------------------------
  449. ALTER TABLE "PJ_JOB_INFO" ADD CONSTRAINT "SYS_C0012213" PRIMARY KEY ("ID");
  450. -- ----------------------------
  451. -- Checks structure for table PJ_JOB_INFO
  452. -- ----------------------------
  453. ALTER TABLE "PJ_JOB_INFO" ADD CONSTRAINT "SYS_C0012209" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
  454. ALTER TABLE "PJ_JOB_INFO" ADD CONSTRAINT "SYS_C0012210" CHECK ("MIN_CPU_CORES" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
  455. ALTER TABLE "PJ_JOB_INFO" ADD CONSTRAINT "SYS_C0012211" CHECK ("MIN_DISK_SPACE" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
  456. ALTER TABLE "PJ_JOB_INFO" ADD CONSTRAINT "SYS_C0012212" CHECK ("MIN_MEMORY_SPACE" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
  457. -- ----------------------------
  458. -- Indexes structure for table PJ_JOB_INFO
  459. -- ----------------------------
  460. CREATE INDEX "IDX01_JOB_INFO"
  461. ON "PJ_JOB_INFO" ("APP_ID" ASC, "NEXT_TRIGGER_TIME" ASC, "TIME_EXPRESSION_TYPE" ASC, "STATUS" ASC)
  462. LOGGING
  463. TABLESPACE "ROOT"
  464. VISIBLE
  465. PCTFREE 10
  466. INITRANS 2
  467. STORAGE (
  468. INITIAL 65536
  469. NEXT 1048576
  470. MINEXTENTS 1
  471. MAXEXTENTS 2147483645
  472. BUFFER_POOL DEFAULT
  473. FLASH_CACHE DEFAULT
  474. )
  475. USABLE;
  476. -- ----------------------------
  477. -- Primary Key structure for table PJ_OMS_LOCK
  478. -- ----------------------------
  479. ALTER TABLE "PJ_OMS_LOCK" ADD CONSTRAINT "SYS_C0012215" PRIMARY KEY ("ID");
  480. -- ----------------------------
  481. -- Uniques structure for table PJ_OMS_LOCK
  482. -- ----------------------------
  483. ALTER TABLE "PJ_OMS_LOCK" ADD CONSTRAINT "UIDX01_OMS_LOCK" UNIQUE ("LOCK_NAME") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
  484. -- ----------------------------
  485. -- Checks structure for table PJ_OMS_LOCK
  486. -- ----------------------------
  487. ALTER TABLE "PJ_OMS_LOCK" ADD CONSTRAINT "SYS_C0012214" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
  488. -- ----------------------------
  489. -- Primary Key structure for table PJ_SERVER_INFO
  490. -- ----------------------------
  491. ALTER TABLE "PJ_SERVER_INFO" ADD CONSTRAINT "SYS_C0012217" PRIMARY KEY ("ID");
  492. -- ----------------------------
  493. -- Uniques structure for table PJ_SERVER_INFO
  494. -- ----------------------------
  495. ALTER TABLE "PJ_SERVER_INFO" ADD CONSTRAINT "UIDX01_SERVER_INFO" UNIQUE ("IP") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
  496. -- ----------------------------
  497. -- Checks structure for table PJ_SERVER_INFO
  498. -- ----------------------------
  499. ALTER TABLE "PJ_SERVER_INFO" ADD CONSTRAINT "SYS_C0012216" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
  500. -- ----------------------------
  501. -- Indexes structure for table PJ_SERVER_INFO
  502. -- ----------------------------
  503. CREATE INDEX "IDX01_SERVER_INFO"
  504. ON "PJ_SERVER_INFO" ("GMT_MODIFIED" ASC)
  505. LOGGING
  506. TABLESPACE "ROOT"
  507. VISIBLE
  508. PCTFREE 10
  509. INITRANS 2
  510. STORAGE (
  511. INITIAL 65536
  512. NEXT 1048576
  513. MINEXTENTS 1
  514. MAXEXTENTS 2147483645
  515. BUFFER_POOL DEFAULT
  516. FLASH_CACHE DEFAULT
  517. )
  518. USABLE;
  519. -- ----------------------------
  520. -- Primary Key structure for table PJ_USER_INFO
  521. -- ----------------------------
  522. ALTER TABLE "PJ_USER_INFO" ADD CONSTRAINT "SYS_C0012219" PRIMARY KEY ("ID");
  523. -- ----------------------------
  524. -- Checks structure for table PJ_USER_INFO
  525. -- ----------------------------
  526. ALTER TABLE "PJ_USER_INFO" ADD CONSTRAINT "SYS_C0012218" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
  527. -- ----------------------------
  528. -- Indexes structure for table PJ_USER_INFO
  529. -- ----------------------------
  530. CREATE INDEX "UIDX01_USER_INFO"
  531. ON "PJ_USER_INFO" ("USERNAME" ASC)
  532. LOGGING
  533. TABLESPACE "ROOT"
  534. VISIBLE
  535. PCTFREE 10
  536. INITRANS 2
  537. STORAGE (
  538. INITIAL 65536
  539. NEXT 1048576
  540. MINEXTENTS 1
  541. MAXEXTENTS 2147483645
  542. BUFFER_POOL DEFAULT
  543. FLASH_CACHE DEFAULT
  544. )
  545. USABLE;
  546. CREATE INDEX "UIDX02_USER_INFO"
  547. ON "PJ_USER_INFO" ("EMAIL" ASC)
  548. LOGGING
  549. TABLESPACE "ROOT"
  550. VISIBLE
  551. PCTFREE 10
  552. INITRANS 2
  553. STORAGE (
  554. INITIAL 65536
  555. NEXT 1048576
  556. MINEXTENTS 1
  557. MAXEXTENTS 2147483645
  558. BUFFER_POOL DEFAULT
  559. FLASH_CACHE DEFAULT
  560. )
  561. USABLE;
  562. -- ----------------------------
  563. -- Primary Key structure for table PJ_WORKFLOW_INFO
  564. -- ----------------------------
  565. ALTER TABLE "PJ_WORKFLOW_INFO" ADD CONSTRAINT "SYS_C0012221" PRIMARY KEY ("ID");
  566. -- ----------------------------
  567. -- Checks structure for table PJ_WORKFLOW_INFO
  568. -- ----------------------------
  569. ALTER TABLE "PJ_WORKFLOW_INFO" ADD CONSTRAINT "SYS_C0012220" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
  570. -- ----------------------------
  571. -- Indexes structure for table PJ_WORKFLOW_INFO
  572. -- ----------------------------
  573. CREATE INDEX "IDX01_WORKFLOW_INFO"
  574. ON "PJ_WORKFLOW_INFO" ("APP_ID" ASC, "NEXT_TRIGGER_TIME" ASC, "TIME_EXPRESSION_TYPE" ASC, "STATUS" ASC)
  575. LOGGING
  576. TABLESPACE "ROOT"
  577. VISIBLE
  578. PCTFREE 10
  579. INITRANS 2
  580. STORAGE (
  581. INITIAL 65536
  582. NEXT 1048576
  583. MINEXTENTS 1
  584. MAXEXTENTS 2147483645
  585. BUFFER_POOL DEFAULT
  586. FLASH_CACHE DEFAULT
  587. )
  588. USABLE;
  589. -- ----------------------------
  590. -- Primary Key structure for table PJ_WORKFLOW_INSTANCE_INFO
  591. -- ----------------------------
  592. ALTER TABLE "PJ_WORKFLOW_INSTANCE_INFO" ADD CONSTRAINT "SYS_C0012223" PRIMARY KEY ("ID");
  593. -- ----------------------------
  594. -- Uniques structure for table PJ_WORKFLOW_INSTANCE_INFO
  595. -- ----------------------------
  596. ALTER TABLE "PJ_WORKFLOW_INSTANCE_INFO" ADD CONSTRAINT "UIDX01_WF_INSTANCE" UNIQUE ("WF_INSTANCE_ID") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
  597. -- ----------------------------
  598. -- Checks structure for table PJ_WORKFLOW_INSTANCE_INFO
  599. -- ----------------------------
  600. ALTER TABLE "PJ_WORKFLOW_INSTANCE_INFO" ADD CONSTRAINT "SYS_C0012222" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
  601. -- ----------------------------
  602. -- Indexes structure for table PJ_WORKFLOW_INSTANCE_INFO
  603. -- ----------------------------
  604. CREATE INDEX "IDX01_WF_INSTANCE"
  605. ON "PJ_WORKFLOW_INSTANCE_INFO" ("WORKFLOW_ID" ASC, "EXPECTED_TRIGGER_TIME" ASC, "APP_ID" ASC, "STATUS" ASC)
  606. LOGGING
  607. TABLESPACE "ROOT"
  608. VISIBLE
  609. PCTFREE 10
  610. INITRANS 2
  611. STORAGE (
  612. INITIAL 65536
  613. NEXT 1048576
  614. MINEXTENTS 1
  615. MAXEXTENTS 2147483645
  616. BUFFER_POOL DEFAULT
  617. FLASH_CACHE DEFAULT
  618. )
  619. USABLE;
  620. -- ----------------------------
  621. -- Primary Key structure for table PJ_WORKFLOW_NODE_INFO
  622. -- ----------------------------
  623. ALTER TABLE "PJ_WORKFLOW_NODE_INFO" ADD CONSTRAINT "SYS_C0012230" PRIMARY KEY ("ID");
  624. -- ----------------------------
  625. -- Checks structure for table PJ_WORKFLOW_NODE_INFO
  626. -- ----------------------------
  627. ALTER TABLE "PJ_WORKFLOW_NODE_INFO" ADD CONSTRAINT "SYS_C0012224" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
  628. ALTER TABLE "PJ_WORKFLOW_NODE_INFO" ADD CONSTRAINT "SYS_C0012225" CHECK ("APP_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
  629. ALTER TABLE "PJ_WORKFLOW_NODE_INFO" ADD CONSTRAINT "SYS_C0012226" CHECK ("ENABLE" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
  630. ALTER TABLE "PJ_WORKFLOW_NODE_INFO" ADD CONSTRAINT "SYS_C0012227" CHECK ("GMT_CREATE" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
  631. ALTER TABLE "PJ_WORKFLOW_NODE_INFO" ADD CONSTRAINT "SYS_C0012228" CHECK ("GMT_MODIFIED" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
  632. ALTER TABLE "PJ_WORKFLOW_NODE_INFO" ADD CONSTRAINT "SYS_C0012229" CHECK ("SKIP_WHEN_FAILED" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
  633. -- ----------------------------
  634. -- Indexes structure for table PJ_WORKFLOW_NODE_INFO
  635. -- ----------------------------
  636. CREATE INDEX "IDX01_WORKFLOW_NODE_INFO"
  637. ON "PJ_WORKFLOW_NODE_INFO" ("GMT_CREATE" ASC, "WORKFLOW_ID" ASC)
  638. LOGGING
  639. TABLESPACE "ROOT"
  640. VISIBLE
  641. PCTFREE 10
  642. INITRANS 2
  643. STORAGE (
  644. INITIAL 65536
  645. NEXT 1048576
  646. MINEXTENTS 1
  647. MAXEXTENTS 2147483645
  648. BUFFER_POOL DEFAULT
  649. FLASH_CACHE DEFAULT
  650. )
  651. USABLE;