Posted - 04/27/2015 : 11:08:22
| We have customer Types that have different business rules required based by class.
Customer Class Type #1
Customer Class Type #2
Customer Class Type #3
In the example above, both the SupplierCustomerID# and the payToCustomerID numbers are referring back to the Customers Table. In order to get information about the Pay To Customer, a query to the Customer table is needed.
What is the best practice for handling this type of database design?
Thank you for your help regarding this database design question.