Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision Both sides next revision
account_schema [2019/01/29 10:58]
kcifreo
account_schema [2019/01/30 09:21]
127.0.0.1 external edit
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 ​
  
-  * Account 
-      * AccountContact 
  
-linked on Account.ID = AccountContact.AccountID 
  
-backlink ​on Account.PrimaryContactID ​= AccountContact.ID+<​html><​div style="​margin-left:​ 40px;">>​ linked ​on Account.ID = AccountContact.AccountID </​div></​html>​
  
-backlink on Account.BillingContactID = AccountContact.ID 
  
-  * AccountContactUserField 
  
-linked ​on AccountContact.ID AccountContactUserField.ID+<​html><​div style="​margin-left:​ 40px;">>​ backlink ​on Account.PrimaryContactID ​AccountContact.ID </​div></​html>​
  
-  * Address 
  
-linked on AccountContact.BillingAddressID = Address.ID 
  
-linked ​on AccountContact.ShippingAddressID ​Address.ID+<​html><​div style="​margin-left:​ 40px;">>​ backlink ​on Account.BillingContactID ​AccountContact.ID </​div></​html>​ 
 +      * AccountContactUserField
  
-  * AddressLink 
  
-linked on AccountContact.ID = AddressLink.ParentID and AccountContact.ClassTypeID = AddressLink.ParentClassTypeID 
  
-  ​* Address+<​html><​div style="​margin-left:​ 40px;">>>​ linked on AccountContact.ID = AccountContactUserField.ID </​div></​html>​ 
 +      ​* Address ​
  
-linked on AddressLink.AddressID = Address.ID 
  
-  * PhoneNumber 
  
-linked on AccountContact.MainPhoneNumberID ​PhoneNumber.ID+<​html><​div style="​margin-left:​ 40px;">>> ​linked on AccountContact.BillingAddressID ​Address.ID </​div></​html>​
  
-linked on AccountContact.MainFaxNumberID = PhoneNumber.ID 
  
-  * Employee (used when using separate sales people for contacts) 
  
-linked on Account.SalespersonID1 ​Employee.ID+<​html><​div style="​margin-left:​ 40px;">>> ​linked on AccountContact.ShippingAddressID ​Address.ID </​div></​html>​ 
 +      * AddressLink
  
-linked on Account.SalespersonID2 = Employee.ID 
  
-linked on Account.SalespersonID3 = Employee.ID 
  
-  ​AccountUserField+<​html><​div style="​margin-left:​ 40px;">>>​ linked on AccountContact.ID = AddressLink.ParentID and AccountContact.ClassTypeID = AddressLink.ParentClassTypeID </​div></​html>​ 
 +        ​Address
  
-linked on Account.ID = AccountUserField.ID 
  
-  * Address 
  
-linked on AccountContact.BillingAddressID ​= Address.ID+<​html><​div style="​margin-left:​ 40px;">>>> ​linked on AddressLink.AddressID ​= Address.ID ​</​div></​html>​ 
 +      * PhoneNumber ​
  
-linked on AccountContact.ShippingAddressID = Address.ID 
  
-  * AddressLink 
  
-linked on Account.ID AddressLink.ParentID and Account.ClassTypeID = AddressLink.ParentClassTypeID+<​html><​div style="​margin-left:​ 40px;">>> ​linked on AccountContact.MainPhoneNumberID ​PhoneNumber.ID </​div></​html>​
  
-  * Address 
  
-linked on AddressLink.AddressID = Address.ID 
  
-  * PhoneNumber+<​html><​div style="​margin-left:​ 40px;">>>​ linked on AccountContact.MainFaxNumberID = PhoneNumber.ID </​div></​html>​ 
 +      * Employee (used when using separate sales people for contacts)
  
-linked on Account.MainPhoneNumberID = PhoneNumber.ID 
  
-linked on Account.MainFaxNumberID = PhoneNumber.ID 
  
-  * PricingLevel+<​html><​div style="​margin-left:​ 40px;">>>​ linked on Account.SalespersonID1 = Employee.ID </​div></​html>​
  
-linked on Account.PricingLevelID = PricingLevel.ID 
  
-  * Promotion 
  
-linked on Account.PromotionID ​Promotion.ID+<​html><​div style="​margin-left:​ 40px;">>> ​linked on Account.SalespersonID2 ​Employee.ID </​div></​html>​
  
-  * PaymentTerms 
  
-linked on Account.PaymentTermsID = PaymentTerm.ID 
  
-  ​TaxClass+<​html><​div style="​margin-left:​ 40px;">>>​ linked on Account.SalespersonID3 = Employee.ID </​div></​html>​ 
 +    ​AccountUserField
  
-linked on Account.ClassTypeID = ClassType.ID 
  
-  * Employee 
  
-linked on Account.SalespersonID1 ​Employee.ID+<​html><​div style="​margin-left:​ 40px;">> ​linked on Account.ID AccountUserField.ID </​div></​html>​ 
 +    * Address ​
  
-linked on Account.SalespersonID2 = Employee.ID 
  
-linked on Account.SalespersonID3 = Employee.ID 
  
-  ​* Account (self-reference for parent/​subsidiaries)+<​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>​ 
 +    * AddressLink 
 + 
 + 
 + 
 +<​html><​div style="​margin-left:​ 40px;">>​ linked on Account.ID = AddressLink.ParentID and Account.ClassTypeID = AddressLink.ParentClassTypeID </​div></​html>​ 
 +      * Address 
 + 
 + 
 + 
 +<​html><​div style="​margin-left:​ 40px;">>>​ linked on AddressLink.AddressID = Address.ID </​div></​html>​ 
 +    * PhoneNumber  
 + 
 + 
 + 
 +<​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>​ 
 +    * PricingLevel 
 + 
 + 
 + 
 +<​html><​div style="​margin-left:​ 40px;">>​ linked on Account.PricingLevelID = PricingLevel.ID </​div></​html>​ 
 +    * Promotion 
 + 
 + 
 + 
 +<​html><​div style="​margin-left:​ 40px;">>​ linked on Account.PromotionID = Promotion.ID </​div></​html>​ 
 +    * PaymentTerms 
 + 
 + 
 + 
 +<​html><​div style="​margin-left:​ 40px;">>​ linked on Account.PaymentTermsID = PaymentTerm.ID </​div></​html>​ 
 +    * TaxClass 
 + 
 + 
 + 
 +<​html><​div style="​margin-left:​ 40px;">>​ linked on Account.ClassTypeID = ClassType.ID </​div></​html>​ 
 +    * Employee 
 + 
 + 
 + 
 +<​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.SalespersonID3 = Employee.ID </​div></​html>​ 
 +    ​* Account (self-reference for parent/​subsidiaries) 
 + 
 + 
 + 
 +<​html><​div style="​margin-left:​ 40px;">>​ linked on Account.ParentID = Account.ID </​div></​html>​ 
 + 
 + 
 + 
 +=Source=
  
-linked on Account.ParentID = Account.ID 
  
-==== Source ==== 
  
 Contributor:​ Cyrious Contributor:​ Cyrious
 +
 +
  
 Date: 6/2016 Date: 6/2016
 +
 +
  
 Version: Control 5/7 Version: Control 5/7
 +
 +