prospect_list_campaigns


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id CHAR 36 null
prospect_list_id CHAR 36 null
prospect_lists.id Defined in XMLR
campaign_id CHAR 36 null
campaigns.id Defined in XMLR
date_modified DATETIME 26 null
deleted BIT 1 0

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
idx_cam_id Performance Asc campaign_id
idx_pro_id Performance Asc prospect_list_id
idx_prospect_list_campaigns Performance Asc/Asc prospect_list_id + campaign_id

Relationships