Schema

EmailCampaign

Email campaign — manual or workflow-triggered. Tracks send/open/click/bounce funnel per customer.

15 fields8 relationships

Fields

Name	Type	Req	Description
id	uuid	yes	Campaign UUID.
name	string	yes	Internal campaign name.
subject	string	—	Email subject.
status	enum	—	draft \| scheduled \| sending \| sent \| cancelled.
type	enum	—	manual \| automated.
is_automated	boolean	—	Workflow-triggered.
sent_at	datetime	—	Dispatched.
created_at	datetime	yes	Created.
org_id	uuid	yes	Owning organisation.
send_count	number	—	Total recipients.
open_count	number	—	Total opens.
click_count	number	—	Total clicks.
bounce_count	number	—	Total bounces.
open_rate	number	—	Open rate 0–1.
click_rate	number	—	Click rate 0–1.

Outbound (6)

EmailCampaign[:BELONGS_TO]→Organization
EmailCampaign[:TARGETS_SEGMENT]→Segment
EmailCampaign[:DROVE_REVENUE]→Venueattributed_bookings, attributed_covers, attributed_revenue_pennies, conversion_rate, computed_at — AI computed
EmailCampaign[:CAMPAIGN_DROVE_WIFI]→Venuerecipients_who_visited, wifi_sessions_generated, foot_traffic_rate, computed_at — AI computed
EmailCampaign[:MARKETING_REACTIVATION]→Organizationreactivated_customers, reactivation_sessions, reactivation_rate, computed_at — AI computed
EmailCampaign[:CAMPAIGN_REVIEW_IMPACT]→Organizationreviews_generated, unique_reviewers, avg_rating, avg_sentiment, review_rate, computed_at — AI computed

Inbound (2)