MySQL Create Table SQL
Table Structure: okayapi_dberp_sales_order_goods:/tablelist/okayapi_dberp_sales_order_goods.html
-- MySQL Table okayapi_dberp_sales_order_goods
-- From: OkayAPI.com
CREATE TABLE `okayapi_dberp_sales_order_goods` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`sales_order_id` int(11) NULL COMMENT '销售订单id',
`goods_id` int(11) NULL COMMENT '商品id',
`goods_name` varchar(100) NULL COMMENT '商品名称',
`goods_number` varchar(30) NULL COMMENT '商品编号',
`goods_spec` varchar(100) NULL COMMENT '商品规格',
`goods_unit` varchar(20) NULL COMMENT '商品单位',
`sales_goods_sell_num` int(11) NULL COMMENT '销售商品数量',
`sales_goods_price` decimal(19,4) NULL DEFAULT '0.0000' COMMENT '',
`sales_goods_tax` decimal(19,4) NULL DEFAULT '0.0000' COMMENT '',
`sales_goods_amount` decimal(19,4) NULL DEFAULT '0.0000' COMMENT '',
`sales_goods_info` varchar(255) NULL COMMENT '',
KEY `sales_order_id` (`sales_order_id`),
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`),
KEY `sales_goods_sell_num` (`sales_goods_sell_num`),
KEY `sales_goods_price` (`sales_goods_price`),
KEY `sales_goods_tax` (`sales_goods_tax`),
KEY `sales_goods_amount` (`sales_goods_amount`),
KEY `sales_goods_info` (`sales_goods_info`),
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-11 of 11 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
sales_order_id | int(11) | 否 | 销售订单id | |||
goods_id | int(11) | 否 | 商品id | |||
goods_name | varchar(100) | 否 | 商品名称 | |||
goods_number | varchar(30) | 否 | 商品编号 | |||
goods_spec | varchar(100) | 是 | 商品规格 | |||
goods_unit | varchar(20) | 否 | 商品单位 | |||
sales_goods_sell_num | int(11) | 否 | 销售商品数量 | |||
sales_goods_price | decimal(19,4) | 0.0000 | 否 | 0.0000 | ||
sales_goods_tax | decimal(19,4) | 0.0000 | 否 | 0.0000 | ||
sales_goods_amount | decimal(19,4) | 0.0000 | 否 | 0.0000 | ||
sales_goods_info | varchar(255) | 是 |