Schema Database
ER Diagram
Users
To collect about users
Users_Detail Table: Will be used at the time of registration or login. And used to collect personal information of user
Users_Cookies Table: Will be used when user click accept permission about us to use cookies
Users_fav_Prod Table:
Reviews
These three tables collect information about reviews information when users review about product such as who is a reviewer and who are like or dislikes this review and collect review sentiment
These three tables collect data from our partners. And will be used for training Machine Learning and used for preliminary datasets on the website.
Products
These tables are for product and banner information. Product information such as category tags description and sponsor. The banner is for collecting image paths.
Click Counting Tag and Product
To collect data when users click some Product or Tag of Product that will be used for analysis about users' interest.
Employee
About our employee information such as personal information, their department, project and hour working.
Last updated