study
Tables (8)
Categories (tb_category)
- CategoryID (Key) — Primary key — NOT NULL
Customers (tb_customer)
- CustomerID (Key) — Primary key — NOT NULL
Employees (tb_employee)
- EmployeeID (Key) — Primary key — NOT NULL
OrderDetails (tb_order_detail)
- OrderDetailID (Key) — Primary key — NOT NULL
- OrderID (Key2) — Foreign key → Orders.OrderID — NOT NULL
- ProductID (Key3) — Foreign key → Products.ProductID — NOT NULL
Orders (tb_order)
- OrderID (Key) — Primary key — NOT NULL
- OrderDate (Field)
- EmployeeID (Key3) — Foreign key → Employees.EmployeeID — NOT NULL
- ShipperID (Key4) — Foreign key → Shippers.ShipperID — NOT NULL
- CustomerID (Key2) — Foreign key → Customers.CustomerID — NOT NULL
Products (tb_product)
- ProductID (Key) — Primary key — NOT NULL
- SupplierID (Key2) — Foreign key → Suppliers.SupplierID — NOT NULL
- CategoryID (Key3) — Foreign key → Categories.CategoryID — NOT NULL
- Field
- Field2
- Field3
Shippers (tb_shipper)
- ShipperID (Key) — Primary key — NOT NULL
Suppliers (tb_supplier)
- SupplierID (Key) — Primary key — NOT NULL