+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_goods:/tablelist/okayapi_goods.html


-- MySQL Table okayapi_goods
-- From: OkayAPI.com
CREATE TABLE `okayapi_goods` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `goods_name` varchar(1024) NULL COMMENT '商品名称',
    `goods_desc` varchar(2024) NULL COMMENT '商品描述',
    `goods_price` int(10) NULL DEFAULT '9999999' COMMENT '商品价格,单位为:分',
    `goods_maket_price` int(10) NULL DEFAULT '9999999' COMMENT '商品市场价,即原价,单位为:分',
    `goods_stock` int(10) NULL DEFAULT '0' COMMENT '商品库存',
    `goods_img` varchar(255) NULL COMMENT '商品图片链接',
    `goods_sell_time` datetime NULL COMMENT '商品上架时间,开始售卖时间',
    `goods_status` tinyint(3) NULL DEFAULT '1' COMMENT '商品状态,0待审核,1正常售卖,2已下架,3已售罄',
    KEY `goods_name` (`goods_name`),
    KEY `goods_desc` (`goods_desc`),
    KEY `goods_price` (`goods_price`),
    KEY `goods_maket_price` (`goods_maket_price`),
    KEY `goods_stock` (`goods_stock`),
    KEY `goods_img` (`goods_img`),
    KEY `goods_sell_time` (`goods_sell_time`),
    KEY `goods_status` (`goods_status`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT '商品表';

After replication, you can go to the database to create the database table.


MySQL database table structure design

Displaying 1-8 of 8 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
goods_namevarchar(1024)商品名称Apple iPhone 8 Plus 64GB 红色特别版
goods_descvarchar(2024)商品描述Apple iPhone 8 Plus 64GB 红色特别版 移动联通电信4G手机
goods_priceint(10)9999999商品价格,单位为:分549900(表示:¥5499.00)
goods_maket_priceint(10)9999999商品市场价,即原价,单位为:分549900(表示:¥5499.00)
goods_stockint(10)0商品库存10
goods_imgvarchar(255)商品图片链接http://admin.okayapi.com/images/model/m16.jpg
goods_sell_timedatetime商品上架时间,开始售卖时间2018-08-08 08:08:08
goods_statustinyint(3)1商品状态,0待审核,1正常售卖,2已下架,3已售罄1

Guess You Like

MySQL Table Design okayapi_goods_comment

MySQL Table Design okayapi_shopxo_s_admin

MySQL Table Design okayapi_shopxo_s_answer

MySQL Table Design okayapi_shopxo_s_app_center_nav

MySQL Table Design okayapi_shopxo_s_app_home_nav

MySQL Table Design okayapi_shopxo_s_article

MySQL Table Design okayapi_shopxo_s_article_category

MySQL Table Design okayapi_shopxo_s_attachment

MySQL Table Design okayapi_shopxo_s_brand

MySQL Table Design okayapi_shopxo_s_brand_category

MySQL Table Design okayapi_shopxo_s_cart

MySQL Table Design okayapi_shopxo_s_config

MySQL Table Design okayapi_shopxo_s_custom_view

MySQL Table Design okayapi_shopxo_s_express

MySQL Table Design okayapi_shopxo_s_goods

MySQL Table Design okayapi_shopxo_s_goods_browse

MySQL Table Design okayapi_shopxo_s_goods_category

MySQL Table Design okayapi_shopxo_s_goods_category_join

MySQL Table Design okayapi_shopxo_s_goods_comments

MySQL Table Design okayapi_shopxo_s_goods_content_app

TOP ↑