Walter Meester
HoogkarspelPays-Bas
Information générale
Forum:
Microsoft SQL Server
Versions des environnements
SQL Server:
SQL Server 2012
Linking table?
>I am looking for the best terminology to use on a specific table.
>
>I have a Store table. That is the parent table. It contains a list of items availble in the store.
>
>I have a StoreChoice table. That is the parent relationship table. It contains a list of choices which could apply to some items. That could be a size or a color.
>
>I have a StoreChoiceItem table. That is the parent child table. This is also known as a many to many relationship table containing the choices available. So, for the size, the list of possibilities would be Small, Medium, Large, Extra large. Then, for color, the list of possibilities, would be White, Black, Green, Red, etc.
>
>I have a StoreStoreChoiceItem table. This is the parent grand child table. This is also known as a many to many relationship table containing the choices available for an item. So, once an item is entered, we select the list of sizes available and the list of choices available. That means an item could be offered in Color (White or Red) and in Size (Small or Medium).
>
>I have an InvoiceStoreChoice. That is a table containing the selected choices for an item that is bound to the InvoiceStore table. So, an invoice has one or multiple items from the Store table. For the many to many relationship of the selections, I have the InvoiceStoreChoice.
>
>So far, this is pretty basis stuff for an online store. What I am wondering about is the proper terminology for recognizing those tables. For example, it is still unclear how to properly recognized the InvoiceStoreChoice table. For now, I am using "Selection table". It is not a child table, it is not a grand child table. How would you see it?
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement