Re: Three tables or one?
Posted by: James Gordon
Date: March 14, 2007 09:20AM

I'd beg to differ.

Having one table with a type id linked to a look up table is better.

IF you have another type of device, e.g. satellite phone you would have to add a new table, alter views etc.

Wth the single table and a look up table you add another row to the look up table and you can then add that type without altering the structure of the database.

table devices
~~~~~~~~~~~~~
deviceid
typeid
...

table devicetypes
~~~~~~~~~~~~~~~~~
typeid
typename
...

Options: ReplyQuote


Subject
Written By
Posted
March 13, 2007 03:55PM
March 14, 2007 03:01AM
Re: Three tables or one?
March 14, 2007 09:20AM
March 14, 2007 09:29AM
March 16, 2007 08:07AM
March 25, 2007 03:38PM
March 26, 2007 04:40AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.