 	PRIMARY KEY (accountId)
 );
 
-CREATE TABLE category (
-	categoryId      		INT UNSIGNED AUTO_INCREMENT NOT NULL,
-	categoryName  			VARCHAR(20) NOT NULL,
-	PRIMARY KEY (categoryId)
+CREATE TABLE purchase (
+	purchaseId     					INT UNSIGNED AUTO_INCREMENT NOT NULL,
+	purchaseBuyerId  					INT UNSIGNED NOT NULL,
+	purchasePayPalTransactionId	INT UNSIGNED NOT NULL,
+	purchaseCreateDate 				DATETIME NOT NULL,
+	INDEX (purchaseBuyerId),
+	FOREIGN KEY (purchaseBuyerId) REFERENCES account(accountId),
+	PRIMARY KEY (purchaseId)
+);
+
+CREATE TABLE product (
+	productId      		INT UNSIGNED AUTO_INCREMENT NOT NULL,
+	productAccountId  	INT UNSIGNED NOT NULL,
+	productImageId 		INT UNSIGNED,
+	productAdminFee 		DECIMAL UNSIGNED NOT NULL,
+	productDescription   VARCHAR(255) NOT NULL,
+	productPrice			DECIMAL UNSIGNED NOT NULL,
+	productShipping   	DECIMAL UNSIGNED NOT NULL,
+	productSold				BOOLEAN DEFAULT 0,
+	productTitle			VARCHAR(50) NOT NULL,
+	INDEX (productAccountId),
+	INDEX (productImageId),
+	FOREIGN KEY (productAccountId) REFERENCES account(accountId),
+	FOREIGN KEY (productImageId) REFERENCES image(imageId),
+	PRIMARY KEY (productId)
 );
 
 CREATE TABLE feedback (

	PRIMARY KEY (messageId)
);

CREATE TABLE product (
	productId      		INT UNSIGNED AUTO_INCREMENT NOT NULL,
	productAccountId  	INT UNSIGNED NOT NULL,
	productImageId 		INT UNSIGNED,
	productAdminFee 		FLOAT UNSIGNED NOT NULL,
	productDescription   VARCHAR(255) NOT NULL,
	productPrice			FLOAT UNSIGNED NOT NULL,
	productShipping   	FLOAT UNSIGNED NOT NULL,
	productSold				BOOLEAN DEFAULT 0,
	productTitle			VARCHAR(50) NOT NULL,
	INDEX (productAccountId),
	INDEX (productImageId),
	FOREIGN KEY (productAccountId) REFERENCES account(accountId),
	FOREIGN KEY (productImageId) REFERENCES image(imageId),
	PRIMARY KEY (productId)
);

CREATE TABLE productCategory (
	productCategoryCategoryId     INT UNSIGNED,
	productCategoryProductId  		INT UNSIGNED,
	INDEX (productCategoryCategoryId),
	INDEX (productCategoryProductId),
	FOREIGN KEY (productCategoryCategoryId) REFERENCES category(categoryId),
	FOREIGN KEY (productCategoryProductId) REFERENCES product(productId)
);

CREATE TABLE productPurchase (

	feedbackProductId 	INT UNSIGNED NOT NULL,
	feedbackSellerId   	INT UNSIGNED NOT NULL,
	feedbackContent		VARCHAR(255) NOT NULL,
	feedbackRating 		TINYINT UNSIGNED NOT NULL,
	INDEX (feedbackBuyerId),
	INDEX (feedbackProductId),
	INDEX (feedbackSellerId),
