create table promotion_attributed_count
(
    id            varchar(255)     not null
        primary key,
    advertiser_id varchar(255)     not null,
    app_code      varchar(255)     not null,
    count         bigint default 0 not null,
    constraint advertiser_app_unique
        unique (advertiser_id, app_code)
);

create index advertiser_index
    on promotion_attributed_count (advertiser_id);