How to Structure this Site?

  • I have a fairly large site that was done in PHP and MySQL and I’m considering moving it to WordPress. You can find it at TrailDamage.com (it’s a site featuring offroad trails and dated reports for the trails) but I can explain it fairly easily. The following hierarchy exists:

    -trail01
    –report01
    —user01
    —user02
    —user03
    –report02
    —user01
    —user02
    –report03
    —user02
    —user03
    -trail02
    –report01
    —user01
    —user02

    https://www.traildamage.com/_etc/highlevel.png

    Each user should be a WP user and there are about 200 of them with new ones added regularly. There are about 450 trails. There are about 1,025 reports. There is a hierarchy between trails and reports, and it’s a 1-to-1 relationship. Each user can be associated with many different reports.

    Each report will have at least one image associated with it, and some also have videos. There are over 55,000 of these binary files.

    I’m a developer, so I feel fairly confident I can eventually write scripts to migrate all of this data into WP. However, I’m not sure how it should be set up originally. Any suggestions, on a high level? How do I show the relationship between trails and reports? If anyone can recommend plugins to solve some tasks I’d really appreciate it.

    Thanks in advance for the pointers!

  • The topic ‘How to Structure this Site?’ is closed to new replies.