Posted by mail2riyadh@gmail.com on 05/17/06 07:50

Hi Tia

As you are saying, associated characteristics of a item should be eight
all time. I think this is not a good idea. My experience says that
after few days you will want add more characteristics for an item. So
it would be better making another two table along with Item table

1. Create table with list of characteristics
CharacterID
Associated characteristics
2. Create table to make many to many releationship with Item table and
Characteristics table
ItemID
CharacterID

By the by, this is my personal preference.

Thanks
Riyadh Hossain

• Next in forum: Re: session_start(): Cannot send session cache limiter - headers already sent
• Prev in forum: Re: The point of REST?
• Thread view: Re: what is better - one field or eight - mysql bit testing

[Reply to this message]