Email_stats table corrupted - looking to rebuild the table

Your software
My Mautic version is: v3.3.5
My PHP version is: 7.4
My Database type and version is: 10.6.19-MariaDB

Your problem
My problem is:
Email_stats has corrupted. There are some topics about it, but nothing has been able to fix the table.

As a last try, I was going to try dropping the table, and then rebuilding the structure of the table.
This will mean that old data will be lost, but new data should come in fine (maybe).

But I can’t find any information on the DB structure, can anyone provide?
Or any other advice?