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
  • productid — int — NOT NULL
  • orderid — int — NOT NULL
  • unitprice — decimal
  • quantity — int

Product

  • id — int — Primary key — NOT NULL
  • ProductName — nvarchar(30)
  • 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 — datetime2
  • totalamount — decimal
  • customerid — int — NOT NULL
  • ordername — nvarchar(40)