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