Database
Database Schema Overview
Database Schema Overview
Core Data Models
The database is structured around several key domains defined in prisma/schema.prisma:
1. User & Authentication
role field.User, stores OAuth provider data (access tokens, refresh tokens).2. Content Management (CMS)
type: "docs") and University SOPs (type: "university").slug (unique identifier), category, content (Markdown), videoUrl.3. CRM & Business Logic
Data seeding
The prisma/seeds directory contains JSON datasets (docs.json, university.json) and a seed.ts script. This allows for rapid environment reset and consistent development data.

