MYOB Exo Business CRM
Project details
ER diagram
Entities
Attributes
Relationships
List of relationships
Relationship details
Name
Relationship type
Parent
Child
Cardinality
CAMPAIGN_CAMPAIGN_CONTACT_LISTS
Non Identifying
CAMPAIGN
CAMPAIGN_CONTACT_LISTS
Zero Or More
CAMPAIGN_CAMPAIGN_HIST
Non Identifying
CAMPAIGN
CAMPAIGN_HIST
Zero Or More
CAMPAIGN_CAMPAIGN_WAVE
Non Identifying
CAMPAIGN
CAMPAIGN_WAVE
Zero Or More
CAMPAIGN_STAGE_CAMPAIGN
Non Identifying
CAMPAIGN_STAGE
CAMPAIGN
Zero Or More
CAMPAIGN_TASKS
Non Identifying
CAMPAIGN
TASKS
Zero Or More
CAMPAIGN_TYPE_CAMPAIGN
Non Identifying
CAMPAIGN_TYPE
CAMPAIGN
Zero Or More
CAMPAIGN_WAVE_CAMPAIGN_WAVE_AUDIT
Non Identifying
CAMPAIGN_WAVE
CAMPAIGN_WAVE_AUDIT
Zero Or More
CAMPAIGN_WAVE_CAMPAIGN_WAVE_CONTACT_LISTS
Non Identifying
CAMPAIGN_WAVE
CAMPAIGN_WAVE_CONTACT_LISTS
Zero Or More
CAMPAIGN_WAVE_CONTACTS
Non Identifying
CAMPAIGN_WAVE
CONTACTS
Zero Or More
CAMPAIGN_WAVE_OPPORTUNITY
Non Identifying
CAMPAIGN_WAVE
OPPORTUNITY
Zero Or More
CAMPAIGN_WAVE_TASKS
Non Identifying
CAMPAIGN_WAVE
TASKS
Zero Or More
CONTACTS_CAMPAIGN_WAVE_AUDIT
Non Identifying
CONTACTS
CAMPAIGN_WAVE_AUDIT
Zero Or More
CONTACTS_CONTACT_LIST_ITEM
Non Identifying
CONTACTS
CONTACT_LIST_ITEM
Zero Or More
CONTACTS_TASKS
Non Identifying
CONTACTS
TASKS
Zero Or More
CONTACT_LIST_CAMPAIGN_CONTACT_LISTS
Non Identifying
CONTACT_LIST
CAMPAIGN_CONTACT_LISTS
Zero Or More
CONTACT_LIST_CAMPAIGN_WAVE_CONTACT_LISTS
Non Identifying
CONTACT_LIST
CAMPAIGN_WAVE_CONTACT_LISTS
Zero Or More
CONTACT_LIST_CONTACT_LIST_ITEM
Non Identifying
CONTACT_LIST
CONTACT_LIST_ITEM
Zero Or More
CONTACT_LIST_TYPE_CONTACT_LIST
Non Identifying
CONTACT_LIST_TYPE
CONTACT_LIST
Zero Or More
FK_CRM_BUDGET_CRM_BUDGET_HDR
Non Identifying
CRM_BUDGET_HDR
CRM_BUDGET
Zero Or More
FK_CRM_BUDGET_EXCLUDED_ACCGROUP2S_CRM_BUDGET
Non Identifying
CRM_BUDGET
CRM_BUDGET_EXCLUDED_ACCGROUP2S
Zero Or More
FK_CRM_BUDGET_EXCLUDED_ACCGROUPS_CRM_BUDGET
Non Identifying
CRM_BUDGET
CRM_BUDGET_EXCLUDED_ACCGROUPS
Zero Or More
FK_CRM_BUDGET_EXCLUDED_BRANCHES_CRM_BUDGET
Non Identifying
CRM_BUDGET
CRM_BUDGET_EXCLUDED_BRANCHES
Zero Or More
FK_CRM_BUDGET_EXCLUDED_DR_ACCS_CRM_BUDGET
Non Identifying
CRM_BUDGET
CRM_BUDGET_EXCLUDED_DR_ACCS
Zero Or More
FK_CRM_BUDGET_EXCLUDED_STAFF_CRM_BUDGET
Non Identifying
CRM_BUDGET
CRM_BUDGET_EXCLUDED_STAFF
Zero Or More
FK_CRM_BUDGET_EXCLUDED_STAFF_STAFF
Non Identifying
STAFF
CRM_BUDGET_EXCLUDED_STAFF
Zero Or More
FK_CRM_BUDGET_EXCLUDED_STOCK_GROUP2S_CRM_BUDGET
Non Identifying
CRM_BUDGET
CRM_BUDGET_EXCLUDED_STOCK_GROUP2S
Zero Or More
FK_CRM_BUDGET_EXCLUDED_STOCK_GROUPS_CRM_BUDGET
Non Identifying
CRM_BUDGET
CRM_BUDGET_EXCLUDED_STOCK_GROUPS
Zero Or More
FK_CRM_BUDGET_EXCLUDED_STOCK_ITEMS_CRM_BUDGET
Non Identifying
CRM_BUDGET
CRM_BUDGET_EXCLUDED_STOCK_ITEMS
Zero Or More
FK_CRM_BUDGET_HDR_MANREP_PERIOD
Non Identifying
MANREP_PERIOD
CRM_BUDGET_HDR
Zero Or More
FK_CRM_BUDGET_LINE_CRM_BUDGET
Non Identifying
CRM_BUDGET
CRM_BUDGET_LINE
Zero Or More
FK_CRM_BUDGET_LINE_STAFF
Non Identifying
STAFF
CRM_BUDGET_LINE
Zero Or More
FK_CRM_BUDGET_MANREP_PERIOD
Non Identifying
MANREP_PERIOD
CRM_BUDGET
Zero Or More
FK_CRM_BUDGET_PERIOD_STATUS
Non Identifying
PERIOD_STATUS
CRM_BUDGET
Zero Or More
FK_CRM_BUDGET_PERIOD_STATUS1
Non Identifying
PERIOD_STATUS
CRM_BUDGET
Zero Or More
OPPORTUNITY_LEAD_OPPORTUNITY
Non Identifying
OPPORTUNITY_LEAD
OPPORTUNITY
Zero Or More
OPPORTUNITY_OPPORTUNITY_HIST
Non Identifying
OPPORTUNITY
OPPORTUNITY_HIST
Zero Or More
OPPORTUNITY_OPPORTUNITY_QUOTE
Non Identifying
OPPORTUNITY
OPPORTUNITY_QUOTE
Zero Or More
OPPORTUNITY_OPPORTUNITY_QUOTE_OPTIONS
Non Identifying
OPPORTUNITY
OPPORTUNITY_QUOTE_OPTIONS
Zero Or More
OPPORTUNITY_QUOTE_OPTIONS_OPPORTUNITY_QUOTE
Non Identifying
OPPORTUNITY_QUOTE_OPTIONS
OPPORTUNITY_QUOTE
Zero Or More
OPPORTUNITY_QUOTE_OPTIONS_OPPORTUNITY_QUOTE1
Non Identifying
OPPORTUNITY_QUOTE_OPTIONS
OPPORTUNITY_QUOTE
Zero Or More
OPPORTUNITY_STAGE_OPPORTUNITY
Non Identifying
OPPORTUNITY_STAGE
OPPORTUNITY
Zero Or More
OPPORTUNITY_TASKS
Non Identifying
OPPORTUNITY
TASKS
Zero Or More
OPPORTUNITY_TYPE_OPPORTUNITY
Non Identifying
OPPORTUNITY_TYPE
OPPORTUNITY
Zero Or More
STAFF_CAMPAIGN
Non Identifying
STAFF
CAMPAIGN
Zero Or More
STAFF_CAMPAIGN_HIST
Non Identifying
STAFF
CAMPAIGN_HIST
Zero Or More
STAFF_CONTACTS
Non Identifying
STAFF
CONTACTS
Zero Or More
STAFF_CONTACT_LIST
Non Identifying
STAFF
CONTACT_LIST
Zero Or More
STAFF_CONTACT_LIST1
Non Identifying
STAFF
CONTACT_LIST
Zero Or More
STAFF_OPPORTUNITY_HIST
Non Identifying
STAFF
OPPORTUNITY_HIST
Zero Or More
STAFF_TASKS
Non Identifying
STAFF
TASKS
Zero Or More
STAFF_TASKS1
Non Identifying
STAFF
TASKS
Zero Or More
STAFF_TASKS2
Non Identifying
STAFF
TASKS
Zero Or More
STAFF_TASKS3
Non Identifying
STAFF
TASKS
Zero Or More
TASK_STATUSES_TASKS
Non Identifying
TASK_STATUSES
TASKS
Zero Or More
TASK_TYPES_TASKS
Non Identifying
TASK_TYPES
TASKS
Zero Or More