发布日期:2025-05-30 06:50:08

 

change的其他属性修改后的值存放

CREATE TABLE REDLINE_ATTRIBUTE (
   CLASS                    NUMBER NOT NULL,
   SUBCLASS 				NUMBER NOT NULL,
   OBJECT_ID                NUMBER NOT NULL,
   CHANGE_ID                NUMBER NOT NULL,
   ATTID                    NUMBER NOT NULL,
   CHANGE_RELEASE_DATE      DATE,
   OLD_NUMBER1              NUMBER,
   OLD_NUMBER2              NUMBER,
   OLD_TEXT                 VARCHAR2(4000),
   OLD_DATE                 DATE,
   NEW_NUMBER1              NUMBER,
   NEW_NUMBER2              NUMBER,
   NEW_TEXT                 VARCHAR2(4000),
   NEW_DATE                 DATE,
   USER_ID NUMBER(30),
   CREATED DATE DEFAULT SYSDATE NOT NULL,
   LAST_UPD DATE DEFAULT SYSDATE NOT NULL,

 )

 

CREATE TABLE REDLINE_MSATTRIBUTE (
   CLASS                    NUMBER NOT NULL,
   SUBCLASS                 NUMBER NOT NULL,
   OBJECT_ID                NUMBER NOT NULL,
   CHANGE_ID                NUMBER NOT NULL,
   ATTID                    NUMBER NOT NULL,
   CHANGE_RELEASE_DATE      DATE,
   OLD_VALUE                CHAR(1) NOT NULL,
   VALUE                    NUMBER NOT NULL,
   USER_ID NUMBER(30),
   CREATED DATE DEFAULT SYSDATE NOT NULL,
   LAST_UPD DATE DEFAULT SYSDATE NOT NULL
)

 

发表评论