|
Relationship: CAMPAIGN_CAMPAIGN_CONTACT_LISTS
| Name | CAMPAIGN_CAMPAIGN_CONTACT_LISTS |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | CAMPAIGN (SEQNO) |
| Child with columns | CAMPAIGN_CONTACT_LISTS (CAMPAIGN_SEQNO) |
| Update rule | None |
| Delete rule | None |
Relationship: CAMPAIGN_CAMPAIGN_HIST
| Name | CAMPAIGN_CAMPAIGN_HIST |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | CAMPAIGN (SEQNO) |
| Child with columns | CAMPAIGN_HIST (CAMPAIGN_SEQNO) |
| Update rule | None |
| Delete rule | None |
Relationship: CAMPAIGN_CAMPAIGN_WAVE
| Name | CAMPAIGN_CAMPAIGN_WAVE |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | CAMPAIGN (SEQNO) |
| Child with columns | CAMPAIGN_WAVE (CAMPAIGN_SEQNO) |
| Update rule | None |
| Delete rule | None |
Relationship: CAMPAIGN_STAGE_CAMPAIGN
| Name | CAMPAIGN_STAGE_CAMPAIGN |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | CAMPAIGN_STAGE (SEQNO) |
| Child with columns | CAMPAIGN (CAMPAIGN_STAGE) |
| Update rule | None |
| Delete rule | None |
Relationship: CAMPAIGN_TASKS
| Name | CAMPAIGN_TASKS |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | CAMPAIGN (SEQNO) |
| Child with columns | TASKS (CAMPAIGN_SEQNO) |
| Update rule | None |
| Delete rule | None |
Relationship: CAMPAIGN_TYPE_CAMPAIGN
| Name | CAMPAIGN_TYPE_CAMPAIGN |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | CAMPAIGN_TYPE (SEQNO) |
| Child with columns | CAMPAIGN (CAMPAIGN_TYPE) |
| Update rule | None |
| Delete rule | None |
Relationship: CAMPAIGN_WAVE_CAMPAIGN_WAVE_AUDIT
| Name | CAMPAIGN_WAVE_CAMPAIGN_WAVE_AUDIT |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | CAMPAIGN_WAVE (SEQNO) |
| Child with columns | CAMPAIGN_WAVE_AUDIT (CAMPAIGN_WAVE_SEQNO) |
| Update rule | None |
| Delete rule | None |
Relationship: CAMPAIGN_WAVE_CAMPAIGN_WAVE_CONTACT_LISTS
| Name | CAMPAIGN_WAVE_CAMPAIGN_WAVE_CONTACT_LISTS |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | CAMPAIGN_WAVE (SEQNO) |
| Child with columns | CAMPAIGN_WAVE_CONTACT_LISTS (CAMPAIGN_WAVE_SEQNO) |
| Update rule | None |
| Delete rule | None |
Relationship: CAMPAIGN_WAVE_CONTACTS
| Name | CAMPAIGN_WAVE_CONTACTS |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | CAMPAIGN_WAVE (SEQNO) |
| Child with columns | CONTACTS (CAMPAIGN_WAVE_SEQNO) |
| Update rule | None |
| Delete rule | None |
Relationship: CAMPAIGN_WAVE_OPPORTUNITY
| Name | CAMPAIGN_WAVE_OPPORTUNITY |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | CAMPAIGN_WAVE (SEQNO) |
| Child with columns | OPPORTUNITY (CAMPAIGN_WAVE_SEQNO) |
| Update rule | None |
| Delete rule | None |
Relationship: CAMPAIGN_WAVE_TASKS
| Name | CAMPAIGN_WAVE_TASKS |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | CAMPAIGN_WAVE (SEQNO) |
| Child with columns | TASKS (CAMPAIGN_WAVE_SEQNO) |
| Update rule | None |
| Delete rule | None |
Relationship: CONTACTS_CAMPAIGN_WAVE_AUDIT
| Name | CONTACTS_CAMPAIGN_WAVE_AUDIT |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | CONTACTS (SEQNO) |
| Child with columns | CAMPAIGN_WAVE_AUDIT (CONTACT_SEQNO) |
| Update rule | None |
| Delete rule | None |
Relationship: CONTACTS_CONTACT_LIST_ITEM
| Name | CONTACTS_CONTACT_LIST_ITEM |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | CONTACTS (SEQNO) |
| Child with columns | CONTACT_LIST_ITEM (ITEM_SEQNO) |
| Update rule | None |
| Delete rule | None |
Relationship: CONTACTS_TASKS
| Name | CONTACTS_TASKS |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | CONTACTS (SEQNO) |
| Child with columns | TASKS (CONTACTSEQNO) |
| Update rule | None |
| Delete rule | None |
Relationship: CONTACT_LIST_CAMPAIGN_CONTACT_LISTS
| Name | CONTACT_LIST_CAMPAIGN_CONTACT_LISTS |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | CONTACT_LIST (SEQNO) |
| Child with columns | CAMPAIGN_CONTACT_LISTS (CONTACT_LIST_SEQNO) |
| Update rule | None |
| Delete rule | None |
Relationship: CONTACT_LIST_CAMPAIGN_WAVE_CONTACT_LISTS
| Name | CONTACT_LIST_CAMPAIGN_WAVE_CONTACT_LISTS |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | CONTACT_LIST (SEQNO) |
| Child with columns | CAMPAIGN_WAVE_CONTACT_LISTS (CONTACT_LIST_SEQNO) |
| Update rule | None |
| Delete rule | None |
Relationship: CONTACT_LIST_CONTACT_LIST_ITEM
| Name | CONTACT_LIST_CONTACT_LIST_ITEM |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | CONTACT_LIST (SEQNO) |
| Child with columns | CONTACT_LIST_ITEM (HDR_SEQNO) |
| Update rule | None |
| Delete rule | None |
Relationship: CONTACT_LIST_TYPE_CONTACT_LIST
| Name | CONTACT_LIST_TYPE_CONTACT_LIST |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | CONTACT_LIST_TYPE (SEQNO) |
| Child with columns | CONTACT_LIST (CONTACT_LIST_TYPE) |
| Update rule | None |
| Delete rule | None |
Relationship: FK_CRM_BUDGET_CRM_BUDGET_HDR
| Name | FK_CRM_BUDGET_CRM_BUDGET_HDR |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | CRM_BUDGET_HDR (SEQNO) |
| Child with columns | CRM_BUDGET (HEADER_SEQNO) |
| Update rule | None |
| Delete rule | None |
Relationship: FK_CRM_BUDGET_EXCLUDED_ACCGROUP2S_CRM_BUDGET
| Name | FK_CRM_BUDGET_EXCLUDED_ACCGROUP2S_CRM_BUDGET |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | CRM_BUDGET (SEQNO) |
| Child with columns | CRM_BUDGET_EXCLUDED_ACCGROUP2S (BUDGET_SEQNO) |
| Update rule | None |
| Delete rule | None |
Relationship: FK_CRM_BUDGET_EXCLUDED_ACCGROUPS_CRM_BUDGET
| Name | FK_CRM_BUDGET_EXCLUDED_ACCGROUPS_CRM_BUDGET |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | CRM_BUDGET (SEQNO) |
| Child with columns | CRM_BUDGET_EXCLUDED_ACCGROUPS (BUDGET_SEQNO) |
| Update rule | None |
| Delete rule | None |
Relationship: FK_CRM_BUDGET_EXCLUDED_BRANCHES_CRM_BUDGET
| Name | FK_CRM_BUDGET_EXCLUDED_BRANCHES_CRM_BUDGET |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | CRM_BUDGET (SEQNO) |
| Child with columns | CRM_BUDGET_EXCLUDED_BRANCHES (BUDGET_SEQNO) |
| Update rule | None |
| Delete rule | None |
Relationship: FK_CRM_BUDGET_EXCLUDED_DR_ACCS_CRM_BUDGET
| Name | FK_CRM_BUDGET_EXCLUDED_DR_ACCS_CRM_BUDGET |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | CRM_BUDGET (SEQNO) |
| Child with columns | CRM_BUDGET_EXCLUDED_DR_ACCS (BUDGET_SEQNO) |
| Update rule | None |
| Delete rule | None |
Relationship: FK_CRM_BUDGET_EXCLUDED_STAFF_CRM_BUDGET
| Name | FK_CRM_BUDGET_EXCLUDED_STAFF_CRM_BUDGET |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | CRM_BUDGET (SEQNO) |
| Child with columns | CRM_BUDGET_EXCLUDED_STAFF (BUDGET_SEQNO) |
| Update rule | None |
| Delete rule | None |
Relationship: FK_CRM_BUDGET_EXCLUDED_STAFF_STAFF
| Name | FK_CRM_BUDGET_EXCLUDED_STAFF_STAFF |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | STAFF (STAFFNO) |
| Child with columns | CRM_BUDGET_EXCLUDED_STAFF (STAFFNO) |
| Update rule | None |
| Delete rule | None |
Relationship: FK_CRM_BUDGET_EXCLUDED_STOCK_GROUP2S_CRM_BUDGET
| Name | FK_CRM_BUDGET_EXCLUDED_STOCK_GROUP2S_CRM_BUDGET |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | CRM_BUDGET (SEQNO) |
| Child with columns | CRM_BUDGET_EXCLUDED_STOCK_GROUP2S (BUDGET_SEQNO) |
| Update rule | None |
| Delete rule | None |
Relationship: FK_CRM_BUDGET_EXCLUDED_STOCK_GROUPS_CRM_BUDGET
| Name | FK_CRM_BUDGET_EXCLUDED_STOCK_GROUPS_CRM_BUDGET |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | CRM_BUDGET (SEQNO) |
| Child with columns | CRM_BUDGET_EXCLUDED_STOCK_GROUPS (BUDGET_SEQNO) |
| Update rule | None |
| Delete rule | None |
Relationship: FK_CRM_BUDGET_EXCLUDED_STOCK_ITEMS_CRM_BUDGET
| Name | FK_CRM_BUDGET_EXCLUDED_STOCK_ITEMS_CRM_BUDGET |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | CRM_BUDGET (SEQNO) |
| Child with columns | CRM_BUDGET_EXCLUDED_STOCK_ITEMS (BUDGET_SEQNO) |
| Update rule | None |
| Delete rule | None |
Relationship: FK_CRM_BUDGET_HDR_MANREP_PERIOD
| Name | FK_CRM_BUDGET_HDR_MANREP_PERIOD |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | MANREP_PERIOD (PERIOD_SEQNO) |
| Child with columns | CRM_BUDGET_HDR (MANREP_PERIOD_SEQNO) |
| Update rule | None |
| Delete rule | None |
Relationship: FK_CRM_BUDGET_LINE_CRM_BUDGET
| Name | FK_CRM_BUDGET_LINE_CRM_BUDGET |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | CRM_BUDGET (SEQNO) |
| Child with columns | CRM_BUDGET_LINE (BUDGET_SEQNO) |
| Update rule | None |
| Delete rule | None |
Relationship: FK_CRM_BUDGET_LINE_STAFF
| Name | FK_CRM_BUDGET_LINE_STAFF |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | STAFF (STAFFNO) |
| Child with columns | CRM_BUDGET_LINE (SALESNO) |
| Update rule | None |
| Delete rule | None |
Relationship: FK_CRM_BUDGET_MANREP_PERIOD
| Name | FK_CRM_BUDGET_MANREP_PERIOD |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | MANREP_PERIOD (PERIOD_SEQNO) |
| Child with columns | CRM_BUDGET (MANREP_PERIOD_SEQNO) |
| Update rule | None |
| Delete rule | None |
Relationship: FK_CRM_BUDGET_PERIOD_STATUS
| Name | FK_CRM_BUDGET_PERIOD_STATUS |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | PERIOD_STATUS (SEQNO) |
| Child with columns | CRM_BUDGET (ACTUAL_PERIOD_STATUS_SEQNO) |
| Update rule | None |
| Delete rule | None |
Relationship: FK_CRM_BUDGET_PERIOD_STATUS1
| Name | FK_CRM_BUDGET_PERIOD_STATUS1 |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | PERIOD_STATUS (SEQNO) |
| Child with columns | CRM_BUDGET (LYACTUAL_PERIOD_STATUS_SEQNO) |
| Update rule | None |
| Delete rule | None |
Relationship: OPPORTUNITY_LEAD_OPPORTUNITY
| Name | OPPORTUNITY_LEAD_OPPORTUNITY |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | OPPORTUNITY_LEAD (SEQNO) |
| Child with columns | OPPORTUNITY (OPPORTUNITY_LEAD) |
| Update rule | None |
| Delete rule | None |
Relationship: OPPORTUNITY_OPPORTUNITY_HIST
| Name | OPPORTUNITY_OPPORTUNITY_HIST |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | OPPORTUNITY (SEQNO) |
| Child with columns | OPPORTUNITY_HIST (OPPORTUNITY_SEQNO) |
| Update rule | None |
| Delete rule | None |
Relationship: OPPORTUNITY_OPPORTUNITY_QUOTE
| Name | OPPORTUNITY_OPPORTUNITY_QUOTE |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | OPPORTUNITY (SEQNO) |
| Child with columns | OPPORTUNITY_QUOTE (HDR_SEQNO) |
| Update rule | None |
| Delete rule | None |
Relationship: OPPORTUNITY_OPPORTUNITY_QUOTE_OPTIONS
| Name | OPPORTUNITY_OPPORTUNITY_QUOTE_OPTIONS |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | OPPORTUNITY (SEQNO) |
| Child with columns | OPPORTUNITY_QUOTE_OPTIONS (HDR_SEQNO) |
| Update rule | None |
| Delete rule | None |
Relationship: OPPORTUNITY_QUOTE_OPTIONS_OPPORTUNITY_QUOTE
| Name | OPPORTUNITY_QUOTE_OPTIONS_OPPORTUNITY_QUOTE |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | OPPORTUNITY_QUOTE_OPTIONS (SEQNO) |
| Child with columns | OPPORTUNITY_QUOTE (OPTION_NO_SEQNO) |
| Update rule | None |
| Delete rule | None |
Relationship: OPPORTUNITY_QUOTE_OPTIONS_OPPORTUNITY_QUOTE1
| Name | OPPORTUNITY_QUOTE_OPTIONS_OPPORTUNITY_QUOTE1 |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | OPPORTUNITY_QUOTE_OPTIONS (OPTION_NO) |
| Child with columns | OPPORTUNITY_QUOTE (OPTION_NO) |
| Update rule | None |
| Delete rule | None |
Relationship: OPPORTUNITY_STAGE_OPPORTUNITY
| Name | OPPORTUNITY_STAGE_OPPORTUNITY |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | OPPORTUNITY_STAGE (SEQNO) |
| Child with columns | OPPORTUNITY (OPPORTUNITY_STAGE) |
| Update rule | None |
| Delete rule | None |
Relationship: OPPORTUNITY_TASKS
| Name | OPPORTUNITY_TASKS |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | OPPORTUNITY (SEQNO) |
| Child with columns | TASKS (OPPORTUNITYSEQNO) |
| Update rule | None |
| Delete rule | None |
Relationship: OPPORTUNITY_TYPE_OPPORTUNITY
| Name | OPPORTUNITY_TYPE_OPPORTUNITY |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | OPPORTUNITY_TYPE (SEQNO) |
| Child with columns | OPPORTUNITY (OPPORTUNITY_TYPE) |
| Update rule | None |
| Delete rule | None |
Relationship: STAFF_CAMPAIGN
| Name | STAFF_CAMPAIGN |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | STAFF (STAFFNO) |
| Child with columns | CAMPAIGN (OWNER) |
| Update rule | None |
| Delete rule | None |
Relationship: STAFF_CAMPAIGN_HIST
| Name | STAFF_CAMPAIGN_HIST |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | STAFF (STAFFNO) |
| Child with columns | CAMPAIGN_HIST (SALESNO) |
| Update rule | None |
| Delete rule | None |
Relationship: STAFF_CONTACTS
| Name | STAFF_CONTACTS |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | STAFF (STAFFNO) |
| Child with columns | CONTACTS (SALESNO) |
| Update rule | None |
| Delete rule | None |
Relationship: STAFF_CONTACT_LIST
| Name | STAFF_CONTACT_LIST |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | STAFF (STAFFNO) |
| Child with columns | CONTACT_LIST (CREATED_BY) |
| Update rule | None |
| Delete rule | None |
Relationship: STAFF_CONTACT_LIST1
| Name | STAFF_CONTACT_LIST1 |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | STAFF (STAFFNO) |
| Child with columns | CONTACT_LIST (OWNER) |
| Update rule | None |
| Delete rule | None |
Relationship: STAFF_OPPORTUNITY_HIST
| Name | STAFF_OPPORTUNITY_HIST |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | STAFF (STAFFNO) |
| Child with columns | OPPORTUNITY_HIST (SALESNO) |
| Update rule | None |
| Delete rule | None |
Relationship: STAFF_TASKS
| Name | STAFF_TASKS |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | STAFF (STAFFNO) |
| Child with columns | TASKS (CREATEDBY) |
| Update rule | None |
| Delete rule | None |
Relationship: STAFF_TASKS1
| Name | STAFF_TASKS1 |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | STAFF (STAFFNO) |
| Child with columns | TASKS (ASSIGNED_TO) |
| Update rule | None |
| Delete rule | None |
Relationship: STAFF_TASKS2
| Name | STAFF_TASKS2 |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | STAFF (STAFFNO) |
| Child with columns | TASKS (ASSIGNED_BY) |
| Update rule | None |
| Delete rule | None |
Relationship: STAFF_TASKS3
| Name | STAFF_TASKS3 |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | STAFF (STAFFNO) |
| Child with columns | TASKS (MODIFIEDBY) |
| Update rule | None |
| Delete rule | None |
Relationship: TASK_STATUSES_TASKS
| Name | TASK_STATUSES_TASKS |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | TASK_STATUSES (SEQNO) |
| Child with columns | TASKS (STATUS) |
| Update rule | None |
| Delete rule | None |
Relationship: TASK_TYPES_TASKS
| Name | TASK_TYPES_TASKS |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | TASK_TYPES (SEQNO) |
| Child with columns | TASKS (TYPE) |
| Update rule | None |
| Delete rule | None |
|