
CREATE TABLE `t_order` (
  `OrderID` varchar(50) NOT NULL,
  `OrderNum` varchar(200) NOT NULL,
  `OrderName` varchar(300) NOT NULL,
  `OrderManager` varchar(50) NOT NULL,
  `OrderAddTime` datetime DEFAULT NULL,
  `OrderModifyTime` datetime DEFAULT NULL,
  `OrderPriceCount` decimal(10,0) DEFAULT NULL,
  PRIMARY KEY (`OrderID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `t_order_product` (
  `ID` varchar(50) NOT NULL,
  `OrderID` varchar(50) NOT NULL,
  `ProductID` varchar(50) NOT NULL,
  `ProductAmount` decimal(10,0) NOT NULL,
  `ProductPriceCount` decimal(10,0) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `t_product` (
  `ProductID` varchar(50) NOT NULL,
  `ProductNum` varchar(200) NOT NULL,
  `ProductName` varchar(300) NOT NULL,
  `ProductUnitPrice` decimal(10,0) NOT NULL,
  `AddTime` datetime DEFAULT NULL,
  PRIMARY KEY (`ProductID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;