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)