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
name VARCHAR 32
model VARCHAR 32
platform VARCHAR 32
version VARCHAR 32
pushid VARCHAR 255
uuid VARCHAR 255
timecreated BIGINT 19 null
timemodified BIGINT 19 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
userdevi_pususe2_uix Must be unique Asc/Asc pushid + userid
userdevi_use4_ix Performance Asc userid
userdevi_uuiuse2_ix Performance Asc/Asc uuid + userid

Relationships

Close relationships within degrees of separation