CREATE DATABASE attendance_db;


USE attendance_db;


CREATE TABLE users (

    user_id INT AUTO_INCREMENT PRIMARY KEY,

    username VARCHAR(50) NOT NULL,

    password VARCHAR(50) NOT NULL,

    role ENUM('admin', 'teacher', 'student') NOT NULL

);


CREATE TABLE attendance (

    attendance_id INT AUTO_INCREMENT PRIMARY KEY,

    user_id INT,

    date DATE,

    status ENUM('Present', 'Absent'),

    FOREIGN KEY (user_id) REFERENCES users(user_id)

);