console_vopbill_items

唯品会账单明细

所属应用: console

表结构

ColumnName	Comment	Type	Not null	Default	Autoincrement
id	主键id	bigint(20) unsigned	Y		Y
bill_id	唯品会账单	int(10) unsigned	N		N
bill_amount_id	唯品会账单	bigint(20) unsigned	N		N
origin_id	唯品会明细ID	bigint(20) unsigned	N		N
barcode	itemNo	varchar(255)	N		N
product_name	itemDescription	varchar(255)	N		N
detail_line_type	行类型	varchar(255)	N		N
detail_line_name	行类型名称	varchar(255)	N		N
shop_id	店铺	varchar(32)	N		N
qty	quantity	decimal(20,3)	N		N
price	billTaxPrice	decimal(20,8)	N		N
datasign	数据标识	tinyint(2)	N		N
totalbillamount	billTaxPrice	decimal(20,8)	N		N
addon	源数据	longtext	N		N

索引

Key name	Column names	Unique	Comment
primary	id	Y
ind_origin_id	origin_id	Y
ind_bill_id	bill_id	N
ind_bill_amount_id	bill_amount_id	N
ind_barcode	barcode	N
ind_detail_line_type	detail_line_type	N
ind_detail_line_name	detail_line_name	N
idx_c_shop_id	shop_id	N