Livoa LogoLivoa
CUSTOMER


PK CustomerID

Name

Email

Phone

CATEGORY


PK CategoryID

Category

PRODUCT


PK ProductID

ProductName

FK CategoryID

FK SellerID

Price

Description

SELLER


PK SellerID

SellerName

ContactDetail

CART


PK CartID

FK CustomerID

FK ProductID

Quantity

ORDER


PK OrderID

FK CustomerID

FK CartID

OrderDate

TotalAmount

DELIVERY


PK DeliveryID

FK OrderID

CourierPartner

TrackingNumber

DeliveryStatus

PAYMENT


PK PaymentID

FK OrderID

PaymentStatus

ONLINE_PAYMENT


PK PaymentID

ReceivedBy

CASH_PAYMENT


PK PaymentID

ReceivedBy

DateReceived

DELIVERY_REPLACEMENT


PK DeliveryReplacementID

Status

Relational database

by Harry

0
0 uses