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
- OrderId — int — NOT NULL
- ProductId — int — NOT NULL
- UnitPrice — decimal
- Quantity — int
Product
- id — int — Primary key — NOT NULL
- ProductName — nvarchar(50)
- 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 — date
- TotalAmount — decimal
- customerId — int — NOT NULL
- OrderName — nvarchar(40)