OrderDB

Tables (8)

Categoris (tb_Categoris)

  • CategoryID (PK) — INT — Primary key — NOT NULL
  • CategoryName (Field) — VARCHAR(64)
  • Description (Field2) — VARCHAR(64)

Customers (tb_Customers)

  • CustomerID (PK) — INT — Primary key — NOT NULL
  • CustomerName (Field) — VARCHAR(64)
  • ConcatName (Field2) — VARCHAR(64)
  • Address (Field3) — VARCHAR(64)
  • City (Field4) — VARCHAR(64)
  • PostalCode (Field5) — INT
  • Country (Field6) — VARCHAR(64)

Employees (tb_Employees)

  • EmployeeID (PK) — INT — Primary key — NOT NULL
  • LastName (Field) — VARCHAR(64)
  • FirstName (Field2) — VARCHAR(64)
  • BirthDate (Field3) — VARCHAR(64)
  • Photo (Field4) — VARCHAR(64)
  • Notes (Field5) — VARCHAR(64)

OrderDetails (tb_OrderDetails)

  • OrderDetailID (PK) — INT — Primary key — NOT NULL
  • OrderID (PK2) — INT — Foreign key → Orders.OrderID — NOT NULL
  • ProductID (PK3) — INT — Foreign key → Products.ProductID — NOT NULL
  • Quantity (Field) — INT

Orders (tb_Orders)

  • OrderID (PK) — INT — Primary key — NOT NULL
  • CustomerID (PK2) — INT — Foreign key → Customers.CustomerID — NOT NULL
  • EmployeeID (PK3) — INT — Foreign key → Employees.EmployeeID — NOT NULL
  • orderDate (Field3) — VARCHAR(64)
  • ShipperID (PK4) — 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 (PK2) — INT — Foreign key → Categoris.CategoryID — NOT NULL
  • Unit (Field2) — VARCHAR(64)
  • Price (Field3) — INT

Shippers (tb_Shippers)

  • ShipperID (PK) — INT — Primary key — NOT NULL
  • ShipperName (Field) — VARCHAR(64)
  • Phone (Field2) — VARCHAR(64)

Suppliers (tb_suppliers)

  • SupplierID (Key) — Primary key — NOT NULL
  • SupllilerName (Field) — VARCHAR(64)
  • ContactName (Field2) — VARCHAR(64)
  • Address (Field3) — VARCHAR(64)
  • City (Field4) — VARCHAR(64)
  • PostalCode (Field5) — VARCHAR(64)
  • Country (Field6) — VARCHAR(64)
  • Phone (Field7) — VARCHAR(64)