Repository navigation
Expand file tree
/
Copy pathSQLQuery2.sql
More file actions
98 lines (79 loc) · 1.74 KB
/
Copy pathSQLQuery2.sql
File metadata and controls
98 lines (79 loc) · 1.74 KB
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
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
create database dbMyOnlineShopping
go
use dbMyOnlineShopping
create table Tbl_Category(
CategoryId int identity primary key,
CategoryName varchar(500) unique,
IsActive bit null,
IsDelete bit null
)
create table Tbl_product
(
ProductId int identity primary key,
ProductName varchar(500) unique,
CategoryId int,
IsActive bit null,
IsDelete bit null,
CreateDate datetime null,
Description datetime null,
ProductImage varchar(max),
IsFeatured bit null,
Quantity int,
foreign key(CategoryId) references Tbl_Category
)
create table Tbl_CartStatus
(
CartStatusId int identity primary key,
CartStatus varchar(500)
)
create table Tbl_Members
(
MemberID int identity primary key,
FirstName varchar(200) ,
LastName varchar(200) unique,
EmailId varchar(200) unique,
Password varchar(500) ,
IsActive bit null,
IsDelete bit null,
CreatedOn datetime,
ModifiedOn datetime
)
Create table Tbl_ShippingDetails
(
ShippingDetailId int identity primary key,
MemberId int,
Address varchar(500),
City varchar(500),
State varchar(500),
Country varchar(50),
ZipCode varchar(50),
OrderId int,
AmountId decimal,
PaymentType varchar(50),
foreign key(MemberId) references Tbl_Members(MemberId)
)
create table Tbl_MemberRole
(
MemberRoleID int identity primary key,
MemberId int,
RoleId int
)
create table Tbl_Roles
(
RoleId int identity primary key,
RoleName varchar(200) unique
)
Create table Tbl_Cart
(
CartId int identity primary key,
ProductId int,
MemberId int,
CartStatusId int,
foreign key (ProductId) references Tbl_product(ProductId)
)
create table Tbl_SlideImage
(
slideId int identity primary key,
SlideTitle varchar(500),
SlideImage varchar(max)
)