OrderDB
Tables (8)
Categories (tb_categories)
- CategoryID (Key) — Primary key — NOT NULL
- Field
- Description (Field2)
Customers (tb_customers)
- CustomerID (Key) — int — Primary key — NOT NULL
- CustomerName (Field) — str
- ContactName (Field2) — str
- Address (Field3) — str
- City (Field4) — str
- PostalCode (Field5) — str
- Country (Field6)
Employees (tb_employees)
- EmployeeID (Key) — int — Primary key — NOT NULL
- LastName (Field) — str
- FirstName (Field2) — str
- BirthDate (Field3) — int
- Photo (Field4) — str
- Notes (Field5) — str
OrderDetails (tb_orderdetails)
- OrderDetailID (Key) — int — Primary key — NOT NULL
- OrderID (Key2) — int — Foreign key → Orders.OrderID — NOT NULL
- ProductID (PK) — INT — Foreign key → Products.ProductID — NOT NULL
- Quantity (Field) — int
Orders (tb_orders)
- OrderID (Key) — int — Primary key — NOT NULL
- CustomerID (Key2) — int — Foreign key → Customers.CustomerID — NOT NULL
- EmployeeID (Key3) — int — Foreign key → Employees.EmployeeID — NOT NULL
- OrderDate (Field) — str
- ShipperID (Key4) — int — Foreign key → Shippers.ShipperID — NOT NULL
Products (tb_products)
- ProductID (PK) — INT — Primary key — NOT NULL
- ProductName (Field) — VARCHAR(64)
- SupplierID (Key) — Foreign key → Suppliers.SupplierID — NOT NULL
- CategoryID (Key2) — Foreign key → Categories.CategoryID — NOT NULL
- Unit (Field2)
- Price (Field3)
Shippers (tb_shippers)
- ShipperID (Key) — int — Primary key — NOT NULL
- ShipperName (Field) — str
- Phone (Field2) — int
Suppliers (tb_suppliers)
- SupplierID (Key) — int — Primary key — NOT NULL
- SupplierName (Field) — str
- Address (Field2) — str
- City (Field3) — str
- PostalCode (Field4) — str
- Country (Field5) — str
- Phone (Field6) — int