Campaignresponse

Columns

Name Type Length Precision Scale References In Description
campaign_event_id NUMBER 39 0 campaign_event_id
Campaignevent
Campaign event ID
campaign_response_extid VARCHAR2 255 Campaign response external ID
campaign_response_id NUMBER 39 0 Campaign response ID
contact_id NUMBER 39 0 contact_id
Contacts
Contact ID
date_sent TIMESTAMP Date sent
entity_id NUMBER 39 0 entity_id
Entity
Entity ID
response_id VARCHAR2 30 Response ID

Primary key

PK Column Name
campaign_response_id

Foreign keys in this table

FK Name FK Column Name PK Table Name PK Column Name Key Seq
campaignresponse_campaignevent_fk campaign_event_id Campaignevent campaign_event_id 1
campaignresponse_contacts_fk contact_id Contacts contact_id 1
campaignresponse_entity_fk entity_id Entity entity_id 1

Foreign keys referencing this table

FK Name PK Column Name FK Table Name FK Column Name Key Seq
Campaignresponsehistory_campaignresponse_fk campaign_response_id Campaignresponsehistory campaign_response_id 1

This table is included in the following domains

Domains
Campaignevents

Domain diagrams

Campaignevents