study_w3schools_erds

Tables (8)

Categories

  • CategoryID — VARCHAR(50) — Primary key — NOT NULL
  • CategoryName — VARCHAR(50)
  • Description — VARCHAR(1000)

Customers

  • CustomerID — VARCHAR(50) — Primary key — NOT NULL
  • CustomerName — VARCHAR(1000)
  • ContactName — VARCHAR(1000)
  • Address — VARCHAR(1000)
  • City — VARCHAR(50)
  • PostalCode — VARCHAR(50)
  • Country — VARCHAR(50)

Employees

  • EmployeeID — VARCHAR(50) — Primary key — NOT NULL
  • LastName — VARCHAR(50)
  • FirstName — VARCHAR(50)
  • BirthDate — VARCHAR(50)
  • Photo — VARCHAR(50)
  • Notes — VARCHAR(1000)

OrderDetails

  • OrderDetailID — VARCHAR(50) — Primary key — NOT NULL
  • OrderID — VARCHAR(50) — Foreign key → Orders.OrderID — NOT NULL
  • ProductID — VARCHAR(50) — Foreign key → Products.ProductID — NOT NULL
  • Quantity — VARCHAR(50)

Orders

  • OrderID — VARCHAR(50) — Primary key — NOT NULL
  • CustomerID — VARCHAR(50) — Foreign key → Customers.CustomerID — NOT NULL
  • EmployeeID — VARCHAR(50) — Foreign key → Employees.EmployeeID — NOT NULL
  • ShipperID — VARCHAR(50) — Foreign key → Shippers.ShipperID — NOT NULL
  • OrderDate — VARCHAR(50)

Products

  • ProductID — VARCHAR(50) — Primary key — NOT NULL
  • SupplierID — VARCHAR(50) — Foreign key → Suppliers.SupplierID — NOT NULL
  • CategoryID — VARCHAR(50) — Foreign key → Categories.CategoryID — NOT NULL
  • ProductName — VARCHAR(50)
  • Unit — VARCHAR(50)
  • Price — VARCHAR(50)

Shippers

  • ShipperID — VARCHAR(50) — Primary key — NOT NULL
  • ShipperName — VARCHAR(50)
  • Field — VARCHAR(50)

Suppliers

  • SupplierID — VARCHAR(50) — Primary key — NOT NULL
  • SupplierName — VARCHAR(1000)
  • ContactName — VARCHAR(1000)
  • Address — VARCHAR(1000)
  • City — VARCHAR(50)
  • PostalCode — VARCHAR(50)
  • Country — VARCHAR(50)