MySQL Create Table SQL
Table Structure: okayapi_xbinstore_tb_item_param_item：/tablelist/okayapi_xbinstore_tb_item_param_item.html
-- MySQL Table okayapi_xbinstore_tb_item_param_item
-- From: OkayAPI.com
CREATE TABLE `okayapi_xbinstore_tb_item_param_item` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`item_id` bigint(20) NULL COMMENT '商品ID',
`param_data` text NULL COMMENT '参数数据，格式为json格式',
`created` datetime NULL COMMENT '',
`updated` datetime NULL COMMENT '',
KEY `item_id` (`item_id`),
KEY `param_data` (`param_data`),
KEY `created` (`created`),
KEY `updated` (`updated`),
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-4 of 4 results.
| Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
|---|---|---|---|---|---|---|
| item_id | bigint(20) | 是 | 商品ID | Normal Index | ||
| param_data | text | 是 | 参数数据，格式为json格式 | |||
| created | datetime | 是 | ||||
| updated | datetime | 是 |
