分销员后台0315

xiaoyong931011

2021-03-15 11e9536bf17e452f947faf14bdce99b5f9d31094

 zq-erp/src/main/resources/config/db/increment/推广员.sql

@@ -11,6 +11,29 @@


/**
 * 分销单明细
 * @author yourName
 * @date 2021-03-12 13:17
 */
CREATE TABLE shop_salesman_order_item(
                                         create_by varchar(100) NOT NULL COMMENT '创建人',
                                         create_time datetime NOT NULL COMMENT '创建时间',
                                         update_by varchar(100) NOT NULL COMMENT '更新人',
                                         update_time datetime NOT NULL COMMENT '更新时间',
                                         id bigint(20)   NOT NULL  AUTO_INCREMENT  COMMENT '主键',

                                         order_id  bigint(20)    COMMENT '订单id',

                                         salesman_order_id bigint(20)    COMMENT '分销订单id',

                                         order_item_id bigint(20)    COMMENT '订单明细id',

                                         amount double(20,2)    COMMENT '收益金额',

PRIMARY KEY(id)
)ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='分销单明细';

/**
 * 收益流水
 * @author yourName
 * @date 2021-03-10 17:34