project_db

CREATE DATABASE TestProject;

USE TestProject;

CREATE TABLE Category (
	id INT PRIMARY KEY identity(1, 1),	
	name nvarchar(50) NOT NULL
);

CREATE TABLE Review (
	id INT PRIMARY KEY identity(1, 1),	
	name nvarchar(MAX)
);

CREATE TABLE Product (
	id INT PRIMARY KEY identity(1, 1),	
	name nvarchar(50) NOT NULL,
	id_category INT,
	FOREIGN KEY (id_category) REFERENCES Category(id)
);

CREATE TABLE ProductReviews (
	id_product INT,
	id_review INT,
	PRIMARY KEY (id_product, id_review),
	FOREIGN KEY (id_product) REFERENCES Product(id),
	FOREIGN KEY (id_review) REFERENCES Review(id),
);

CREATE TABLE Users (
	id INT PRIMARY KEY identity(1, 1),
	name nvarchar(50) NOT NULL
);

CREATE TABLE Orders (
	id INT PRIMARY KEY identity(1, 1),
	id_user INT,
	id_product INT,
	FOREIGN KEY (id_user) REFERENCES Users(id),
	FOREIGN KEY (id_product) REFERENCES Product(id)
);