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