CREATE TABLE `fc_events`.`advertisement_meta_data` (
  `id` varchar(45) NOT NULL,
  `type` varchar(45) DEFAULT NULL,
  `service_types` text,
  `workspaces` text,
  `latitude` varchar(45) DEFAULT NULL,
  `longitude` varchar(45) DEFAULT NULL,
  `pet_type` text,
  `pet_breed` text,
  `media_position` varchar(45) DEFAULT NULL,
  `frequency_occurrence` varchar(45) DEFAULT NULL,
  `frequency_unit` varchar(45) DEFAULT NULL,
  `advertisement_id` varchar(45) NOT NULL,
  `media` varchar(255) NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `modified_by` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id_UNIQUE` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

ALTER TABLE `fc_events`.`advertisement`
ADD COLUMN `link_type` VARCHAR(45) NULL AFTER `file_view`;