如何管理数据库中用户帐户的多个推送通知设备标识符？ [关闭]

Question

I'm trying to create a REST API system in PHP Symfony2 for a website and apps for iOS, Android and Windows Phone.

I'm actually thinking about the database table for the devices of the user, because he may have multiple devices.

So, my solution for now is to create an array of devices for the user. The device table contain the type of the device (iPhone, iPad, Nexus, Nokia, etc), the device push identifier, the OS (iOS, Android, Windows Phone), and the user id.

But I don't know if is the good way, so what do you think ?

Thanks

Answer 1

I think that's a good approach, but I'm not sure whether it is important to keep track of the Device Type?

My approach would be:

User (table)
    UserId
    UserName
    ...

Devices (table)
    OSType
    DevicePushId
    UserId

You would only need to know the OS type since each OS handles notifications differently. But knowing whether the device is an iPad vs iPhone is not as important unless you are going to be sending different types of notifications/content dependent on whether they have a phone or a tablet.