2024.4.20

CREATE TABLE ConstructionPlan (
plan_id INT PRIMARY KEY AUTO_INCREMENT,
plan_name VARCHAR(100) NOT NULL,
equipment_id INT,
construction_reason TEXT,
construction_content TEXT,
construction_level ENUM('high', 'medium', 'low'),
construction_height DECIMAL(5,2),
start_time DATETIME,
end_time DATETIME,
impact_scope TEXT,
cooperating_units TEXT,
construction_scheme TEXT,
status ENUM('draft', 'submitted', 'approved', 'rejected', 'completed'),
creator_id INT,
create_time DATETIME DEFAULT CURRENT_TIMESTAMP,
FOREIGN KEY (equipment_id) REFERENCES Equipment(equipment_id),
FOREIGN KEY (creator_id) REFERENCES Users(user_id)
);今天写了以上数据表，期间遇到了数据类型不匹配，创建不成功等问题，经过去csdn上面寻找解决方案后解决了问题