11 months ago

Relationship with State(s)

Posted 11 months ago by geetpurwar


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.

Please sign in or create an account to participate in this conversation.