CREATE TABLE students (
id INT AUTO_INCREMENT PRIMARY KEY,
student_id VARCHAR(20) NOT NULL UNIQUE COMMENT '学号',
name VARCHAR(50) NOT NULL COMMENT '姓名',
class VARCHAR(50) COMMENT '班级',
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
CREATE TABLE attendance (
id INT AUTO_INCREMENT PRIMARY KEY,
student_id VARCHAR(20) NOT NULL COMMENT '学号',
date DATE NOT NULL COMMENT '签到日期',
status ENUM('present', 'absent', 'late') DEFAULT 'absent' COMMENT '签到状态',
score DECIMAL(5,2) DEFAULT 0 COMMENT '本次得分',
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
FOREIGN KEY (student_id) REFERENCES students(student_id)
);