OrderDB
Tables (8)
Categories (th-Categories)
- CategoryID (Key) — Primary key — NOT NULL
- CategoryName (Field)
- Description (Field2)
Customers (th_Customers)
- Customer ID (Key) — Primary key — NOT NULL
- CustomerName (Field)
- ContactName (Field2)
- Address (Field3)
- City (Field4)
- PostalCode (Field5)
- Country (Field6)
Employees (th_Employees)
- EmployeeID (Key) — Primary key — NOT NULL
- LastName (Field)
- FirstName (Field2)
- BirthDate (Field3)
- Photo (Field4)
- Notes (Field5)
OrderDetails (th_OrderDetails)
- OrderDetail ID (Key) — Primary key — NOT NULL
- Quantity (Field3)
- Order ID (Key2) — Foreign key → Orders.Order ID — NOT NULL
- Product ID (PK) — INT — Foreign key → Products.Product ID — NOT NULL
Orders (th_Orders)
- Order ID (Key) — Primary key — NOT NULL
- Customer ID (Key3) — Foreign key → Customers.Customer ID — NOT NULL
- OrderDate (Field3)
- Shipper ID (Key2) — Foreign key → ShipperID.Shipper ID — NOT NULL
- EmployeeID (Key4) — Foreign key → Employees.EmployeeID — NOT NULL
Products (tb_products)
- Product ID (PK) — INT — Primary key — NOT NULL
- ProductName (Field) — VARCHAR(64)
- SupplierID (Key) — Foreign key → Suppliers.SupplierID — NOT NULL
- Unit (Field3)
- Price (Field4)
- CategoryID (Key2) — Foreign key → Categories.CategoryID — NOT NULL
ShipperID (Untitled)
- Shipper ID (Key) — Primary key — NOT NULL
- ShipperName (Field)
- Phone (Field2)
Suppliers (th_suppliers)
- SupplierID (Key) — Primary key — NOT NULL
- SupplierName (Field)
- ContactName (Field2)
- Address (Field3)
- City (Field4)
- PostalCode (Field5)
- Country (Field6)
- Phone (Field7)