Import

erDiagram
    CATEGORIES {
        int categoryID PK
        string categoryName
        string description
        blob picture
    }
    
    CUSTOMERS {
        string customerID PK
        string companyName
        string contactName
        string contactTitle
        string address
        string city
        string region
        string postalCode
        string country
        string phone
        string fax
    }
    
    EMPLOYEES {
        int employeeID PK
        string lastName
        string firstName
        string title
        string titleOfCourtesy
        datetime birthDate
        datetime hireDate
        string address
        string city
        string region
        string postalCode
        string country
        string homePhone
        string extension
        blob photo
        text notes
        int reportsTo FK
        string photoPath
    }
    
    PRODUCTS {
        int productID PK
        string productName
        int supplierID FK
        int categoryID FK
        string quantityPerUnit
        decimal unitPrice
        int unitsInStock
        int unitsOnOrder
        int reorderLevel
        bit discontinued
    }
    
    ORDERS {
        int orderID PK
        string customerID FK
        int employeeID FK
        datetime orderDate
        datetime requiredDate
        datetime shippedDate
        int shipVia FK
        decimal freight
        string shipName
        string shipAddress
        string shipCity
        string shipRegion
        string shipPostalCode
        string shipCountry
    }
    
    ORDER_DETAILS {
        int orderID FK
        int productID FK
        decimal unitPrice
        int quantity
        decimal discount
    }
    
    SUPPLIERS {
        int supplierID PK
        string companyName
        string contactName
        string contactTitle
        string address
        string city
        string region
        string postalCode
        string country
        string phone
        string fax
        string homePage
    }
    
    SHIPPERS {
        int shipperID PK
        string companyName
        string phone
    }
    
    REGIONS {
        int regionID PK
        string regionDescription
    }
    
    TERRITORIES {
        string territoryID PK
        string territoryDescription
        int regionID FK
    }
    
    EMPLOYEE_TERRITORIES {
        int employeeID FK
        string territoryID FK
    }

    %% Relationships
    CATEGORIES ||--o{ PRODUCTS : "categorizes"
    SUPPLIERS ||--o{ PRODUCTS : "supplies"
    CUSTOMERS ||--o{ ORDERS : "places"
    EMPLOYEES ||--o{ ORDERS : "handles"
    EMPLOYEES ||--o{ EMPLOYEES : "reports to"
    SHIPPERS ||--o{ ORDERS : "ships"
    ORDERS ||--o{ ORDER_DETAILS : "contains"
    PRODUCTS ||--o{ ORDER_DETAILS : "included in"
    REGIONS ||--o{ TERRITORIES : "contains"
    EMPLOYEES ||--o{ EMPLOYEE_TERRITORIES : "assigned to"
    TERRITORIES ||--o{ EMPLOYEE_TERRITORIES : "covers"