Information générale
Forum:
Microsoft SQL Server
Catégorie:
Conception bases de données
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
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