Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Last revision Both sides next revision
account_schema [2019/01/30 09:21]
127.0.0.1 external edit
account_schema [2019/01/30 11:57]
kcifreo
Line 1: Line 1:
-=Description= +==== Description ====
- +
  
 The Account Schema is the logical relationship between tables in a Control database that deal with Customers and Contacts. The Account Schema is the logical relationship between tables in a Control database that deal with Customers and Contacts.
-  * Account  
-    * AccountContact  
- 
- 
- 
-<html><div style="margin-left: 40px;">> linked on Account.ID = AccountContact.AccountID </div></html> 
- 
- 
- 
-<html><div style="margin-left: 40px;">> backlink on Account.PrimaryContactID = AccountContact.ID </div></html> 
  
 +  * Account
 +      * AccountContact
  
 +<html><div style="margin-left: 40px;"> linked on Account.ID = AccountContact.AccountID </div></html>
  
-<html><div style="margin-left: 40px;">> backlink on Account.BillingContactID = AccountContact.ID </div></html> +<html><div style="margin-left: 40px;"> backlink on Account.PrimaryContactID = AccountContact.ID </div></html>
-      * AccountContactUserField+
  
 +<html><div style="margin-left: 40px;"> backlink on Account.BillingContactID = AccountContact.ID </div></html>
  
 +  * AccountContactUserField
  
 <html><div style="margin-left: 40px;">>> linked on AccountContact.ID = AccountContactUserField.ID </div></html> <html><div style="margin-left: 40px;">>> linked on AccountContact.ID = AccountContactUserField.ID </div></html>
-      * Address  
- 
  
 +  * Address
  
 <html><div style="margin-left: 40px;">>> linked on AccountContact.BillingAddressID = Address.ID </div></html> <html><div style="margin-left: 40px;">>> linked on AccountContact.BillingAddressID = Address.ID </div></html>
- 
- 
  
 <html><div style="margin-left: 40px;">>> linked on AccountContact.ShippingAddressID = Address.ID </div></html> <html><div style="margin-left: 40px;">>> linked on AccountContact.ShippingAddressID = Address.ID </div></html>
-      * AddressLink 
- 
  
 +  * AddressLink
  
 <html><div style="margin-left: 40px;">>> linked on AccountContact.ID = AddressLink.ParentID and AccountContact.ClassTypeID = AddressLink.ParentClassTypeID </div></html> <html><div style="margin-left: 40px;">>> linked on AccountContact.ID = AddressLink.ParentID and AccountContact.ClassTypeID = AddressLink.ParentClassTypeID </div></html>
-        * Address 
- 
  
 +  * Address
  
 <html><div style="margin-left: 40px;">>>> linked on AddressLink.AddressID = Address.ID </div></html> <html><div style="margin-left: 40px;">>>> linked on AddressLink.AddressID = Address.ID </div></html>
-      * PhoneNumber  
- 
  
 +  * PhoneNumber
  
 <html><div style="margin-left: 40px;">>> linked on AccountContact.MainPhoneNumberID = PhoneNumber.ID </div></html> <html><div style="margin-left: 40px;">>> linked on AccountContact.MainPhoneNumberID = PhoneNumber.ID </div></html>
- 
- 
  
 <html><div style="margin-left: 40px;">>> linked on AccountContact.MainFaxNumberID = PhoneNumber.ID </div></html> <html><div style="margin-left: 40px;">>> linked on AccountContact.MainFaxNumberID = PhoneNumber.ID </div></html>
-      * Employee (used when using separate sales people for contacts) 
- 
  
 +  * Employee (used when using separate sales people for contacts)
  
 <html><div style="margin-left: 40px;">>> linked on Account.SalespersonID1 = Employee.ID </div></html> <html><div style="margin-left: 40px;">>> linked on Account.SalespersonID1 = Employee.ID </div></html>
- 
- 
  
 <html><div style="margin-left: 40px;">>> linked on Account.SalespersonID2 = Employee.ID </div></html> <html><div style="margin-left: 40px;">>> linked on Account.SalespersonID2 = Employee.ID </div></html>
- 
- 
  
 <html><div style="margin-left: 40px;">>> linked on Account.SalespersonID3 = Employee.ID </div></html> <html><div style="margin-left: 40px;">>> linked on Account.SalespersonID3 = Employee.ID </div></html>
-    * AccountUserField 
- 
  
 +  * AccountUserField
  
 <html><div style="margin-left: 40px;">> linked on Account.ID = AccountUserField.ID </div></html> <html><div style="margin-left: 40px;">> linked on Account.ID = AccountUserField.ID </div></html>
-    * Address  
- 
  
 +  * Address
  
 <html><div style="margin-left: 40px;">> linked on AccountContact.BillingAddressID = Address.ID </div></html> <html><div style="margin-left: 40px;">> linked on AccountContact.BillingAddressID = Address.ID </div></html>
- 
- 
  
 <html><div style="margin-left: 40px;">> linked on AccountContact.ShippingAddressID = Address.ID </div></html> <html><div style="margin-left: 40px;">> linked on AccountContact.ShippingAddressID = Address.ID </div></html>
-    * AddressLink 
- 
  
 +  * AddressLink
  
 <html><div style="margin-left: 40px;">> linked on Account.ID = AddressLink.ParentID and Account.ClassTypeID = AddressLink.ParentClassTypeID </div></html> <html><div style="margin-left: 40px;">> linked on Account.ID = AddressLink.ParentID and Account.ClassTypeID = AddressLink.ParentClassTypeID </div></html>
-      * Address 
- 
  
 +  * Address
  
 <html><div style="margin-left: 40px;">>> linked on AddressLink.AddressID = Address.ID </div></html> <html><div style="margin-left: 40px;">>> linked on AddressLink.AddressID = Address.ID </div></html>
-    * PhoneNumber  
- 
  
 +  * PhoneNumber
  
 <html><div style="margin-left: 40px;">> linked on Account.MainPhoneNumberID = PhoneNumber.ID </div></html> <html><div style="margin-left: 40px;">> linked on Account.MainPhoneNumberID = PhoneNumber.ID </div></html>
- 
- 
  
 <html><div style="margin-left: 40px;">> linked on Account.MainFaxNumberID = PhoneNumber.ID </div></html> <html><div style="margin-left: 40px;">> linked on Account.MainFaxNumberID = PhoneNumber.ID </div></html>
-    * PricingLevel 
- 
  
 +  * PricingLevel
  
 <html><div style="margin-left: 40px;">> linked on Account.PricingLevelID = PricingLevel.ID </div></html> <html><div style="margin-left: 40px;">> linked on Account.PricingLevelID = PricingLevel.ID </div></html>
-    * Promotion 
- 
  
 +  * Promotion
  
 <html><div style="margin-left: 40px;">> linked on Account.PromotionID = Promotion.ID </div></html> <html><div style="margin-left: 40px;">> linked on Account.PromotionID = Promotion.ID </div></html>
-    * PaymentTerms 
- 
  
 +  * PaymentTerms
  
 <html><div style="margin-left: 40px;">> linked on Account.PaymentTermsID = PaymentTerm.ID </div></html> <html><div style="margin-left: 40px;">> linked on Account.PaymentTermsID = PaymentTerm.ID </div></html>
-    * TaxClass 
- 
  
 +  * TaxClass
  
 <html><div style="margin-left: 40px;">> linked on Account.ClassTypeID = ClassType.ID </div></html> <html><div style="margin-left: 40px;">> linked on Account.ClassTypeID = ClassType.ID </div></html>
-    * Employee 
- 
  
 +  * Employee
  
 <html><div style="margin-left: 40px;">> linked on Account.SalespersonID1 = Employee.ID </div></html> <html><div style="margin-left: 40px;">> linked on Account.SalespersonID1 = Employee.ID </div></html>
- 
- 
  
 <html><div style="margin-left: 40px;">> linked on Account.SalespersonID2 = Employee.ID </div></html> <html><div style="margin-left: 40px;">> linked on Account.SalespersonID2 = Employee.ID </div></html>
- 
- 
  
 <html><div style="margin-left: 40px;">> linked on Account.SalespersonID3 = Employee.ID </div></html> <html><div style="margin-left: 40px;">> linked on Account.SalespersonID3 = Employee.ID </div></html>
-    * Account (self-reference for parent/subsidiaries) 
- 
  
 +  * Account (self-reference for parent/subsidiaries)
  
 <html><div style="margin-left: 40px;">> linked on Account.ParentID = Account.ID </div></html> <html><div style="margin-left: 40px;">> linked on Account.ParentID = Account.ID </div></html>
- 
- 
  
 =Source= =Source=
- 
- 
  
 Contributor: Cyrious Contributor: Cyrious
- 
- 
  
 Date: 6/2016 Date: 6/2016
- 
- 
  
 Version: Control 5/7 Version: Control 5/7
- 
-