CREATE TABLE Quilt ( Quilt_id INTEGER NOT NULL AUTO_INCREMENT, title VARCHAR(20) NOT NULL, story BLOB NOT NULL, width DECIMAL(5,2) NOT NULL, height DECIMAL(5,2) NOT NULL, price DECIMAL(7,2), currency CHAR(3), maker INTEGER REFERENCES Maker ( Maker_id) , PRIMARY KEY ( Quilt_id ) ); CREATE TABLE Member ( Member_id INTEGER NOT NULL AUTO_INCREMENT, memberName VARCHAR(20) NOT NULL, password VARCHAR(20) NOT NULL, dateJoined DATE NOT NULL, language CHAR(3) NOT NULL, PRIMARY KEY ( Member_id ) ); CREATE TABLE Maker ( Maker_id INTEGER NOT NULL AUTO_INCREMENT, name VARCHAR(20) NOT NULL, story BLOB NOT NULL, PRIMARY KEY ( Maker_id ) ); CREATE TABLE Photo ( Photo_id INTEGER NOT NULL AUTO_INCREMENT, image BLOB NOT NULL, text VARCHAR(20) NOT NULL, datetimeEntered VARCHAR(20) NOT NULL, illustrates INTEGER REFERENCES Quilt ( Quilt_id) , PRIMARY KEY ( Photo_id ) ); CREATE TABLE Comment ( timestamp VARCHAR(20) NOT NULL, Quilt_id INTEGER REFERENCES Quilt ( Quilt_id) , madeBy INTEGER REFERENCES Member ( Member_id) , PRIMARY KEY ( Quilt_id, timestamp ) );