NC二開日志表設(shè)計-用于記錄二開的錯誤與記錄保存（非最終版）

整體和NC開發(fā)中間表一樣确买。這個只是日志表的設(shè)計與創(chuàng)建

********數(shù)據(jù)庫表設(shè)計**********

--創(chuàng)建人：chensy
--創(chuàng)建時間：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 '內(nèi)容';
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 '單據(jù)號';
comment on column SYS_PR_LOG.log_dockingsystem is '對接系統(tǒng)';
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 '發(fā)送數(shù)據(jù)';
comment on column SYS_PR_LOG.log_receivedata is '接收數(shù)據(jù)';
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 '自定義';

?著作權(quán)歸作者所有,轉(zhuǎn)載或內(nèi)容合作請聯(lián)系作者