CREATE TABLE "Job" ( "id" int PRIMARY KEY, "user" varchar(255) FOREIGN KEY("user") REFERENCES "user" ("email"), "...data" varchar(255), "q1" varchar(255) FOREIGN KEY("q1") REFERENCES "answer1" ("q1"), "q2" varchar(255) ); 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) FOREIGN KEY("q2") REFERENCES "Job" ("q2"), "answer" varchar(255), "user" varchar(255) FOREIGN KEY("user") REFERENCES "user" ("email") );