-- Review requests (hub plan 0.4): who was asked to review a proposal, by

-- whom and when; a request goes when that reviewer reviews.

CREATE TABLE proposal_review_requests (

    proposal_id  INTEGER NOT NULL REFERENCES proposals(id) ON DELETE CASCADE,

    account_id   INTEGER NOT NULL REFERENCES accounts(id) ON DELETE CASCADE,

    requested_by TEXT NOT NULL,

    requested_ms INTEGER NOT NULL,

    PRIMARY KEY (proposal_id, account_id)

);