Quote:
Originally Posted by princeton
you can still use the same table ... add additional fields and call/display them when needed.
there is no need to add 3 different tables
|
Yep if you wanted to do it this way you could, but I don't know exactly the effects that you would be trying to achieve. You wouldn't really save storage space because you would still have to add a new column for the type so that you could perform the select to receive specific data. Also if you're trying to save query usage it would be quite difficult to get the data in one query unless you did specific caching of the database.
Cheers,
g-force2k2