CREATE TABLE `game_answer_facts` (
  `username` varchar(128) NOT NULL,
  `user_type` varchar(32) NOT NULL,
  `game_id` varchar(64) NOT NULL,
  `date_started` datetime NOT NULL,
  `date_ended` datetime NOT NULL,
  `game_status` varchar(32) NOT NULL,
  `locale` varchar(32) NOT NULL,
  `game_first_losing_position` int(11) DEFAULT NULL,
  `game_second_losing_position` int(11) DEFAULT NULL,
  `game_questions_failed` int(11) NOT NULL,
  `game_duration_seconds` int(11) NOT NULL,
  `game_credit_id` varchar(32) NOT NULL,
  `game_credit_date_redeemed` datetime NOT NULL,
  `game_credit_value` varchar(128) NOT NULL,
  `game_credit_status` varchar(32) NOT NULL,
  `game_credit_date_created` datetime NOT NULL,
  `game_credit_date_modified` datetime NOT NULL,
  `game_credit_created_by` varchar(128) NOT NULL,
  `game_credit_last_modified_by` varchar(128) NOT NULL,
  `game_credit_version` int(11) NOT NULL,
  `question_id` varchar(32) NOT NULL,
  `question_path` varchar(32) NOT NULL,
  `question_pool` varchar(32) NOT NULL,
  `question_type` varchar(32) NOT NULL,
  `question_date_created` datetime NOT NULL,
  `question_date_modified` datetime NOT NULL,
  `question_created_by` varchar(128) NOT NULL,
  `question_last_modified_by` varchar(128) NOT NULL,
  `question_version` int(11) NOT NULL,
  `question_position` int(11) NOT NULL,
  `question_date_started` datetime NOT NULL,
  `question_date_ended` datetime NOT NULL,
  `question_game_status` varchar(32) NOT NULL,
  `question_is_first_losing_position` tinyint(1) NOT NULL,
  `question_is_second_losing_position` tinyint(1) NOT NULL,
  `answer_id` varchar(32) NOT NULL,
  `answer_is_correct` tinyint(1) NOT NULL,
  `answer_is_selected` tinyint(1) NOT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8mb4;