Re: [Rails] Database design, working but looking for better ways

On 13 October 2012 06:10, Soichi Ishida <lists@ruby-forum.com> wrote:
> Rails 3.1.3
>
> Hi. I have designed the database used for my travel plan application.
> 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 space, I detach the city name (string)
> from both departures and destinations, dealing with the connections
> among them by id's.
>
> It works. But I am wondering if there are better ways to do it. The
> logic becomes rather complex and inevitably the database workload will
> be troublesome(?), I suppose.

Destination and Departure should not be separate tables, you should
just have a table of places, then city is just a member of Place and a
FlightName belongs to two Places, as departure and destination.

I am not sure why a plan needs destination and departure, can it not
get these from the FlightName?

Colin
>
> So what do you think?
>
> soichi
>
> --
> Posted via http://www.ruby-forum.com/.
>
> --
> You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
> To post to this group, send email to rubyonrails-talk@googlegroups.com.
> To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>

--
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To post to this group, send email to rubyonrails-talk@googlegroups.com.
To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.