Subversion Repositories bacoAlunos

--
-- 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`
--