push_notifications

This table is used to store push notification events and users receives these events and action performed on notification

Model

Field	Type	Nullable	Constraints
id	int4	No
user_id	int4	Yes	Foreign key
created_at	timestamp	No
updated_at	timestamp	No
clicked_at	timestamp	Yes
notifications	json	No
event	varchar	Yes

Description of fields

id

user_id

This is user unique identifier for which notification is sent

created_at

updated_at

clicked_at

Timestamp when the user clicked on the notification

notifications

This is json data include notification title and notification message

event

name of the event