db.sql

CREATE TABLE `User` (
	`id` INT(11) NOT NULL AUTO_INCREMENT,
	`first_name` VARCHAR(40),
	`last_name` VARCHAR(40),
	`nationality` VARCHAR(40),
	`nationality` VARCHAR(20),
	`sex` INT,
	`age` INT,
	`rating` INT,
	PRIMARY KEY (`id`)
);


CREATE TABLE `Selling` (
	`id` INT(11) NOT NULL AUTO_INCREMENT,
	`seller_id` INT(11),
	`category_id` INT(11),
	`price` INT,
	`stock` INT,
	`shipping_price` INT,
	`description` TEXT,
	`rating` INT,
	PRIMARY KEY (`id`)
);

ALTER TABLE `Selling` ADD CONSTRAINT `Selling_fk0` FOREIGN KEY (`seller_id`) REFERENCES User(`id`);
ALTER TABLE `Selling` ADD CONSTRAINT `Selling_fk1` FOREIGN KEY (`category_id`) REFERENCES Category(`id`);

CREATE TABLE `Category` (
	`id` INT(11) NOT NULL AUTO_INCREMENT,
	`name` VARCHAR(20),
	PRIMARY KEY (`id`)
);


CREATE TABLE `Comment` (
	`id` INT(11) NOT NULL AUTO_INCREMENT,
	`user_id` INT(11),
	`product_id` INT(11),
	PRIMARY KEY (`id`)
);

ALTER TABLE `Comment` ADD CONSTRAINT `Comment_fk0` FOREIGN KEY (`user_id`) REFERENCES User(`id`);
ALTER TABLE `Comment` ADD CONSTRAINT `Comment_fk1` FOREIGN KEY (`product_id`) REFERENCES Selling(`id`);

CREATE TABLE `Purchased` (
	`product_id` INT(11),
	`buyer_id` INT(11)
);

ALTER TABLE `Purchased` ADD CONSTRAINT `Purchased_fk0` FOREIGN KEY (`product_id`) REFERENCES Selling(`id`);
ALTER TABLE `Purchased` ADD CONSTRAINT `Purchased_fk1` FOREIGN KEY (`buyer_id`) REFERENCES User(`id`);