Course General Overview
Relationship Diagram
Course
Links to categories, body types, material types, awareness levels, and videos through various relationships. Serves as the central model for educational content.
Category
Has a many-to-many relationship with courses through CategoryCourse pivot table. Supports hierarchical structure with parent/child relationships.
CategoryCourse Model (Pivot)
Manages the many-to-many relationship between courses and categories.
BodyType
Has a many-to-many relationship with courses through body_type_course pivot table.
MaterialType
Has a many-to-many relationship with courses through course_material_type pivot table.
AwarenessLevel
Has a many-to-many relationship with courses through awareness_level_course pivot table.
Video
Belongs to a course and has many notes and watched_videos. Tracks video content and user interaction.
Tag
Has a polymorphic many-to-many relationship with courses through the taggable pivot table. Tags can be used to categorize and filter courses with specific attributes like name and color.