Multi User type Database

[Solo1]

Still very green to Adalo so any input or help will be much appreciated…
Wonder if someone could advise on database setup for a Multi User type database…?
I’m sure some of this must have been covered somewhere in the forum before so please forgive if this is a repeat.

Basic app description:
The App is a Services on Demand App with the following Role/Users:

1. A User will register and log in via username and password, have a profile with all their previous bookings, order details, payments done, address, contact info etc.
2. Multiple Service providers can register and log in via username and password, have a profile with all their previous bookings, order details, payments done, address, contact info etc.
3. Service provider can have multiple work teams/drivers that will accept service requests and go out to users onsite.
4. App will have Sales Agents with their own log in, keeping track of all the service providers they have signed up and calculate commission derived from their services delivered.
5. Admin, login to dashboard where all bookings, payments, commissions can be monitored.

App functions:
Multiple categories of services that users can chose from.
App display via Geo-location the service providers available in the users area.
User fills in a request that describes services needed and date time they need the services to be completed in. A request to quote is then sent to all active Service providers in the Users area.
Service providers reply with quotes to user.
User accept a quote from one of the service providers based on best price or best rating.
User is then asked to make payment. That payment then reflects in their wallet as funds available.
Service provider delivers service and once delivered sends completion acceptance request to user. User confirm job completion and system then pays service provider from the Users available wallet funds.
Database needs to handle thousands of users and Service providers requests per day.

That’s it in a nutshell…

To be honest I have no Idea where to start. Structuring the database correctly I think is a great start the functionality of the app should then be addressed one by one…

So, if anyone has any advice or can point me in the direction of tutorials, videos or any previous discussions, similar topics that can help will be much appreciated.

Thanks,

[Jacob_Lange]

CHeck out This thread.

It speaks of join tables. I utilized this database structure in my app and it doesn’t affect performance and I can link anything to everything! This structure may be where you need to lean for your database structure.