🧾 Title

Add a Follow model to enable users to follow each other (Many-to-Many relationship)

🧠 Description

Implement a many-to-many self-referential relationship in the User model to allow users to follow and be followed by other users.

Create a Follow mapping table that maintains follower and following relationships with appropriate indexes and unique constraints to prevent duplicate follows.

📦 Acceptance Criteria

• [ ] A new Follow model is created.
• [ ] The model connects two User entities (follower and following).
• [ ] The relationship is many-to-many and self-referential.
• [ ] Duplicate follow entries (same follower-following pair) are prevented with a unique constraint.
• [ ] Proper indexes are added for efficient querying (e.g., follower/following lookups).
• [ ] Prisma schema is updated and migration is successful.
• [ ] Relationship fields (followers and following) are reflected in the User model.

Solution