Looks like route names aren't always original, and duplicates exist in our datatset. I've changed the the Primary Key of a Route to be (RouteName, Latitude) to ensure unique primary keys.
Maybe it's cleaner to just do auto-incremented route id's like @luwop had originally suggested?
Looks like route names aren't always original, and duplicates exist in our datatset. I've changed the the Primary Key of a Route to be (RouteName, Latitude) to ensure unique primary keys.
Maybe it's cleaner to just do auto-incremented route id's like @luwop had originally suggested?