Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Localisation.adresse field should not be unique #309

Open
jmaupetit opened this issue Dec 19, 2024 · 0 comments
Open

Localisation.adresse field should not be unique #309

jmaupetit opened this issue Dec 19, 2024 · 0 comments
Labels
API Item related to the API service improvement schema Discussions around data schemas

Comments

@jmaupetit
Copy link
Member

Purpose

At the time of writing, it has been reported that we cannot create two distinct stations using the same address and different coordinates. As addresses could be sparse data, we should be more flexible on this and allow two stations to be referenced with the same address (e.g. street, zip code and city but no street number).

Proposal

  1. remove the uniqueness constraint on the Localisation.adresse field,
  2. add (pick one):
    • a unique-together constraint on the Localisation.(adresse, coordonneesXY) fields couple, or,
    • a unique constraint on the Localisation.coordonneesXY field
@jmaupetit jmaupetit added improvement schema Discussions around data schemas API Item related to the API service labels Dec 19, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
API Item related to the API service improvement schema Discussions around data schemas
Projects
None yet
Development

No branches or pull requests

1 participant