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