Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | serial | 10 | √ | nextval('oc_notifications_pushhash_id_seq'::regclass) |
|
|
||
| uid | varchar | 64 | null |
|
|
|||
| token | int4 | 10 | 0 |
|
|
|||
| deviceidentifier | varchar | 128 | null |
|
|
|||
| devicepublickey | varchar | 512 | null |
|
|
|||
| devicepublickeyhash | varchar | 128 | null |
|
|
|||
| pushtokenhash | varchar | 128 | null |
|
|
|||
| proxyserver | varchar | 256 | null |
|
|
|||
| apptype | varchar | 32 | 'unknown'::character varying |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| oc_notifications_pushhash_pkey | Primary key | Asc | id |
| oc_npushhash_di | Performance | Asc | deviceidentifier |
| oc_npushhash_uid | Must be unique | Asc/Asc | uid + token |