create_user_mention.sql

CREATE TABLE users(user_id SERIAL PRIMARY KEY, user_name TEXT);

CREATE TABLE mentions(mention_id SERIAL PRIMARY KEY, mention_symbol TEXT, mention_user INT REFERENCES users(user_id), mention_date TIMESTAMP DEFAULT now());

INSERT INTO users (user_name) VALUES ('Tom Taylor'), ('Tom Caruso'), ('Other Rando User');

INSERT INTO mentions (mention_symbol, mention_user) VALUES ('AMD', 2);
INSERT INTO mentions (mention_symbol, mention_user) VALUES ('APPL', 1);
INSERT INTO mentions (mention_symbol, mention_user) VALUES ('BLPD', 1);
INSERT INTO mentions (mention_symbol, mention_user) VALUES ('GALT', 1);
INSERT INTO mentions (mention_symbol, mention_user) VALUES ('AKRX', 2);
INSERT INTO mentions (mention_symbol, mention_user) VALUES ('AMD', 3);
INSERT INTO mentions (mention_symbol, mention_user) VALUES ('AMD', 2);
INSERT INTO mentions (mention_symbol, mention_user) VALUES ('AMD', 2);