Skip to content

ome_order_batch

订单批次号计算

所属应用: ome

表结构

ColumnNameCommentTypeNot nullDefaultAutoincrement
source_shop_id来源店铺IDvarchar(32)YN
source_account前台会员名varchar(50)YN
ship_info_md5收货人地址+姓名—+手机号码的MD5varchar(32)YN
order_date当天日期varchar(8)NN
ship_running_noship_running_nomediumint(8) unsignedNN
incrementincrementtinyint(3) unsignedNN

索引

Key nameColumn namesUniqueComment
primarysource_shop_id, source_account, ship_info_md5Y