> ## Documentation Index > Fetch the complete documentation index at: https://docs.superoffice.com/llms.txt > Use this file to discover all available pages before exploring further. # PushNotificationService table > Used for storing handles to user devices that should receive push notifications ## PushNotificationService Table (511) Used for storing handles to user devices that should receive push notifications ## Fields | Name | Description | Type | Nullable | | --------------------------- | -------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------------------------- | :------: | | pushnotificationservice\_id | Primary key | PK | No | | AssociateId | To whom does this handle belong | FK [associate](./associate.mdx) | No | | DeviceIdentifier | Unique device identifier | String(256) | No | | DeviceDisplayName | Userfriendly name for device. Ex: 'My iPhone 5S' | String(256) | Yes | | DevicePlatform | Device platform. Apple, Google, Microsoft, etc. | Enum [NotificationPlatform](./enums/notificationplatform.mdx) | No | | PNSHandle | The platform specific handle needed for pushing messages directly to this device | String(1024) | No | | Tags | Comma separated list of notification types this device should or should not receive notifications about. Ex: 'invitations=0,meetings=1 | String(3072) | Yes | | PNSHandleUpdateDate | When was the PNSHandle for this device last updated | DateTime | Yes | | LastNotificationDate | When was a notification last sent to this device | DateTime | Yes | | TotalNotificationCount | How many notifications have been sent to this device | Int | Yes | | registered | Registered when | UtcDateTime | No | | registered\_associate\_id | Registered by whom | FK [associate](./associate.mdx) | No | | updated | Last updated when | UtcDateTime | No | | updated\_associate\_id | Last updated by whom | FK [associate](./associate.mdx) | No | | updatedCount | Number of updates made to this record | UShort | No | | Language | The language to send translated messages in | String(256) | Yes | | PocketVersion | The version of Pocket CRM this device is using | String(256) | Yes | | OSVersion | The operating system version this device is using | String(256) | Yes | | TimeZoneId | The timezone to show for dates in messages | Int | Yes | PushNotificationService table relationship diagram ## Indexes | Fields | Types | Description | | ------ | ----- | ----------- | ## Relationships | Table | Description | | ------------------------ | ------------------------------------------------------------------ | | [associate](./associate) | Employees, resources and other users - except for External persons | ## Replication Flags * None ## Security Flags * No access control via user's Role. ## Related topics - [What's new in version 10.3.9.718](/release-notes/database/changes-10.3.9.md) - [What's new in version 10.5.1.1092](/release-notes/database/changes-10.5.1.md) - [What's new in version 10.5.2.435](/release-notes/database/changes-10.5.2.md) - [What's new in version 10.5.3.711](/release-notes/database/changes-10.5.3.md) - [What's new in version 10.5.4.867](/release-notes/database/changes-10.5.4.md) - [What's new in version 10.5.5.982](/release-notes/database/changes-10.5.5.md)