-- Active: 1739365328253@@127.0.0.1@3306@madrasha



CREATE TABLE hadiya(
    id INT PRIMARY KEY AUTO_INCREMENT,
    name VARCHAR(100) NOT NULL,
    phone INT(15) NOT NULL,
    salary DOUBLE(10, 2) NOT NULL,
    categories VARCHAR(50) NOT NULL,
    type VARCHAR(50) NOT NULL,
    dates TIMESTAMP DEFAULT CURRENT_TIMESTAMP,

    email VARCHAR(100) NOT NULL,

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


);


DROP TABLE IF EXISTS hadiya;