staff table-howo to connect with bookings and bus. users table
Posted by: Dimitris Papageorgiou
Date: February 20, 2014 02:02PM

I am making a booking app(appointments specifically).As such I have created a booking table where details about the appointmetns are kept,details such as date/time,duration,name(who made the booking-end user of the app) and...staff name.

The end user will have to option to choose with what staff of the business user he/she wants to make the booking with(as is the case of hair salon for example).

So, I have created also a second table...which he will contain details regarding the staff,details such as name and with whom business user he/she is associated with.

I must mention also that there is a 3rd table that contains data regarding the business users and as I see it must be connected also with the staff table so as to indicate the connection between a business user and a staff.

The question is how to connect all of these 3 tables...
What do you propose?

Here is an image so that you can see in an EER diagram the 3 tables mentioned.
http://1drv.ms/Mf1inz

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.