Sesac
Tables (8)
Categories (tb_categories)
- CategoriesID (Key) — Primary key — NOT NULL
- CategoryName (Field)
- Description (Field2)
Customers (tb_customer)
- CustomerID (Key) — Primary key — NOT NULL
- CustomerName (Field)
- ContactName (Field2)
- Address (Field3)
- PostalCode (Field4)
- Country (Field5)
Employee (tb_employee)
- EmployeeID (Key) — Primary key — NOT NULL
- LastName (Field)
- FirstName (Field2)
- BirthDate (Field3)
- Photo (Field4)
- Field5
OrderDetails (tb_OD)
- OrderDetailID (Key) — Primary key — NOT NULL
- OrderID (Key2) — Foreign key → Orders.OrderID — NOT NULL
- Quantity (Field)
- ProductID (Key3) — Foreign key → Products.ProductID — NOT NULL
Orders (tb_orders)
- OrderID (Key) — Primary key — NOT NULL
- OrderDate (Field2)
- CustomerID (Key2) — Foreign key → Customers.CustomerID — NOT NULL
- ShipperID (Key3) — Foreign key → Shippers.ShipperID — NOT NULL
- EmployeeID (Key4) — Foreign key → Employee.EmployeeID — NOT NULL
Products (tb_products)
- ProductID (Key) — Primary key — NOT NULL
- ProductName (Field)
- Unit (Field2)
- Price (Field3)
- SupplierID (Key2) — Foreign key → Suppliers.SupplierID — NOT NULL
- CategoriesID (Key3) — Foreign key → Categories.CategoriesID — NOT NULL
Shippers (tb_shippers)
- ShipperID (Key) — Primary key — NOT NULL
- ShipperName (Field)
- Phone (Field2)
Suppliers (tb_suppliers)
- SupplierID (Key) — Primary key — NOT NULL
- SupplierName (Field)
- ContactName (Field2)
- Address (Field3)
- City (Field4)
- PostalCode (Field5)
- Phone (Field6)
- Country (Field7)