58 different stadium names under the Games table for the database.
- [ ] Update old stadium names to match current list of stadium names when only a renaming occurred.
(ex: Cleveland Browns Stadium -> FirstEnergy (nothing much changed other than the naming rights, making it pretty much the same stadium in terms of field surface/roof type)
- [ ] Add new entries to stadiums table for old stadiums that were different buildings as the current stadium. Include a new entry for any renamed stadium IF there was a change in field surface type/
(ex: Texans' current "NRG Stadium" was a rename of their old "Reliant Stadium" BUT the surface was changed from grass -> turf)
- [ ] Link teams somehow with associated stadiums.
(Record for each team that has ever played in a given stadium? Junction Table?)
58 different stadium names under the Games table for the database.
- [ ] Update old stadium names to match current list of stadium names when only a renaming occurred. (ex: Cleveland Browns Stadium -> FirstEnergy (nothing much changed other than the naming rights, making it pretty much the same stadium in terms of field surface/roof type) - [ ] Add new entries to stadiums table for old stadiums that were different buildings as the current stadium. Include a new entry for any renamed stadium IF there was a change in field surface type/ (ex: Texans' current "NRG Stadium" was a rename of their old "Reliant Stadium" BUT the surface was changed from grass -> turf)
- [ ] Link teams somehow with associated stadiums. (Record for each team that has ever played in a given stadium? Junction Table?)