I'm trying to build a database of K-12 schools for a directory site and wanted to organize them nicely as well as make it easy to enter information in without re-entering the same info in too much.
I came up with this solution that involves 4 channels and playa fields:
- Channel: States - has only Title field (50 entries)
- Channel: Counties - has a Title field and a Playa field: state (58 entries in this channel for the state of CA alone)
- Channel: School Districts - has a Title field and a Playa field: county (100's of entries in this channel for the state of CA alone)
- Channel: Schools - has a Title field, a Playa field: district, as well as a number of other fields that pertain to the school.
I figured by having the prior relationships I can traverse up and get all the info I need without having to enter in the same info in each school all the time.
Main question is: Is my structure overkill?
My end goal is to use the module Reefine to use for filtering. This way users can use the filter menu to select their state, county and school district to find their school.
I have already entered some of the data in (all the states and counties for the state of CA, as well as about 150 school districts so far.
Any help/guidance for making this easier/more streamlined would be great. Thanks!