Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Best terminology to use
Message
De
09/03/2015 14:36:19
Walter Meester
HoogkarspelPays-Bas
 
 
À
09/03/2015 14:19:15
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Versions des environnements
SQL Server:
SQL Server 2012
Application:
Web
Divers
Thread ID:
01616505
Message ID:
01616508
Vues:
40
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
Fil
Voir

Click here to load this message in the networking platform