VIDYARTI

Create a Syllabus Master module where admin can:

• Add syllabus based on course
• Define topics / subtopics for each course
• Manage (add, edit, delete) syllabus entries

Also implement a public view:

• Users can view syllabus course-wise
• Display in a structured format (Module → Topics)

Table

vid_course_master

• id INT (PK) Course ID
• course_name VARCHAR(150) Name of course
• description TEXT Course description
• status BOOLEAN Active/Inactive
• created_at DATETIME Created date

vid_syllabus_master

• id INT (PK) Syllabus ID
• course_id INT (FK) Reference to course
• module_name VARCHAR(150) Module/Section name
• topic_name VARCHAR(200) Topic name
• sub_topic TEXT Sub topic details
• display_order INT Order of display
• status BOOLEAN Active/Inactive
• created_at DATETIME Created date
• updated_at DATETIME Updated date

Validations

Backend

• course_id must exist (FK constraint)
• module_name cannot be empty
• topic_name cannot be empty
• display_order must be a positive number
• Prevent duplicate:

Frontend

Required fields:

• Course
• Module Name
• Topic Name
• Display order should accept only numbers
• Show error if duplicate entry attempt