fruit

테이블 (4)

Untitled (BUY)

  • Key (b_id) — Int — 기본 키 — NOT NULL
  • Field (b_quantity) — Int
  • Field (b_date) — datetime
  • Field (b_unit) — varchar(10)
  • f_name — varchar(30) — 외래 키 → 과일.f_name — NOT NULL
  • Key (b_w_name) — varchar(20) — 외래 키 → Untitled.Key — NOT NULL

Untitled (WholeSaler)

  • Key (w_name) — varchar(20) — 기본 키 — NOT NULL
  • Field (w_location) — varchar(50)

Untitled (Sell)

  • Key (s_id) — Int — 기본 키 — NOT NULL
  • Field (s_date) — datetime
  • Field (s_quantity) — Int
  • Field (s_price) — Int
  • Field (s_method) — varchar(4)
  • Field (s_unit) — varchar(10)
  • f_name — varchar(30) — 외래 키 → 과일.f_name — NOT NULL

과일 (FRUIT)

  • f_name — varchar(30) — 기본 키 — NOT NULL
  • f_price — Int
  • f_stock — Int
  • f_unit — varchar(10)