QuestionAnsweringSystem/deep-qa/src/main/resources/mysql/questionanswer_fulltext.sql at master · javamickey/QuestionAnsweringSystem · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
CREATE DATABASE questionanswer_fulltext;

USE questionanswer_fulltext;

CREATE  TABLE `questionanswer_fulltext`.`question` (

  `id` INT NOT NULL AUTO_INCREMENT ,

  `question` VARCHAR(200)  NOT NULL ,

  PRIMARY KEY (`id`) ,

  UNIQUE INDEX `question_UNIQUE` (`question` ASC) );

CREATE  TABLE `questionanswer_fulltext`.`evidence` (

  `id` INT NOT NULL AUTO_INCREMENT ,

  `title` VARCHAR(445) NOT NULL ,

  `snippet` TEXT NOT NULL ,

  `question` INT NOT NULL ,

  PRIMARY KEY (`id`) ,

  INDEX `question_idx` (`question` ASC) ,

  CONSTRAINT `question`

    FOREIGN KEY (`question` )

    REFERENCES `questionanswer_fulltext`.`question` (`id` )

    ON DELETE NO ACTION

    ON UPDATE NO ACTION);

CREATE  TABLE `questionanswer`.`rewind` (

  `id` INT NOT NULL AUTO_INCREMENT ,

  `question` VARCHAR(445) NOT NULL ,

  `text` TEXT NOT NULL ,

  PRIMARY KEY (`id`) ,

  UNIQUE INDEX `id_UNIQUE` (`id` ASC) );