Entity Diagram

The system revolves around two key components:

1. Campaign: A marketing initiative that can be either manual (started by users) or automatic (scheduled)

2. Campaign Execution: A specific run of a campaign that processes clients and tracks status

The basic workflow is straightforward:

• Create and activate a campaign

• The campaign executes (either manually triggered or automatically scheduled)

• The execution processes eligible clients

• The execution completes or encounters errors that can be handled

• Campaigns can be deactivated when no longer needed