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)