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