CREATE TABLE Photo ( Photo_id INTEGER NOT NULL AUTO_INCREMENT, description VARCHAR(20) NOT NULL, placeSeen VARCHAR(20) NOT NULL, dateSeen DATE NOT NULL, image MEDIUMBLOB NOT NULL, seen INTEGER REFERENCES Ship ( Ship_id) , PRIMARY KEY ( Photo_id ) ); CREATE TABLE Ship ( Ship_id INTEGER NOT NULL AUTO_INCREMENT, name VARCHAR(20) NOT NULL, yearBuilt VARCHAR(20) NOT NULL, grossWeight VARCHAR(20) NOT NULL, description VARCHAR(20) NOT NULL, kind VARCHAR(20) NOT NULL, category VARCHAR(20) NOT NULL, operator INTEGER REFERENCES Operator ( Operator_id) , PRIMARY KEY ( Ship_id ) ); CREATE TABLE Change ( Change_id INTEGER NOT NULL AUTO_INCREMENT, year VARCHAR(20) NOT NULL, name VARCHAR(20) NOT NULL, history INTEGER REFERENCES Ship ( Ship_id) , PRIMARY KEY ( Change_id ) ); CREATE TABLE Builder ( Builder_id INTEGER NOT NULL AUTO_INCREMENT, name VARCHAR(20) NOT NULL, website VARCHAR NOT NULL, abbreviation VARCHAR(20) NOT NULL, PRIMARY KEY ( Builder_id ) ); CREATE TABLE Operator ( Operator_id INTEGER NOT NULL AUTO_INCREMENT, name VARCHAR(20) NOT NULL, website VARCHAR, abbreviation VARCHAR(20) NOT NULL, PRIMARY KEY ( Operator_id ) ); CREATE TABLE builder ( Builder_id INTEGER NOT NULL REFERENCES Builder ( Builder_id) , Ship_id INTEGER NOT NULL REFERENCES Ship ( Ship_id) , buildNumber VARCHAR(20), placeBuilt VARCHAR(20), PRIMARY KEY ( Ship_id, Builder_id ) );