You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
20 lines
2.1 KiB
20 lines
2.1 KiB
CREATE TABLE 仓库记录 (
|
|
仓库记录编号 INT AUTO_INCREMENT PRIMARY KEY,
|
|
设备编号 VARCHAR(50) NOT NULL,
|
|
出入库类型 ENUM('入库', '出库') NOT NULL,
|
|
出入库时间 DATETIME NOT NULL,
|
|
仓库编号 INT NOT NULL,
|
|
FOREIGN KEY (设备编号) REFERENCES 设备(设备编号),
|
|
FOREIGN KEY (仓库编号) REFERENCES 仓库(仓库编号)
|
|
);
|
|
INSERT INTO `仓库记录`(`仓库记录编号`, `设备编号`, `出入库类型`, `出入库时间`, `仓库编号`) VALUES (1, 'DEV001', '入库', '2023-10-05 12:34:56', 1);
|
|
INSERT INTO `仓库记录`(`仓库记录编号`, `设备编号`, `出入库类型`, `出入库时间`, `仓库编号`) VALUES (2, 'DEV002', '入库', '2023-10-11 12:35:16', 1);
|
|
INSERT INTO `仓库记录`(`仓库记录编号`, `设备编号`, `出入库类型`, `出入库时间`, `仓库编号`) VALUES (3, 'DEV003', '出库', '2023-10-10 12:35:36', 2);
|
|
INSERT INTO `仓库记录`(`仓库记录编号`, `设备编号`, `出入库类型`, `出入库时间`, `仓库编号`) VALUES (4, 'DEV004', '入库', '2023-10-12 12:35:14', 1);
|
|
INSERT INTO `仓库记录`(`仓库记录编号`, `设备编号`, `出入库类型`, `出入库时间`, `仓库编号`) VALUES (5, 'DEV005', '出库', '2024-05-21 12:36:16', 3);
|
|
INSERT INTO `仓库记录`(`仓库记录编号`, `设备编号`, `出入库类型`, `出入库时间`, `仓库编号`) VALUES (6, 'DEV006', '入库', '2023-02-10 12:36:36', 1);
|
|
INSERT INTO `仓库记录`(`仓库记录编号`, `设备编号`, `出入库类型`, `出入库时间`, `仓库编号`) VALUES (7, 'DEV007', '出库', '2023-06-05 12:36:56', 1);
|
|
INSERT INTO `仓库记录`(`仓库记录编号`, `设备编号`, `出入库类型`, `出入库时间`, `仓库编号`) VALUES (8, 'DEV008', '入库', '2023-05-09 12:37:16', 2);
|
|
INSERT INTO `仓库记录`(`仓库记录编号`, `设备编号`, `出入库类型`, `出入库时间`, `仓库编号`) VALUES (9, 'DEV009', '入库', '2023-06-30 12:37:36', 1);
|
|
INSERT INTO `仓库记录`(`仓库记录编号`, `设备编号`, `出入库类型`, `出入库时间`, `仓库编号`) VALUES (10, 'DEV010', '入库', '2018-02-05 10:37:56', 3);
|