Livoa LogoLivoa
Customer


CustomerID (PK)

Name

Contact

Address

ServiceProvider


ProviderID (PK)

Name

ServiceType

Contact

Service


ServiceID (PK)

ClientID (FK)

OrganizerID (FK)

Amount

ServiceDetails

Booking


BookingID (PK)

UserID (FK)

ProviderID (FK)

ServiceID (FK)

Date

Location


LocationID (PK)

Address

Capacity

User


UserID (PK)

UserName

UserMobile

UserEmail

Feedback


FeedbackID (PK)

BookingID (FK)

Rating

Comments

Admin


Admin_id

Name

Email

Password

login()

manageUsers()

manageOrganizers()

monitorLogs()

generateReport()

Organizer


Organizer_id

Name

Email

Password

login()

reviewLog()

approvalLog()

selectLog()

giveFeedback()

User


User_id

Name

Email

Password

login()

submitLog()

updateLog()

reportLog()

ServiceList


Service_id

Organizer_id

Location_id

DateTime

Details

bookService()

cancelService()

editService()

Service


Service_id

Organizer_id

Details

Amount

ContactInfo

updateService()

deleteService()

Payment


Payment_id

Event_id

Amount

Details

makePayment()

getInvoice()

Organizer


OrganizerID (PK)

OrganizerName

Payment


PaymentID (PK)

PayDate

Status

PayCusID (FK)

Login


LoginID (PK)

UserID (FK)

UserPass

sp

by sp

0
0 uses