okayapi_shopxo_s_goods_spec_type - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_shopxo_s_goods_spec_type：/tablelist/okayapi_shopxo_s_goods_spec_type.html


-- MySQL Table okayapi_shopxo_s_goods_spec_type
-- From: OkayAPI.com
CREATE TABLE `okayapi_shopxo_s_goods_spec_type` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `goods_id` int(11) NOT NULL DEFAULT '0' COMMENT '商品id',
    `okayapi_shopxo_s_goods_spec_type_value` text NOT NULL COMMENT '类型值（json字符串存储）',
    `okayapi_shopxo_s_goods_spec_type_name` char(60) NOT NULL COMMENT '类型名称',
    KEY `goods_id` (`goods_id`),
    KEY `okayapi_shopxo_s_goods_spec_type_value` (`okayapi_shopxo_s_goods_spec_type_value`),
    KEY `okayapi_shopxo_s_goods_spec_type_name` (`okayapi_shopxo_s_goods_spec_type_name`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'ShopXO商城-商品规格类型';

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

MySQL database table structure design

Displaying 1-3 of 3 results.

Field Name	Field Type	Default	IS NULL	Field Comment	Index	Demo Data
goods_id	int(11)	0	否	商品id	Normal Index	0
okayapi_shopxo_s_goods_spec_type_value	text		否	类型值（json字符串存储）
okayapi_shopxo_s_goods_spec_type_name	char(60)		否	类型名称