CREATE TABLE exams ( id INT PRIMARY KEY, name VARCHAR(255), date DATE, class_id INT, subject_id INT );