Database Structure for CakePHP Models
- by Michael T. Smith
We're building a data tracking web app using CakePHP, and I'm having some issues getting the database structure right. We have Companies that haveMany Sites. Sites haveMany DataSamples. Tags haveAndBelongToMany Sites.
That is all set up fine. The problem is "ranking" the sites within tags. We need to store it in the database as an archive. I…