CREATE DATABASE EStore;
GO
USE EStore;
GO
--DROP TABLE Category;
GO
CREATE TABLE Category(
CategoryId TINYINT NOT NULL IDENTITY(1, 1) PRIMARY KEY,
CategoryName NVARCHAR(64) NOT NULL,
ParentId TINYINT REFERENCES Category(CategoryId)
);
--TRUNCATE TABLE Category;
GO
SET IDENTITY_INSERT Category ON;
INSERT INTO Category(CategoryId, CategoryName) VALUES
(1, N'Thời trang nữ'),
(2, N'Phụ kiện');
GO
SET IDENTITY_INSERT Category OFF;
GO
DROP TABLE Product;
GO
CREATE TABLE Product(
ProductId INT NOT NULL IDENTITY(1, 1) PRIMARY KEY,
CategoryId TINYINT NOT NULL,
ProductCode VARCHAR(18) NOT NULL,
ProductName NVARCHAR(128) NOT NULL,
Price INT NOT NULL,
Color NVARCHAR(16) NOT NULL
);
GO
--DROP TABLE ProductImage;
GO
CREATE TABLE ProductImage(
ProductId INT NOT NULL,
ImageUrl NVARCHAR(64) NOT NULL
);
GO
--DROP TABLE ProductSize;
GO
CREATE TABLE ProductSize(
ProductId INT NOT NULL,
Size VARCHAR(4) NOT NULL,
IsSoldOut BIT NOT NULL DEFAULT 0
);
GO