Displaying 1 result from an estimated 1 matches for "departure_id".
2012 Oct 13
4
Database design, working but looking for better ways
...plication.
You should be able to look at the diagram in the link below, hopefully.
https://cacoo.com/diagrams/biDSyxh8yzk2kIeg
("belongs_to" is omitted since it''s obvious)
Basically, the application can list the destinations from a choice of
the departure.
Not mention that the departure_id (integer) and destination_id (integer)
should not appear but the "city.name" must appear for the users.
Each "Plan" will find both Departure and Destination implicitly and the
only corresponding City.name ''s must show up on the screen.
In order to save the database sp...