order
Tables (8)
Categories (Untitled2)
- CategoryID (Field) — INT
- CategoryName (Field2) — CHAR
- Field3 — CHAR
Customers (Untitled5)
- CustomerID (Field) — INT
- CustomerName (Field2) — CHAR
- ContactName (Field3) — CHAR
- Address (Field4) — CHAR
- City (Field5) — CHAR
- PostalCode (Field6) — INT
- Country (Field7) — CHAR
Employees (Untitled3)
- EmployeeID (Field) — INT
- LastName (Field2) — CHAR
- FirstName (Field3) — CHAR
- BirthDate (Field4) — DATE
- Photo (Field5)
- Notes (Field6) — TEXT
OrderDetails (Untitled4)
- OrderDetailID (Field) — INT
- OrderID (Field2) — INT
- ProductID (Field3) — INT
- Quantity (Field4) — INT
Orders
- OrderID — INT
- CustomerID — INT
- EmployeeID — INT
- OrderDate (Field4) — DATE
- ShipperID (Field5) — INT
Products (Untitled6)
- ProductID (Field) — INT
- ProductName (Field2) — CHAR
- SupplierID (Field3) — INT
- CategoryID (Field4) — INT
- Unit (Field5) — CHAR
- Price (Field6) — FLOAT
Shippers (Untitled7)
- ShipperID (Field) — INT
- ShipperName (Field2) — IINT
- Phone (Field3) — INT
Suppliers (Untitled8)
- SupplierID (Field) — INT
- SupplierName (Field2) — CHAR
- ContactName (Field3) — CHAR
- Address (Field4) — CHAR
- City (Field5) — CHAR
- PostalCode (Field6) — CHAR
- Country (Field7) — CHAR