PushNotificationService Table (494)

•
Environment: onsite, online
• 2 minutes to read
 • 2 minutes to read

Used for storing handles to user devices that should receive push notifications

Fields

Name Description Type Null
pushnotificationservice_id Primary key PK
AssociateId To whom does this handle belong FK associate
DeviceIdentifier Unique device identifier String(256)
DeviceDisplayName Userfriendly name for device. Ex: 'My iPhone 5S' String(256) ●
DevicePlatform Device platform. Apple, Google, Microsoft, etc. Enum NotificationPlatform
PNSHandle The platform specific handle needed for pushing messages directly to this device String(1024)
Tags Comma separated list of notification types this device should or should not receive notifications about. Ex: 'invitations=0,meetings=1 String(3072) ●
PNSHandleUpdateDate When was the PNSHandle for this device last updated DateTime ●
LastNotificationDate When was a notification last sent to this device DateTime ●
TotalNotificationCount How many notifications have been sent to this device Int ●
registered Registered when UtcDateTime
registered_associate_id Registered by whom FK associate
updated Last updated when UtcDateTime
updated_associate_id Last updated by whom FK associate
updatedCount Number of updates made to this record UShort
Language The language to send translated messages in String(256) ●
PocketVersion The version of Pocket CRM this device is using String(256) ●
OSVersion The operating system version this device is using String(256) ●
TimeZoneId The timezone to show for dates in messages Int ●

PushNotificationService table relationship diagram

Indexes

Fields Types Description
pushnotificationservice_id PK Clustered, Unique

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.