2 Normal / ID_BATCH Y ID_BATCH CHANNEL_ID Y CHANNEL_ID TRANSNAME Y TRANSNAME STATUS Y STATUS LINES_READ Y LINES_READ LINES_WRITTEN Y LINES_WRITTEN LINES_UPDATED Y LINES_UPDATED LINES_INPUT Y LINES_INPUT LINES_OUTPUT Y LINES_OUTPUT LINES_REJECTED Y LINES_REJECTED ERRORS Y ERRORS STARTDATE Y STARTDATE ENDDATE Y ENDDATE LOGDATE Y LOGDATE DEPDATE Y DEPDATE REPLAYDATE Y REPLAYDATE LOG_FIELD Y LOG_FIELD EXECUTING_SERVER N EXECUTING_SERVER EXECUTING_USER N EXECUTING_USER CLIENT N CLIENT
ID_BATCH Y ID_BATCH SEQ_NR Y SEQ_NR LOGDATE Y LOGDATE TRANSNAME Y TRANSNAME STEPNAME Y STEPNAME STEP_COPY Y STEP_COPY LINES_READ Y LINES_READ LINES_WRITTEN Y LINES_WRITTEN LINES_UPDATED Y LINES_UPDATED LINES_INPUT Y LINES_INPUT LINES_OUTPUT Y LINES_OUTPUT LINES_REJECTED Y LINES_REJECTED ERRORS Y ERRORS INPUT_BUFFER_ROWS Y INPUT_BUFFER_ROWS OUTPUT_BUFFER_ROWS Y OUTPUT_BUFFER_ROWS
ID_BATCH Y ID_BATCH CHANNEL_ID Y CHANNEL_ID LOG_DATE Y LOG_DATE LOGGING_OBJECT_TYPE Y LOGGING_OBJECT_TYPE OBJECT_NAME Y OBJECT_NAME OBJECT_COPY Y OBJECT_COPY REPOSITORY_DIRECTORY Y REPOSITORY_DIRECTORY FILENAME Y FILENAME OBJECT_ID Y OBJECT_ID OBJECT_REVISION Y OBJECT_REVISION PARENT_CHANNEL_ID Y PARENT_CHANNEL_ID ROOT_CHANNEL_ID Y ROOT_CHANNEL_ID
ID_BATCH Y ID_BATCH CHANNEL_ID Y CHANNEL_ID LOG_DATE Y LOG_DATE TRANSNAME Y TRANSNAME STEPNAME Y STEPNAME STEP_COPY Y STEP_COPY LINES_READ Y LINES_READ LINES_WRITTEN Y LINES_WRITTEN LINES_UPDATED Y LINES_UPDATED LINES_INPUT Y LINES_INPUT LINES_OUTPUT Y LINES_OUTPUT LINES_REJECTED Y LINES_REJECTED ERRORS Y ERRORS LOG_FIELD N LOG_FIELD
ID_BATCH Y ID_BATCH CHANNEL_ID Y CHANNEL_ID LOG_DATE Y LOG_DATE METRICS_DATE Y METRICS_DATE METRICS_CODE Y METRICS_CODE METRICS_DESCRIPTION Y METRICS_DESCRIPTION METRICS_SUBJECT Y METRICS_SUBJECT METRICS_TYPE Y METRICS_TYPE METRICS_VALUE Y METRICS_VALUE
0.0 0.0 10000 50 50 N Y 50000 Y N 1000 100 - 2020/09/23 15:19:08.644 - 2020/09/23 15:19:08.644 H4sIAAAAAAAAAAMAAAAAAAAAAAA= N 10.10.14.211 10.10.14.211 MARIADB Native base_db_dev 22066 root Encrypted 2faebc6ac0fc6bed5ff4efc2586c1f983 FORCE_IDENTIFIERS_TO_LOWERCASE N FORCE_IDENTIFIERS_TO_UPPERCASE N IS_CLUSTERED N PORT_NUMBER 22066 PRESERVE_RESERVED_WORD_CASE Y QUOTE_ALL_FIELDS N SUPPORTS_BOOLEAN_DATA_TYPE Y SUPPORTS_TIMESTAMP_DATA_TYPE Y USE_POOLING N 增量查询 插入 / 更新 Y 增量查询 TableInput Y 1 none 10.10.14.211 SELECT * FROM t_base_teacher where LAST_UPDATED_TIME>'${LAST_UPDATED_TIME}' 0 N Y N N String normal person_id 36 -1 增量查询 person_id . , none N Y 0 N N N zh_CN Asia/Shanghai N Integer normal identity_id 9 0 增量查询 identity_id ####0;-####0 . , none N Y 0 N N N zh_CN Asia/Shanghai N Integer normal id_int 9 0 增量查询 id_int ####0;-####0 . , none N Y 0 N N N zh_CN Asia/Shanghai N String normal xm 100 -1 增量查询 xm . , none N Y 0 N N N zh_CN Asia/Shanghai N String normal xmpy 100 -1 增量查询 xmpy . , none N Y 0 N N N zh_CN Asia/Shanghai N String normal cym 100 -1 增量查询 cym . , none N Y 0 N N N zh_CN Asia/Shanghai N String normal xbm 1 -1 增量查询 xbm . , none N Y 0 N N N zh_CN Asia/Shanghai N Date normal csrq -1 -1 增量查询 csrq . , none N Y 0 N N N zh_CN Asia/Shanghai N String normal mzm 2 -1 增量查询 mzm . , none N Y 0 N N N zh_CN Asia/Shanghai N String normal zzmmm 2 -1 增量查询 zzmmm . , none N Y 0 N N N zh_CN Asia/Shanghai N String normal sfzjlxm 1 -1 增量查询 sfzjlxm . , none N Y 0 N N N zh_CN Asia/Shanghai N String normal sfzjh 100 -1 增量查询 sfzjh . , none N Y 0 N N N zh_CN Asia/Shanghai N String normal xlm 2 -1 增量查询 xlm . , none N Y 0 N N N zh_CN Asia/Shanghai N String normal xwm 1 -1 增量查询 xwm . , none N Y 0 N N N zh_CN Asia/Shanghai N String normal zcm 1 -1 增量查询 zcm . , none N Y 0 N N N zh_CN Asia/Shanghai N String normal bzlbm 1 -1 增量查询 bzlbm . , none N Y 0 N N N zh_CN Asia/Shanghai N Date normal cjny -1 -1 增量查询 cjny . , none N Y 0 N N N zh_CN Asia/Shanghai N String normal stage_id 1 -1 增量查询 stage_id . , none N Y 0 N N N zh_CN Asia/Shanghai N String normal subject_id 2 -1 增量查询 subject_id . , none N Y 0 N N N zh_CN Asia/Shanghai N String normal gwzym 2 -1 增量查询 gwzym . , none N Y 0 N N N zh_CN Asia/Shanghai N String normal lxdh 100 -1 增量查询 lxdh . , none N Y 0 N N N zh_CN Asia/Shanghai N String normal dzxx 100 -1 增量查询 dzxx . , none N Y 0 N N N zh_CN Asia/Shanghai N Boolean normal b_use -1 -1 增量查询 b_use . , none N Y 0 N N N zh_CN Asia/Shanghai N Integer normal state_id 9 0 增量查询 state_id ####0;-####0 . , none N Y 0 N N N zh_CN Asia/Shanghai N Date normal last_updated_time 0 -1 增量查询 last_updated_time . , none N Y 0 N N N zh_CN Asia/Shanghai N Date normal create_time 0 -1 增量查询 create_time . , none N Y 0 N N N zh_CN Asia/Shanghai N 204 153 Y 插入 / 更新 InsertUpdate Y 1 none 10.10.14.211 100 N
lookup
person_id person_id = person_id person_id Y identity_id identity_id Y id_int id_int Y xm xm Y xmpy xmpy Y cym cym Y xbm xbm Y csrq csrq Y mzm mzm Y zzmmm zzmmm Y sfzjlxm sfzjlxm Y sfzjh sfzjh Y xlm xlm Y xwm xwm Y zcm zcm Y bzlbm bzlbm Y cjny cjny Y stage_id stage_id Y subject_id subject_id Y gwzym gwzym Y lxdh lxdh Y dzxx dzxx Y b_use b_use Y state_id state_id Y last_updated_time last_updated_time Y create_time create_time Y 380 153 Y N