CREATE TABLE `fc_events`.`advertisement` (
  `id` VARCHAR(45) NOT NULL,
  `title` VARCHAR(45) NOT NULL,
  `description` TEXT NOT NULL,
  `file` TEXT NULL,
  `raw_data` TEXT NULL,
  `start_date` DATETIME NULL,
  `end_date` DATETIME NULL,
  `advertiser_name` VARCHAR(255) NULL,
  `status` VARCHAR(45) NULL,
  `created_at` DATETIME NULL,
  `modified_at` DATETIME NULL,
  `created_by` VARCHAR(45) NULL,
  `modified_by` VARCHAR(45) NULL,
  PRIMARY KEY (`id`),
  UNIQUE INDEX `id_UNIQUE` (`id` ASC) VISIBLE,
  UNIQUE INDEX `start_date_UNIQUE` (`start_date` ASC) VISIBLE,
  UNIQUE INDEX `end_date_UNIQUE` (`end_date` ASC) VISIBLE,
  UNIQUE INDEX `advertiser_name_UNIQUE` (`advertiser_name` ASC) VISIBLE,
  UNIQUE INDEX `status_UNIQUE` (`status` ASC) VISIBLE);