study
Tables (8)
Categories (tb_Category)
- CategoryID (Key) — Primary key — NOT NULL
- CategoryName (Field)
- Description (Field2)
Employees (tb_employee)
- EmployeeID (Key) — Primary key — NOT NULL
- LastName (Field)
- FirstName (Field2)
- BirthDate (Field3)
- Photo (Field4)
- Notes (Field5)
OrderDetails (tb _Order_Details)
- OrderDetailID (Key) — Primary key — NOT NULL
- ProductID (Field2)
- Quantity (Field3)
- ProductID (Key2) — Foreign key → Prducts.ProductID — NOT NULL
- OrderID (Key3) — Foreign key → orders.OrderID — NOT NULL
Prducts (tb_product)
- ProductID (Key) — Primary key — NOT NULL
- ProductName (Field)
- SupplierID (Field2)
- CategoryID (Field3)
- Unit (Field4)
- Price (Field5)
- SupplierID (Key2) — Foreign key → Supplier.SupplierID — NOT NULL
- CategoryID (Key3) — Foreign key → Categories.CategoryID — NOT NULL
Sippers (tb Shipper)
- ShipperID (Key) — Primary key — NOT NULL
- ShipperName (Field)
- Phone (Field2)
Supplier (tb_ Supplier)
- SupplierID (Key) — Primary key — NOT NULL
- SupplierName (Field)
- ContactName (Field2)
- Address (Field3)
- City (Field4)
- PostalCode (Field5)
- Country (Field6)
- Phone (Field7)
customers (tb_customers)
- CustomerID (Key) — Primary key — NOT NULL
- CustomerName (Field)
- ContactName (Field2)
- Address (Field3)
- City (Field4)
- PostalCode (Field5)
- Country (Field6)
orders (Untitled)
- OrderID (Key) — Primary key — NOT NULL
- CustomerID (Key2) — Foreign key → customers.CustomerID — NOT NULL
- OrderDate (Field)
- EmployeeID (Key3) — Foreign key → Employees.EmployeeID — NOT NULL
- ShipperID (Key4) — Foreign key → Sippers.ShipperID — NOT NULL