--
-- Table structure for table `interactions`
--
DROP TABLE IF EXISTS `interactions`;
CREATE TABLE `interactions` (
  `interaction_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `outfit_id` int(11) UNSIGNED DEFAULT NULL,
  `user_id` int(11) UNSIGNED DEFAULT NULL,
  `interaction_type` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `product_liked` int(11) UNSIGNED DEFAULT NULL,
  `original_product_id` int(11) UNSIGNED DEFAULT NULL,
  `swapped_product_id` int(11) UNSIGNED DEFAULT NULL,
  `outfit_altered` boolean DEFAULT 0,
  `is_personalized` boolean DEFAULT 0,
  `outfit_score` double DEFAULT NULL,
  `occasion_filter` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `season_filter` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `price_filter` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `created_at` datetime NULL DEFAULT NULL,
  PRIMARY KEY (`interaction_id`),
  INDEX outfit_id (outfit_id),
  INDEX user_id (user_id),
  INDEX interaction_type (interaction_type),
  INDEX user_interaction (interaction_type,user_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
