Skip to main content

Example Database

Here you can find the tables of the database used for the examples

📄️ Table: Categories

| CategoryID | CategoryName | Description |

📄️ Table: Customers

| CustomerID | CustomerName | ContactName | Address | City | PostalCode | Country |

📄️ Table: Employees

| EmployeeID | LastName | FirstName | BirthDate | Photo | Notes |

📄️ Table: OrderDetails

| OrderDetailID | OrderID | ProductID | Quantity |

📄️ Table: Orders

| OrderID | CustomerID | EmployeeID | OrderDate | ShipperID |

📄️ Table: Products

| ProductID | ProductName | SupplierID | CategoryID | Unit | Price |

📄️ Table: Shippers

| ShipperID | ShipperName | Phone |

📄️ Table: Suppliers

| SupplierID | SupplierName | ContactName | Address | City | PostalCode | Country | Phone |