PushNotificationService Table (511)
Used for storing handles to user devices that should receive push notificationsFields
| Name | Description | Type | Nullable |
|---|---|---|---|
| pushnotificationservice_id | Primary key | PK | No |
| AssociateId | To whom does this handle belong | FK associate | 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 | 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 | No |
| updated | Last updated when | UtcDateTime | No |
| updated_associate_id | Last updated by whom | FK associate | 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 |
Indexes
| Fields | Types | Description |
|---|
Relationships
| Table | Description |
|---|---|
| associate | Employees, resources and other users - except for External persons |
Replication Flags
- None
Security Flags
- No access control via user’s Role.