timeline aggs_hourly Table bidder aggs_hourly Column Type Collation Nu

 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
timeline=> \d aggs_hourly
Table "bidder.aggs_hourly"
Column | Type | Collation | Nullable | Default
-----------------+-----------------------------+-----------+----------+---------
key | character varying(254) | | not null |
date | timestamp without time zone | | not null |
package | character varying(254) | | |
ssp | character varying(254) | | |
country | character varying(254) | | |
banner_size | character varying(254) | | |
banner_type | character varying(254) | | |
adspace_type | character varying(254) | | |
device_platform | character varying(254) | | |
impressions | integer | | |
bids | integer | | |
expenses | double precision | | |
revenue | double precision | | |
clicks | integer | | |
volume | integer | | |
mode | character varying(254) | | |
bidprices | double precision | | | 0
installs | integer | | | 0
wins | integer | | | 0
winprices | double precision | | | 0
errors_bidfloor | integer | | | 0
errors_country | integer | | | 0
errors_noads | integer | | | 0
errors_other | integer | | | 0