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
- 
-