CREATE TABLE "Job" (
	"id" int PRIMARY KEY,
	"user" varchar(255) CONSTRAINT user_email REFERENCES user(email),
	"...data" varchar(255),
	"q1" varchar(255) CONSTRAINT answer1_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) CONSTRAINT user_emaik REFERENCES user(emaik)
);
CREATE TABLE "student" (
	"id" int PRIMARY KEY,
	"user" varchar(255) CONSTRAINT user_email REFERENCES user(email)
);
CREATE TABLE "answer2" (
	"id" int,
	"q2" varchar(255) CONSTRAINT Job_q2 REFERENCES Job(q2),
	"answer" varchar(255),
	"user" varchar(255) CONSTRAINT user_email REFERENCES user(email)
);