-- Active: 1744018034595@@127.0.0.1@3306@madrasha


CREATE TABLE ts_attendance (
    id INT PRIMARY KEY AUTO_INCREMENT,
    name VARCHAR(255),
    status VARCHAR(25),
    phone VARCHAR(25),
    datetime TIMESTAMP DEFAULT CURRENT_TIMESTAMP,

    madrasha_email VARCHAR(255) NOT NULL,

    FOREIGN KEY (madrasha_email) REFERENCES madrashas(email) ON DELETE CASCADE

);

DROP TABLE IF EXISTS ts_attendance;