오더프로세스

테이블 (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)