app_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 bigserial 19 nextval('app_user_devices_id_seq'::regclass)
app_message_airnotifier_devices.userdeviceid Defined in XMLR
userid int8 19 0
app_user.id Defined in XMLR
appid varchar 128 ''::character varying
name varchar 32 ''::character varying
model varchar 32 ''::character varying
platform varchar 32 ''::character varying
version varchar 32 ''::character varying
pushid varchar 255 ''::character varying
uuid varchar 255 ''::character varying
timecreated int8 19 null
timemodified int8 19 null

Indexes

Constraint Name Type Sort Column(s)
app_userdevi_id_pk Primary key Asc id
app_userdevi_pususe_uix Must be unique Asc/Asc pushid + userid
app_userdevi_use_ix Performance Asc userid
app_userdevi_uuiuse_ix Performance Asc/Asc uuid + userid

Relationships