Untitled
unknown
sql
a year ago
1.2 kB
5
Indexable
CREATE TABLE Item ( Id UNIQUEIDENTIFIER PRIMARY KEY, [Name] NVARCHAR(MAX) NOT NULL, Description NVARCHAR(MAX) NOT NULL, PhotoUrl NVARCHAR(MAX) NOT NULL ); CREATE TABLE Product ( Id UNIQUEIDENTIFIER PRIMARY KEY, [Name] NVARCHAR(MAX) NOT NULL, Price FLOAT NOT NULL ); CREATE TABLE Color ( Id UNIQUEIDENTIFIER PRIMARY KEY, [Name] NVARCHAR(MAX) NOT NULL, [Code] NVARCHAR(20) NOT NULL, ItemId UNIQUEIDENTIFIER, ProductId UNIQUEIDENTIFIER, FOREIGN KEY (ItemId) REFERENCES Item(Id), FOREIGN KEY (ProductId) REFERENCES Product(Id) ); CREATE TABLE Feedback ( Id UNIQUEIDENTIFIER PRIMARY KEY, Rating FLOAT NOT NULL, [Comment] NVARCHAR(MAX) NOT NULL, ItemId UNIQUEIDENTIFIER, ProductId UNIQUEIDENTIFIER, FOREIGN KEY (ItemId) REFERENCES Item(Id), FOREIGN KEY (ProductId) REFERENCES Product(Id) ); CREATE TABLE [User] ( Id UNIQUEIDENTIFIER PRIMARY KEY, [Name] NVARCHAR(MAX) NOT NULL, Email NVARCHAR(MAX) NOT NULL, FeedbackId UNIQUEIDENTIFIER, FOREIGN KEY (FeedbackId) REFERENCES Feedback(Id) ); CREATE TABLE Vendor ( Id UNIQUEIDENTIFIER PRIMARY KEY, [Name] NVARCHAR(MAX) NOT NULL, Enlisted BIT NOT NULL );
Editor is loading...
Leave a Comment