study_w3schools_erds

Tables (8)

Category (Untitled2)

  • CategoryID — VARCHAR — Primary key — NOT NULL
  • CategoryName — VARCHAR
  • Description — VARCHAR

Customers (Untitled)

  • CustomerID — VARCHAR — Primary key — NOT NULL
  • CustomerName — VARCHAR
  • ContactName — VARCHAR
  • Address — VARCHAR
  • City — VARCHAR
  • PostalCode — VARCHAR
  • Country — VARCHAR

Employees (Untitled3)

  • EmployeeID — VARCHAR — Primary key — NOT NULL
  • LastName — VARCHAR
  • FirstName — VARCHAR
  • BirthDate — VARCHAR
  • Photo — VARCHAR
  • Notes — VARCHAR

OrderDetails (Untitled4)

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

Orders (Untitled5)

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

Products (Untitled6)

  • ProductID — VARCHAR — Primary key — NOT NULL
  • CategoryID — VARCHAR — Foreign key → Category.CategoryID — NOT NULL
  • SupplierID — VARCHAR — Foreign key → Suppliers.SupplierID — NOT NULL
  • ProductName — VARCHAR
  • Unit — VARCHAR
  • Price — VARCHAR

Shippers (Untitled7)

  • ShipperID — VARCHAR — Primary key — NOT NULL
  • ShipperName — VARCHAR
  • Phone — VARCHAR

Suppliers (Untitled8)

  • SupplierID — VARCHAR — Primary key — NOT NULL
  • SupplierName — VARCHAR
  • ContactName — VARCHAR
  • Address — VARCHAR
  • City — VARCHAR
  • PostalCode — VARCHAR
  • Country — VARCHAR
  • Phone — VARCHAR