create database FoodieDB
USE FoodieDB
CREATE TABLE [Users](
[UserId] [int] Primary key identity(1,1) not null,
[Name] [varchar] (50) null,
[Username][varchar](50) null unique,
[Mobile] [varchar] (50) null,
[Email] [varchar] (50) null unique,
[Address] [varchar](Max) null,
[PosteCode] [varchar] (50) null,
[Password] [varchar] (50) null,
[ImageUrl] [varchar] (Max) null,
[CreatedDate] [datetime] null
)
CREATE TABLE [Contact](
[ContactId] [int] Primary key identity(1,1) not null,
[Name] [varchar] (50) null,
[Email] [varchar] (50) null,
[Subject] [varchar](200) Null,
[Message] [varchar](max) null,
[CreatedDate] [datetime] null
)
CREATE TABLE [Categories](
[CategoryId] [int] Primary key identity(1,1) not null,
[Name] [varchar] (50) null,
[ImageUrl] [varchar] (Max) null,
[IsActive] [bit] null,
[CreatedDate] [datetime] null
)
CREATE TABLE [Products](
[ProductsId] [int] Primary key identity(1,1) not null,
[Name] [varchar] (50) null,
[Description] [varchar] (max) null,
[Price] [decimal](18,2) null,
[Quantity] [int] null,
[ImageUrl] [varchar] (Max) null,
[CategoryId] [int] null, --fk
[IsActive] [bit] null,
[CreatedDate] [datetime] null
)
CREATE TABLE [Carts](
[CartId] [int] Primary key identity(1,1) not null,
[ProductsId] [int] null, --fk
[Quantity] [int] null,
[UserId] [int] null , --fk
)
CREATE TABLE [Orders](
[OrderDetailsId] [int] Primary key identity(1,1) not null,
[OrderNo] [varchar](max) null,
[ProductsId] [int] null, --fk
[Quantity] [int] null,
[UserId] [int] null ,--fk
[Status] [varchar](50) null,
[PaymentId] [int] null , --fk
[OrderDate] [datetime] null
)
CREATE TABLE [Payment](
[PaymentId] [int] Primary key identity(1,1) not null,
[Name] [varchar](50) null,
[CardNo] [varchar](50) null,
[ExpiryDate] [varchar] (50) null,
[CvvNo] [int] null,
[Address] [varchar] (max) null,
[PaymentMode] [varchar] (50) null
)
