Database Schema Overview

Core Data Models

The database is structured around several key domains defined in prisma/schema.prisma:

1. User & Authentication

User: The central identity model. Supports role-based access via the role field.

Account: Linked to User, stores OAuth provider data (access tokens, refresh tokens).

Session: Manages active user sessions.

2. Content Management (CMS)

DocArticle: A polymorphic model handling both System Documentation (type: "docs") and University SOPs (type: "university").

Fields: slug (unique identifier), category, content (Markdown), videoUrl.

BlogPost: Manages public-facing blog content with author relations.

FooterSection / FooterLink: Dynamically configurable footer navigation. Allows admins to update site links without code changes.

3. CRM & Business Logic

crm_Accounts: Represents business entities or client companies.

crm_Contacts: Individual people associated with Accounts.

crm_Opportunities: Tracks sales deals, value, and pipeline stages.

crm_Leads: Top-of-funnel prospects.

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.

Database Schema Overview

Database Schema Overview

Core Data Models

1. User & Authentication

2. Content Management (CMS)

3. CRM & Business Logic

Data seeding

Architecture

Core Concepts

Database

Development

Features

Getting Started

Guides

Integrations

Security

Theming