CREATE TABLE doo_order_states (
    DOO_SEQ                    NUMBER(18, 0),
    OBJECT_VERSION_NUMBER      NUMBER(9, 0)     NOT NULL,
    HEADER_ID                  NUMBER(18, 0),
    GROUP_ID                   NUMBER(18, 0),
    VERSION                    NUMBER(9, 0)     NOT NULL,
    PROCESS_NAME               VARCHAR2(800)    NOT NULL,
    DOO_PROCESS_INSTANCE_ID    NUMBER(18, 0)    NOT NULL,
    STEP_INSTANCE_ID           NUMBER(18, 0),
    STATE_INFO                 BLOB             NOT NULL,
    CREATED_BY                 VARCHAR2(256)    NOT NULL,
    CREATION_DATE              TIMESTAMP(6)     NOT NULL,
    LAST_UPDATED_BY            VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_DATE           TIMESTAMP(6)     NOT NULL,
    LAST_UPDATE_LOGIN          VARCHAR2(128),
    DOO_SEQ                    NUMBER(18, 0),
    OBJECT_VERSION_NUMBER      NUMBER(9, 0)     NOT NULL,
    HEADER_ID                  NUMBER(18, 0),
    GROUP_ID                   NUMBER(18, 0),
    VERSION                    NUMBER(9, 0)     NOT NULL,
    PROCESS_NAME               VARCHAR2(800)    NOT NULL,
    DOO_PROCESS_INSTANCE_ID    NUMBER(18, 0)    NOT NULL,
    STEP_INSTANCE_ID           NUMBER(18, 0),
    STATE_INFO                 BLOB             NOT NULL,
    CREATED_BY                 VARCHAR2(256)    NOT NULL,
    CREATION_DATE              TIMESTAMP(6)     NOT NULL,
    LAST_UPDATED_BY            VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_DATE           TIMESTAMP(6)     NOT NULL,
    LAST_UPDATE_LOGIN          VARCHAR2(128),
    CONSTRAINT pk_doo_order_states PRIMARY KEY (DOO_SEQ, DOO_SEQ)
);
