app dt List of relations Schema Name Type Owner -------- -------------

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
app=# \dt
List of relations
Schema | Name | Type | Owner
--------+--------------------------------------------+-------+-------
public | auth_group | table | app
public | auth_group_permissions | table | app
public | auth_permission | table | app
public | auth_user | table | app
public | auth_user_groups | table | app
public | auth_user_user_permissions | table | app
public | cache | table | app
public | django_admin_log | table | app
public | django_content_type | table | app
public | django_migrations | table | app
public | django_session | table | app
public | push_billingperiod | table | app
public | push_domain | table | app
public | push_notification | table | app
public | push_notificationtemplate | table | app
public | push_segment | table | app
public | push_subscription | table | app
public | push_templateset | table | app
public | push_transaction | table | app
public | push_userprofile | table | app
public | push_welcomenotification | table | app
public | registration_registrationprofile | table | app
public | registration_supervisedregistrationprofile | table | app
(23 rows)
app=# select count(*) from push_notification;
count
---------
2486007
(1 row)
app=# select * from push_notification limit 1;
app=# \x
Expanded display is on.
app=# select * from push_notification limit 1;
-[ RECORD 1 ]---------+---------------------------------------------------------------------------------------------------------------
id | 2475970
delivery_date | 2019-07-14 17:26:11.242737+00
last_delivery_attempt | 2019-07-14 17:37:05.930223+00
state | completed
title | You have been chosen…
text |
image |
url | http://difice-milton.com/9ee10c2a-9e81-4fc8-ab97-d98ba1fb0dd2?sr={utm_source}&w={week}&t=walmartT9&date={date}
favourite | f
domain_id | 392
counts |
limit_exceeded | f
actions_text | {}
actions_url | {}
allow_openrtb | f