Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tou_pilsner
Starting Member
1 Post |
 Posted - 2011-10-06 : 10:50:54
|
| I have created a sql webshop design for physical products, but I want to sell services in my webshop. I am wondering how to extend or change the design so I can start selling services? A service people buy can last for 1,2,3,4,5 years, or 30 days which is free. Some services can last for max 3 years, others for max 5 years, or one only 30 free days. Which field do I need to add to the products table to do this? I think I can add "validYears" and "validDays", but is this good database design? Here is a link to the sql design:http://www.flickr.com/photos/68317286@N05/6217522854/ |
|
|
iradev
Starting Member
45 Posts |
Posted - 2011-12-01 : 06:55:03
|
| A year can be broken down in days so I don't really see a need for validYears |
 |
|
|
|
|
|
Help with Webshop design