create table subscription (
    id text
        not null
        primary key,
    user text
        not null
        references user (id),
    endpoint text
        unique
        not null,
    key_p256dh text
        not null,
    key_auth text
        not null
);