MySQL Create Table SQL
Table Structure: okayapi_dberp_stock_check_goods:/tablelist/okayapi_dberp_stock_check_goods.html
-- MySQL Table okayapi_dberp_stock_check_goods
-- From: OkayAPI.com
CREATE TABLE `okayapi_dberp_stock_check_goods` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`stock_check_id` int(11) NOT NULL COMMENT '',
`stock_check_pre_goods_num` int(11) NOT NULL COMMENT '',
`stock_check_aft_goods_num` int(11) NOT NULL COMMENT '',
`stock_check_goods_amount` decimal(19,4) NOT NULL DEFAULT '0.0000' COMMENT '',
`goods_id` int(11) NOT NULL COMMENT '',
`goods_name` varchar(100) NOT NULL COMMENT '',
`goods_number` varchar(30) NOT NULL COMMENT '',
`goods_spec` varchar(100) NOT NULL COMMENT '',
`goods_unit` varchar(20) NOT NULL COMMENT '',
KEY `stock_check_id` (`stock_check_id`),
KEY `stock_check_pre_goods_num` (`stock_check_pre_goods_num`),
KEY `stock_check_aft_goods_num` (`stock_check_aft_goods_num`),
KEY `stock_check_goods_amount` (`stock_check_goods_amount`),
KEY `goods_id` (`goods_id`),
KEY `goods_name` (`goods_name`),
KEY `goods_number` (`goods_number`),
KEY `goods_spec` (`goods_spec`),
KEY `goods_unit` (`goods_unit`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'DBErp进销存-库存盘点表';
After replication, you can go to the database to create the database table.
MySQL database table structure design
Displaying 1-9 of 9 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
stock_check_id | int(11) | 否 | ||||
stock_check_pre_goods_num | int(11) | 否 | ||||
stock_check_aft_goods_num | int(11) | 否 | ||||
stock_check_goods_amount | decimal(19,4) | 0.0000 | 否 | 0.0000 | ||
goods_id | int(11) | 否 | ||||
goods_name | varchar(100) | 否 | ||||
goods_number | varchar(30) | 否 | ||||
goods_spec | varchar(100) | 否 | ||||
goods_unit | varchar(20) | 否 |