ltduranltduran
8 years agoQrew Cadet
Do I need a Many to Many relationship?
My company is having an integration developed between our Booking Software and Quickbase to aggregate our bookings from all of our stores in one place. The data that is associated with this booking is being mapped to three different tables. The tables are as follows:
- Booking Info - The data being mapped here is general booking information (number of participants, type of booking, location, etc.)
- Booking Transaction: The data being mapped here is anything financial associated with the booking (revenue, taxes, coupon discounts,etc)
- Booking Customers: The data being mapped here is the customer info associated with the booking (Customer Name, Email, etc)