Description:

Define the complete database structure for the MSC website including all models (Member, Publication, ResearchArea, Collaborator, etc.) and their relationships. Set up the Prisma schema with proper indexing and create seed data for testing.

Tasks:

• Define all data models in prisma/schema.prisma
• Set up many-to-many relationships (Member ↔ Publication, Publication ↔ ResearchArea, etc.)
• Add indexes for frequently queried fields (DOI, slug, email, etc.)
• Create seed script with realistic test data
• Run migration and verify schema in Prisma Studio