2024/2/25日 日志 第一次测试案例分析(2)--数据库层面

数据库方面:
create table ft_user(
id int primary key auto_increment,
username varchar(30),
password varchar(30),
identify varchar(100)
);

create table ft_storehouse(
id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
storehouseName varchar(30),
description varchar(30)

)ENGINE=InnoDB DEFAULT CHARSET=utf8mb4,
AUTO_INCREMENT = 202501;

create table ft_material(
id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
materialName varchar(50) not null,
description varchar(100),
materialType varchar(50)

)ENGINE=InnoDB DEFAULT CHARSET=utf8mb4,
AUTO_INCREMENT = 20250001;

create table ft_materialDetails(
id bigint NOT NULL PRIMARY KEY AUTO_INCREMENT,
createType varchar(50),
quantity int,
unit varchar(50),
storehouseId int,
materialId int

)ENGINE=InnoDB DEFAULT CHARSET=utf8mb4,
AUTO_INCREMENT = 202502210001;