oracle版本ESB初始化sql及表结构说明

drop table SSM_AUDIT_JSON_DETAIL cascade constraints;
drop table SSM_AUDIT_JSON cascade constraints;
drop table SSM_SERVICE_STATISTICS cascade constraints;
drop table SSM_SERVICE_EXCEPTION cascade constraints;
drop table SSM_SERVICE_TOP cascade constraints;
DROP TABLE SSM_SERVICE_ALL cascade constraints;
DROP TABLE SSM_SERVICE_MSG cascade constraints;
/==============================================================/
/* Table: SSM_AUDIT_JSON_DETAIL                                 */
/==============================================================/
CREATE TABLE SSM_AUDIT_JSON_DETAIL  (
   AUDIT_JSON_ID  VARCHAR2(64) NOT NULL,
   MESSAGE_ID     VARCHAR2(128) NOT NULL,
   IN_OUT         CHAR(1) NOT NULL
)
/
/==============================================================/
/* Table: SSM_AUDIT_JSON                                        */
/==============================================================/
CREATE TABLE    SSM_AUDIT_JSON    (
 AUDIT_JSON_ID      VARCHAR2(64) NOT NULL,
 CLIENT_ID          VARCHAR2(128) NOT NULL,
 OPERATION_CODE     VARCHAR2(128) NOT NULL,
 TIME               TIMESTAMP(6) NOT NULL,
 SAMPLE_RATE        NUMBER(15,5) NOT NULL,
 TOTAL              NUMBER(15,5),
 TOTAL_COUNT        NUMBER(15,5),
 MAX_SAMPLE         NUMBER(15,5),
 INPUT_VALID_COUNT  NUMBER(15,5),
 OUTPUT_VALID_COUNT NUMBER(15,5),
        constraint PK_SSM_AUDIT_JSON primary key (AUDIT_JSON_ID)
)
/
COMMENT ON COLUMN SSM_AUDIT_JSON.CLIENT_ID IS '客户端标识';
COMMENT ON COLUMN SSM_AUDIT_JSON.OPERATION_CODE IS '目标操作编码';
COMMENT ON COLUMN SSM_AUDIT_JSON.TIME IS '时间';
COMMENT ON COLUMN SSM_AUDIT_JSON.SAMPLE_RATE IS '采样率';
COMMENT ON COLUMN SSM_AUDIT_JSON.TOTAL IS '总数';
COMMENT ON COLUMN SSM_AUDIT_JSON.TOTAL_COUNT IS '样本数';
COMMENT ON COLUMN SSM_AUDIT_JSON.MAX_SAMPLE IS '最大样本数';
COMMENT ON COLUMN SSM_AUDIT_JSON.INPUT_VALID_COUNT IS '合法样本数';
/==============================================================/
/* Table: SSM_SERVICE_STATISTICS                                */
/==============================================================/
create table SSM_SERVICE_STATISTICS  (
   SRC_APP_CODE         VARCHAR2(128),
   SRC_IP               VARCHAR2(20),
   DEST_OPERATION_CODE  VARCHAR2(128),
   ESB_ID               VARCHAR2(128),
   STATISTICS_TIME      TIMESTAMP,
   TARGET_URL           VARCHAR2(256),
   TOTAL_DURATION         NUMBER(10) default 0,
   SUCCESS_NUM           NUMBER(10) default 0,
   SYSTEM_EXCEPTION_NUM     NUMBER(10) default 0,
   BUSI_EXCEPTION_NUM       NUMBER(10) default 0,
   TIMEOUT_NUM          NUMBER(10),
   ILLEGAL_USE_NUM          NUMBER(10) default 0,
   ILLEGAL_IP_NUM          NUMBER(10) default 0,
   TOTAL_REQ_SIZE         NUMBER(10) default 0,
   TOTAL_RESP_SIZE        NUMBER(10) default 0
)
/
/==============================================================/
/* Table: SSM_SERVICE_EXCEPTION                                 */
/==============================================================/
create table SSM_SERVICE_EXCEPTION  (
   REQUEST_ID           VARCHAR2(128)                   not null,
   DEST_OPERATION_CODE  VARCHAR2(128),
   ESB_ID               VARCHAR2(128),
   SRC_APP_CODE         VARCHAR2(128),
   SRC_IP               VARCHAR2(20),
   STATISTICS_TIME      TIMESTAMP,
   TARGET_URL           VARCHAR2(256),  
   IN_DATA              CLOB,
   OUT_DATA             CLOB,
   STATUS               CHAR,
   constraint PK_SSM_SERVICE_EXCEPTION primary key (REQUEST_ID)
)
/
/==============================================================/
/* Table: SSM_SERVICE_TOP                                       */
/==============================================================/
create table SSM_SERVICE_TOP  (
   REQUEST_ID           VARCHAR2(128)                   not null,
   DEST_OPERATION_CODE  VARCHAR2(128),
   ESB_ID               VARCHAR2(128),
   SRC_APP_CODE         VARCHAR2(128),
   SRC_IP               VARCHAR2(20),
   STATISTICS_TIME      TIMESTAMP,
   TARGET_URL           VARCHAR2(256),
   LOG_TIME1            TIMESTAMP,
   LOG_TIME2            TIMESTAMP,
   LOG_TIME3            TIMESTAMP,
   LOG_TIME4            TIMESTAMP,
   DURATION             NUMBER(10),
   IN_DATA              CLOB,
   OUT_DATA             CLOB,
   constraint PK_SSM_SERVICE_TOP primary key (REQUEST_ID)
)
/
create table SSM_SERVICE_ALL  (
   REQUEST_ID           VARCHAR2(128)                   not null,
   DEST_OPERATION_CODE  VARCHAR2(128),
   ESB_ID               VARCHAR2(128),
   SRC_APP_CODE         VARCHAR2(128),
   SRC_IP               VARCHAR2(20),
   STATISTICS_TIME      TIMESTAMP,
   TARGET_URL           VARCHAR2(256),
   LOG_TIME1            TIMESTAMP,
   LOG_TIME2            TIMESTAMP,
   LOG_TIME3            TIMESTAMP,
   LOG_TIME4            TIMESTAMP,
   DURATION             NUMBER(10),
   IN_DATA              CLOB,
   OUT_DATA             CLOB,
   IN_DATA_SIZE       NUMBER(10) default 0,
   OUT_DATA_SIZE      NUMBER(10) default 0,
   STATUS               CHAR,
   constraint PK_SSM_SERVICE_ALL primary key (REQUEST_ID)
);
CREATE TABLE SSM_SERVICE_MSG (
 REQUEST_ID VARCHAR2(100),
 MSGID VARCHAR2(100)
);
commit;