hello guys, need some advice, for who read this, for you what is best way to make an address table (use for many other tables) if you have some example for db design and prisma.

If you're referring to physical address like for a location such as:

street No, suburb, PC, City, Country

Personally it'd depend on how you intend consuming this information later on. Ask yourself, do you actually need all the components of a physical address or do you just need something that will tell google places API what value to show? Otherwise, I'd suggest providing more context, coz that information alone is not enough to provide a more helpful answer :)

So i need address of user (zipcode adress city country) i need address for where the product is located ( in same deposit ) so many Product can have exactly same address, and some user can have same address (employee)