--- notification-inbox

alter table notifications add updated_at timestamptz;
alter table notifications add resolved boolean;

update notifications set resolved = true;


create table notification_inboxes (
    user_id bigint primary key references users(id),
    unresolved bigint not null,

    created_at timestamptz not null,
    updated_at timestamptz not null
);

create index notifications_viol_ix on notifications(target_violation_id);
