okayapi_crm_salesorder_items - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_crm_salesorder_items：/tablelist/okayapi_crm_salesorder_items.html


-- MySQL Table okayapi_crm_salesorder_items
-- From: OkayAPI.com
CREATE TABLE `okayapi_crm_salesorder_items` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `product_id` int(11) NULL COMMENT '产品ID',
    `num` int(11) NULL COMMENT '数量',
    `price` decimal(10,0) NULL COMMENT '价格',
    `memo` varchar(255) NULL COMMENT '备注',
    `amount` decimal(10,0) NULL COMMENT '小计',
    `salesorder_id` int(11) NULL COMMENT '订单主键',
    KEY `product_id` (`product_id`),
    KEY `num` (`num`),
    KEY `price` (`price`),
    KEY `memo` (`memo`),
    KEY `amount` (`amount`),
    KEY `salesorder_id` (`salesorder_id`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'CRM-订单明细表';

After replication, you can go to the database to create the database table.

MySQL database table structure design

Displaying 1-6 of 6 results.

Field Name	Field Type	IS NULL	Field Comment
product_id	int(11)	是	产品ID
num	int(11)	是	数量
price	decimal(10,0)	是	价格
memo	varchar(255)	是	备注
amount	decimal(10,0)	是	小计
salesorder_id	int(11)	是	订单主键