NotificationSQL

CREATE SEQUENCE notification_id_seq;

CREATE TABLE notification
(
  id integer NOT NULL DEFAULT nextval('notification_id_seq'::regclass),
  channels text[],
  message json,
  createdts timestamp without time zone,
  user_id integer,
  isread boolean DEFAULT false,
  CONSTRAINT notification_pkey PRIMARY KEY (id)
);

CREATE INDEX user_id
  ON notification
  USING btree
  (user_id);