## 1.商品主表 ``` CREATE TABLE `ims_goods`(`goods_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,`cat_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '分類id',`goods_sn` varchar(60) NOT NULL DEFAULT '' COMMENT '商品貨號', `goods_name` varchar(120) NOT NULL DEFAULT '' COMMENT '商品名',`click_count` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '瀏覽量', `brand_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '品牌id', `suppliers_id` varchar(100) NOT NULL DEFAULT '' COMMENT '供應商id', `market_price` decimal(9,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '市場價格', `shop_price` decimal(9,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '本店售價', `promote_price` decimal(9,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '促銷價格', `promote_start_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '促銷開始日期', `promote_end_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '促銷結束日期', `keywords` varchar(255) NOT NULL DEFAULT '' COMMENT '商品關鍵字', `goods_brief` varchar(255) NOT NULL DEFAULT '' COMMENT '商品簡介', `goods_desc` text NOT NULL COMMENT '商品詳情', `goods_img` varchar(255) NOT NULL DEFAULT '' COMMENT '商品圖' , `is_putaway` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否上架', `putaway_time` timestamp NOT NULL COMMENT '上架時間', `create_time` timestamp NOT NULL COMMENT '添加時間', `sort_order` smallint(4) unsigned NOT NULL DEFAULT '100' COMMENT '排序', `is_delete` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否被刪除', `is_best` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '精品', `is_new` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '新品', `is_hot` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '熱銷', `is_promote` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '促銷', `goods_for` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '商品歸屬于哪個活動', `give_integral` int(11) NOT NULL DEFAULT '-1' COMMENT '贈送積分', `rank_integral` int(11) NOT NULL DEFAULT '-1' COMMENT '贈送等級經驗', `rest_count` mediumint(5) NOT NULL DEFAULT '0' COMMENT '庫存', `sell_count` mediumint(5) NOT NULL DEFAULT '0' COMMENT '銷量', PRIMARY KEY(`goods_id`), KEY`goods_sn`(`goods_sn`), KEY`cat_id`(`cat_id`), KEY`brand_id`(`brand_id`), KEY`promote_end_date`(`promote_end_date`), KEY`promote_start_date`(`promote_start_date`) )ENGINE=MyISAM DEFAULT CHARSET=utf8 ```