dealer_series_endorse

产品线授权到店

所属应用: dealer

表结构

ColumnName	Comment	Type	Not null	Default	Autoincrement
en_id	产品线授权到店ID	int(10) unsigned	Y		Y
series_id	产品线ID	int(10) unsigned	N		N
bs_id	一个经销店铺只能选一个经销商	int(10) unsigned	N		N
shop_id	店铺ID	varchar(32)	N		N
sku_nums	产品数	int(10) unsigned	N	0	N
at_time	创建时间	TIMESTAMP	N	CURRENT_TIMESTAMP	N
up_time	更新时间	TIMESTAMP	N	CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP	N

索引

Key name	Column names	Unique	Comment
primary	en_id	Y
ind_series_id	series_id	N
ind_shop_id	shop_id	N
ind_bs_id	bs_id	N
ind_at_time	at_time	N
ind_up_time	up_time	N