• Home
• ru.taskurotta
• services-ora
• 0.8.0
• source code
• create_process.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

sql.create_process.sql Maven / Gradle / Ivy

CREATE TABLE process (
  process_id    VARCHAR2(36)        NOT NULL,
  start_task_id VARCHAR2(36)        NOT NULL,
  custom_id     VARCHAR2(256)       NULL,
  start_time    NUMBER              NOT NULL,
  end_time      NUMBER              NULL,
  state         NUMBER              NOT NULL,
  return_value  CLOB                NULL,
  START_JSON    CLOB                NULL,
  actor_id       VARCHAR2(500 char),
  PRIMARY KEY (process_id)
)
NOCOMPRESS
;

exit;

alter table process add actor_id VARCHAR2(500 char);