From: brian <brian@...>
Date: 2008-07-01T01:09:00+09:00
Subject: Tables: Unnecessary duplication of id fields

=begin

Hello,

I'm fairly new to Ruby, but I am trying to understand the relationship
between database structure and models.

My difficulty is that I have five or so tables all linked together and their
primary key column is a serial number

The tables are a set of tables called:

itemmasters
products
prices
subprices
imprints
etc.

products, prices, and subprices, imprints, etc. belong to itemmasters based
on a serial number

How can I get about linking them without having to have a column in
itemmasters for each of the sub tables?

For instance:

product_id
price_id
subprice_id
imprint_id

This would be somewhat silly as they all contain the same information.
Right?

Thank you,

Brian Anderson

=end