mail_partner_device

-1 rows


Description

Partner Web Push Device

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('mail_partner_device_id_seq'::regclass)
mail_notification_web_push.user_device mail_notification_web_push_user_device_fkey C
partner_id int4 10 null
res_partner.id mail_partner_device_partner_id_fkey R

Partner
create_uid int4 10 √ null
res_users.id mail_partner_device_create_uid_fkey N

Created by
write_uid int4 10 √ null
res_users.id mail_partner_device_write_uid_fkey N

Last Updated by
endpoint varchar 2147483647 null

Browser endpoint
keys varchar 2147483647 null

Browser keys
expiration_time timestamp 29,6 √ null

Expiration Token Date
create_date timestamp 29,6 √ null

Created on
write_date timestamp 29,6 √ null

Last Updated on

Indexes

Constraint Name Type Sort Column(s)
mail_partner_device_pkey Primary key Asc id
mail_partner_device__partner_id_index Performance Asc partner_id
mail_partner_device_endpoint_unique Must be unique Asc endpoint

Relationships

Close relationships within degrees of separation