-- A repository's boards (oxygenhub#360): a board made or chosen with a new

-- repository takes its issues and proposals as they open, each a card at

-- the bottom of the board's first column.

CREATE TABLE project_repos (

    project_id BIGINT NOT NULL REFERENCES projects(id) ON DELETE CASCADE,

    repo_id    BIGINT NOT NULL REFERENCES repositories(id) ON DELETE CASCADE,

    PRIMARY KEY (project_id, repo_id)

);

CREATE INDEX project_repos_by_repo ON project_repos (repo_id);