WmZilla - Webmaster and Marketplace

The Next Generation Webmaster and Trade Forum

Database Structure for Statistics

Marinette

New member

0

0%

Status

Offline

Posts

39

Likes

0

Rep

0

Bits

205

3

Months of Service

0%
I have a project focused on highlighting local sellers. I want to provide statistics to sellers on a monthly, yearly, and weekly basis. Products are entered on the website by us, and companies provide their own prices. I list companies by city and district (a company can be listed in multiple districts). I list companies within the product, displaying their contact information (phone - whatsapp). I want to provide indicators such as which product is viewed in which city/district, how many times it received whatsapp and phone clicks to companies. In terms of database structure, how do you think it can be the cleanest?
 

249

6,622

6,642

Top