Message Airnotifier Devices Table Schema (message_airnotifier_devices)


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 19 null
userdeviceid BIGINT 19 null 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