tbl_chapter_history

-1 rows


Description

Module: Learning Management
Purpose: Stores historical snapshots of chapter details whenever updates occur.
Process Usage:
- Tracks changes made to chapters, such as title, content, or video updates.
- Used for auditing, rollback, or content version tracking purposes.
Key Points:
- Maintains historical versions of chapters without affecting active content.
- Contains all key chapter fields for accurate reconstruction of past states.
Business Impact:
Improves auditability and content governance by preserving historical versions of learning materials.

Columns

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

Primary Key
Format: BIGSERIAL
Usage: Unique identifier for each chapter history record.
chapter_id int8 19 √ null

Chapter ID
Meaning: References the original chapter record from tbl_chapter.
Usage: Identifies which chapter version this history entry corresponds to.
course_id int8 19 √ null

Course ID
Meaning: The parent course ID associated with the chapter.
Usage: Maintains reference integrity with the course to which the chapter belonged at the time of history creation.
title varchar 200 √ null

Title
Meaning: The chapter title at the time this historical record was created.
Usage: Allows viewing past names or titles after chapter updates.
content text 2147483647 √ null

Content
Meaning: The HTML content of the chapter stored during that historical snapshot.
Usage: Used for audit or rollback reference of previous content versions.
order_no int4 10 √ null

Order Number
Meaning: The display order of the chapter at the time this version was stored.
Usage: Helps retain original sequencing in audit logs.
video_url varchar 500 √ null

Video URL
Meaning: Video resource link associated with the chapter version.
Usage: Used for content versioning of video material.
thumbnail text 2147483647 √ null

Thumbnail
Meaning: S3 thumbnail image link associated with this historical version.
Usage: Maintains historical references to chapter preview images.
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_chapter_history_pkey Primary key Asc history_id

Relationships

Close relationships within degrees of separation