Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Forgot

Author  Topic 

Rauken
Posting Yak Master

108 Posts

Posted - 2002-09-17 : 10:51:43
Here's some info on the design:

Table: product
product_id
material_dictionary_id
description_dictionary_id
garment_type_id

Table: dictionary_entry
dictionary_id
dictionary_text
language_id

Table: garment_type
garment_type_id
dictionary_id

I have a link between the tables on the dictionary_id's and between garment_type and product. All text is stored in the dictionary_entry table.

robvolk
Most Valuable Yak

15732 Posts

Posted - 2002-09-17 : 10:54:27
Link to:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=19878

Go to Top of Page
   

- Advertisement -