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.

 All Forums
 General SQL Server Forums
 Database Design and Application Architecture
 Database Design Best Plan

Author  Topic 

buckeyeJane
Starting Member

11 Posts

Posted - 2015-04-27 : 11:08:22
We have customer Types that have different business rules required based by class.



Customers
BillingCustomer#
OperationalCustomer#
CustomerId#
.
.
.

Customer Class Type #1
AcquisitionCode
Disposition
**PayToCustomerId#

Customer Class Type #2
Latitude
Longitude
OperationType
**PayToCustomerId#

Customer Class Type #3
Acquisition Code
Disposition
Notification Method
**SupplierCustomerID#


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.

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2015-04-27 : 14:07:33
please follow these posting guidelines: http://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum/

be sure to show the query you have worked up so far!
Go to Top of Page
   

- Advertisement -