OrderDB
Tables (8)
Categories (Untitled2)
- CategoryID (FK) — INT — Primary key — NOT NULL
- CategoryName (Field) — VARCHAR(255)
- Description (Field2) — VARCHAR(255)
Customers (Untitled)
- CustomerID (Key) — INT — Primary key — NOT NULL
- CustomerName (Field) — VARCHAR(255)
- ContactName (Field2) — VARCHAR(255)
- Address (Field3) — VARCHAR(255)
- City (Field4) — VARCHAR(64)
- PostalCode (Field5) — VARCHAR(255)
- Country (Field6) — VARCHAR(255)
Employees (Untitled3)
- EmployeeID (Key) — INT — Primary key — NOT NULL
- LastName (Field) — VARCHAR(255)
- FirstName (Field2) — VARCHAR(255)
- BirthDate (Field3)
- Photo (Field4)
- Notes (Field5)
OrderDetails (Untitled4)
- OrderDetailID (FK) — INT — Primary key — NOT NULL
- ProductID (Field2) — INT
- Quantity (Field3) — INT
- OrderID (FK2) — INT — Foreign key → Orders.OrderID — NOT NULL
Orders (Untitled5)
- OrderID (FK) — INT — Primary key — NOT NULL
- OrderDate (Field3)
- ShipperID (FK2) — INT — Foreign key → Shippers.ShipperID — NOT NULL
- EmployeeID (Key) — INT — Foreign key → Employees.EmployeeID — NOT NULL
- CustomerID (Key2) — INT — Foreign key → Customers.CustomerID — NOT NULL
Products (Untitled6)
- ProductID (FK) — INT — Primary key — NOT NULL
- ProductName (Field) — VARCHAR(255)
- Unit (Field4) — VARCHAR(255)
- Price (Field5) — INT
- OrderDetailID (FK2) — INT — Foreign key → OrderDetails.OrderDetailID — NOT NULL
- CategoryID (FK3) — INT — Foreign key → Categories.CategoryID — NOT NULL
- SupplierID (FK4) — INT — Foreign key → Suppliers.SupplierID — NOT NULL
Shippers (Untitled7)
- ShipperID (FK) — INT — Primary key — NOT NULL
- ShipperName (Field) — VARCHAR(255)
- Phone (Field2) — VARCHAR(255)
Suppliers (Untitled8)
- SupplierID (FK) — INT — Primary key — NOT NULL
- SupplierName (Field) — VARCHAR(255)
- ContactName (Field2) — VARCHAR(255)
- Address (Field3) — VARCHAR(255)
- City (Field4) — VARCHAR(255)
- PostalCode (Field5) — VARCHAR(255)
- Country (Field6) — VARCHAR(64)
- Phone (Field7) — VARCHAR(255)