MySQL Create Table SQL
Table Structure: okayapi_landi_grocery_item:/tablelist/okayapi_landi_grocery_item.html
-- MySQL Table okayapi_landi_grocery_item
-- From: OkayAPI.com
CREATE TABLE `okayapi_landi_grocery_item` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`okayapi_landi_grocery_item_name` varchar(64) NULL COMMENT '',
`okayapi_landi_grocery_item_type` varchar(64) NULL COMMENT '',
`cat` varchar(64) NULL COMMENT '',
`total` int(11) NULL DEFAULT '0' COMMENT '',
`total_loss` int(11) NULL DEFAULT '0' COMMENT '',
`total_sold` int(11) NULL DEFAULT '0' COMMENT '',
`total_benifit` double NULL DEFAULT '0' COMMENT '',
`avaliable` int(11) NULL DEFAULT '0' COMMENT '',
`buy_money` double NULL COMMENT '',
`sell_money` double NULL COMMENT '',
KEY `okayapi_landi_grocery_item_name` (`okayapi_landi_grocery_item_name`),
KEY `okayapi_landi_grocery_item_type` (`okayapi_landi_grocery_item_type`),
KEY `cat` (`cat`),
KEY `total` (`total`),
KEY `total_loss` (`total_loss`),
KEY `total_sold` (`total_sold`),
KEY `total_benifit` (`total_benifit`),
KEY `avaliable` (`avaliable`),
KEY `buy_money` (`buy_money`),
KEY `sell_money` (`sell_money`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'LD酒店租房管理-饮料';
After replication, you can go to the database to create the database table.
MySQL database table structure design
Displaying 1-10 of 10 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
okayapi_landi_grocery_item_name | varchar(64) | 是 | Unique Index | |||
okayapi_landi_grocery_item_type | varchar(64) | 是 | ||||
cat | varchar(64) | 是 | ||||
total | int(11) | 0 | 是 | 0 | ||
total_loss | int(11) | 0 | 是 | 0 | ||
total_sold | int(11) | 0 | 是 | 0 | ||
total_benifit | double | 0 | 是 | 0 | ||
avaliable | int(11) | 0 | 是 | 0 | ||
buy_money | double | 是 | ||||
sell_money | double | 是 |