Users Table (customers and backend users)
id, username, role
Profiles table (in case you have a parent that wants to book two kids so they can create as many profiles as they want)
id, user_id, name,expertise,ratings,phone,address,age,gender, price per hour,geolocation and certify_yourself
staff_availability (this will be a type_id in the profiles table)
id, profile_id,status,active_consulatancies
Booking
id, ca_id,cus_id,date, time, end time in UTC, status, note, etc
Status type to be decided
// Non priority
Chat
Id,ca_id,cus_id,snapshots,files,cusName,caName,cusProfileImgURL,caProfileImageURL
Users Table (customers and backend users) id, username, role
Profiles table (in case you have a parent that wants to book two kids so they can create as many profiles as they want) id, user_id, name,expertise,ratings,phone,address,age,gender, price per hour,geolocation and certify_yourself
staff_availability (this will be a type_id in the profiles table) id, profile_id,status,active_consulatancies
Booking id, ca_id,cus_id,date, time, end time in UTC, status, note, etc
Status type to be decided
// Non priority Chat Id,ca_id,cus_id,snapshots,files,cusName,caName,cusProfileImgURL,caProfileImageURL
Invoice id, booking_id, price, currency transacrion_id,date,
// Non priority Complaints id,booking_id,status