오더프로세스
테이블 (5)
Customer
- Id — int — NOT NULL
- FirstName — nvarchar(40) — NOT NULL
- LastName — nvarchar(40) — NOT NULL
- City — nvarchar(40)
- Country — nvarchar(40)
- Phone — nvarchar(20)
OrderItem
- Id — int — NOT NULL
- OrderId — int — NOT NULL
- ProductId — int — NOT NULL
- UnitPrice — decimal(12, 2) — NOT NULL
- Quantity — int — NOT NULL
Product
- Id — int — NOT NULL
- ProductName — nvarchar(50) — NOT NULL
- SupplierId — int — NOT NULL
- UnitPrice — decimal(12, 2)
- Package — nvarchar(30)
- IsDiscontinued — bit — NOT NULL
Supplier
- Id — int — NOT NULL
- CompanyName — nvarchar(40) — NOT NULL
- ContactName — nvarchar(50)
- ContactTitle — nvarchar(40)
- City — nvarchar(40)
- Country — nvarchar(40)
- Phone — nvarchar(30)
- Fax — nvarchar(30)
_Order
- Id — int — NOT NULL
- OrderDate — date — NOT NULL
- OrderNumber — nvarchar(10)
- CustomerId — int — NOT NULL
- TotalAmount — decimal(12, 2)