1 CREATE TABLE user_mention (
3 recipient_id int REFERENCES user_ ON UPDATE CASCADE ON DELETE CASCADE NOT NULL,
4 comment_id int REFERENCES COMMENT ON UPDATE CASCADE ON DELETE CASCADE NOT NULL,
5 read boolean DEFAULT FALSE NOT NULL,
6 published timestamp NOT NULL DEFAULT now(),
7 UNIQUE (recipient_id, comment_id)
10 CREATE VIEW user_mention_view AS
13 um.id AS user_mention_id,
25 c.banned_from_community,