Task #7
openCreate masters for Question Topics and Question Bank
0%
Description
Create master tables and related logic for managing question topics and question bank.
Create question_topics_table with fields: id, topic_name, created_at
Create question_bank_table with fields: id, topic_id, question-varchar, option1-varchar, option2-varchar, option3-varchar, option4-varchar, answer-varchar, created_at
Ensure questions are mapped to topics
Updated by Dana Basheer about 2 months ago · Edited
1.question_topics_table
id – Unique identifier for each topic
topic_name – Name of the question topic (e.g., Math, Science)
created_at – Date and time when the topic is created
- question_bank_table
id – Unique identifier for each question
topic_id – Reference to the related question topic
question – Question text
option1 – option4 – Multiple choice answer options
answer – Correct answer (must match one of the options)
created_at – Date and time when the question is created
Updated by Gokul G about 2 months ago
- Status changed from In Progress to Resolved