1 2 3 4 5 6 7 8 9
CREATE TABLE notes ( id SERIAL NOT NULL, user_id BIGINT NOT NULL, guild_id BIGINT NOT NULL, note TEXT NOT NULL, moderator BIGINT NOT NULL, timestamp TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT now(), PRIMARY KEY(id, user_id, guild_id) )