Hi, after a goodbye kiss to MySQL and some dig into
MongoDB non-relational way, i've found some questions and couldn't find any
direct answer to that.
The mais question about non-relacional databases is, imagine
I have three tables:
*Clients | Suppliers | Orders*
Each one have it's own info:
*Clients* have phone, name, etc per row,
*Suppliers* have adress, fax, etc,
*Orders *(pay attention, now comes the crux) instead, have both clients who
is ordering, and the Supplier who owns the product.
In MySQL i would simply create a column called "clientID" and "supplierID"
to refer to the respective datas.
*Now the question is:*
The table clients and Suppliers already have their infos, to transform this
database into non-relational, how the schema would be?
Should i made a refer the collection Order to the collection Suppliers and
I really can't think in a different way to make it, sorry about that,
its difficulty to change the way we see database after many years using