[sql] AB
Viewer
- CREATE TABLE `QuestionSet` (
- `id` INT PRIMARY KEY,
- `question_set_id` INT,
- `title` VARCHAR(255),
- `short_tile` VARCHAR(255),
- `product_identifier` VARCHAR(255),
- `description` VARCHAR(255),
- `created_at` TIMESTAMP,
- `updated_at` TIMESTAMP,
- `is_iap` bool,
- `is_mcq` bool,
- `original_prufung` bool,
- `url` VARCHAR(255),
- `area` VARCHAR(255),
- `question_count` INT,
- `weight` INT,
- `app_name` VARCHAR(255)
- );
- CREATE TABLE `Questions` (
- `id` INT PRIMARY KEY,
- `question_set_id` INT,
- `question_id` INT,
- `body` VARCHAR(255),
- `answer_conmment` VARCHAR(255),
- `display_order` INT,
- `box_no` INT
- );
- CREATE TABLE `Options` (
- `id` INT PRIMARY KEY,
- `question_id` INT,
- `body` VARCHAR(255),
- `isCorrect` bool,
- `display_order` INT
- );
- CREATE TABLE `Session` (
- `sessionId` INT PRIMARY KEY,
- `question_set_id` INT,
- `product_identifier` VARCHAR(255),
- `quizType` VARCHAR(255),
- `startTime` TIMESTAMP,
- `durationOfQuiz` INT,
- `anlytics_id` INT
- );
- CREATE TABLE `Percentage` (
- `id` INT PRIMARY KEY,
- `total` INT,
- `noOfAnswered` INT,
- `noOfRight` INT,
- `noOfWrong` INT
- );
- CREATE TABLE `Statiastics` (
- `id` INT PRIMARY KEY,
- `question_set_id` INT,
- `startTime` TIMESTAMP,
- `duration` INT,
- `noOfRight` INT,
- `noOfWrong` INT,
- `noOfUnaswered` INT,
- `totalQuestion` INT
- );
- CREATE TABLE `GivenQuestionAnswer` (
- `id` INT PRIMARY KEY,
- `session_id` INT,
- `question_id` INT,
- `isCorrect` bool
- );
- CREATE TABLE `SelectedOptions` (
- `id` INT PRIMARY KEY,
- `give_answer_id` INT,
- `body` VARCHAR(255),
- `isCorrect` bool,
- `checked` bool
- );
- ALTER TABLE `Questions` ADD FOREIGN KEY (`question_set_id`) REFERENCES `QuestionSet` (`question_set_id`);
- ALTER TABLE `Options` ADD FOREIGN KEY (`question_id`) REFERENCES `Questions` (`question_id`);
- ALTER TABLE `Session` ADD FOREIGN KEY (`question_set_id`) REFERENCES `QuestionSet` (`question_set_id`);
- ALTER TABLE `Session` ADD FOREIGN KEY (`anlytics_id`) REFERENCES `Percentage` (`id`);
- ALTER TABLE `Statiastics` ADD FOREIGN KEY (`question_set_id`) REFERENCES `QuestionSet` (`question_set_id`);
- ALTER TABLE `GivenQuestionAnswer` ADD FOREIGN KEY (`session_id`) REFERENCES `Session` (`sessionId`);
- ALTER TABLE `GivenQuestionAnswer` ADD FOREIGN KEY (`question_id`) REFERENCES `Questions` (`id`);
- ALTER TABLE `SelectedOptions` ADD FOREIGN KEY (`give_answer_id`) REFERENCES `GivenQuestionAnswer` (`id`);
Editor
You can edit this paste and save as new: