FZjuJWLx

1CREATE  TABLE IF NOT EXISTS `DAHMS`.`Answers` (
2  `aid` INT(11) NOT NULL AUTO_INCREMENT ,
3  `qid` INT(11) NOT NULL ,
4  `sid` INT(11) NOT NULL ,
5  `answer` VARCHAR(45) NOT NULL ,
6  PRIMARY KEY (`aid`) ,
7  INDEX `fk_Answers_Session1_idx` (`sid` ASC) ,
8  INDEX `fk_Answers_Questions1_idx` (`qid` ASC) ,
9  CONSTRAINT `fk_Answers_Session1`
10    FOREIGN KEY (`sid` )
11    REFERENCES `DAHMS`.`Session` (`sid` )
12    ON DELETE NO ACTION
13    ON UPDATE NO ACTION,
14  CONSTRAINT `fk_Answers_Questions1`
15    FOREIGN KEY (`qid` )
16    REFERENCES `DAHMS`.`Questions` (`qid` )
17    ON DELETE NO ACTION
18    ON UPDATE NO ACTION)
19ENGINE = InnoDB
20DEFAULT CHARACTER SET = latin1
21COLLATE = latin1_swedish_ci