tbl_chapter

-1 rows


Description

Module: Learning Management
Purpose: Stores details of chapters within a course.
Process Usage:
- Each course consists of multiple chapters, and this table defines each chapter’s metadata and learning content.
- Used by the Learning Management System (LMS) to render video content, textual content, and related materials for learners.
Key Points:
- Linked to tbl_course to represent chapters belonging to a specific course.
- Stores video, thumbnail, and HTML-based learning materials.
- Maintains the display order for sequential course delivery.
Business Impact:
Supports structured learning delivery and modular content management for courses, enabling easy updates, tracking, and learner progress visualization.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
chapter_id bigserial 19 √ nextval('tbl_chapter_chapter_id_seq'::regclass)
tbl_assessment.chapter_id tbl_assessment_chapter_id_fkey C
tbl_chapter_progress.chapter_id tbl_chapter_progress_chapter_id_fkey C

Primary key
Format: VARCHAR (auto-incremented using tbl_chapter_chapter_id_seq)
Usage: Unique identifier for each chapter record.
course_id int8 19 null
tbl_course.course_id tbl_chapter_course_id_fkey C

Course ID
Meaning: References the parent course to which this chapter belongs.
Usage: Establishes a one-to-many relationship between course and chapters.
title varchar 200 null

Title
Meaning: Name of the chapter.
Usage: Displayed in the LMS course view to represent chapter identity.
content text 2147483647 √ null

Content
Meaning: Stores HTML-based learning material generated from the editor in the frontend.
Usage: Displayed as reading or theory content for the chapter.
order_no int4 10 null

Order Number
Meaning: Numeric position of the chapter within the course.
Usage: Determines the sequence of chapters during course playback or navigation.
video_url varchar 500 √ null

Video URL
Meaning: URL of the video resource associated with the chapter (YouTube or S3).
Usage: Used by the frontend video player for chapter content delivery.
thumbnail text 2147483647 √ null

Thumbnail
Meaning: URL of the uploaded thumbnail image stored in S3.
Usage: Used as a preview image for the chapter in UI lists and dashboards.
createdby varchar 50 null
createddate timestamp 29,6 √ null
modifiedby varchar 50 √ null
modifieddate timestamp 29,6 √ null
description text 2147483647 √ null

Description
Meaning: Short summary or additional notes describing the chapter.
Usage: Helps learners understand what the chapter covers.
duration int4 10 √ null

Duration (minutes)
Meaning: Time length of the chapter as defined by the user.
Usage: Used for progress tracking and learning analytics.

Indexes

Constraint Name Type Sort Column(s)
tbl_chapter_pkey Primary key Asc chapter_id

Relationships

Close relationships within degrees of separation