transformationcreatetables.sql

数据仓库工具

Create table PERSON
(
		ID VARCHAR(255) ,
    NAME VARCHAR(255) ,
    PERSONDATAOID DECIMAL(19,0) ,
    oid DECIMAL(19,0) PRIMARY KEY ,
    version INTEGER NOT NULL
);


Create table PERSONDATA
(
    CITY VARCHAR(255) ,
    TELEPHONE VARCHAR(255) ,
    STREETNAME VARCHAR(255) ,
    STREETNUM VARCHAR(255) ,
    PERSONID VARCHAR(255) ,
    oid DECIMAL(19,0) PRIMARY KEY ,
    version INTEGER NOT NULL
);