order2025-2

Tables (5)

Customer

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

OrderItem

  • id — int — Primary key — NOT NULL
  • productid — int — NOT NULL
  • orderid — int — NOT NULL
  • unitprice — decimal
  • quantity — int

Product

  • id — int — Primary key — NOT NULL
  • supplierid — int — NOT NULL
  • productname — nvarchar(30)
  • unitprice — decimal

Supplier

  • id — int — Primary key — NOT NULL
  • companyname — nvarchar(30)
  • city — nvarchar(30)
  • country — nvarchar(30)
  • ContactName — nvarchar(30)

_Order

  • id — int — Primary key — NOT NULL
  • custimerid — int — NOT NULL
  • orderdate — datetime2
  • totalamount — decimal
  • ordername — nvarchar(30)