Online Exam Table Creation sql

#institute
CREATE TABLE `onlineexam`.`Institution` ( `Institution_Id` INT NOT NULL , `Institution_Name` VARCHAR(1000) NOT NULL , `Phone_Number` VARCHAR(15) NOT NULL , PRIMARY KEY (`Institution_Id`)) ENGINE = InnoDB;

#Student
CREATE TABLE `onlineexam`.`Student` ( `Student_Id` INT NOT NULL , `Institution_Id` INT NOT NULL , `Student_Name` VARCHAR(100) NOT NULL , `Phone_Number` VARCHAR(15) NOT NULL , `Email` VARCHAR(100) NOT NULL , PRIMARY KEY (`Student_Id`), INDEX `Foreign_Key` (`Institution_Id`)) ENGINE = InnoDB;


#teacher
CREATE TABLE `onlineexam`.`Teacher` ( `Teacher_Id` INT NOT NULL , `Institution_Id` INT NOT NULL , `Teacher_Name` VARCHAR(100) NOT NULL , `Phone_Number` VARCHAR(15) NOT NULL , `Email` VARCHAR(100) NOT NULL , `isVerified` BOOLEAN NOT NULL , PRIMARY KEY (`Teacher_Id`), INDEX `Foreign_Key` (`Institution_Id`)) ENGINE = InnoDB;

#Subject
CREATE TABLE `onlineexam`.`subject` ( `Subject_Id` INT NOT NULL , `Subject_Name` VARCHAR(50) NOT NULL , PRIMARY KEY (`Subject_Id`)) ENGINE = InnoDB;

#Question
CREATE TABLE `onlineexam`.`Question` ( `Question_id` INT NOT NULL , `Teacher_Id` INT NOT NULL , `Subject_id` INT NOT NULL , `question_text` VARCHAR(1000) NOT NULL , `Answer` VARCHAR(5) NOT NULL , `Option1` VARCHAR(1000) NOT NULL , `Option2` VARCHAR(1000) NOT NULL , `Option3` VARCHAR(1000) NOT NULL , `Option4` VARCHAR(1000) NOT NULL , `Option5` VARCHAR(1000) NULL DEFAULT NULL , PRIMARY KEY (`Question_id`), INDEX `Foreign_Key` (`Teacher_Id`), INDEX `Foreign_Key` (`Subject_id`)) ENGINE = InnoDB;

#Exam
CREATE TABLE `onlineexam`.`Exam` ( `Exam_Id` INT NOT NULL , `Teacher_Id` INT NOT NULL , `Exam_Name` VARCHAR(200) NOT NULL , `Duration` INT NOT NULL , `Start_Time` DATE NOT NULL , PRIMARY KEY (`Exam_Id`), INDEX `Foreign_Key` (`Teacher_Id`)) ENGINE = InnoDB;

#Question_Paper_Id
CREATE TABLE `onlineexam`.`Question_Paper` ( `Question_Paper_Id` INT NOT NULL , `Teacher_Id` INT NOT NULL , `Exam_id` INT NOT NULL , PRIMARY KEY (`Question_Paper_Id`), INDEX `Foreign_key1` (`Teacher_Id`), INDEX `Foreign_key2` (`Exam_id`)) ENGINE = InnoDB;

#Question_Question_Paper_id
CREATE TABLE `onlineexam`.`Question_Question_Paper` ( `Question_Id` INT NOT NULL , `Question_Paper_id` INT NOT NULL , PRIMARY KEY (`Question_Id`, `Question_Paper_id`)) ENGINE = InnoDB;

#Student_Registration
CREATE TABLE `onlineexam`.`Student_registartion` ( `Student_id` INT NOT NULL , `Exam_id` INT NOT NULL , `Tranx_id` VARCHAR(50) NOT NULL , `Payment_Number` VARCHAR(15) NOT NULL , `Payment_Time` TIMESTAMP NOT NULL , `Amount` INT NOT NULL , `isVerified` BOOLEAN NOT NULL , PRIMARY KEY (`Student_id`, `Exam_id`)) ENGINE = InnoDB;

#Result
CREATE TABLE `onlineexam`.`Result` ( `Student_id` INT NOT NULL , `Exam_id` INT NOT NULL , `Marks` FLOAT NOT NULL , PRIMARY KEY (`Student_id`, `Exam_id`)) ENGINE = InnoDB;

#Admin
CREATE TABLE `onlineexam`.`Admin` ( `Admin_id` INT NOT NULL , `Admin_name` VARCHAR(100) NOT NULL , `Role` VARCHAR(100) NOT NULL , PRIMARY KEY (`Admin_id`)) ENGINE = InnoDB;

#Blog
CREATE TABLE `onlineexam`.`Blog` ( `Blog_id` INT NOT NULL , `Teacher_Id` INT NOT NULL , `Blog_Text` VARCHAR(10000) NOT NULL , `Publish_Time` TIMESTAMP NOT NULL , PRIMARY KEY (`Blog_id`), INDEX `Foreign_Key` (`Teacher_Id`)) ENGINE = InnoDB;

#Comment
CREATE TABLE `onlineexam`.`Comment` ( `Comment_Id` INT NOT NULL , `Comment_Text` VARCHAR(5000) NOT NULL , `Comment_Time` TIMESTAMP NOT NULL , PRIMARY KEY (`Comment_Id`)) ENGINE = InnoDB;

#Comment_user
CREATE TABLE `onlineexam`.`Comment_User` ( `Comment_Id` INT NOT NULL , `Blog_id` INT NOT NULL , `Teacher_id` INT NULL , `Student_id` INT NULL , `Admin_id` INT NULL , INDEX `Foreign_key1` (`Comment_Id`), INDEX `Foreign_key2` (`Blog_id`), INDEX `Foreign_key3` (`Teacher_id`), INDEX `Foreign_key4` (`Student_id`), INDEX `Foreign_key5` (`Admin_id`)) ENGINE = InnoDB;