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 CONSTRAINT Users_User_ID REFERENCES Users(User_ID),
	"Category_ID" int CONSTRAINT Categories_Category_ID REFERENCES Categories(Category_ID)
);
CREATE TABLE "Answers" (
	"Answer_ID" int PRIMARY KEY,
	"Answer" varchar(255),
	"Answer_Date" datetime,
	"User_ID" int CONSTRAINT Users_User_ID REFERENCES Users(User_ID),
	"Question_ID" int CONSTRAINT Questions_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
);