kettle6.0使用手册(5)

, 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)