gatherspiel / gatherspiel/database

Update schema for locations

Open
#21 0 comments 0 reactions 0 assignees View on GitHub
2 points
Dominant language
No language data
Stars
0
Forks
0
PR merge metrics
No merged PRs in 30d

Description

The locations table currently has two types of location data. One type is locations with a city, state, street address and zip code. The other type is a location with just a city that is associated with a location group.

The schema should be updated so that both types of data are not in the same table. One possibility could be to create a location_details table that has a location id as a foreign key and contains state, street address, and zip code information.

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.