ome_batch_log

批量日志

所属应用: ome

表结构

ColumnName	Comment	Type	Not null	Default	Autoincrement
log_id	log_id	int(10)	Y		Y
createtime	发起同步时间	int(10) unsigned	N		N
op_id	op_id	mediumint(8) unsigned	Y		N
op_name	op_name	varchar(30)	N		N
batch_number	批量发货总数	mediumint(8) unsigned	Y	0	N
fail_number	批量发货失败总数	mediumint(8) unsigned	Y	0	N
succ_number	批量成功总数	mediumint(8) unsigned	N	0	N
status	状态 0:等待中;1:已处理;2:处理中;	enum('0','1','2')	N	0	N
log_type	日志类型 consign:发货;check:校验;combine:系统自动审单;ordertaking:手动获取订单;confirm_reship:退换货单;confirm_inventory:盘点确认;pre_select_branch:提前选仓;	enum('consign','check','combine','ordertaking','confirm_reship','confirm_inventory','pre_select_branch')	N	consign	N
log_text	参数	longtext	N		N
source	来源：direct->默认，task->定时任务, combineagain->再次合单, split->拆单	varchar(16)	N	direct	N
up_time	更新时间	TIMESTAMP	N	CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP	N

索引

Key name	Column names	Unique	Comment
primary	log_id	Y
idx_log_type	log_type	N
idx_status	status	N
idx_c_op_id	op_id	N