-- backend/scripts/migrate_20260731_pl_feedback_brand_qty.sql

CREATE TABLE IF NOT EXISTS `pl_inbound_order_item_brand_qty` (
  `id` varchar(64) NOT NULL COMMENT '主键ID',
  `order_id` varchar(64) NOT NULL COMMENT '入库单ID',
  `order_item_id` varchar(64) NOT NULL COMMENT '入库明细ID',
  `plan_product_id` varchar(64) NOT NULL COMMENT '计划产品行ID',
  `brand_id` varchar(64) NOT NULL DEFAULT '' COMMENT '品牌ID',
  `brand_name` varchar(100) DEFAULT NULL COMMENT '品牌名称',
  `qty` decimal(15,3) NOT NULL DEFAULT '0.000' COMMENT '本品牌数量',
  `tenant_no` varchar(64) NOT NULL DEFAULT 'shanxia2.0' COMMENT '租户编号',
  `order_num` int(11) DEFAULT NULL COMMENT '排序号',
  `remark` varchar(512) DEFAULT NULL COMMENT '备注',
  `create_by` varchar(64) DEFAULT NULL,
  `create_dept_id` varchar(64) NOT NULL DEFAULT '',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_by` varchar(64) DEFAULT NULL,
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `del_flag` smallint(6) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idx_order_item` (`order_item_id`),
  KEY `idx_order` (`order_id`),
  KEY `idx_tenant` (`tenant_no`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='入库明细品牌数量';

CREATE TABLE IF NOT EXISTS `pl_outbound_order_item_brand_qty` (
  `id` varchar(64) NOT NULL COMMENT '主键ID',
  `order_id` varchar(64) NOT NULL COMMENT '出库单ID',
  `order_item_id` varchar(64) NOT NULL COMMENT '出库明细ID',
  `plan_product_id` varchar(64) NOT NULL COMMENT '计划产品行ID',
  `brand_id` varchar(64) NOT NULL DEFAULT '' COMMENT '品牌ID',
  `brand_name` varchar(100) DEFAULT NULL COMMENT '品牌名称',
  `qty` decimal(15,3) NOT NULL DEFAULT '0.000' COMMENT '本品牌数量',
  `tenant_no` varchar(64) NOT NULL DEFAULT 'shanxia2.0' COMMENT '租户编号',
  `order_num` int(11) DEFAULT NULL COMMENT '排序号',
  `remark` varchar(512) DEFAULT NULL COMMENT '备注',
  `create_by` varchar(64) DEFAULT NULL,
  `create_dept_id` varchar(64) NOT NULL DEFAULT '',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_by` varchar(64) DEFAULT NULL,
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `del_flag` smallint(6) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idx_order_item` (`order_item_id`),
  KEY `idx_order` (`order_id`),
  KEY `idx_tenant` (`tenant_no`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='出库明细品牌数量';

CREATE TABLE IF NOT EXISTS `pl_transport_product_feedback` (
  `id` varchar(64) NOT NULL COMMENT '主键ID',
  `transport_id` varchar(64) NOT NULL COMMENT '运输单ID',
  `plan_id` varchar(64) NOT NULL COMMENT '计划ID',
  `plan_product_id` varchar(64) NOT NULL COMMENT '计划产品行ID',
  `actual_qty` decimal(15,3) NOT NULL DEFAULT '0.000' COMMENT '该产品回传总量',
  `tenant_no` varchar(64) NOT NULL DEFAULT 'shanxia2.0' COMMENT '租户编号',
  `order_num` int(11) DEFAULT NULL COMMENT '排序号',
  `remark` varchar(512) DEFAULT NULL COMMENT '备注',
  `create_by` varchar(64) DEFAULT NULL,
  `create_dept_id` varchar(64) NOT NULL DEFAULT '',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_by` varchar(64) DEFAULT NULL,
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `del_flag` smallint(6) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idx_transport` (`transport_id`),
  KEY `idx_plan_product` (`plan_product_id`),
  KEY `idx_tenant` (`tenant_no`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='运输单按产品回传';

CREATE TABLE IF NOT EXISTS `pl_transport_product_brand_qty` (
  `id` varchar(64) NOT NULL COMMENT '主键ID',
  `transport_id` varchar(64) NOT NULL COMMENT '运输单ID',
  `plan_product_id` varchar(64) NOT NULL COMMENT '计划产品行ID',
  `feedback_id` varchar(64) DEFAULT NULL COMMENT '产品回传行ID',
  `brand_id` varchar(64) NOT NULL DEFAULT '' COMMENT '品牌ID',
  `brand_name` varchar(100) DEFAULT NULL COMMENT '品牌名称',
  `qty` decimal(15,3) NOT NULL DEFAULT '0.000' COMMENT '本品牌数量',
  `tenant_no` varchar(64) NOT NULL DEFAULT 'shanxia2.0' COMMENT '租户编号',
  `order_num` int(11) DEFAULT NULL COMMENT '排序号',
  `remark` varchar(512) DEFAULT NULL COMMENT '备注',
  `create_by` varchar(64) DEFAULT NULL,
  `create_dept_id` varchar(64) NOT NULL DEFAULT '',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_by` varchar(64) DEFAULT NULL,
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `del_flag` smallint(6) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idx_transport_product` (`transport_id`,`plan_product_id`),
  KEY `idx_feedback` (`feedback_id`),
  KEY `idx_tenant` (`tenant_no`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='运输单产品回传品牌数量';