tbl_chapter_progress

-1 rows


Description

Module: Learning Management
Purpose: Contains progression details of users on a chapter-wise basis.
Data: One row is created for each user and each chapter to track completion and time spent.
Process Usage:
- Stores whether a chapter is completed by the user.
- Tracks how much time a user spent on a chapter or associated video.
- Helps determine overall course progression and engagement metrics.
Key Points:
- Maps to enrollment and chapter tables for accurate tracking.
- Supports both page-based and video-based time tracking.
Business Impact: Enables progress monitoring, course completion tracking, and analytics for Learning Management.

Columns

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

Primary key
Format: BIGSERIAL (auto-increment)
Used as: Unique identifier for each chapter progress record.
enrollment_id int8 19 null
tbl_enrollment.enrollment_id tbl_chapter_progress_enrollment_id_fkey C

FK: public.tbl_enrollment.enrollment_id
Meaning: References the enrollment of the user.
Usage: Maps the chapter progress to a specific user enrollment.
Dependency: Ensures tracking is tied to valid enrollments.
chapter_id int8 19 null
tbl_chapter.chapter_id tbl_chapter_progress_chapter_id_fkey C

FK: public.tbl_chapter.chapter_id
Meaning: References the chapter for which progress is being tracked.
Usage: Links progress data to a specific chapter in the course.
completed bool 1 √ false

Chapter completion flag
Format: BOOLEAN (default: false)
Meaning: Indicates whether the user has completed the chapter.
Usage: Used to determine progress and eligibility for subsequent content.
completed_at timestamp 29,6 √ null

Timestamp when the chapter was completed.
Format: TIMESTAMP
Meaning: Records the exact time of chapter completion.
Usage: Supports reporting and time-based analytics on user progression.
progress numeric 8,2 √ null

Time spent on the chapter page.
Format: NUMERIC(8,2)
Meaning: Minutes spent by the user on the chapter content.
Usage: Tracks engagement and helps determine if the chapter is sufficiently completed.
video_progress numeric 8,2 √ null

Time spent on chapter video content.
Format: NUMERIC(8,2)
Meaning: Minutes spent by the user watching the chapter video.
Usage: Supports video-based engagement tracking and overall completion metrics.

Indexes

Constraint Name Type Sort Column(s)
tbl_chapter_progress_pkey Primary key Asc progress_id

Relationships

Close relationships within degrees of separation