Relationship between Trips and Regions

hellboy1975 / pilsi

PiLSi

MIT License

1 stars 0 forks source link

Relationship between Trips and Regions #143

Open speleonut opened 5 months ago

speleonut commented 5 months ago

A Trip belongs to a Region in the schema however a Trip (in real-world terms) can easily cross over several regions (e.g. Upper and Lower SE in SA).
Suggested resolution: This would be better as a many to many relationship with Regions shown as a delimited list in the Trip table.
Work around: Segment a real-world trip into multiple sections for each Region.

hellboy1975 commented 5 months ago

Agree this would be a nice to have feature.