database 是否有标准的电子商务数据库模式将折扣/税收/礼券应用于产品？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/320211/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Is there a standard e-commerce database schema to apply the discounts/taxes/gift vouchers to products?
提问by suhair
A good and flexible database schema illustrating e-commerce products and their rates management is required.
需要一个良好且灵活的数据库模式来说明电子商务产品及其费率管理。
回答by domusvita
I agree with Chris Roberts, OSCommerceis a good place to start as well as DatabaseAnswers.org.
我同意 Chris Roberts 的观点，OSCommerce和DatabaseAnswers.org都是一个很好的起点。
Hope that helps.
希望有帮助。
回答by Chris Roberts
I'm sure there are many examples about - try looking at some open source shopping cart tools.
我确信有很多关于 - 尝试查看一些开源购物车工具的例子。
As a general point, though, I think there are so many ways that a product pricing and discount / gift voucher system couldwork that finding a database schema that works for everypossibility is unlikely!
不过，总的来说，我认为产品定价和折扣/礼券系统可以通过多种方式发挥作用，因此不太可能找到适用于所有可能性的数据库模式！
Perhaps you can save yourself some heartache by refining the requirements a little?
也许你可以通过稍微提炼一下需求来为自己省去一些心痛？
