Example PostgreSQL schema for Vinyl Record Store

vinyl.sql

CREATE TABLE artists (
  id SERIAL PRIMARY KEY,
  name TEXT NOT NULL,
  alias INT REFERENCES artists(id)
);

CREATE TABLE records (
  id SERIAL PRIMARY KEY,
  name TEXT,
  artist INT REFERENCES artists(id) NOT NULL,
  label CHAR(50) NOT NULL,
  format TEXT NOT NULL CHECK (format IN ('12', '10', '7', 'lp', '2lp', '3lp', '4lp'))
);

CREATE TABLE sales (
  id SERIAL PRIMARY KEY,
  price INT NOT NULL,
  date timestamp NOT NULL,
  record INT NOT NULL REFERENCES records(id)
);