study

Tables (8)

Categories (tb_Category)

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

Employees (tb_employee)

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

OrderDetails (tb _Order_Details)

  • OrderDetailID (Key) — Primary key — NOT NULL
  • ProductID (Field2)
  • Quantity (Field3)
  • ProductID (Key2) — Foreign key → Prducts.ProductID — NOT NULL
  • OrderID (Key3) — Foreign key → orders.OrderID — NOT NULL

Prducts (tb_product)

  • ProductID (Key) — Primary key — NOT NULL
  • ProductName (Field)
  • SupplierID (Field2)
  • CategoryID (Field3)
  • Unit (Field4)
  • Price (Field5)
  • SupplierID (Key2) — Foreign key → Supplier.SupplierID — NOT NULL
  • CategoryID (Key3) — Foreign key → Categories.CategoryID — NOT NULL

Sippers (tb Shipper)

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

Supplier (tb_ Supplier)

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

customers (tb_customers)

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

orders (Untitled)

  • 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 → Sippers.ShipperID — NOT NULL