0 rows


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


Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 nextval('app_user_devices_id_seq'::regclass)
userid int8 19 0 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


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