MySQL Create Table SQL
Table Structure: okayapi_xbinstore_tb_item:/tablelist/okayapi_xbinstore_tb_item.html
-- MySQL Table okayapi_xbinstore_tb_item
-- From: OkayAPI.com
CREATE TABLE `okayapi_xbinstore_tb_item` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(100) NOT NULL COMMENT '商品标题',
`sell_point` varchar(500) NOT NULL COMMENT '商品卖点',
`price` bigint(20) NOT NULL COMMENT '商品价格,单位为:分',
`num` int(10) NOT NULL COMMENT '库存数量',
`barcode` varchar(30) NOT NULL COMMENT '商品条形码',
`image` varchar(500) NOT NULL COMMENT '商品图片',
`cid` bigint(10) NOT NULL COMMENT '所属类目,叶子类目',
`okayapi_xbinstore_tb_item_status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '商品状态,1-正常,2-下架,3-删除',
`weight` int(10) NOT NULL COMMENT '重量',
`created` datetime NOT NULL COMMENT '创建时间',
`updated` datetime NOT NULL COMMENT '更新时间',
`colour` varchar(10) NOT NULL COMMENT '颜色',
`size` varchar(10) NOT NULL COMMENT '尺寸',
KEY `title` (`title`),
KEY `sell_point` (`sell_point`),
KEY `price` (`price`),
KEY `num` (`num`),
KEY `barcode` (`barcode`),
KEY `image` (`image`),
KEY `cid` (`cid`),
KEY `okayapi_xbinstore_tb_item_status` (`okayapi_xbinstore_tb_item_status`),
KEY `weight` (`weight`),
KEY `created` (`created`),
KEY `updated` (`updated`),
KEY `colour` (`colour`),
KEY `size` (`size`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'B2C商城-商品表';
After replication, you can go to the database to create the database table.
MySQL database table structure design
Displaying 1-13 of 13 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
title | varchar(100) | 否 | 商品标题 | |||
sell_point | varchar(500) | 是 | 商品卖点 | |||
price | bigint(20) | 否 | 商品价格,单位为:分 | |||
num | int(10) | 否 | 库存数量 | |||
barcode | varchar(30) | 是 | 商品条形码 | |||
image | varchar(500) | 是 | 商品图片 | |||
cid | bigint(10) | 否 | 所属类目,叶子类目 | Normal Index | ||
okayapi_xbinstore_tb_item_status | tinyint(4) | 1 | 否 | 商品状态,1-正常,2-下架,3-删除 | Normal Index | 1 |
weight | int(10) | 否 | 重量 | |||
created | datetime | 否 | 创建时间 | |||
updated | datetime | 否 | 更新时间 | Normal Index | ||
colour | varchar(10) | 否 | 颜色 | |||
size | varchar(10) | 否 | 尺寸 |