Alright. So I'm converting a site I already have to Processwire (really enjoying it so far!). I wanted to convert the previous tables that I had data in to Processwire pages. But I'm wondering what the optimal way to structure pages would be.
So basically, I have three main tables.
Users (and all accompanying information)
Items (and all accompanying information)
Aquariums (each user only has 1 aquarium. Currently, user_id is a FK)
Fish (type of item. Aquariums may have multiple fish)
Aqua_settings (Things like lightness, temperature, etc)
So in my current setup, there are a lot of Foreign Keys. I could accomplish essentially the same thing by using the Page Reference field.
Alternatively, I could make fish and aqua_settings both be children of Aquarium. I could differentiate by doing $aquarium->children('template=aqua_settings'); or something.
So my question is...should I be using the Page Reference field or structuring the pages as children? (Or are both equally fine depending on how I want to go about doing things)