We need to modify the existing incentive_activity table to support additional attributes as per the new requirement.

🔹 Table: incentive_activity

Add the following columns:

• 🔹 New / Updated Columns in incentive_activity

• • district_id → District mapping (can contain multiple IDs separated by comma if applicable)
  • role → Role associated with the activity (ASHA / ASHA Supervisor / Block Coordinator etc.)

• • activity_order → Serial/order number of the activity as per claim form (used for ordering activities)

• • location → Rural / Urban / both

• • type → Community / Institutional

🔹 Multi-Language Support

Create a new table m_incentive_activity_translation to store activity names and descriptions in multiple languages.
Fields required:

• id (PK)

• activity_id (FK → incentive_activity)
• language_code (EN / HI etc.)
• activity_description
• gorup_name

This structure will ensure:

• Unique activity tracking across state/district/role.

• Category-wise grouping of activities.

• Proper incentive mapping with FMR code and order serial.

• Serial/order number of the activity as per claim form (used for ordering activities)

• Multi-language support for activity display (English, Hindi, etc.).

• • 
    Table to be renamed:
• 
  From: db_iemr.incentive_activity
• 
  To: db_iemr.m_incentive_activity

Every Activity should be associated with activity unique code, State, District, Role (ASHA/ ASHA Supervisor/ Block Coordinator, etc), State activity code, FMR code, activity order serial number as per claim form, activity category (Child Health/ Immunization/ Maternal Health, etc), activity incentive amount, location (Rural/ Urban) and Type (Community/ Institutional).