CREATE TABLE student (
studentID INT AUTO_INCREAMENT NOT NULL,
firstName VARCHAR(20) NOT NULL,
lastName VARCHAR(20) NOT NULL,
address VARCHAR(50) NOT NULL,
email VARCHAR(50) NOT NULL,
phone VARCHAR(30) NOT NULL,
gender VARCHAR(6) NOT NULL,
dateOfBirth DATE NOT NULL,
nationality VARCHAR(20) NOT NULL,
religion VARCHAR(20),
allergies VARCHAR(100),
diet VARCHAR(100),
medical VARCHAR(100),
hobbies VARCHAR(100),
smoker TINYINT(1),
description VARCHAR(500),
PRIMARY KEY (studentID)
);