Database Schema

Tables and data models

Database Schema

Core Content Tables

Actions:

  • id, title, slug, description, content
  • icon, gradientClass, accentClass
  • published, displayOrder
  • approvalStatus, scheduledPublishAt

News:

  • id, title, slug, description, content
  • category, imageUrl
  • published, publishedAt
  • approvalStatus

Events:

  • id, title, slug, description, content
  • startDate, endDate, location
  • published, approvalStatus

User Management

StaffUser:

  • id, username, email, displayName
  • passwordHash

Role:

  • id, name, description
  • permissions (JSON string)

UserRole:

  • Junction table for user-role assignments

CRM Tables

Contact:

  • id, name, email, phone
  • status, progressionStage

ContactProgression:

  • Timeline entries for contact progression

ProgressionStage:

  • Custom progression stages

Related Guides

Edit this page
Overview
Database overview
Migrations
Creating and applying database migrations