CREATE TABLE membership_access (
    membership_id INT UNSIGNED NOT NULL,
    person_company_id INT UNSIGNED NOT NULL,
    role_id VARCHAR(20) NOT NULL,
    date_added DATE NOT NULL,

    PRIMARY KEY (membership_id, person_company_id),
    FOREIGN KEY (person_company_id)
        REFERENCES person_company (person_company_id),
    FOREIGN KEY (membership_id) REFERENCES membership (membership_id),
    FOREIGN KEY (role_id) REFERENCES role (role_id)
) Engine=InnoDb;