Database Architecture

D1 database and schema design

Database Architecture

Cloudflare D1

  • Serverless SQLite database
  • Automatic scaling
  • Edge deployment
  • Point-in-time recovery

Schema Design

Content Tables:

  • actions, news, events - Content types
  • custom_pages - Custom pages

User Management:

  • staff_users - User accounts
  • roles - Role definitions
  • user_roles - User-role assignments

CRM:

  • contacts - Contact records
  • progression_stages - Stages
  • contact_progression - Timeline entries

Relationships

  • One-to-many: Contact → Progression entries
  • Many-to-many: Content ↔ Tags
  • Foreign keys with cascade deletes

Migrations

  • Prisma schema management
  • SQL migration files
  • Version-controlled schema changes

Related Guides

Edit this page
Backend Architecture
Cloudflare Workers and API structure
Security Architecture
Authentication, authorization, and security