편의점

테이블 (3)

Item (Untitled3)

  • Key (store_id2) — 외래 키 → Store.Key — NOT NULL
  • Key (item_id2) — 외래 키 → Iteminfo.Key — NOT NULL
  • Field (stock)
  • Field2 (expiration_date)

Iteminfo (Untitled2)

  • Key (item_id) — 기본 키 — NOT NULL
  • Field (price)
  • Field2 (margin)
  • Field3 (kind)

Store (Untitled)

  • Key (store_id) — 기본 키 — NOT NULL
  • Field (address)
  • Field2 (owner)
  • Field3 (phone_number)
  • Field4 (cash)
  • Field5 (part_timer_cnt)