dealer_series

产品线

所属应用: dealer

表结构

ColumnName	Comment	Type	Not null	Default	Autoincrement
series_id	产品线ID	int(10) unsigned	Y		Y
series_code	产品线编码	varchar(30)	N		N
series_name	产品线名称	varchar(50)	N		N
description	产品线描述	text	N		N
cat_name	产品线分类	varchar(50)	N		N
status	状态 active:启用;close:停用;	enum('active','close')	N	active	N
sku_nums	产品数	int(10) unsigned	N	0	N
betc_id	所属贸易公司	int(10) unsigned	N		N
cos_id	组织架构ID	int(10) unsigned	N		N
remark	备注	text	N		N
op_name	创建人	varchar(32)	N		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	series_id	Y
ind_series_code	series_code	N
ind_series_name	series_name	N
ind_status	status	N
ind_betc_id	betc_id	N
ind_cos_id	cos_id	N
ind_at_time	at_time	N
ind_up_time	up_time	N
idx_c_betc_id	betc_id	N