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