박훈민

테이블 (6)

Addr (Untitled)

  • Key (zipcode) — char(5) — 기본 키 — NOT NULL
  • do — nchar(10)
  • Field (city) — nchar(10)
  • Field (dong) — nchar(10)

Untitled (Customer)

  • Key (ID) — int — 기본 키 — NOT NULL
  • Field (Lastname) — nchar(30)
  • Field (Firstname) — nchar(30)
  • Field (Country) — nchar(30)
  • Field (tellphone) — char(13)
  • Field (zipcode) — char(5)
  • Field (do) — nchar(30)
  • Field (city) — nchar(10)
  • Field (dong) — nchar(10)
  • Field (detail addr) — nchar(30)
  • Key (zipcode2) — char(5) — 외래 키 → Addr.Key — NOT NULL

Untitled (_Order)

  • Key (ID) — int — 기본 키 — NOT NULL
  • Key (CustomerID) — int — 외래 키 → Untitled.Key — NOT NULL
  • Field (Orderdate) — datetime2
  • Field (Total_amount) — int

Untitled (Product)

  • Key (ID) — int — 기본 키 — NOT NULL
  • Field (Product_name) — nchar(30)
  • Field (Unit_price) — int
  • Key (SupplierID) — int — 외래 키 → Untitled.Key — NOT NULL

Untitled (Order_item)

  • Key (ID) — int — 기본 키 — NOT NULL
  • Field (Quantity) — int
  • Key (_OrderID) — int — 외래 키 → Untitled.Key — NOT NULL
  • Key (ProductID) — int — 외래 키 → Untitled.Key — NOT NULL

Untitled (Supplier)

  • Key (ID) — int — 기본 키 — NOT NULL
  • Field (tellphone) — char(13)
  • Field (zipcode) — char(5)
  • Field (do) — nchar(10)
  • Field (city) — nchar(10)
  • Field2 (detail addr) — nchar(30)
  • Key (zipcode2) — char(5) — 외래 키 → Addr.Key — NOT NULL