CREATE TABLE appointments (
id INT AUTO_INCREMENT PRIMARY KEY,
patient_name VARCHAR(100),
phone VARCHAR(20),
doctor VARCHAR(100),
slot VARCHAR(50),
date DATE,
payment_method VARCHAR(20),
trxid VARCHAR(50),
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);