Files/Download - Query to return info

[AlexJ]

What table files application use to store :  User, File Path, Download File Name, custom fields, etc information? I would like to export details to Excel to find duplicate files. 

Thanks in advance for helping with query. Thanks

[Adriano Faria]

downloads_files contains file information, like file name, submitter, date, path, category, number of comments/reviews, ratings, etc.

downloads_fields and downloads _ccontent contains extra fields information. 

downloads_downloads contains information about who downloaded a file and when.