OrderDB

Tables (8)

Categories (th-Categories)

  • CategoryID (Key) — Primary key — NOT NULL
  • CategoryName (Field)
  • Description (Field2)

Customers (th_Customers)

  • Customer ID (Key) — Primary key — NOT NULL
  • CustomerName (Field)
  • ContactName (Field2)
  • Address (Field3)
  • City (Field4)
  • PostalCode (Field5)
  • Country (Field6)

Employees (th_Employees)

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

OrderDetails (th_OrderDetails)

  • OrderDetail ID (Key) — Primary key — NOT NULL
  • Quantity (Field3)
  • Order ID (Key2) — Foreign key → Orders.Order ID — NOT NULL
  • Product ID (PK) — INT — Foreign key → Products.Product ID — NOT NULL

Orders (th_Orders)

  • Order ID (Key) — Primary key — NOT NULL
  • Customer ID (Key3) — Foreign key → Customers.Customer ID — NOT NULL
  • OrderDate (Field3)
  • Shipper ID (Key2) — Foreign key → ShipperID.Shipper ID — NOT NULL
  • EmployeeID (Key4) — Foreign key → Employees.EmployeeID — NOT NULL

Products (tb_products)

  • Product ID (PK) — INT — Primary key — NOT NULL
  • ProductName (Field) — VARCHAR(64)
  • SupplierID (Key) — Foreign key → Suppliers.SupplierID — NOT NULL
  • Unit (Field3)
  • Price (Field4)
  • CategoryID (Key2) — Foreign key → Categories.CategoryID — NOT NULL

ShipperID (Untitled)

  • Shipper ID (Key) — Primary key — NOT NULL
  • ShipperName (Field)
  • Phone (Field2)

Suppliers (th_suppliers)

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