How to implement website with list of sites and related resources

I would like to create a self hosted wp site which lists various sites (physical locations) and then for each site offers various digital assets like maps, photos, even comments from other users. I am not highly experienced with wp and would appreciate a bit of guidance.

It would make sense to have a ‘page’ for each site. I need to then have a list of all sites, searchable and with an a-z filter feature at the top.

For the digital assets like maps and photos, one interesting angle is that some of the maps will be in common between sites. I am database developer, and so I was thinking in terms of a many to many relationship between sites and maps…but I’m not sure how that might be implemented in wp and it may be overkill. If it’s a simple ‘page’ per site, I suppose it might suffice to link to the relevant maps etc.

As a database person, I like the idea of a map ‘record’, which if deleted (out of date map etc) would cascade delete the joining records to sites…and thus no broken links etc. And from a map ‘record’, one could see which sites are related, which would be useful.

I am working out exactly that the goal is with the end users, so some of this is vague, but I would appreciate any pointers in the meantime so that I can experiment with the options.

• This topic was modified 8 years, 1 month ago by lacon.