每日例会第五天2025.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)
);
以上是古明源今天完成的任务
曹明阳今天完成了第三模块

以下是丁明辉今天完成的任务