createdatacleaningtables.sql

来自「数据仓库工具」· SQL 代码 · 共 59 行

/* End of SQL file : \Develop\GRECOOMDSBROWSER\javadev\OMDSBrowserData\src\org\webdocwf\util\numerator\data\NumeratorSQL.sql*/

create table BOOKLINKS
(
    BOOKOID DECIMAL(19,0) NOT NULL ,
    BOOKLINENUMBER DECIMAL(10,0) NOT NULL   ,
    KEYVALUE VARCHAR(254) NOT NULL   ,
    XMLNAME VARCHAR(30) NOT NULL   ,
    BOOKLINKSOID DECIMAL(19,0)  ,
    URLSTRING01 VARCHAR(254)    ,
    URLSTRING02 VARCHAR(254)    ,
    URLSTRING03 VARCHAR(254)    ,
    URLSTRING04 VARCHAR(254)    ,
    URLSTRING05 VARCHAR(254)    ,
    URLSTRING06 VARCHAR(254)    ,
    URLSTRING07 VARCHAR(254)    ,
    URLSTRING08 VARCHAR(254)    ,
    URLSTRING09 VARCHAR(254)    ,
    URLSTRING10 VARCHAR(254)    ,
    oid DECIMAL(19,0) PRIMARY KEY ,
    version INTEGER NOT NULL
);

/* End of SQL file : \Develop\GRECOOMDSBROWSER\javadev\OMDSBrowserData\src\org\webdocwf\util\persistenttree\data\PersistentTreeSQL.sql*/

create table BOOKS
(
    BOOKNAME VARCHAR(100) NOT NULL   ,
    LANGUAGE VARCHAR(12) NOT NULL   ,
    KEYVALUE VARCHAR(254) NOT NULL   ,
    XMLNAME VARCHAR(30) NOT NULL   ,
    CHAPTER01DESC VARCHAR(2)    ,
    CHAPTER02DESC VARCHAR(254)    ,
    CHAPTER03DESC VARCHAR(254)    ,
    CHAPTER04DESC VARCHAR(254)    ,
    CHAPTER05DESC VARCHAR(254)    ,
    CHAPTER06DESC VARCHAR(254)    ,
    CHAPTER07DESC VARCHAR(254)    ,
    CHAPTER08DESC VARCHAR(254)    ,
    CHAPTER09DESC VARCHAR(254)    ,
    CHAPTER10DESC VARCHAR(254)    ,
    oid DECIMAL(19,0) PRIMARY KEY ,
    version INTEGER NOT NULL
);

/* End of SQL file : \Develop\GRECOOMDSBROWSER\javadev\OMDSBrowserData\src\org\webdocwf\util\persistenttree\data\PersistentTreeTypeSQL.sql*/


create table LOGTABLE
(     
     LOGIMPORTDEFINITIONNAME VARCHAR(254)    ,
     LOGOPERATIONNAME VARCHAR(254)    ,
     LOGTYPENAME VARCHAR(254)        ,     
     LOGTABLE VARCHAR(254)    ,
     LOGCOLUMNNAME VARCHAR(254)    ,
     LOGROWNUMBER VARCHAR(254)    ,
     LOGORIGINALVALUE VARCHAR(254)    ,
     LOGNEWVALUE VARCHAR(254)         
);