I need to build an order and invoicing system for a service company. I hope that people can recommend templates for tables that will guide my architecture. Here is what I am trying to accomplish:
Order header is a straightforward table. Customer and order information, begin date, end date, etc.
Then there is the service type. That describes which of the many services that this company offers appear on this particular order. That will include pricing information and related data. Next, we have a weekly schedule. In this service business, services can be ordered everyday and the schedule for the week is replicated for a given number of weeks into the future. At the end of the service period, the schedule might be extended for another period of 60 or 90 days.
Within each service , there is a set of optional items that might be included in the order at no charge. These would be analogous to cream and sugar with the coffee - they do not alter the price, but they are options at may be selected or not selected for each order. The given bundle of options is the same on each day's instance of that order throughout the perio.
Can anyone point me to a resource that describes the preferred table approach to shut a system?
Order header is a straightforward table. Customer and order information, begin date, end date, etc.
Then there is the service type. That describes which of the many services that this company offers appear on this particular order. That will include pricing information and related data. Next, we have a weekly schedule. In this service business, services can be ordered everyday and the schedule for the week is replicated for a given number of weeks into the future. At the end of the service period, the schedule might be extended for another period of 60 or 90 days.
Within each service , there is a set of optional items that might be included in the order at no charge. These would be analogous to cream and sugar with the coffee - they do not alter the price, but they are options at may be selected or not selected for each order. The given bundle of options is the same on each day's instance of that order throughout the perio.
Can anyone point me to a resource that describes the preferred table approach to shut a system?
