CREATE TABLE mkt_rm_rule_conditions (
    RULE_CONDITION_ID           NUMBER(18, 0),
    RULE_HEADER_ID              NUMBER(18, 0)    NOT NULL,
    PARENT_RULE_CONDITION_ID    NUMBER(18, 0),
    SEQUENCE_NUMBER             NUMBER(18, 0),
    PREV_RULE_CONDITION_ID      NUMBER(18, 0),
    AGGREGATE_CONDITION_FLAG    VARCHAR2(4)  ,
    AGGREGATE_OPERATOR          VARCHAR2(120),
    LHS_FACT_TYPE               VARCHAR2(120),
    LHS_ATTRIBUTE               VARCHAR2(120),
    OPERATOR                    VARCHAR2(120),
    CONNECTOR                   VARCHAR2(120),
    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,
    OBJECT_VERSION_NUMBER       NUMBER(9, 0)     NOT NULL,
    LAST_UPDATE_LOGIN           VARCHAR2(128),
    RULE_CONDITION_ID           NUMBER(18, 0),
    RULE_HEADER_ID              NUMBER(18, 0)    NOT NULL,
    PARENT_RULE_CONDITION_ID    NUMBER(18, 0),
    SEQUENCE_NUMBER             NUMBER(18, 0),
    PREV_RULE_CONDITION_ID      NUMBER(18, 0),
    AGGREGATE_CONDITION_FLAG    VARCHAR2(4)  ,
    AGGREGATE_OPERATOR          VARCHAR2(120),
    LHS_FACT_TYPE               VARCHAR2(120),
    LHS_ATTRIBUTE               VARCHAR2(120),
    OPERATOR                    VARCHAR2(120),
    CONNECTOR                   VARCHAR2(120),
    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,
    OBJECT_VERSION_NUMBER       NUMBER(9, 0)     NOT NULL,
    LAST_UPDATE_LOGIN           VARCHAR2(128),
    CONSTRAINT pk_mkt_rm_rule_conditions PRIMARY KEY (RULE_CONDITION_ID, RULE_CONDITION_ID)
);
