same table in different databases with different data vs single table in singlle database
Posted on 2011-02-23
Actually i am designing a database in MySql, In that the structure is there is one root organization and there are several child organization. So should I go for a single databse in which the group interrelated tables store the data identified by a unique id to differentiate each child organization.
Or should I maintain different databases for each child organization with the same table structure and same tables in all of them, but data related to each of them.