Introduction
While working on an eCoach project built with WordPress Multisite, I faced a database architecture challenge that looked small at first but became an important lesson about plugin limitations, data ownership, and designing scalable solutions.
The project requirement was to use ACF Pro Custom Tables because the client wanted to manage custom fields through the familiar ACF interface. However, the database structure they required was different from the way ACF Pro handles tables in a WordPress Multisite environment.
The client wanted a learner management system where the data was shared across the entire network.
The expected database structure was:
