グッズアンケート #672

CREATE TABLE `user_questionnaire` (
  `event_no` int NOT NULL,
  `user_no` bigint NOT NULL,
  `answer_no` int NOT NULL,
  `answer_value` int NOT NULL DEFAULT '1',
  `reg_date` datetime NOT NULL,
  PRIMARY KEY (`event_no`,`user_no`,`answer_no`) USING BTREE,
  KEY `reg_date` (`reg_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `user_questionnaire_freely_answer` (
  `event_no` int NOT NULL,
  `user_no` bigint NOT NULL,
  `answer_no` int NOT NULL,
  `text` text NOT NULL,
  PRIMARY KEY (`event_no`,`user_no`,`answer_no`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;