Rev 808 |
Go to most recent revision |
Blame |
Compare with Previous |
Last modification |
View Log
| RSS feed
--
-- Definition of table `assessment`
--
DROP TABLE IF EXISTS `assessment`;
CREATE TABLE `assessment` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`discriminator` varchar(255) NOT NULL,
`updateDate` datetime NOT NULL,
`title` varchar(255) DEFAULT NULL,
`type` varchar(255) DEFAULT NULL,
`year` varchar(255) DEFAULT NULL,
`semester` varchar(255) DEFAULT NULL,
`startDate` datetime DEFAULT NULL,
`endDate` datetime DEFAULT NULL,
`saveDate` datetime DEFAULT NULL,
`time` time DEFAULT NULL,
`timeExtra` time DEFAULT NULL,
`evaluationsIdentifier` varchar(255) DEFAULT NULL,
`identifier` varchar(255) DEFAULT NULL,
`status` varchar(255) DEFAULT NULL,
`statusPercentage` int(11) DEFAULT NULL,
`evaluationTime` varchar(255) DEFAULT NULL,
`owner` bigint(20) DEFAULT NULL,
`courseUnit` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `FK7E5336C252876F6F` (`owner`),
KEY `FK7E5336C2DF034EA4` (`courseUnit`),
CONSTRAINT `FK7E5336C2DF034EA4` FOREIGN KEY (`courseUnit`) REFERENCES `courseunit` (`id`),
CONSTRAINT `FK7E5336C252876F6F` FOREIGN KEY (`owner`) REFERENCES `user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `assessment`
--
--
-- Definition of table `assessmentquestion`
--
DROP TABLE IF EXISTS `assessmentquestion`;
CREATE TABLE `assessmentquestion` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`discriminator` varchar(255) NOT NULL,
`textpt` varchar(255) DEFAULT NULL,
`texten` varchar(255) DEFAULT NULL,
`type` varchar(255) DEFAULT NULL,
`quotation` double DEFAULT NULL,
`textExtra` varchar(255) DEFAULT NULL,
`textLimit` int(11) DEFAULT NULL,
`image` bigint(20) DEFAULT NULL,
`assessment` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `FK11B90A821B70CB0` (`image`),
KEY `FK11B90A8B2ABDFCA` (`assessment`),
CONSTRAINT `FK11B90A8B2ABDFCA` FOREIGN KEY (`assessment`) REFERENCES `assessment` (`id`),
CONSTRAINT `FK11B90A821B70CB0` FOREIGN KEY (`image`) REFERENCES `image` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `assessmentquestion`
--
--
-- Definition of table `assessmentquestionanswer`
--
DROP TABLE IF EXISTS `assessmentquestionanswer`;
CREATE TABLE `assessmentquestionanswer` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`discriminator` varchar(255) NOT NULL,
`textAnswer` varchar(255) DEFAULT NULL,
`identifier` varchar(255) DEFAULT NULL,
`note` varchar(255) DEFAULT NULL,
`quotation` double DEFAULT NULL,
`evaluated` bit(1) DEFAULT NULL,
`possibleAnswer` bigint(20) DEFAULT NULL,
`response` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `FK6510B26670BADAA` (`response`),
KEY `FK6510B266F549A9AC` (`possibleAnswer`),
CONSTRAINT `FK6510B266F549A9AC` FOREIGN KEY (`possibleAnswer`) REFERENCES `assessmentquestionpossibleanswer` (`id`),
CONSTRAINT `FK6510B26670BADAA` FOREIGN KEY (`response`) REFERENCES `assessmentresponse` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `assessmentquestionanswer`
--
--
-- Definition of table `assessmentquestionitem`
--
DROP TABLE IF EXISTS `assessmentquestionitem`;
CREATE TABLE `assessmentquestionitem` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`discriminator` varchar(255) NOT NULL,
`textpt` varchar(255) DEFAULT NULL,
`texten` varchar(255) DEFAULT NULL,
`question` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `FKF24477BBA4A1FCF4` (`question`),
CONSTRAINT `FKF24477BBA4A1FCF4` FOREIGN KEY (`question`) REFERENCES `assessmentquestion` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `assessmentquestionitem`
--
--
-- Definition of table `assessmentquestionpossibleanswer`
--
DROP TABLE IF EXISTS `assessmentquestionpossibleanswer`;
CREATE TABLE `assessmentquestionpossibleanswer` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`discriminator` varchar(255) NOT NULL,
`textpt` varchar(255) DEFAULT NULL,
`texten` varchar(255) DEFAULT NULL,
`quotation` double DEFAULT NULL,
`correct` bit(1) DEFAULT NULL,
`questionItem` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `FKBEEF5B175906CD3A` (`questionItem`),
CONSTRAINT `FKBEEF5B175906CD3A` FOREIGN KEY (`questionItem`) REFERENCES `assessmentquestionitem` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `assessmentquestionpossibleanswer`
--
--
-- Definition of table `assessmentresponse`
--
DROP TABLE IF EXISTS `assessmentresponse`;
CREATE TABLE `assessmentresponse` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`discriminator` varchar(255) NOT NULL,
`date` datetime DEFAULT NULL,
`answered` bit(1) DEFAULT NULL,
`evaluated` bit(1) DEFAULT NULL,
`quotation` double DEFAULT NULL,
`identifier` varchar(255) DEFAULT NULL,
`owner` bigint(20) DEFAULT NULL,
`assessment` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `FK3250690352876F6F` (`owner`),
KEY `FK32506903B2ABDFCA` (`assessment`),
CONSTRAINT `FK32506903B2ABDFCA` FOREIGN KEY (`assessment`) REFERENCES `assessment` (`id`),
CONSTRAINT `FK3250690352876F6F` FOREIGN KEY (`owner`) REFERENCES `user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `assessmentresponse`
--