CREATE TYPE recording_type AS ENUM('top_artist', 'similar_artist')

CREATE TABLE recommendation.cf_recording (
  id                  SERIAL,
  user_id             INTEGER,
  msid                UUID,
  recommender_id      INTEGER,
  type                recording_type,
  created             TIMESTAMP
);

CREATE TABLE recommendation.recommender (
  id                  SERIAL,
  repository          TEXT,
  author_email        TEXT,
  name                TEXT,
  created             TIMESTAMP
);

CREATE TABLE recommendation.cf_recording_recommender_join(
  last_used           TIMESTAMP,
  cf_recording_id     INTEGER,
  recommender_id      INTEGER
);