# Schema Database

## ER Diagram

<figure><img src="https://853940038-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FntmS61Ori9y4VOBrX1Ds%2Fuploads%2F3MSsJbJKGk5RlhX015d4%2F405%20ER%20Diagram%20(1).jpg?alt=media&#x26;token=15f4d210-6af2-403e-93b8-3fefb0c758bd" alt=""><figcaption><p>ER Diagram</p></figcaption></figure>

### Users

To collect about users&#x20;

<figure><img src="https://853940038-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FntmS61Ori9y4VOBrX1Ds%2Fuploads%2FleDpsE9lRZxMywEhCcs0%2Fimage.png?alt=media&#x26;token=008ab777-fe3b-4c6a-a830-b6a09a12e741" alt=""><figcaption><p>User Detail</p></figcaption></figure>

Users\_Detail Table: Will be used at the time of registration or login. And used to collect personal information of user&#x20;

Users\_Cookies Table: Will be used when user click accept permission about us to use cookies&#x20;

Users\_fav\_Prod Table:&#x20;

&#x20;

### Reviews&#x20;

<figure><img src="https://853940038-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FntmS61Ori9y4VOBrX1Ds%2Fuploads%2FuPWDsTYs0EqIrRgeCKld%2Fimage.png?alt=media&#x26;token=300da305-e95b-4a85-b792-96c4f6c13ea7" alt=""><figcaption><p>Reviews Tables</p></figcaption></figure>

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&#x20;

<figure><img src="https://853940038-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FntmS61Ori9y4VOBrX1Ds%2Fuploads%2FC3G6QUwg1fTuGoE9ut7n%2Fimage.png?alt=media&#x26;token=24aab123-7067-441b-b54d-d837a4b89db4" alt=""><figcaption><p>Reviews Dataset from another src </p></figcaption></figure>

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

<figure><img src="https://853940038-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FntmS61Ori9y4VOBrX1Ds%2Fuploads%2FNn38KnYuounxuKXUbZLV%2Fimage.png?alt=media&#x26;token=ed4d9947-950e-40c7-8007-029261e06f99" alt=""><figcaption><p>About Product table</p></figcaption></figure>

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

<figure><img src="https://853940038-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FntmS61Ori9y4VOBrX1Ds%2Fuploads%2Ff5m9hA9pCV4sNWaoaSLN%2Fimage.png?alt=media&#x26;token=16bf3aac-2466-41fa-84d1-267bb0031f0d" alt=""><figcaption><p>count table</p></figcaption></figure>

To collect data when users click some Product or Tag of Product that will be used for analysis about users' interest.

### Employee

<figure><img src="https://853940038-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FntmS61Ori9y4VOBrX1Ds%2Fuploads%2FBetjMGvEEO9BLdGfwADw%2Fimage.png?alt=media&#x26;token=1a8c4720-d5ee-461a-ba2b-b8db9dff134b" alt=""><figcaption><p>employee table</p></figcaption></figure>

About our employee information such as personal information, their department, project and hour working.
