create table "application_analytics"
(
    "id"             char(36) not null primary key,
    "application_id" char(36) not null,
    "gateway_id"     bigint   not null,
    "hit_date"    date     not null,
    "value"          integer  not null
);
comment on table "application_analytics" is 'null';