hh
Tables (8)
Categories
- CategoryID — int(11) — Primary key — NOT NULL
- CategoryName — varchar(255)
- Description — varchar(255)
Customers
- CustomerID — int(11) — Primary key — NOT NULL
- CustomerName — varchar(255)
- ContactName — varchar(255)
- Address — varchar(255)
- City — varchar(255)
- PostalCode — varchar(255)
- Country — varchar(255)
Employees
- EmployeeID — int(11) — Primary key — NOT NULL
- LastName — varchar(255)
- FirstName — varchar(255)
- BirthDate — date
- Photo — varchar(255)
- Notes — text
OrderDetails
- OrderDetailID — int(11) — Primary key — NOT NULL
- OrderID — int(11) — Foreign key → Orders.OrderID
- ProductID — int(11)
- Quantity — int(11)
Orders
- OrderID — int(11) — Primary key — NOT NULL
- CustomerID — int(11) — Foreign key → Customers.CustomerID
- EmployeeID — int(11)
- OrderDate — date
- ShipperID — int(11)
Products
- ProductID — int(11) — Primary key — NOT NULL
- ProductName — varchar(255)
- SupplierID — int(11)
- CategoryID — int(11) — Foreign key → Categories.CategoryID
- Unit — varchar(255)
- Price — double
Shippers
- ShipperID — int(11) — Primary key — NOT NULL
- ShipperName — varchar(255)
- Phone — varchar(255)
Suppliers
- SupplierID — int(11) — Primary key — NOT NULL
- SupplierName — varchar(255)
- ContactName — varchar(255)
- Address — varchar(255)
- City — varchar(255)
- PostalCode — varchar(255)
- Country — varchar(255)
- Phone — varchar(255)