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") );