EntityFrameworkGiris/Database Script.sql at master · yms8416/EntityFrameworkGiris · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
CREATE TABLE Brands(
	Id INT PRIMARY KEY IDENTITY(1,1),
	Name VARCHAR(30) NOT NULL,
	Created DATETIME NULL,
	Modified DATETIME NULL,
	IsActive BIT NOT NULL DEFAULT(1),
	IsDeleted BIT NOT NULL DEFAULT(0)
)

CREATE TABLE Stores(
	Id INT PRIMARY KEY IDENTITY(1,1),
	Name VARCHAR(30) NOT NULL,
	Phone VARCHAR(14) NULL,
	ManagerId INT NOT NULL,
	Created DATETIME NULL,
	Modified DATETIME NULL,
	IsActive BIT NOT NULL DEFAULT(1),
	IsDeleted BIT NOT NULL DEFAULT(0)
)

CREATE TABLE Products(
	Id INT PRIMARY KEY IDENTITY(1,1),
	Name VARCHAR(30) NOT NULL,
	BrandId INT,
	Price MONEY NOT NULL,
	Created DATETIME NULL,
	Modified DATETIME NULL,
	IsActive BIT NOT NULL DEFAULT(1),
	IsDeleted BIT NOT NULL DEFAULT(0),
	CONSTRAINT FK_Products_BrandId FOREIGN KEY(BrandId) REFERENCES Brands(Id)
)

CREATE TABLE Employees(
	Id INT PRIMARY KEY IDENTITY(1,1),
	FirstName VARCHAR(20) NOT NULL,
	LastName VARCHAR(20) NOT NULL,
	Email VARCHAR(30) NOT NULL,
	IsManager BIT NOT NULL,
	StoreId INT NOT NULL,
	Created DATETIME NULL,
	Modified DATETIME NULL,
	IsActive BIT NOT NULL DEFAULT(1),
	IsDeleted BIT NOT NULL DEFAULT(0),
	CONSTRAINT FK_Employees_Store FOREIGN KEY (StoreId) REFERENCES Stores(Id)
)

CREATE TABLE Warehouses(
	Id INT PRIMARY KEY IDENTITY(1,1),
	Name VARCHAR(30) NOT NULL,
	ManagerId INT NOT NULL,
	Created DATETIME NULL,
	Modified DATETIME NULL,
	IsActive BIT NOT NULL DEFAULT(1),
	IsDeleted BIT NOT NULL DEFAULT(0)
	CONSTRAINT FK_WareHouses_Empoyee FOREIGN KEY (ManagerId) REFERENCES Employees(Id)
)

CREATE TABLE StoreWarehouses(
	Id INT PRIMARY KEY IDENTITY(1,1),
	StoreId INT NOT NULL,
	WarehouseId INT NOT NULL,
	Created DATETIME NULL,
	Modified DATETIME NULL,
	IsActive BIT NOT NULL DEFAULT(1),
	IsDeleted BIT NOT NULL DEFAULT(0)
	CONSTRAINT FK_StoreWareHouses_Store FOREIGN KEY (StoreId) REFERENCES Stores(Id),
	CONSTRAINT FK_StoreWareHouses_WareHouse FOREIGN KEY (WarehouseId) REFERENCES Warehouses(Id)
)

CREATE TABLE ProductWarehouses(
	Id INT PRIMARY KEY IDENTITY(1,1),
	ProductId INT NOT NULL,
	WarehouseId INT NOT NULL,
	Created DATETIME NULL,
	Modified DATETIME NULL,
	IsActive BIT NOT NULL DEFAULT(1),
	IsDeleted BIT NOT NULL DEFAULT(0),
	CONSTRAINT FK_ProductWarehouses_Products FOREIGN KEY (ProductId) REFERENCES Products(Id),
	CONSTRAINT FK_ProductWarehouses_Warehouses FOREIGN KEY (WarehouseId) REFERENCES Warehouses(Id)
)