CREATE TABLE reviewing ( reviewingid INTEGER , papername char(1), reviewername text, PRIMARY KEY(reviewingid,papername) ); CREATE TABLE score ( reviewingid integer, papername char(1), questionnumber integer, score integer, FOREIGN KEY (reviewingid,papername) REFERENCES reviewing (papername,reviewingid) on delete cascade );