
CREATE TABLE mobile (
 id INT AUTO_INCREMENT PRIMARY KEY,
 name VARCHAR(100),
 father_name VARCHAR(100),
 aadhaar_no VARCHAR(20),
 mobile_no VARCHAR(20),
 email VARCHAR(100),
 purpose VARCHAR(50),
 parent VARCHAR(50),
 status VARCHAR(20),
 reject_reason TEXT,
 updated_by VARCHAR(50)
);

CREATE TABLE notifications (
 id INT AUTO_INCREMENT PRIMARY KEY,
 userid VARCHAR(50),
 message TEXT,
 is_read ENUM('0','1') DEFAULT '0',
 created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
