tbl_assessment

-1 rows


Description

Module: Learning Management
Purpose: Stores assessment details for chapters within a course.
Data: Each row represents an assessment linked to a specific chapter.
Process Usage:
- Defines assessment information for chapters in the Learning Management module.
- Used to connect with the question table (tbl_question) to define assessment questions.
Key Points:
- Ensures structured evaluation for each learning chapter.
- Supports pass/fail configuration and grading criteria.
Business Impact: Provides a foundation for measuring learner understanding and performance within each course chapter.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
assessment_id bigserial 19 √ nextval('tbl_assessment_assessment_id_seq'::regclass)
tbl_assessment_attempt.assessment_id tbl_assessment_attempt_assessment_id_fkey C
tbl_question.assessment_id tbl_question_assessment_id_fkey C

Primary key
Format: BIGSERIAL (auto-increment)
Used as: Unique identifier for each assessment record.
chapter_id int8 19 null
tbl_chapter.chapter_id tbl_assessment_chapter_id_fkey C

Chapter ID
Meaning: References the chapter to which this assessment belongs.
Usage: Links the assessment to its parent chapter record in tbl_chapter.
title varchar 200 null

Title
Meaning: The name or title of the assessment.
Usage: Displayed to users as the label or heading for the assessment.
instructions text 2147483647 √ null

Instructions
Meaning: Additional details or guidelines for completing the assessment.
Usage: Displayed to users before they begin the assessment.
total_marks int4 10 √ null

Total Marks
Meaning: Specifies the maximum score that can be obtained in the assessment.
Usage: Used to calculate performance and pass/fail results.
fail_config varchar 50 √ null

Fail Configuration
Status: Present in code but currently unused.
Purpose: Reserved for future configuration related to failure handling or conditions.
passing_marks int4 10 √ null

Passing Marks
Meaning: The minimum marks required to pass the assessment.
Usage: Used to determine if a learner has successfully cleared the assessment.
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_assessment_pkey Primary key Asc assessment_id

Relationships

Close relationships within degrees of separation