CREATE TABLE "Users" (
	"User_ID" int PRIMARY KEY,
	"Username" varchar(255),
	"Password" varchar(255),
	"Firstname" varchar(255),
	"Lastname" varchar(255),
	"Gender" varchar(255),
	"DateOfBirth" datetime,
	"Join_Date" datetime,
	"Profile_Picture" varchar(255),
	"isAdmin" bool,
	"Activated" bool,
	"Banned" bool,
	"Activation_Code" varchar(255)
);
CREATE TABLE "Questions" (
	"Question_ID" int PRIMARY KEY,
	"Question" varchar(255),
	"Question_Details" varchar(255),
	"Question_Date" datetime,
	"Best_Answer_ID" int,
	"User_ID" int FOREIGN KEY("User_ID") REFERENCES "Users" ("User_ID"),
	"Category_ID" int FOREIGN KEY("Category_ID") REFERENCES "Categories" ("Category_ID")
);
CREATE TABLE "Answers" (
	"Answer_ID" int PRIMARY KEY,
	"Answer" varchar(255),
	"Answer_Date" datetime,
	"User_ID" int FOREIGN KEY("User_ID") REFERENCES "Users" ("User_ID"),
	"Question_ID" int FOREIGN KEY("Question_ID") REFERENCES "Questions" ("Question_ID")
);
CREATE TABLE "Categories" (
	"Category_ID" int PRIMARY KEY,
	"Category" varchar(255),
	"Category_Description" varchar(255),
	"Category_Image" varchar(255),
	"Parent_Category_ID" int
);