OrderDB

Tables (8)

Categories (Untitled3)

  • CategoryID (Key) — INT — Primary key — NOT NULL
  • CategoryName (Field) — VARCHAR(32)
  • Description (Field2) — VARCHAR(255)

Customers (Untitled2)

  • CustomerID (Key) — INT — Primary key — NOT NULL
  • CustomerName (Field) — VARCHAR(255)
  • ContactName (Field2) — VARCHAR(128)
  • Address (Field3) — VARCHAR(255)
  • City (Field4) — VARCHAR(32)
  • PostalCode (Field5) — VARCHAR(32)
  • Country (Field6) — VARCHAR(32)
  • Email (Field7) — VARCHAR(128)

Employees (Untitled4)

  • EmployeeID (Key) — INT — Primary key — NOT NULL
  • LastName (Field) — VARCHAR(32)
  • FirstName (Field2) — VARCHAR(32)
  • BirthDate (Field4) — VARCHAR(10)
  • Photo (Field5) — VARCHAR(32)
  • Notes (Field3) — VARCHAR(255)

OrderDetails (Untitled5)

  • OrderDetailID (Key) — INT — Primary key — NOT NULL
  • OrderID (Key2) — INT — Primary key — NOT NULL
  • ProductID (Key3) — INT — Primary key — NOT NULL
  • Quantity (Field) — INT

Orders (Untitled6)

  • OrderID (Key) — INT — Primary key — NOT NULL
  • CustomerID (Key2) — INT — Primary key — NOT NULL
  • EmployeeID (Key3) — INT — Primary key — NOT NULL
  • ShipperID (Key4) — INT — Primary key — NOT NULL
  • OrderDate (Field) — VARCHAR(10)
  • CustomerID (Key5) — INT — Foreign key → Customers.CustomerID — NOT NULL
  • EmployeeID (Key6) — INT — Foreign key → Employees.EmployeeID — NOT NULL
  • EmployeeID (Key7) — INT — Foreign key → Employees.EmployeeID — NOT NULL
  • EmployeeID (Key8) — INT — Foreign key → Employees.EmployeeID — NOT NULL

Products (Untitled7)

  • ProductID (Key) — INT — Primary key — NOT NULL
  • SupplierID (Key3) — INT — Primary key — NOT NULL
  • CategoryID (Key4) — INT — Primary key — NOT NULL
  • ProductName (Field) — VARCHAR(32)
  • Unit (Key2) — VARCHAR(128) — NOT NULL
  • Price (Field2) — INT
  • SupplierID (Key5) — INT — Foreign key → Suppliers.SupplierID — NOT NULL

Shippers (Untitled8)

  • ShipperID (Key) — INT — Primary key — NOT NULL
  • ShipperName (Field) — VARCHAR(128)
  • Phone (Field2) — VARCHAR(32)

Suppliers (Untitled9)

  • SupplierID (Key) — INT — Primary key — NOT NULL
  • SupplierName (Field) — VARCHAR(128)
  • ContactName (Field2) — VARCHAR(128)
  • Address (Field3) — VARCHAR(255)
  • City (Field4) — VARCHAR(32)
  • PostalCode (Field5) — VARCHAR(32)
  • Country (Field6) — VARCHAR(32)
  • Phone (Field7) — VARCHAR(32)