Livoa LogoLivoa

Service

PK | serviceId | PK

| ownerId | FK

| name

| description

| price

| serviceType

CancelRequest

PK | cancelId | PK

| bookingId | FK

| userId

| status

| createdAt

| resolvedAt

Support Ticket

PK | ticketId | PK

| userId | FK

| message

| status

| createdAt

| resolvedAt

| adminId | FK

Location

PK | locationId | PK

| bookingId | FK

| address

User

PK | userId | PK

| name

| email

| password

Owner

PK | ownerId | PK

| userId | FK

| name

| email

Service

PK | serviceId | PK

| ownerId | FK

| name

| description

| price

| serviceType

OwnerRequest

PK | requestId | PK

| ownerId | FK

| serviceId | FK

| requestType

| status

| submitDate

Admin

PK | adminId | PK

| name

| email

UserReward

PK | rewardId | PK

| userId | FK

| rewardPoints

Support Ticket

PK | ticketId | PK

| userId | FK

| message

| status

| createdAt

| resolvedAt

| adminId | FK

Review

PK | reviewId | PK

| userId | FK

| serviceId | FK

| rating

| comment

Booking

PK | bookingId | PK

| userId | FK

| serviceId | FK

| status

| bookingDate

UpdateService

PK | updateId | PK

| serviceId | FK

| ownerId | FK

| newData

| timestamp

Payment

PK | paymentId | PK

| bookingId | FK

| amount

| status

| attempts

| method

OrderTracking

PK | trackingId | PK

| bookingId | FK

| status

| timestamp

Location

PK | locationId | PK

| bookingId | FK

| address

CancelRequest

PK | cancelId | PK

| bookingId | FK

| userId | FK

| status

| createdAt

| resolvedAt

ERD

by MANAR

0
0 uses