User Devices Table Schema (user_devices)


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

user_devices table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
userid BIGINT 19 0 userdevi_use2_fk R
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

Table contained -1 rows

user_devices table 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

user_devices table relationships