Table of Contents

Description

The Account Schema is the logical relationship between tables in a Control database that deal with Customers and Contacts.

  • Account
    • AccountContact
      • linked on Account.ID = AccountContact.AccountID
      • backlink on Account.PrimaryContactID = AccountContact.ID
      • backlink on Account.BillingContactID = AccountContact.ID
      • AccountContactUserField
        • linked on AccountContact.ID = AccountContactUserField.ID
      • Address
        • linked on AccountContact.BillingAddressID = Address.ID
        • linked on AccountContact.ShippingAddressID = Address.ID
      • AddressLink
        • linked on AccountContact.ID = AddressLink.ParentID and AccountContact.ClassTypeID = AddressLink.ParentClassTypeID
        • Address
          • linked on AddressLink.AddressID = Address.ID
      • PhoneNumber
        • linked on AccountContact.MainPhoneNumberID = PhoneNumber.ID
        • linked on AccountContact.MainFaxNumberID = PhoneNumber.ID
      • Employee (used when using separate sales people for contacts)
        • linked on Account.SalespersonID1 = Employee.ID
        • linked on Account.SalespersonID2 = Employee.ID
        • linked on Account.SalespersonID3 = Employee.ID

    • AccountUserField
      • linked on Account.ID = AccountUserField.ID
    • Address
      • linked on AccountContact.BillingAddressID = Address.ID
      • linked on AccountContact.ShippingAddressID = Address.ID
    • AddressLink
      • linked on Account.ID = AddressLink.ParentID and Account.ClassTypeID = AddressLink.ParentClassTypeID
      • Address
        • linked on AddressLink.AddressID = Address.ID
    • PhoneNumber
      • linked on Account.MainPhoneNumberID = PhoneNumber.ID
      • linked on Account.MainFaxNumberID = PhoneNumber.ID

    • PricingLevel
      • linked on Account.PricingLevelID = PricingLevel.ID
    • Promotion
      • linked on Account.PromotionID = Promotion.ID
    • PaymentTerms
      • linked on Account.PaymentTermsID = PaymentTerm.ID
    • TaxClass
      • linked on Account.ClassTypeID = ClassType.ID
    • Employee
      • linked on Account.SalespersonID1 = Employee.ID
      • linked on Account.SalespersonID2 = Employee.ID
      • linked on Account.SalespersonID3 = Employee.ID
    • Account (self-reference for parent/subsidiaries)
      • linked on Account.ParentID = Account.ID



Source

Contributor: Cyrious
Date: 6/2016
Version: Control 5/7

See Also