order2025-2
Tables (5)
Customer
- Id — int — Primary key — NOT NULL
- FirstName — nvarchar(40)
- LastName — nvarchar(40)
- City — nvarchar(40)
- Country — nvarchar(40)
- Phone — nvarchar(40)
OrderItem
- Id — int — Primary key — NOT NULL
- OrderId — int
- ProductId — int
- UnitPrice — decimal(12,2)
- Quantity — int
Product
- Id — int — Primary key — NOT NULL
- ProductName — nvarchar(50)
- SupplierId — int
- UnitPrice — decimal(12,2)
- Package — nvarchar(30)
- IsDiscontinured — bit
Supplier
- Id — int — Primary key — NOT NULL
- CompanyName — nvarchar(40)
- ContactName — nvarchar(50)
- ContactTitle — nvarchar(40)
- City — nvarchar(40)
- Country — nvarchar(40)
- Phone — nvarchar(30)
- Fax — nvarchar(30)
- Field — VARCHAR(255)
_Order
- Id — int — Primary key — NOT NULL
- OrderDate — Date
- OrderNumber — nvarchar(10)
- CustomerId — int
- TotalAmount — decimal(12,2)
- Ordername — nvarchar(50)