Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Order and Order details table
Message
From
11/04/2006 13:24:12
 
General information
Forum:
Microsoft SQL Server
Category:
Database design
Miscellaneous
Thread ID:
01112440
Message ID:
01112583
Views:
9
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform