qDraJ3n8

1CREATE TABLE IF NOT EXISTS `mydb`.`Authors` (
2  `Author_ID` INT NOT NULL AUTO_INCREMENT,
3  `Paper_ID` VARCHAR(45) NULL,
4  `Affiliations` VARCHAR(45) NULL,
5  `Email` VARCHAR(45) NULL,
6  `Papers_Paper_ID` INT NOT NULL,
7  PRIMARY KEY (`Author_ID`, `Papers_Paper_ID`),
8  INDEX `fk_Authors_Papers1_idx` (`Papers_Paper_ID` ASC),
9  CONSTRAINT `fk_Authors_Papers1`
10    FOREIGN KEY (`Papers_Paper_ID`)
11    REFERENCES `mydb`.`Papers` (`Paper_ID`)
12    ON DELETE NO ACTION
13    ON UPDATE NO ACTION);
14
15CREATE TABLE IF NOT EXISTS `mydb`.`Papers` (
16  `Paper_ID` INT NOT NULL AUTO_INCREMENT,
17  `Abstract` VARCHAR(45) NULL,
18  `PDF` BLOB NULL,
19  PRIMARY KEY (`Paper_ID`));
20
21CREATE TABLE IF NOT EXISTS `mydb`.`Papers_has_PC_Members` (
22  `Paper_ID` INT NOT NULL,
23  `PC_ID` INT NOT NULL,
24  PRIMARY KEY (`Paper_ID`, `PC_ID`),
25  INDEX `fk_Papers_has_PC_Members_PC_Members1_idx` (`PC_ID` ASC),
26  INDEX `fk_Papers_has_PC_Members_Papers1_idx` (`Paper_ID` ASC),
27  CONSTRAINT `fk_Papers_has_PC_Members_Papers1`
28    FOREIGN KEY (`Paper_ID`)
29    REFERENCES `mydb`.`Papers` (`Paper_ID`)
30    ON DELETE NO ACTION
31    ON UPDATE NO ACTION,
32  CONSTRAINT `fk_Papers_has_PC_Members_PC_Members1`
33    FOREIGN KEY (`PC_ID`)
34    REFERENCES `mydb`.`PC_Members` (`PC_ID`)
35    ON DELETE NO ACTION
36    ON UPDATE NO ACTION);
37
38CREATE TABLE IF NOT EXISTS `mydb`.`PC_Members` (
39  `PC_ID` INT NOT NULL,
40  `Review_Reports_Report_ID` INT NOT NULL,
41  PRIMARY KEY (`PC_ID`),
42  INDEX `fk_PC_Members_Review_Reports1_idx` (`Review_Reports_Report_ID` ASC),
43  CONSTRAINT `fk_PC_Members_Review_Reports1`
44    FOREIGN KEY (`Review_Reports_Report_ID`)
45    REFERENCES `mydb`.`Review_Reports` (`Report_ID`)
46    ON DELETE NO ACTION
47    ON UPDATE NO ACTION);
48
49CREATE TABLE IF NOT EXISTS `mydb`.`Review_Reports` (
50  `Report_ID` INT NOT NULL,
51  `Review_Description` TEXT(300) NULL,
52  `Final_Rec` CHAR(1) NULL,
53  `Date_Submitted` DATETIME NULL,
54  PRIMARY KEY (`Report_ID`));