order2025-2

Tables (5)

Customer

  • id — int — Primary key — NOT NULL
  • FirstName — nvarchar(30)
  • LastName — nvarchar(30)
  • phone — varchar(20)
  • city — nvarchar(30)
  • country — nvarchar(30)

OrderItem

  • id — int — Primary key — NOT NULL
  • OrderId — int — NOT NULL
  • ProductId — int — NOT NULL
  • UnitPrice — decimal
  • Quantity — int

Product

  • id — int — Primary key — NOT NULL
  • ProductName — nvarchar(50)
  • UnitPrice — decimal
  • SupplierId — int — NOT NULL

Supplier

  • id — int — Primary key — NOT NULL
  • CompanyName — nvarchar(30)
  • City — nvarchar(30)
  • Country — nvarchar(30)
  • ContactName — nvarchar(40)

_Order

  • id — int — Primary key — NOT NULL
  • OrderDate — date
  • TotalAmount — decimal
  • customerId — int — NOT NULL
  • OrderName — nvarchar(40)