Database design for B2B2C system

20
January 13, 2019, at 05:00 AM

I want to create an application, where my direct clients are business person. They would use the application to make transactions with their customers. The business people whom I'll be vending out the application may have common customers. I want to have a customer table too and a customer end appication. How should I desing my database, so that the customer is able to view his/her transactions all at once from different business persons. Should I keep the transactions of all the business persons in one table with their businessId as PK?
Typical examples are the food delivery applications showing array of restaurants on one platform. So do they save orders and food-menu of all restaurants in one table with restaurant's PK as differentiator?
Any help would be appreciated.

READ ALSO
i can't get the following $resultCheck to redirect

i can't get the following $resultCheck to redirect

I have the following code and it is displaying the select tag options as $level1promo_competition based on what is in my databaseThe thing that is puzzing me is that if I changed the name in my database or my variable to something else other than what is in my database,...

35
how to call json with and without data [on hold]

how to call json with and without data [on hold]

i tried to make a json from php and want it can be get with data like http://localhost/moviereview/?action=get_review&genre=biography and or without data like http://localhost/moviereview/?action=get_review

25
Image from database is not appearing on the .jsp page [on hold]

Image from database is not appearing on the .jsp page [on hold]

The screenshot below shows my web page that is not showing the imageCan someone see why that might be

19
convert the url & hashtag into link

convert the url & hashtag into link

In my code I have #hashtag standing but also Iframe + URL but It shows only the hashtag further it does not show the Iframe + URL

19