Rev 1306 | Go to most recent revision | Details | Compare with Previous | Last modification | View Log | RSS feed
| Rev | Author | Line No. | Line |
|---|---|---|---|
| 808 | jmachado | 1 | |
| 2 | -- |
||
| 3 | -- Definition of table `assessment` |
||
| 4 | -- |
||
| 5 | |||
| 6 | DROP TABLE IF EXISTS `assessment`; |
||
| 7 | CREATE TABLE `assessment` ( |
||
| 8 | `id` bigint(20) NOT NULL AUTO_INCREMENT, |
||
| 9 | `discriminator` varchar(255) NOT NULL, |
||
| 10 | `updateDate` datetime NOT NULL, |
||
| 11 | `title` varchar(255) DEFAULT NULL, |
||
| 12 | `type` varchar(255) DEFAULT NULL, |
||
| 13 | `year` varchar(255) DEFAULT NULL, |
||
| 14 | `semester` varchar(255) DEFAULT NULL, |
||
| 15 | `startDate` datetime DEFAULT NULL, |
||
| 16 | `endDate` datetime DEFAULT NULL, |
||
| 17 | `saveDate` datetime DEFAULT NULL, |
||
| 18 | `time` time DEFAULT NULL, |
||
| 19 | `timeExtra` time DEFAULT NULL, |
||
| 20 | `evaluationsIdentifier` varchar(255) DEFAULT NULL, |
||
| 21 | `identifier` varchar(255) DEFAULT NULL, |
||
| 22 | `status` varchar(255) DEFAULT NULL, |
||
| 23 | `statusPercentage` int(11) DEFAULT NULL, |
||
| 24 | `evaluationTime` varchar(255) DEFAULT NULL, |
||
| 25 | `owner` bigint(20) DEFAULT NULL, |
||
| 26 | `courseUnit` bigint(20) DEFAULT NULL, |
||
| 27 | PRIMARY KEY (`id`), |
||
| 28 | KEY `FK7E5336C252876F6F` (`owner`), |
||
| 29 | KEY `FK7E5336C2DF034EA4` (`courseUnit`), |
||
| 30 | CONSTRAINT `FK7E5336C2DF034EA4` FOREIGN KEY (`courseUnit`) REFERENCES `courseunit` (`id`), |
||
| 31 | CONSTRAINT `FK7E5336C252876F6F` FOREIGN KEY (`owner`) REFERENCES `user` (`id`) |
||
| 32 | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
||
| 33 | |||
| 34 | -- |
||
| 35 | -- Dumping data for table `assessment` |
||
| 36 | -- |
||
| 37 | |||
| 38 | |||
| 39 | -- |
||
| 40 | -- Definition of table `assessmentquestion` |
||
| 41 | -- |
||
| 42 | |||
| 43 | DROP TABLE IF EXISTS `assessmentquestion`; |
||
| 44 | CREATE TABLE `assessmentquestion` ( |
||
| 45 | `id` bigint(20) NOT NULL AUTO_INCREMENT, |
||
| 46 | `discriminator` varchar(255) NOT NULL, |
||
| 47 | `textpt` varchar(255) DEFAULT NULL, |
||
| 48 | `texten` varchar(255) DEFAULT NULL, |
||
| 49 | `type` varchar(255) DEFAULT NULL, |
||
| 50 | `quotation` double DEFAULT NULL, |
||
| 51 | `textExtra` varchar(255) DEFAULT NULL, |
||
| 52 | `textLimit` int(11) DEFAULT NULL, |
||
| 53 | `image` bigint(20) DEFAULT NULL, |
||
| 54 | `assessment` bigint(20) DEFAULT NULL, |
||
| 55 | PRIMARY KEY (`id`), |
||
| 56 | KEY `FK11B90A821B70CB0` (`image`), |
||
| 57 | KEY `FK11B90A8B2ABDFCA` (`assessment`), |
||
| 58 | CONSTRAINT `FK11B90A8B2ABDFCA` FOREIGN KEY (`assessment`) REFERENCES `assessment` (`id`), |
||
| 59 | CONSTRAINT `FK11B90A821B70CB0` FOREIGN KEY (`image`) REFERENCES `image` (`id`) |
||
| 60 | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
||
| 61 | |||
| 62 | -- |
||
| 63 | -- Dumping data for table `assessmentquestion` |
||
| 64 | -- |
||
| 65 | |||
| 66 | -- |
||
| 67 | -- Definition of table `assessmentquestionanswer` |
||
| 68 | -- |
||
| 69 | |||
| 70 | DROP TABLE IF EXISTS `assessmentquestionanswer`; |
||
| 71 | CREATE TABLE `assessmentquestionanswer` ( |
||
| 72 | `id` bigint(20) NOT NULL AUTO_INCREMENT, |
||
| 73 | `discriminator` varchar(255) NOT NULL, |
||
| 74 | `textAnswer` varchar(255) DEFAULT NULL, |
||
| 75 | `identifier` varchar(255) DEFAULT NULL, |
||
| 76 | `note` varchar(255) DEFAULT NULL, |
||
| 77 | `quotation` double DEFAULT NULL, |
||
| 78 | `evaluated` bit(1) DEFAULT NULL, |
||
| 79 | `possibleAnswer` bigint(20) DEFAULT NULL, |
||
| 80 | `response` bigint(20) DEFAULT NULL, |
||
| 81 | PRIMARY KEY (`id`), |
||
| 82 | KEY `FK6510B26670BADAA` (`response`), |
||
| 83 | KEY `FK6510B266F549A9AC` (`possibleAnswer`), |
||
| 84 | CONSTRAINT `FK6510B266F549A9AC` FOREIGN KEY (`possibleAnswer`) REFERENCES `assessmentquestionpossibleanswer` (`id`), |
||
| 85 | CONSTRAINT `FK6510B26670BADAA` FOREIGN KEY (`response`) REFERENCES `assessmentresponse` (`id`) |
||
| 86 | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
||
| 87 | |||
| 88 | -- |
||
| 89 | -- Dumping data for table `assessmentquestionanswer` |
||
| 90 | -- |
||
| 91 | |||
| 92 | -- |
||
| 93 | -- Definition of table `assessmentquestionitem` |
||
| 94 | -- |
||
| 95 | |||
| 96 | DROP TABLE IF EXISTS `assessmentquestionitem`; |
||
| 97 | CREATE TABLE `assessmentquestionitem` ( |
||
| 98 | `id` bigint(20) NOT NULL AUTO_INCREMENT, |
||
| 99 | `discriminator` varchar(255) NOT NULL, |
||
| 100 | `textpt` varchar(255) DEFAULT NULL, |
||
| 101 | `texten` varchar(255) DEFAULT NULL, |
||
| 102 | `question` bigint(20) DEFAULT NULL, |
||
| 103 | PRIMARY KEY (`id`), |
||
| 104 | KEY `FKF24477BBA4A1FCF4` (`question`), |
||
| 105 | CONSTRAINT `FKF24477BBA4A1FCF4` FOREIGN KEY (`question`) REFERENCES `assessmentquestion` (`id`) |
||
| 106 | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
||
| 107 | |||
| 108 | -- |
||
| 109 | -- Dumping data for table `assessmentquestionitem` |
||
| 110 | -- |
||
| 111 | |||
| 112 | -- |
||
| 113 | -- Definition of table `assessmentquestionpossibleanswer` |
||
| 114 | -- |
||
| 115 | |||
| 116 | DROP TABLE IF EXISTS `assessmentquestionpossibleanswer`; |
||
| 117 | CREATE TABLE `assessmentquestionpossibleanswer` ( |
||
| 118 | `id` bigint(20) NOT NULL AUTO_INCREMENT, |
||
| 119 | `discriminator` varchar(255) NOT NULL, |
||
| 120 | `textpt` varchar(255) DEFAULT NULL, |
||
| 121 | `texten` varchar(255) DEFAULT NULL, |
||
| 122 | `quotation` double DEFAULT NULL, |
||
| 123 | `correct` bit(1) DEFAULT NULL, |
||
| 124 | `questionItem` bigint(20) DEFAULT NULL, |
||
| 125 | PRIMARY KEY (`id`), |
||
| 126 | KEY `FKBEEF5B175906CD3A` (`questionItem`), |
||
| 127 | CONSTRAINT `FKBEEF5B175906CD3A` FOREIGN KEY (`questionItem`) REFERENCES `assessmentquestionitem` (`id`) |
||
| 128 | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
||
| 129 | |||
| 130 | -- |
||
| 131 | -- Dumping data for table `assessmentquestionpossibleanswer` |
||
| 132 | -- |
||
| 133 | |||
| 134 | -- |
||
| 135 | -- Definition of table `assessmentresponse` |
||
| 136 | -- |
||
| 137 | |||
| 138 | DROP TABLE IF EXISTS `assessmentresponse`; |
||
| 139 | CREATE TABLE `assessmentresponse` ( |
||
| 140 | `id` bigint(20) NOT NULL AUTO_INCREMENT, |
||
| 141 | `discriminator` varchar(255) NOT NULL, |
||
| 142 | `date` datetime DEFAULT NULL, |
||
| 143 | `answered` bit(1) DEFAULT NULL, |
||
| 144 | `evaluated` bit(1) DEFAULT NULL, |
||
| 145 | `quotation` double DEFAULT NULL, |
||
| 146 | `identifier` varchar(255) DEFAULT NULL, |
||
| 147 | `owner` bigint(20) DEFAULT NULL, |
||
| 148 | `assessment` bigint(20) DEFAULT NULL, |
||
| 149 | PRIMARY KEY (`id`), |
||
| 150 | KEY `FK3250690352876F6F` (`owner`), |
||
| 151 | KEY `FK32506903B2ABDFCA` (`assessment`), |
||
| 152 | CONSTRAINT `FK32506903B2ABDFCA` FOREIGN KEY (`assessment`) REFERENCES `assessment` (`id`), |
||
| 153 | CONSTRAINT `FK3250690352876F6F` FOREIGN KEY (`owner`) REFERENCES `user` (`id`) |
||
| 154 | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
||
| 155 | |||
| 156 | -- |
||
| 157 | -- Dumping data for table `assessmentresponse` |
||
| 158 | -- |