tbl_question

-1 rows


Description

Module: Learning Management
Purpose: Stores question data for assessments.
Data: One row is created for each question associated with a specific assessment.
Process Usage:
- Used during the assessment process to present questions to users.
- Questions are mapped chapter-wise and connected to courses via assessments.
Key Points:
- Supports multiple question types (currently only MCQ is in use).
- Stores marks for each question for scoring purposes.
Business Impact: Enables structured assessment creation, scoring, and reporting in Learning Management.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
question_id bigserial 19 √ nextval('tbl_question_question_id_seq'::regclass)
tbl_answer.question_id tbl_answer_question_id_fkey C
tbl_option.question_id tbl_option_question_id_fkey C

Primary key
Format: BIGSERIAL (auto-increment)
Used as: Unique identifier for each question record.
assessment_id int8 19 null
tbl_assessment.assessment_id tbl_question_assessment_id_fkey C

Assessment ID
FK: public.tbl_assessment.assessment_id
Meaning: References the assessment to which this question belongs.
Usage: Links question data to a specific assessment for a course.
question_text text 2147483647 null

Question text
Meaning: Contains the full text of the question to be presented to the learner.
Usage: Rendered in the assessment UI for the user to answer.
question_type varchar 20 √ null

Possible Values: MCQ
Status: Currently only MCQ is used.
Usage: not used currently
marks int4 10 null

Meaning: Points assigned for a correct answer to this question.
Usage: Used in assessment scoring and result calculation.
createdby varchar 50 null
createddate timestamp 29,6 √ null
modifiedby varchar 50 √ null
modifieddate timestamp 29,6 √ null

Indexes

Constraint Name Type Sort Column(s)
tbl_question_pkey Primary key Asc question_id

Check Constraints

Constraint Name Constraint
tbl_question_question_type_check (((question_type)::text = ANY (ARRAY[('MCQ'::character varying)::text, ('SUBJECTIVE'::character varying)::text, ('MULTI_SELECT'::character varying)::text])))

Relationships

Close relationships within degrees of separation