Table 1 | Table 2 | Key Pairs | State |
|---|
dbo.[campaign_event_customer_map]
| dbo.[campaign_event]
| dbo.[campaign_event_customer_map].[campaign_event_id] to dbo.[campaign_event].[campaign_event_id]
| Unchanged |
dbo.[campaign_event]
| dbo.[campaign_event_extn]
| dbo.[campaign_event].[campaign_event_id] to dbo.[campaign_event_extn].[campaign_event_id]
| Unchanged |
dbo.[campaign_event]
| dbo.[response_event]
| dbo.[campaign_event].[campaign_event_id] to dbo.[response_event].[campaign_event_id]
| Unchanged |
dbo.[campaign_event]
| ir.[campaign_event_pii_detail]
| dbo.[campaign_event].[campaign_event_id] to ir.[campaign_event_pii_detail].[campaign_event_id]
| Unchanged |
dbo.[campaign_event]
| dbo.[campaign]
| dbo.[campaign_event].[campaign_id] to dbo.[campaign].[campaign_id]
| Unchanged |
dbo.[campaign_event]
| dbo.[channel_lookup]
| dbo.[campaign_event].[channel_code] to dbo.[channel_lookup].[channel_code]
| Unchanged |
dbo.[campaign_event]
| dbo.[cell]
| dbo.[campaign_event].[cell_id] to dbo.[cell].[cell_id]
| Unchanged |
dbo.[campaign_event]
| dbo.[offer]
| dbo.[campaign_event].[offer_id] to dbo.[offer].[offer_id]
| Unchanged |
dbo.[customer_account_bu_summary]
| dbo.[party_profile]
| dbo.[customer_account_bu_summary].[main_party_profile_id] to dbo.[party_profile].[party_profile_id]
| Unchanged |
dbo.[customer_account_bu_summary]
| dbo.[transaction_detail_summary]
| dbo.[customer_account_bu_summary].[customer_account_id] to dbo.[transaction_detail_summary].[customer_account_id]
| Unchanged |
dbo.[customer_account_bu_summary]
| ir.[party_profile_pii]
| dbo.[customer_account_bu_summary].[main_party_profile_id] to ir.[party_profile_pii].[party_profile_id]
| Unchanged |
dbo.[customer_account_bu_summary]
| rpi.[offerhistory]
| dbo.[customer_account_bu_summary].[customer_account_id] to rpi.[offerhistory].[customer_account_id]
| Unchanged |
dbo.[customer_account_bu_summary]
| rpi.[offerhistory_web]
| dbo.[customer_account_bu_summary].[customer_account_id] to rpi.[offerhistory_web].[customer_account_id]
| Unchanged |
dbo.[customer_account_bu_summary]
| rpi.[offerhistory_sandbox]
| dbo.[customer_account_bu_summary].[customer_account_id] to rpi.[offerhistory_sandbox].[customer_account_id]
| Unchanged |
dbo.[customer_account_bu_summary]
| ir.[email]
| dbo.[customer_account_bu_summary].[email_id] to ir.[email].[email_id]
| Unchanged |
dbo.[customer_account_bu_summary]
| dbo.[contact_auth_email_summary]
| dbo.[customer_account_bu_summary].[business_unit_code] to dbo.[contact_auth_email_summary].[business_unit_code] and dbo.[customer_account_bu_summary].[email_id] to dbo.[contact_auth_email_summary].[email_id]
| Unchanged |
dbo.[customer_account_bu_summary]
| dbo.[individual_bu_retail_summary]
| dbo.[customer_account_bu_summary].[main_individual_business_unit_id] to dbo.[individual_bu_retail_summary].[individual_business_unit_id]
| Unchanged |
dbo.[customer_account_bu_summary]
| dbo.[loyalty_account_bu_summary]
| dbo.[customer_account_bu_summary].[main_individual_business_unit_id] to dbo.[loyalty_account_bu_summary].[main_individual_business_unit_id]
| Unchanged |
dbo.[customer_account_bu_summary]
| dbo.[campaign_event_customer_map]
| dbo.[customer_account_bu_summary].[main_party_profile_id] to dbo.[campaign_event_customer_map].[party_profile_id]
| Unchanged |
dbo.[email_model_score]
| dbo.[model]
| dbo.[email_model_score].[model_id] to dbo.[model].[model_id]
| Unchanged |
dbo.[email_summary]
| dbo.[email_model_score]
| dbo.[email_summary].[email_id] to dbo.[email_model_score].[email_id]
| Unchanged |
dbo.[household_model_score]
| dbo.[model]
| dbo.[household_model_score].[model_id] to dbo.[model].[model_id]
| Unchanged |
dbo.[individual_bu_golden_record_summary]
| dbo.[business_unit_lookup]
| dbo.[individual_bu_golden_record_summary].[business_unit_code] to dbo.[business_unit_lookup].[business_unit_code]
| Unchanged |
dbo.[individual_bu_golden_record_summary]
| dbo.[contact_auth_address_summary]
| dbo.[individual_bu_golden_record_summary].[address_id] to dbo.[contact_auth_address_summary].[address_id] and dbo.[individual_bu_golden_record_summary].[business_unit_code] to dbo.[contact_auth_address_summary].[business_unit_code]
| Unchanged |
dbo.[individual_bu_golden_record_summary]
| dbo.[email_summary]
| dbo.[individual_bu_golden_record_summary].[email_id] to dbo.[email_summary].[email_id]
| Unchanged |
dbo.[individual_bu_golden_record_summary]
| dbo.[contact_auth_email_summary]
| dbo.[individual_bu_golden_record_summary].[business_unit_code] to dbo.[contact_auth_email_summary].[business_unit_code] and dbo.[individual_bu_golden_record_summary].[email_id] to dbo.[contact_auth_email_summary].[email_id]
| Unchanged |
dbo.[individual_bu_golden_record_summary]
| dbo.[contact_auth_phone_summary]
| dbo.[individual_bu_golden_record_summary].[business_unit_code] to dbo.[contact_auth_phone_summary].[business_unit_code] and dbo.[individual_bu_golden_record_summary].[home_phone_id] to dbo.[contact_auth_phone_summary].[phone_id]
| Unchanged |
dbo.[individual_bu_golden_record_summary]
| dbo.[contact_auth_sms_summary]
| dbo.[individual_bu_golden_record_summary].[business_unit_code] to dbo.[contact_auth_sms_summary].[business_unit_code] and dbo.[individual_bu_golden_record_summary].[mobile_phone_id] to dbo.[contact_auth_sms_summary].[phone_id]
| Unchanged |
dbo.[individual_bu_golden_record_summary]
| dbo.[country_lookup]
| dbo.[individual_bu_golden_record_summary].[iso_2_country_code] to dbo.[country_lookup].[iso_2_country_code]
| Unchanged |
dbo.[individual_bu_golden_record_summary]
| dbo.[individual_profile_type_lookup]
| dbo.[individual_bu_golden_record_summary].[individual_profile_type_code] to dbo.[individual_profile_type_lookup].[individual_profile_type_code]
| Unchanged |
dbo.[individual_bu_golden_record_summary]
| dbo.[language_type_lookup]
| dbo.[individual_bu_golden_record_summary].[pref_language_code] to dbo.[language_type_lookup].[language_code]
| Unchanged |
dbo.[individual_bu_golden_record_summary]
| rpi.[offerhistory]
| dbo.[individual_bu_golden_record_summary].[individual_business_unit_id] to rpi.[offerhistory].[individual_business_unit_id]
| Unchanged |
dbo.[individual_bu_golden_record_summary]
| rpi.[offerhistory_web]
| dbo.[individual_bu_golden_record_summary].[individual_business_unit_id] to rpi.[offerhistory_web].[individual_business_unit_id]
| Unchanged |
dbo.[individual_bu_golden_record_summary]
| rpi.[offerhistory_sandbox]
| dbo.[individual_bu_golden_record_summary].[individual_business_unit_id] to rpi.[offerhistory_sandbox].[individual_business_unit_id]
| Unchanged |
dbo.[individual_bu_golden_record_summary]
| dbo.[individual_bu_retail_summary]
| dbo.[individual_bu_golden_record_summary].[individual_business_unit_id] to dbo.[individual_bu_retail_summary].[individual_business_unit_id]
| Unchanged |
dbo.[individual_bu_golden_record_summary]
| dbo.[individual_bu_suppression_summary]
| dbo.[individual_bu_golden_record_summary].[individual_business_unit_id] to dbo.[individual_bu_suppression_summary].[individual_business_unit_id]
| Unchanged |
dbo.[individual_bu_golden_record_summary]
| dbo.[individual_bu_product_category_summary]
| dbo.[individual_bu_golden_record_summary].[individual_business_unit_id] to dbo.[individual_bu_product_category_summary].[individual_business_unit_id]
| Unchanged |
dbo.[individual_bu_golden_record_summary]
| ir.[individual_bu_golden_record_pii]
| dbo.[individual_bu_golden_record_summary].[individual_business_unit_id] to ir.[individual_bu_golden_record_pii].[individual_business_unit_id]
| Unchanged |
dbo.[individual_bu_golden_record_summary]
| dbo.[loyalty_account_bu_summary]
| dbo.[individual_bu_golden_record_summary].[individual_business_unit_id] to dbo.[loyalty_account_bu_summary].[main_individual_business_unit_id]
| Unchanged |
dbo.[individual_bu_golden_record_summary]
| dbo.[customer_account_bu_summary]
| dbo.[individual_bu_golden_record_summary].[individual_business_unit_id] to dbo.[customer_account_bu_summary].[main_individual_business_unit_id]
| Unchanged |
dbo.[individual_bu_golden_record_summary]
| dbo.[transaction_detail_summary]
| dbo.[individual_bu_golden_record_summary].[individual_business_unit_id] to dbo.[transaction_detail_summary].[individual_business_unit_id]
| Unchanged |
dbo.[individual_bu_golden_record_summary]
| dbo.[campaign_event_customer_map]
| dbo.[individual_bu_golden_record_summary].[individual_business_unit_id] to dbo.[campaign_event_customer_map].[individual_business_unit_id]
| Unchanged |
dbo.[individual_bu_golden_record_summary]
| dbo.[individual_model_score]
| dbo.[individual_bu_golden_record_summary].[individual_business_unit_id] to dbo.[individual_model_score].[individual_business_unit_id]
| Unchanged |
dbo.[individual_bu_golden_record_summary]
| dbo.[household_model_score]
| dbo.[individual_bu_golden_record_summary].[business_unit_code] to dbo.[household_model_score].[business_unit_code] and dbo.[individual_bu_golden_record_summary].[household_id] to dbo.[household_model_score].[household_id]
| Unchanged |
dbo.[individual_bu_golden_record_summary]
| dbo.[email_model_score]
| dbo.[individual_bu_golden_record_summary].[business_unit_code] to dbo.[email_model_score].[business_unit_code] and dbo.[individual_bu_golden_record_summary].[email_id] to dbo.[email_model_score].[email_id]
| Unchanged |
dbo.[individual_bu_retail_summary]
| dbo.[location]
| dbo.[individual_bu_retail_summary].[business_unit_code] to dbo.[location].[business_unit_code] and dbo.[individual_bu_retail_summary].[client_primary_store_id] to dbo.[location].[location_id]
| Unchanged |
dbo.[individual_model_score]
| dbo.[model]
| dbo.[individual_model_score].[model_id] to dbo.[model].[model_id]
| Unchanged |
dbo.[loyalty_account_bu_summary]
| dbo.[party_profile]
| dbo.[loyalty_account_bu_summary].[main_party_profile_id] to dbo.[party_profile].[party_profile_id]
| Unchanged |
dbo.[loyalty_account_bu_summary]
| ir.[party_profile_pii]
| dbo.[loyalty_account_bu_summary].[main_party_profile_id] to ir.[party_profile_pii].[party_profile_id]
| Unchanged |
dbo.[loyalty_account_bu_summary]
| rpi.[offerhistory]
| dbo.[loyalty_account_bu_summary].[loyalty_account_id] to rpi.[offerhistory].[loyalty_account_id]
| Unchanged |
dbo.[loyalty_account_bu_summary]
| rpi.[offerhistory_web]
| dbo.[loyalty_account_bu_summary].[loyalty_account_id] to rpi.[offerhistory_web].[loyalty_account_id]
| Unchanged |
dbo.[loyalty_account_bu_summary]
| rpi.[offerhistory_sandbox]
| dbo.[loyalty_account_bu_summary].[loyalty_account_id] to rpi.[offerhistory_sandbox].[loyalty_account_id]
| Unchanged |
dbo.[party_profile]
| ir.[party_profile_pii]
| dbo.[party_profile].[party_profile_id] to ir.[party_profile_pii].[party_profile_id]
| Unchanged |
dbo.[party_profile]
| dbo.[transaction_detail_summary]
| dbo.[party_profile].[party_profile_id] to dbo.[transaction_detail_summary].[party_profile_id]
| Unchanged |
dbo.[response_event]
| dbo.[response_event_extn]
| dbo.[response_event].[response_event_id] to dbo.[response_event_extn].[response_event_id]
| Unchanged |
dbo.[response_event]
| dbo.[event_disposition_lookup]
| dbo.[response_event].[event_disposition_code] to dbo.[event_disposition_lookup].[event_disposition_code]
| Unchanged |
ir.[email]
| rpi.[suppression_email]
| ir.[email].[email_address] to rpi.[suppression_email].[emailaddress]
| Unchanged |
ir.[individual_bu_golden_record_pii]
| rpi.[suppression_email]
| ir.[individual_bu_golden_record_pii].[email_address] to rpi.[suppression_email].[emailaddress]
| Unchanged |
rpi.[offerhistory_content]
| rpi.[offerhistory_content_meta]
| rpi.[offerhistory_content].[channelexecutionid] to rpi.[offerhistory_content_meta].[channelexecutionid] and rpi.[offerhistory_content].[offercode] to rpi.[offerhistory_content_meta].[offercode]
| Unchanged |
rpi.[offerhistory_sandbox]
| rpi.[offerhistory_meta_sandbox]
| rpi.[offerhistory_sandbox].[outputid] to rpi.[offerhistory_meta_sandbox].[outputid]
| Unchanged |
rpi.[offerhistory]
| rpi.[offerhistory_meta]
| rpi.[offerhistory].[outputid] to rpi.[offerhistory_meta].[outputid]
| Unchanged |
rpi.[offerhistory]
| rpi.[offerhistory_states]
| rpi.[offerhistory].[rpcontactid] to rpi.[offerhistory_states].[rpcontactid]
| Unchanged |
rpi.[offerhistory]
| rpi.[offerhistory_web]
| rpi.[offerhistory].[individual_business_unit_id] to rpi.[offerhistory_web].[individual_business_unit_id]
| Unchanged |
rpi.[offerhistory]
| rpi.[offerhistory_details]
| rpi.[offerhistory].[channelexecutionid] to rpi.[offerhistory_details].[channelexecutionid]
| Unchanged |
rpi.[offerhistory]
| rpi.[offerhistory_content]
| rpi.[offerhistory].[rpcontactid] to rpi.[offerhistory_content].[rpcontactid]
| Unchanged |
rpi.[queue_listener]
| rpi.[offerhistory]
| rpi.[queue_listener].[rpiresolutionkey] to rpi.[offerhistory].[rpiresolutionkey]
| Unchanged |
rpi.[queue_listener]
| rpi.[offerhistory_web]
| rpi.[queue_listener].[rpiresolutionkey] to rpi.[offerhistory_web].[rpiresolutionkey]
| Unchanged |
rpi.[queue_listener]
| rpi.[offerhistory_sandbox]
| rpi.[queue_listener].[rpiresolutionkey] to rpi.[offerhistory_sandbox].[rpiresolutionkey]
| Unchanged |
rpi.[queue_listener]
| rpi.[suppression_email]
| rpi.[queue_listener].[email] to rpi.[suppression_email].[emailaddress]
| Unchanged |
