Database Schema

erDiagram
    COMPANY {
        int COMPANY_ID PK
        varchar COMPANY_NAME
        varchar CATEGORY
        text OVERVIEW
        text FEATURES
        varchar COMPANY_WEBSITE
        int RATING
    }
    PRODUCT {
        int PRODUCT_ID PK
        varchar PRODUCT_NAME
        varchar CATEGORY
        int COMPANY_ID FK
        decimal PRICE
        text FEATURES
        int RATING
    }
    COMPANY_REVIEW {
        int CRID PK
        int AUTHOR FK
        varchar TITLE
        int CR_RATING
        datetime CREATION_DATE
        int COMPANYID FK
        text ANSWER_1
        text ANSWER_2
        text ANSWER_3
        text ANSWER_4
    }
    PRODUCT_REVIEW {
        int PRID PK
        int AUTHOR FK
        varchar TITLE
        int PR_RATING
        datetime CREATION_DATE
        int PRODUCTID FK
        text ANSWER_1
        text ANSWER_2
        text ANSWER_3
        text ANSWER_4
    }
    USER {
        int ID PK
        varchar USERNAME
        varchar PASSWORD
    }

    COMPANY ||--o{ PRODUCT : "has"
    COMPANY ||--o{ COMPANY_REVIEW : "receives"
    PRODUCT ||--o{ PRODUCT_REVIEW : "receives"
    USER ||--o{ COMPANY_REVIEW : "writes"
    USER ||--o{ PRODUCT_REVIEW : "writes"

Loading