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)