商品goods简表sql语句

最新推荐文章于 2021-03-20 22:03:56 发布

原创最新推荐文章于 2021-03-20 22:03:56 发布 · 2.3k 阅读

0 ·

CC 4.0 BY-SA版权

Mysql 专栏收录该内容

5 篇文章

订阅专栏

这篇博客介绍了用于存储商品信息的数据库表`goods`的详细结构，包括商品ID、分类ID、商品条形码、名称、点击量、品牌、供应商、库存、重量、市场价格、店铺价格等关键字段，以及各种索引的设置。

部署运行你感兴趣的模型镜像

---------------------------------------------------------------------
goods | CREATE TABLE `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(10) 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(11) NOT NULL default '-1',
`rank_integral` int(11) 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`)
ENGINE=MyISAM AUTO_INCREMENT=33 DEFAULT CHARSET=utf8 |

您可能感兴趣的与本文相关的镜像