Slide 10
Slide 10 text
answer_detailテーブル
10
CREATE TABLE `answer_detail` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`answer_id` int(11) DEFAULT NULL,
`questionnaire_item_id` int(11) DEFAULT NULL,
`input` longtext,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `questionnaire_item_answer_idx`
(`answer_id`,`questionnaire_item_id`),
KEY `IDX_DCFF4534AA334807` (`answer_id`),
KEY `IDX_DCFF45344DF37C59` (`questionnaire_item_id`),
CONSTRAINT `FK_DCFF45344DF37C59` FOREIGN KEY
(`questionnaire_item_id`) REFERENCES `questionnaire_item` (`id`),
CONSTRAINT `FK_DCFF4534AA334807` FOREIGN KEY (`answer_id`) REFERENCES
`answer` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8