.mode column
.header ON

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

INSERT INTO payroll
  VALUES (123, 'Jack', 'TA', 50000);


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


SELECT *
FROM payroll;


SELECT p.name, p.user_id
  FROM payroll AS p
 WHERE p.job = 'TA';


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

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