CREATE TABLE participants (
    id INT AUTO_INCREMENT PRIMARY KEY,
    first_name VARCHAR(100),
    middle_name VARCHAR(100),
    last_name VARCHAR(100),
    full_name_on_certificate VARCHAR(255),
    email VARCHAR(150),
    phone_number VARCHAR(20),
    gender VARCHAR(20),
    designation VARCHAR(255),
    registration_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE `attendance_records` (
  `id` INT AUTO_INCREMENT PRIMARY KEY,
  `participant_id` INT,
  `participant_full_name` VARCHAR(255),
  `participant_email` VARCHAR(255),
  `date` DATE,
  `sign_in_time` DATETIME,
  `sign_out_time` DATETIME,
  FOREIGN KEY (`participant_id`) REFERENCES `participants`(`id`)
);