order2025-2

Tables (5)

Customer

  • Id — int — Primary key — NOT NULL
  • FirstName — nvarchar(40)
  • LastName — nvarchar(40)
  • City — nvarchar(40)
  • Country — nvarchar(40)
  • Phone — nvarchar(40)

OrderItem

  • Id — int — Primary key — NOT NULL
  • OrderId — int
  • ProductId — int
  • UnitPrice — decimal(12,2)
  • Quantity — int

Product

  • Id — int — Primary key — NOT NULL
  • ProductName — nvarchar(50)
  • SupplierId — int
  • UnitPrice — decimal(12,2)
  • Package — nvarchar(30)
  • IsDiscontinured — bit

Supplier

  • Id — int — Primary key — NOT NULL
  • CompanyName — nvarchar(40)
  • ContactName — nvarchar(50)
  • ContactTitle — nvarchar(40)
  • City — nvarchar(40)
  • Country — nvarchar(40)
  • Phone — nvarchar(30)
  • Fax — nvarchar(30)
  • Field — VARCHAR(255)

_Order

  • Id — int — Primary key — NOT NULL
  • OrderDate — Date
  • OrderNumber — nvarchar(10)
  • CustomerId — int
  • TotalAmount — decimal(12,2)
  • Ordername — nvarchar(50)