user_devices

0 rows


Description

This table stores user’s mobile devices information in order to send PUSH notifications

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
message_airnotifier_devices.userdeviceid messairndevi_use_fkR
userid BIGINT 19 0
user.id userdevi_use2_fkR
appid VARCHAR 128

the app id, usually something like com.moodle.moodlemobile

name VARCHAR 32

the device name, occam or iPhone etc..

model VARCHAR 32

the device model, Nexus 4 or iPad 1,1

platform VARCHAR 32

the device platform, Android or iOS etc

version VARCHAR 32

The device version, 6.1.2, 4.2.2 etc..

pushid VARCHAR 255

the device PUSH token/key/identifier/registration id

uuid VARCHAR 255

The device vendor UUID

timecreated BIGINT 19 null
timemodified BIGINT 19 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
userdevi_pususe_uix Must be unique Asc/Asc pushid + userid
userdevi_use_ix Performance Asc userid
userdevi_uuiuse_ix Performance Asc/Asc uuid + userid

Relationships