The up script is simple and contains a statement that creates the memberships table with three fields—the id of a membership, the id of a channel in the channel_id column whose member is a user with the user_id column:

CREATE TABLE memberships (
  id SERIAL PRIMARY KEY,
  channel_id INTEGER NOT NULL REFERENCES channels,
  user_id INTEGER NOT NULL REFERENCES users
);