편의점

테이블 (3)

Convience (convience)

  • Key — INTEGER — 기본 키 — NOT NULL
  • Name (name) — VARCHAR(10)
  • Location (location) — VARCHAR(30)
  • Host (host) — VARCHAR(10)
  • Worker (worker) — VARCHAR(10)
  • Phone_number (phone_number) — INTEGER
  • Product (product) — VARCHAR(10)

Middle (middle)

  • Where (where) — INTEGER — 외래 키 → Convience.Key — NOT NULL
  • Product (product) — INTEGER — 외래 키 → Product.Key — NOT NULL

Product (product)

  • Key — INTEGER — 기본 키 — NOT NULL
  • Name — VARCHAR(20)
  • Kinds (kinds) — VARCHAR(20)
  • Price (price) — INTEGER
  • Field