tbl_answer

-1 rows


Description

Module: Learning Management
Purpose: Contains history of selected option IDs for each question within an assessment attempt.
Data: One row is created for each question answered by a user during an assessment attempt.
Process Usage:
- Stores user-selected options for each question under a specific assessment attempt.
- Maintains a record of selections for audit, review, or analytical purposes.
- Data is retained for historical tracking and not actively used in calculations beyond scoring.
Key Points:
- Helps in reconstructing user responses for each attempt.
- Useful for debugging, reporting, or re-evaluation scenarios.
Business Impact: Provides transparency and traceability of user answers across assessments.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
answer_id bigserial 19 √ nextval('tbl_answer_answer_id_seq'::regclass)

Primary key
Format: BIGSERIAL (auto-increment)
Used as: Unique identifier for each answer record.
attempt_id int8 19 null
tbl_assessment_attempt.attempt_id tbl_answer_attempt_id_fkey C

FK: public.tbl_assessment_attempt.attempt_id
Meaning: References the assessment attempt to which this answer belongs.
Usage: Links all user answers to a specific assessment attempt.
Dependency: Ensures referential integrity between user attempts and their answers.
question_id int8 19 null
tbl_question.question_id tbl_answer_question_id_fkey C

FK: public.tbl_question.question_id
Meaning: References the specific question for which this answer was submitted.
Usage: Helps in identifying which question the user responded to within the attempt.
selected_option_id varchar 200 √ null

Stores the selected option(s) for the question.
Format: Comma-separated list of selected option IDs.
Usage: Used to capture user-selected responses for multiple-choice or multi-select questions.
answer_text text 2147483647 √ null

Optional text-based answer field.
Format: TEXT
Status: Currently unused.
Potential Use: May be used for subjective or descriptive type questions in future.
marks_awarded int4 10 √ null

Marks awarded for the question.
Format: INTEGER
Meaning: Represents the score obtained by the user for the particular question.
Usage: Used in result calculation and performance analysis.

Indexes

Constraint Name Type Sort Column(s)
tbl_answer_pkey Primary key Asc answer_id

Relationships

Close relationships within degrees of separation