整体和NC开发中间表一样。 这个只是日志表的设计与创建

********数据库表设计**********

--创建人：chensy
--创建时间：2020.8
--作用：二开日志表
--***********************************************
-- Create table
create table SYS_PR_LOG
(
log_level VARCHAR2(30),
log_issolve VARCHAR2(128),
log_classname VARCHAR2(128),
log_content VARCHAR2(128),
log_type VARCHAR2(30),
log_ address VARCHAR2(128),
log_applicationname VARCHAR2(128),
isVbillcode VARCHAR2(128),
log_dockingsystem VARCHAR2(32),
log_senddata VARCHAR2(128),
log_receivedata VARCHAR2(128),
log_Typedocument VARCHAR2(128),
ts CHAR(19) default to_char(sysdate,'yyyy-mm-dd hh24:mi:ss'),
dr NUMBER(10) default 0,
vdef1 VARCHAR2(128),
vdef2 VARCHAR2(128),
vdef3 VARCHAR2(128),
vdef4 VARCHAR2(128),
vdef5 VARCHAR2(128),
vdef6 VARCHAR2(128),
vdef7 VARCHAR2(128),
vdef8 VARCHAR2(128),
vdef9 VARCHAR2(128),
vdef10 VARCHAR2(128),
log_msg CLOB
);

-- Add comments to the columns
comment on column SYS_PR_LOG. log_level is '日志级别';
comment on column SYS_PR_LOG.log_msg is '错误信息';
comment on column SYS_PR_LOG.ts is '时间戳';
comment on column SYS_PR_LOG.log_issolve is '是否解决';
comment on column SYS_PR_LOG.log_classname is '类名';
comment on column SYS_PR_LOG.log_content is '内容';
comment on column SYS_PR_LOG.log_ address is '服务器名称';
comment on column SYS_PR_LOG.log_applicationname is '应用名称';
comment on column SYS_PR_LOG.isVbillcode is '单据号';
comment on column SYS_PR_LOG.log_dockingsystem is '对接系统';
comment on column SYS_PR_LOG.log_type is '类型';
comment on column SYS_PR_LOG.dr is '删除标识';
comment on column SYS_PR_LOG.log_senddata is '发送数据';
comment on column SYS_PR_LOG.log_receivedata is '接收数据';
comment on column SYS_PR_LOG.vdef1 is '自定义';
comment on column SYS_PR_LOG.vdef2 is '自定义';
comment on column SYS_PR_LOG.vdef3 is '自定义';
comment on column SYS_PR_LOG.vdef4 is '自定义';
comment on column SYS_PR_LOG.vdef5 is '自定义';
comment on column SYS_PR_LOG.vdef6 is '自定义';
comment on column SYS_PR_LOG.vdef7 is '自定义';
comment on column SYS_PR_LOG.vdef8 is '自定义';
comment on column SYS_PR_LOG.vdef9 is '自定义';
comment on column SYS_PR_LOG.vdef10 is '自定义';