user_devices

0 rows


Description

This table stores user’s mobile devices information in order

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

publickey LONGTEXT 2147483647 null

The app generated public key

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