aa

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

Product

  • id — int — Primary key — NOT NULL
  • productName — nvarchar(30)
  • unitPrice — decimal
  • supplierid — id — NOT NULL

Supplier

  • id — id — Primary key — NOT NULL
  • CompanyName — nvarchar(30)
  • city — nvarchar(30)
  • country — nvarchar(30)
  • contactname — nvarchar(30)

_Order

  • id — int — Primary key — NOT NULL
  • orderdate — datetime2
  • totalamount — decimal
  • customerid — int — NOT NULL