CREATE TABLE doo_service_definitions_tl (
    SERVICE_ID                      NUMBER(18, 0) ,
    OBJECT_VERSION_NUMBER           NUMBER(9, 0)      NOT NULL,
    SERVICE_NAME                    VARCHAR2(320)     NOT NULL,
    DESCRIPTION                     VARCHAR2(2048),
    SOURCE_LANG                     VARCHAR2(16)      NOT NULL,
    LANGUAGE                        VARCHAR2(16)  ,
    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) ,
    ORCHESTRATION_APPLICATION_ID    NUMBER(18, 0) ,
    SEED_DATA_SOURCE                VARCHAR2(2048),
    ORA_SEED_SET1                   VARCHAR2(4)       NOT NULL,
    ORA_SEED_SET2                   VARCHAR2(4)       NOT NULL,
    SERVICE_ID                      NUMBER(18, 0) ,
    OBJECT_VERSION_NUMBER           NUMBER(9, 0)      NOT NULL,
    SERVICE_NAME                    VARCHAR2(320)     NOT NULL,
    DESCRIPTION                     VARCHAR2(2048),
    SOURCE_LANG                     VARCHAR2(16)      NOT NULL,
    LANGUAGE                        VARCHAR2(16)  ,
    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) ,
    ORCHESTRATION_APPLICATION_ID    NUMBER(18, 0) ,
    SEED_DATA_SOURCE                VARCHAR2(2048),
    ORA_SEED_SET1                   VARCHAR2(4)       NOT NULL,
    ORA_SEED_SET2                   VARCHAR2(4)       NOT NULL,
    CONSTRAINT pk_doo_service_definitions_tl PRIMARY KEY (SERVICE_ID, LANGUAGE, ORCHESTRATION_APPLICATION_ID, SERVICE_ID, LANGUAGE, ORCHESTRATION_APPLICATION_ID)
);
