SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
#student CREATE TABLE IF NOT EXISTS `student` ( `student_id` int NOT NULL AUTO_INCREMENT, `student_name` varchar(255) NOT NULL, `password` varchar(100) NOT NULL, `email` varchar(255) NOT NULL, UNIQUE(`email`), PRIMARY KEY (`student_id`) ) DEFAULT CHARSET=utf8; #staff CREATE TABLE IF NOT EXISTS `staff` ( `staff_id` int NOT NULL AUTO_INCREMENT, `staff_name` varchar(255) NOT NULL, `password` varchar(100) NOT NULL, `email` varchar(255) NOT NULL, UNIQUE(`email`), PRIMARY KEY (`staff_id`) ) DEFAULT CHARSET=utf8; #about CREATE TABLE IF NOT EXISTS `about` ( `quiz_name` varchar(255) NOT NULL , `quiz_author` varchar(255) NOT NULL, `quiz_duration` varchar(100), `content` TEXT NULL DEFAULT NULL, PRIMARY KEY (`quiz_name`), FOREIGN KEY (`quiz_author`) REFERENCES staff(`staff_name`) ) DEFAULT CHARSET=utf8; #quiz CREATE TABLE IF NOT EXISTS `quiz` ( `quiz_id` int NOT NULL AUTO_INCREMENT, `quiz_name` varchar(255), `quiz_available` varchar(100), PRIMARY KEY (`quiz_id`), FOREIGN KEY (`quiz_name`) REFERENCES about(`quiz_name`) ) DEFAULT CHARSET=utf8; #questions CREATE TABLE IF NOT EXISTS `questions` ( `question_id` int NOT NULL AUTO_INCREMENT, `quiz_id` int NOT NULL, `answer` varchar(255) NOT NULL, `score` smallint NOT NULL, `content` TEXT NULL DEFAULT NULL, PRIMARY KEY (`question_id`), FOREIGN KEY (`quiz_id`) REFERENCES quiz(`quiz_id`) ) DEFAULT CHARSET=utf8; #attempt CREATE TABLE IF NOT EXISTS `attempt` ( `attempt_id` int NOT NULL AUTO_INCREMENT, `student_id` int NOT NULL, `quiz_id` int NOT NULL, `date` DATE, `total_score` smallint, PRIMARY KEY (`attempt_id`), FOREIGN KEY (`student_id`) REFERENCES student(`student_id`), FOREIGN KEY (`quiz_id`) REFERENCES quiz(`quiz_id`) ) DEFAULT CHARSET=utf8;
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear