Table Trouble

[Irene]

Hi all :)

 

I've been around a bit, but I'm new around here and am getting on fine with customising and so on. But...

 

I have some new fields and I can't decide which table they should go in. As you'll see the products are books and to be more specific I've got:

 

products_author          ---> new field in products table

products_title              ---> products_name in products table

products_publisher      ---> manufacturers_name in manufacturers table

products_keywords    ---> new field in products table (needs to be included in simple search)

products_description  ---> products_description in products_description table

products_isbn            ---> products_model in products table

products_illustrator    ---> new field in products_description table

products_stock_id      ---> new field in products

 

I'm so not sure about this. Does that seem ok or is there a better way?

 

I guess that some of them will need indexed, particularly products_author?

 

Is it the case that the products_description table is best used for storing information that is only displayed when an items details are displayed and are not for searching through? (Apart from the description switch of course)

 

Thanks for any help :thumbsup: .

 

Cheers,

 

Irene

[Guest]

Consider using the product attributes and just renaming manufacturer to publisher instead of changing so much. It might be easier.

[Irene]

Consider using the product attributes and just renaming manufacturer to publisher instead of changing so much. It might be easier.

<{POST_SNAPBACK}>

 

That's an interesting suggestion, but I can't see it working as the products_attributes table is all about options for specific items. These books have no options at all. I feel it's better to create new fields if there aren't any potential surrogates available rather than mangle some other mechanism - you never know, perhaps we will need options at some point in the future.

 

Using manufacturer for publisher is exactly what I was thinking of doing for that field though.

 

Cheers,

 

Irene