Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Order and Order details table
Message
De
11/04/2006 13:24:12
Sergio Ortiz
Tek Services Group, Llc
Hollywood, Floride, États-Unis
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Conception bases de données
Divers
Thread ID:
01112440
Message ID:
01112583
Vues:
10
Hello Enmanuel,

Thanks for your feedback. I was leaning for your solution. Since the 'Orders Detail' records will contains lots of records, it is better to minimize the number of fields.On the other hand Products and Services table will have few records and I can afford to have many fields. For example tack_stockLevel does not apply to services.

>You may also want a type table where you indicate the different types of >items just in case you want to add more than just services & products, >let's say for example "no billable".

Good idea. I did not think about it.


Thanks,
Sergio
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform