重复订单(Recurring Orders)

 大家好，我正在研究一个学校项目，对于我的项目，我选择创建一个可以处理重复订单的电子商务系统。 这是我最后的项目，我将于5月份与计算机科学的同事一起毕业。 
 
 请记住，这不是最终解决方案，它基本上是这个数据库设计的起点。 
 
  
 
 关于业务流程的一点背景。 
 - 客户将订购产品，并在结账时指定是一次性订单还是每周/每月订单。 
 - 客户将指定一个接收订单的位置（此位置仅针对订单） 
 - 如果订单的价值> 25.00则接受，否则将被拒绝。 
 - 这将分别填充orders_test和order_products_test表 
 
 
 
 后端的人将根据这两个表生成当天交付的报告。 
 
 
 他们将能够将其打印出来，并生成一个列表，列出哪些项目可以到达哪个位置。 基于以下标准。 
 
 
 date_of_next_scheduled_delivery =当前日期 
 
 
 remaining_deliveries> 0 
 
 
 一旦他们对交货清单感到满意，他们将按“处理交货”按钮。 
 
 
 这将调整order_products_test表，如下所示 
 
 
 从remaining_deliveries中减去1 
 
 
 将当前日期插入date_of_last_delivery_processed 
 
 
 根据delivery_frequency（即一次，每周，每月），它将更改date_of_next_scheduled_delivery 
 
 
 order_products_test表中的状态值可以是活动的，保持的，也可以是取消的，已过期 
 
 
 如果我正确地接近这一点，或者我应该抓住这种方法并重新开始，我只是想要一些意见。 

Hi everyone I'm working on a school project, and for my project I chose to create an ecommerce system that can process recurring orders. This is for my final project, I'll be graduating in May with an associates in computer science.
 
Keep in mind this is no where a final solution and it's basically a jumping off point for this database design.
 
 
A little background on the business processes.
 - Customer will order a product, and will specify during checkout whether it is a one time order or a weekly/monthly order.
 - Customer will specify a location in which to pick up their order (this location is specific only to the order)
 - If the value of the order > 25.00 then it is accepted otherwise it is rejected.
 - This will populate the orders_test and order_products_test tables respectively 
 
 
 
Person on the back end will have a report generated for deliveries for the day based on these two tables. 
 
 
They will be able to print it off and it will generate a list of what items go to what location. Based on the following criteria. 
 
 
date_of_next_scheduled_delivery = current date 
 
 
remaining_deliveries > 0 
 
 
Once they are satisfied with the delivery list they will press "Process Deliveries" button. 
 
 
This will adjust the order_products_test table as follows 
 
 
Subtract 1 from remaining_deliveries 
 
 
Insert current date into date_of_last_delivery_processed 
 
 
Based on delivery_frequency (i.e. once, weekly, monthly) it will change the date_of_next_scheduled_delivery 
 
 
status values in the order_products_test table can either be active, hold, or canceled, expired 
 
 
I just would like some opinions if I am approaching this correctly or if I should scratch this approach and start over again.

原文：https://stackoverflow.com/questions/4738504