AiDOPWarehouse/doc/migrations/2026-04-17_aidopdev_linkage_ddl_part4a_stubs_and_wost.sql

-- Part4a：采购收货存根表（供 vscm_cgshrk）+ WorkOrdSetupTimeRecord
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

DROP TABLE IF EXISTS `PurOrdRctDetail`;
CREATE TABLE `PurOrdRctDetail` (
  `Domain` varchar(8) NOT NULL,
  `Receiver` varchar(80) NOT NULL,
  `OrdNbr` varchar(48) NOT NULL,
  `OrdLine` int NOT NULL,
  `RctType` varchar(20) NOT NULL,
  `Line` varchar(80) NULL DEFAULT NULL,
  `QtyReceived` decimal(23, 10) NULL DEFAULT NULL,
  `Delivery` varchar(200) NULL DEFAULT NULL,
  `ItemNum` varchar(128) NULL DEFAULT NULL,
  `CreateTime` datetime NULL DEFAULT NULL,
  `QCNbr` varchar(80) NULL DEFAULT NULL,
  `StatusByQC` varchar(80) NULL DEFAULT NULL,
  `QCDescr` varchar(500) NULL DEFAULT NULL,
  `RctQty` decimal(23, 10) NULL DEFAULT NULL,
  `QtyReturn` decimal(23, 10) NULL DEFAULT NULL,
  `LotSerial` varchar(200) NULL DEFAULT NULL,
  PRIMARY KEY (`Domain`, `Receiver`, `OrdNbr`, `OrdLine`, `RctType`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

DROP TABLE IF EXISTS `PurOrdRctMaster`;
CREATE TABLE `PurOrdRctMaster` (
  `Domain` varchar(8) NOT NULL,
  `Receiver` varchar(80) NOT NULL,
  `Remark` varchar(500) NULL DEFAULT NULL,
  PRIMARY KEY (`Domain`, `Receiver`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

DROP TABLE IF EXISTS `PurOrdDetail`;
CREATE TABLE `PurOrdDetail` (
  `Domain` varchar(8) NOT NULL DEFAULT '',
  `PurOrd` varchar(48) NOT NULL DEFAULT '',
  `Line` int NOT NULL DEFAULT 0,
  `Req` varchar(80) NULL DEFAULT NULL,
  `QtyOrded` decimal(23, 10) NULL DEFAULT NULL,
  `ReceiptQty` decimal(23, 10) NULL DEFAULT NULL,
  `RctQty` decimal(23, 10) NULL DEFAULT NULL,
  `QtyReturned` decimal(23, 10) NULL DEFAULT NULL,
  PRIMARY KEY (`Domain`, `PurOrd`, `Line`),
  KEY `IX_PurOrdDetail_Req` (`Req`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

DROP TABLE IF EXISTS `WorkOrdSetupTimeRecord`;
CREATE TABLE `WorkOrdSetupTimeRecord` (
  `RecID` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `Domain` varchar(8) NOT NULL,
  `WorkOrd` varchar(50) NOT NULL,
  `ItemNum` varchar(128) NOT NULL,
  `Op` int NOT NULL DEFAULT 0 COMMENT '工序',
  `CreateTime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `StartTime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '开始时间',
  `Line` varchar(120) NULL DEFAULT NULL,
  `Qty` int NULL DEFAULT 0 COMMENT '占用设备 占用设备/人工数量',
  `DailyPlanOrder` int NULL DEFAULT NULL COMMENT '拆分日工单的第几天',
  PRIMARY KEY (`RecID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

SET FOREIGN_KEY_CHECKS = 1;