I need advise and solution for a use-case. I have built up a push notification service, which has multiple website (Model).
Each website has many Subscribers (Model) and many Notifications (Model). Each Notification has 4 states: Sent, Delivered, Clicked & Closed.
Now I need to setup a relationship between Notification & Subscriber of each Website, so I can create a queryScope where I can get specific subscribers who clicked Notification and who closed it.
I think pivot table might not be use here.
Please advise. Thanks.