MySQL Create Table SQL
Table Structure: okayapi_dberp_sales_order_goods_return:/tablelist/okayapi_dberp_sales_order_goods_return.html
-- MySQL Table okayapi_dberp_sales_order_goods_return
-- From: OkayAPI.com
CREATE TABLE `okayapi_dberp_sales_order_goods_return` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`sales_order_return_id` int(11) NOT NULL COMMENT '',
`sales_goods_id` int(11) NOT NULL COMMENT '',
`goods_name` varchar(100) NOT NULL COMMENT '',
`goods_number` varchar(50) NOT NULL COMMENT '',
`goods_spec` varchar(100) NOT NULL COMMENT '',
`goods_unit` varchar(20) NOT NULL COMMENT '',
`sales_goods_price` decimal(19,4) NOT NULL DEFAULT '0.0000' COMMENT '',
`sales_goods_tax` decimal(19,4) NOT NULL DEFAULT '0.0000' COMMENT '',
`goods_return_num` int(11) NOT NULL DEFAULT '0' COMMENT '',
`goods_return_amount` decimal(19,4) NOT NULL DEFAULT '0.0000' COMMENT '',
KEY `sales_order_return_id` (`sales_order_return_id`),
KEY `sales_goods_id` (`sales_goods_id`),
KEY `goods_name` (`goods_name`),
KEY `goods_number` (`goods_number`),
KEY `goods_spec` (`goods_spec`),
KEY `goods_unit` (`goods_unit`),
KEY `sales_goods_price` (`sales_goods_price`),
KEY `sales_goods_tax` (`sales_goods_tax`),
KEY `goods_return_num` (`goods_return_num`),
KEY `goods_return_amount` (`goods_return_amount`),
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-10 of 10 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
sales_order_return_id | int(11) | 否 | ||||
sales_goods_id | int(11) | 否 | ||||
goods_name | varchar(100) | 否 | ||||
goods_number | varchar(50) | 否 | ||||
goods_spec | varchar(100) | 是 | ||||
goods_unit | varchar(20) | 否 | ||||
sales_goods_price | decimal(19,4) | 0.0000 | 否 | 0.0000 | ||
sales_goods_tax | decimal(19,4) | 0.0000 | 否 | 0.0000 | ||
goods_return_num | int(11) | 0 | 否 | 0 | ||
goods_return_amount | decimal(19,4) | 0.0000 | 否 | 0.0000 |