发布时间 : 星期四 文章kettle6.0使用手册更新完毕开始阅读e4a53f44a9956bec0975f46527d3240c8447a132
ID_DIRECTORY INTEGER
, ID_DIRECTORY_PARENT INTEGER , DIRECTORY_NAME VARCHAR2(255) , PRIMARY KEY (ID_DIRECTORY) ) ;
CREATE UNIQUE INDEX IDX_RDIR ON R_DIRECTORY(ID_DIRECTORY_PARENT, DIRECTORY_NAME) ;
CREATE TABLE R_TRANSFORMATION (
ID_TRANSFORMATION INTEGER , ID_DIRECTORY INTEGER , NAME VARCHAR2(255) , DESCRIPTION CLOB
, EXTENDED_DESCRIPTION CLOB , TRANS_VERSION VARCHAR2(255) , TRANS_STATUS INTEGER , ID_STEP_READ INTEGER , ID_STEP_WRITE INTEGER , ID_STEP_INPUT INTEGER , ID_STEP_OUTPUT INTEGER , ID_STEP_UPDATE INTEGER , ID_DATABASE_LOG INTEGER , TABLE_NAME_LOG VARCHAR2(255) , USE_BATCHID CHAR(1) , USE_LOGFIELD CHAR(1)
, ID_DATABASE_MAXDATE INTEGER , TABLE_NAME_MAXDATE VARCHAR2(255) , FIELD_NAME_MAXDATE VARCHAR2(255) , OFFSET_MAXDATE NUMBER(12, 2) , DIFF_MAXDATE NUMBER(12, 2) , CREATED_USER VARCHAR2(255) , CREATED_DATE DATE
, MODIFIED_USER VARCHAR2(255) , MODIFIED_DATE DATE , SIZE_ROWSET INTEGER
, PRIMARY KEY (ID_TRANSFORMATION) ) ;
CREATE TABLE R_TRANS_ATTRIBUTE
(
ID_TRANS_ATTRIBUTE INTEGER , ID_TRANSFORMATION INTEGER , NR INTEGER
, CODE VARCHAR2(255) , VALUE_NUM INTEGER , VALUE_STR CLOB
, PRIMARY KEY (ID_TRANS_ATTRIBUTE) ) ;
CREATE UNIQUE INDEX IDX_TATT ON R_TRANS_ATTRIBUTE(ID_TRANSFORMATION, CODE, NR) ;
CREATE TABLE R_JOB_ATTRIBUTE (
ID_JOB_ATTRIBUTE INTEGER , ID_JOB INTEGER , NR INTEGER
, CODE VARCHAR2(255) , VALUE_NUM INTEGER , VALUE_STR CLOB
, PRIMARY KEY (ID_JOB_ATTRIBUTE) ) ;
CREATE UNIQUE INDEX IDX_JATT ON R_JOB_ATTRIBUTE(ID_JOB, CODE, NR) ;
CREATE TABLE R_DEPENDENCY (
ID_DEPENDENCY INTEGER , ID_TRANSFORMATION INTEGER , ID_DATABASE INTEGER , TABLE_NAME VARCHAR2(255) , FIELD_NAME VARCHAR2(255) , PRIMARY KEY (ID_DEPENDENCY) ) ;
CREATE TABLE R_PARTITION_SCHEMA (
ID_PARTITION_SCHEMA INTEGER , NAME VARCHAR2(255)
, DYNAMIC_DEFINITION CHAR(1)
, PARTITIONS_PER_SLAVE VARCHAR2(255) , PRIMARY KEY (ID_PARTITION_SCHEMA) ) ;
CREATE TABLE R_PARTITION (
ID_PARTITION INTEGER
, ID_PARTITION_SCHEMA INTEGER , PARTITION_ID VARCHAR2(255) , PRIMARY KEY (ID_PARTITION) ) ;
CREATE TABLE R_TRANS_PARTITION_SCHEMA (
ID_TRANS_PARTITION_SCHEMA INTEGER , ID_TRANSFORMATION INTEGER , ID_PARTITION_SCHEMA INTEGER
, PRIMARY KEY (ID_TRANS_PARTITION_SCHEMA) ) ;
CREATE TABLE R_CLUSTER (
ID_CLUSTER INTEGER , NAME VARCHAR2(255) , BASE_PORT VARCHAR2(255)
, SOCKETS_BUFFER_SIZE VARCHAR2(255) , SOCKETS_FLUSH_INTERVAL VARCHAR2(255) , SOCKETS_COMPRESSED CHAR(1) , DYNAMIC_CLUSTER CHAR(1) , PRIMARY KEY (ID_CLUSTER) ) ;
CREATE TABLE R_SLAVE (
ID_SLAVE INTEGER , NAME VARCHAR2(255) , HOST_NAME VARCHAR2(255) , PORT VARCHAR2(255)
, WEB_APP_NAME VARCHAR2(255)
, USERNAME VARCHAR2(255) , PASSWORD VARCHAR2(255)
, PROXY_HOST_NAME VARCHAR2(255) , PROXY_PORT VARCHAR2(255) , NON_PROXY_HOSTS VARCHAR2(255) , MASTER CHAR(1)
, PRIMARY KEY (ID_SLAVE) ) ;
CREATE TABLE R_CLUSTER_SLAVE (
ID_CLUSTER_SLAVE INTEGER , ID_CLUSTER INTEGER , ID_SLAVE INTEGER
, PRIMARY KEY (ID_CLUSTER_SLAVE) ) ;
CREATE TABLE R_TRANS_SLAVE (
ID_TRANS_SLAVE INTEGER , ID_TRANSFORMATION INTEGER , ID_SLAVE INTEGER
, PRIMARY KEY (ID_TRANS_SLAVE) ) ;
CREATE TABLE R_TRANS_CLUSTER (
ID_TRANS_CLUSTER INTEGER , ID_TRANSFORMATION INTEGER , ID_CLUSTER INTEGER
, PRIMARY KEY (ID_TRANS_CLUSTER) ) ;
CREATE TABLE R_TRANS_HOP (
ID_TRANS_HOP INTEGER , ID_TRANSFORMATION INTEGER , ID_STEP_FROM INTEGER , ID_STEP_TO INTEGER , ENABLED CHAR(1)