I have an API written using CakePHP and one of the tables contain data for AppUsers. The request is to place the AppUsers table into a separate database but somehow maintain the App working as it is one Database. I need to take into account that other tables have data that belongs to the AppUsers table. Is this even possible? How can I manage it. If not, any suggestions? Note that this table is not used to log in a user into the application. It is just used to collect data from a device.
