Skip to main content
The application uses TypeORM with PostgreSQL as the primary database and ClickHouse for analytics.

​
Reactivate Module Entities

​
Users & Brands

EntityDescription
UserEntityUser accounts for the Reactivate module
BrandSegmentDefinitionEntityCustomer segment definitions per brand
BrandVariableEntityBrand-specific AI prompt variables
GlobalVariableEntitySystem-level prompt variables
BrandExclusionListEntityCustomer exclusion lists
BrandProductGridTemplateEntityEmail product grid layout templates

​
Email & Campaigns

EntityDescription
EmailEntityEmail templates and campaigns
EmailEventEntityEmail delivery and engagement tracking (opens, clicks, bounces)
SequenceEntityEmail sequence definitions (automated flows)
SequenceRequestEntityAI-generated email copy requests
CampaignTextBlockEntityEmail content blocks
PromotionEntityPromotional content for campaigns
SequenceExclusionListEntityPer-sequence customer opt-outs
SequenceUnsubscribeCacheEntityUnsubscribe cache for fast lookups

​
Content Generation

EntityDescription
BannerGenerationEntityBanner image generation requests and results
HeroGenerationEntityHero section template generation
ModuleSourceImageEntityImage assets for email modules
ResearchSessionEntityAI research agent sessions
ProductRecommendationResultEntityAI-driven product recommendations
SurveyEntityCustomer survey definitions

​
Integration

EntityDescription
IntegrationEntityThird-party service integrations
ClientEntityAPI client configurations
ExternalAccountEntityConnected email accounts (Outlook, Gmail)
EmailVerificationTokenEntityEmail verification flows
WebhookEventEntityWebhook event logs
WaitlistItemEntityReactivate module waitlist

​
Core Entities

EntityDescription
CustomerCustomer account with profile data
RetailerStore/merchant configuration
AdminUserAdmin panel user accounts
PortalUserMerchant portal user accounts
ApiKeyAPI authentication tokens linked to retailers

​
Database Migrations

PostgreSQL migrations are stored in db/postgres/migrations/. ClickHouse migrations are in db/clickhouse/ for analytics tables.

​
Migration Commands

# Generate a new migration from entity changes
npm run typeorm:generate-migration -- -n MigrationName

# Run pending migrations
npm run typeorm:run-migrations

# Revert the last migration
npm run typeorm:revert-migration