CREATE TABLE `Job` ( `id` int PRIMARY KEY, `user` varchar(255), `...data` varchar(255), `q1` varchar(255), `q2` varchar(255), FOREIGN KEY(`user`) REFERENCES `user` (`email`), FOREIGN KEY(`q1`) REFERENCES `answer1` (`q1`) ); CREATE TABLE `user` ( `email` varchar(255) PRIMARY KEY ); CREATE TABLE `answer1` ( `id` int PRIMARY KEY, `q1` varchar(255), `answer` varchar(255), `user` varchar(255), FOREIGN KEY(`user`) REFERENCES `user` (`emaik`) ); CREATE TABLE `student` ( `id` int PRIMARY KEY, `user` varchar(255), FOREIGN KEY(`user`) REFERENCES `user` (`email`) ); CREATE TABLE `answer2` ( `id` int, `q2` varchar(255), `answer` varchar(255), `user` varchar(255), FOREIGN KEY(`q2`) REFERENCES `Job` (`q2`), FOREIGN KEY(`user`) REFERENCES `user` (`email`) );