MySQL Create Table SQL
Table Structure: okayapi_xbinstore_tb_item_desc:/tablelist/okayapi_xbinstore_tb_item_desc.html
-- MySQL Table okayapi_xbinstore_tb_item_desc
-- From: OkayAPI.com
CREATE TABLE `okayapi_xbinstore_tb_item_desc` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`item_id` bigint(20) NULL COMMENT '商品ID',
`item_desc` text NULL COMMENT '商品描述',
`created` datetime NULL COMMENT '创建时间',
`updated` datetime NULL COMMENT '更新时间',
KEY `item_id` (`item_id`),
KEY `item_desc` (`item_desc`),
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 | |||
item_desc | text | 是 | 商品描述 | |||
created | datetime | 是 | 创建时间 | |||
updated | datetime | 是 | 更新时间 |