sesac

Tables (8)

Categories (tb_category)

  • CategoryID (CategoryName) — Primary key — NOT NULL

Customers (tb_customer)

  • CustomerID (Key) — Primary key — NOT NULL

Employees (tb_employee)

  • EmployeeID (Key) — Primary key — NOT NULL
  • LastName (FirstName)

OrderDetails (tb_orderdetails)

  • OrderDetailID (Key) — Primary key — NOT NULL
  • OrderID (ProductID)
  • OrderID (Key3) — Foreign key → Orders.OrderID — NOT NULL
  • ProductID (Key4) — Foreign key → Products.ProductID — NOT NULL

Orders (tb_order)

  • OrderID (Key) — Primary key — NOT NULL
  • CustomerID (Key2) — Foreign key → Customers.CustomerID — NOT NULL
  • OrderDate (Field)
  • EmployeeID (Key3) — Foreign key → Employees.EmployeeID — NOT NULL
  • ShipperID (Key4) — Foreign key → Shippers.ShipperID — NOT NULL

Products (tb_product)

  • ProductID (Key) — Primary key — NOT NULL
  • ProductName (SupplierID) — Unit
  • Price (Field)
  • SupplierID (SupplierName2) — Address — Foreign key → Suppliers.SupplierID — NOT NULL
  • CategoryID (CategoryName2) — Foreign key → Categories.CategoryID — NOT NULL

Shippers (tb_shipper)

  • ShipperID (Key) — Primary key — NOT NULL
  • ShipperName (Phone)

Suppliers (tb_supplier)

  • SupplierID (SupplierName) — Address — Primary key — NOT NULL
  • City (Country)