MySQL Create Table SQL
Table Structure: okayapi_dberp_other_warehouse_order_goods:/tablelist/okayapi_dberp_other_warehouse_order_goods.html
-- MySQL Table okayapi_dberp_other_warehouse_order_goods
-- From: OkayAPI.com
CREATE TABLE `okayapi_dberp_other_warehouse_order_goods` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`other_warehouse_order_id` int(11) NULL COMMENT '',
`warehouse_id` int(11) NULL COMMENT '',
`warehouse_goods_buy_num` int(11) NULL COMMENT '',
`warehouse_goods_price` decimal(19,4) NULL DEFAULT '0.0000' COMMENT '',
`warehouse_goods_tax` decimal(19,4) NULL DEFAULT '0.0000' COMMENT '',
`warehouse_goods_amount` decimal(19,4) NULL DEFAULT '0.0000' COMMENT '',
`goods_id` int(11) NULL COMMENT '',
`goods_name` varchar(100) NULL COMMENT '',
`goods_number` varchar(30) NULL COMMENT '',
`goods_spec` varchar(100) NULL COMMENT '',
`goods_unit` varchar(20) NULL COMMENT '',
KEY `other_warehouse_order_id` (`other_warehouse_order_id`),
KEY `warehouse_id` (`warehouse_id`),
KEY `warehouse_goods_buy_num` (`warehouse_goods_buy_num`),
KEY `warehouse_goods_price` (`warehouse_goods_price`),
KEY `warehouse_goods_tax` (`warehouse_goods_tax`),
KEY `warehouse_goods_amount` (`warehouse_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-11 of 11 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
other_warehouse_order_id | int(11) | 否 | ||||
warehouse_id | int(11) | 否 | ||||
warehouse_goods_buy_num | int(11) | 否 | ||||
warehouse_goods_price | decimal(19,4) | 0.0000 | 否 | 0.0000 | ||
warehouse_goods_tax | decimal(19,4) | 0.0000 | 否 | 0.0000 | ||
warehouse_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) | 是 |