We discovered that some uniqueids on the vicidail_closr_log table has several Lead_ids linked to it. My question is, is the uniqueid in the vicidial_closer_log table a primary key and should only be assigned to a single lead_id?
- Code: Select all
select max(lead_id) as lead_id, uniqueid, count(*) from vicidial_closer_log where campaign_id='MEDIBCOPT' group by uniqueid having count(*)>1;
1278007 2455092 2008 MEDIBCOPT 2023-10-15 07:55:13 1697381713 QUEUE 1 9377178784 VDCL N 0.00 0 NONE 1697381712.150 45 1
1278008 2455093 2008 MEDIBCOPT 2023-10-15 07:55:13 1697381713 1697385314 3600 TIMEOT 1 6065944353 VDCL N 3600.00 0 QUEUETIMEOUT 1697381712.150 46 1
1278009 2455094 2008 MEDIBCOPT 2023-10-15 07:55:13 1697381713 1697384875 3162 DROP 1 5743202174 VDCL N 3162.00 0 ABANDON 1697381712.150 47 1