LuL - SQL Backend

CREATE TABLE Student
(
UUID VARCHAR(32) NOT NULL UNIQUE,
Name VARCHAR(42) NOT NULL UNIQUE,
PRIMARY KEY(UUID)
);

create table Board (
UUID VARCHAR(32) NOT NULL UNIQUE,
Category VARCHAR(32) NULL,
Questions VARCHAR(1024) NOT NULL,
PRIMARY KEY(UUID)
);

create table Student_Board (
student_id VARCHAR(32) NOT NULL UNIQUE,
board_id VARCHAR(32) NOT NULL UNIQUE,
Completed INTEGER NOT NULL DEFAULT 0,
Fails INTEGER NOT NULL DEFAULT 0,
CONSTRAINT `student` FOREIGN KEY (student_id) REFERENCES Student(UUID),
CONSTRAINT `board` FOREIGN KEY (board_id) REFERENCES Board(UUID),
PRIMARY KEY(student_id, board_id)
);