CREATE TABLE `slots` (
  `id` INT AUTO_INCREMENT PRIMARY KEY,
  `date` DATE NOT NULL,
  `start_time` TIME NOT NULL,
  `end_time` TIME NOT NULL,
  `is_booked` TINYINT(1) DEFAULT 0
);

CREATE TABLE `appointments` (
  `id` INT AUTO_INCREMENT PRIMARY KEY,
  `slot_id` INT,
  `name` VARCHAR(100),
  `email` VARCHAR(100),
  `phone` VARCHAR(15),
  `booked_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  FOREIGN KEY (`slot_id`) REFERENCES `slots`(`id`) ON DELETE CASCADE
);
