kettle6.0使用手册(4)

, FONT_BACK_GROUND_COLOR_RED INTEGER , FONT_BACK_GROUND_COLOR_GREEN INTEGER , FONT_BACK_GROUND_COLOR_BLUE INTEGER , FONT_BORDER_COLOR_RED INTEGER , FONT_BORDER_COLOR_GREEN INTEGER , FONT_BORDER_COLOR_BLUE INTEGER , DRAW_SHADOW CHAR(1) , PRIMARY KEY (ID_NOTE) ) ;

CREATE TABLE R_DATABASE (

ID_DATABASE INTEGER , NAME VARCHAR2(255) , ID_DATABASE_TYPE INTEGER , ID_DATABASE_CONTYPE INTEGER , HOST_NAME VARCHAR2(255) , DATABASE_NAME CLOB , PORT INTEGER

, USERNAME VARCHAR2(255) , PASSWORD VARCHAR2(255) , SERVERNAME VARCHAR2(255) , DATA_TBS VARCHAR2(255) , INDEX_TBS VARCHAR2(255) , PRIMARY KEY (ID_DATABASE) ) ;

CREATE TABLE R_DATABASE_ATTRIBUTE (

ID_DATABASE_ATTRIBUTE INTEGER , ID_DATABASE INTEGER , CODE VARCHAR2(255) , VALUE_STR CLOB

, PRIMARY KEY (ID_DATABASE_ATTRIBUTE) ) ;

CREATE UNIQUE INDEX IDX_RDAT ON R_DATABASE_ATTRIBUTE(ID_DATABASE, CODE) ;

CREATE TABLE R_DIRECTORY (

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