13 lines
555 B
SQL
13 lines
555 B
SQL
CREATE TABLE IF NOT EXISTS absensi (
|
|
id INT AUTO_INCREMENT PRIMARY KEY,
|
|
jadwal_id INT NOT NULL,
|
|
murid_id INT NOT NULL,
|
|
tanggal DATE NOT NULL,
|
|
status ENUM('Hadir', 'Izin', 'Sakit', 'Alpa') NOT NULL,
|
|
keterangan TEXT,
|
|
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
|
|
updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
|
|
FOREIGN KEY (jadwal_id) REFERENCES jadwal(id) ON DELETE CASCADE,
|
|
FOREIGN KEY (murid_id) REFERENCES murid(id) ON DELETE CASCADE,
|
|
UNIQUE KEY (jadwal_id, murid_id, tanggal)
|
|
); |