VIDYARTI

Create a Current Affairs Master module where admin can:

• Add daily current affairs
• Categorize (e.g., National, International, Economy, Sports, etc.)
• Attach description, date, region, category and image/reference

Also implement a public view:

• Users can browse current affairs date-wise / category-wise
• Useful for daily study and mock preparation

Table

vid_content_region_master

• id INT (PK) Region ID
• region_name VARCHAR(100) Region name (Kerala, India, International)
• status BOOLEAN Active/Inactive
• created_at DATETIME Created date

vid_current_affairs_master

• id INT (PK) Current affair ID
• title VARCHAR(200) Headline/title
• description TEXT Detailed content
• category VARCHAR(100) Category (National, Sports, etc.)
• region_id INT (FK) Reference to content region
• affair_date DATE Date of news
• image VARCHAR(255) Optional image path
• reference_link VARCHAR(255) Optional source link
• status BOOLEAN Active/Inactive
• created_at DATETIME Created date
• updated_at DATETIME Updated date

Validations

Backend

• title → required
• description → required
• affair_date → cannot be future
• region_id → must exist in region master
• category → required
• reference_link → valid URL (if provided)
• Prevent duplicate

Frontend

Required fields:

• Title
• Description
• Date
• Category
• Region

Dropdown for:

• Category
• Region
• Date picker restrict future
• Image preview before upload