ecs的商品主表

admin · 发表于 2016-4-22 13:21:53

CREATE TABLE `ecs_goods` (
`goods_id` mediumint(8) unsigned NOT NULL auto_increment,
`cat_id` smallint(5) unsigned NOT NULL default '0',
`goods_sn` varchar(60) NOT NULL default '',
`goods_name` varchar(120) NOT NULL default '',
`goods_name_style` varchar(60) NOT NULL default '+',
`click_count` int(10) unsigned NOT NULL default '0',
`brand_id` smallint(5) unsigned NOT NULL default '0',
`provider_name` varchar(100) NOT NULL default '',
`goods_number` smallint(5) unsigned NOT NULL default '0',
`goods_weight` decimal(10,3) unsigned NOT NULL default '0.000',
`market_price` decimal(10,2) unsigned NOT NULL default '0.00',
`shop_price` decimal(10,2) unsigned NOT NULL default '0.00',
`promote_price` decimal(10,2) unsigned NOT NULL default '0.00',
`promote_start_date` int(11) unsigned NOT NULL default '0',
`promote_end_date` int(11) unsigned NOT NULL default '0',
`warn_number` tinyint(3) unsigned NOT NULL default '1',
`keywords` varchar(255) NOT NULL default '',
`goods_brief` varchar(255) NOT NULL default '',
`goods_desc` text NOT NULL,
`goods_thumb` varchar(255) NOT NULL default '',
`goods_img` varchar(255) NOT NULL default '',
`original_img` varchar(255) NOT NULL default '',
`is_real` tinyint(3) unsigned NOT NULL default '1',
`extension_code` varchar(30) NOT NULL default '',
`is_on_sale` tinyint(1) unsigned NOT NULL default '1',
`is_alone_sale` tinyint(1) unsigned NOT NULL default '1',
`is_shipping` tinyint(1) unsigned NOT NULL default '0',
`integral` int unsigned NOT NULL default '0',
`add_time` int(10) unsigned NOT NULL default '0',
`sort_order` smallint(4) unsigned NOT NULL default '100',
`is_delete` tinyint(1) unsigned NOT NULL default '0',
`is_best` tinyint(1) unsigned NOT NULL default '0',
`is_new` tinyint(1) unsigned NOT NULL default '0',
`is_hot` tinyint(1) unsigned NOT NULL default '0',
`is_promote` tinyint(1) unsigned NOT NULL default '0',
`bonus_type_id` tinyint(3) unsigned NOT NULL default '0',
`last_update` int(10) unsigned NOT NULL default '0',
`goods_type` smallint(5) unsigned NOT NULL default '0',
`seller_note` varchar(255) NOT NULL default '',
`give_integral` int NOT NULL default '-1',
`rank_integral` int NOT NULL default '-1',
`suppliers_id` smallint(5) unsigned default NULL,
`is_check` tinyint(1) unsigned default NULL,
PRIMARY KEY (`goods_id`),
KEY `goods_sn` (`goods_sn`),
KEY `cat_id` (`cat_id`),
KEY `last_update` (`last_update`),
KEY `brand_id` (`brand_id`),
KEY `goods_weight` (`goods_weight`),
KEY `promote_end_date` (`promote_end_date`),
KEY `promote_start_date` (`promote_start_date`),
KEY `goods_number` (`goods_number`),
KEY `sort_order` (`sort_order`)
)

复制代码

疯子 · 发表于 2016-5-5 00:24:17

ecs是指ecshop吗？？？

wwwzv · 发表于 2016-5-30 02:44:02

不错支持下

		自动登录	找回密码
密码			立即注册