Message Airnotifier Devices Table Schema (message_airnotifier_devices)


Description

Store information about the devices registered in Airnotifier for PUSH notifications

message_airnotifier_devices table columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigint 10 null
userdeviceid bigint 10 null
user.id Implied Constraint R

The user device id in the user_devices table

enable BIT 1 1

The user can enable/disable his devices

Table contained -1 rows

message_airnotifier_devices table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
messairndevi_use_uix Must be unique Asc userdeviceid

message_airnotifier_devices table relationships