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