-- hello postgres


CREATE TABLE payroll (
  user_id INT PRIMARY KEY,
  name TEXT,
  job TEXT,
  salary INT
);

INSERT INTO payroll
  VALUES (666, 'James', 'Prof', 'a big number');

INSERT INTO payroll
  VALUES (666, 'James', 'Prof', '100000');



INSERT INTO payroll
  VALUES (123, 'Jack', 'TA', 50000)
         (345, 'Allison', 'TA', 60000),
         (567, 'Magda', 'Prof', 90000),
         (789, 'Dan', 'Prof', 100000);

SELECT * FROM payroll;

CREATE TABLE regist (
  user_id INT REFERENCES payroll,
  car TEXT
);


INSERT INTO regist
  VALUES (123, 'Charger'),
         (567, 'Civic'),
         (567, 'Pinto');

SELECT * FROM regist;