편의점 상품 관리

테이블 (4)

All_store_info (all_store_info)

  • Store_id (store_id) — INT(10) — 기본 키 — NOT NULL
  • Store_name (store_name) — CHAR(100)
  • City (city) — CHAR(100)
  • Phone (phone) — CHAR(20)
  • Email (email) — CHAR(30)
  • Construct_date (construct_date) — CHAR(20)
  • Size — INT(10)
  • Address (address) — CHAR(20)
  • Store_owner (store_owner) — CHAR(100)

Category (category)

  • Category_id (category_id) — INT(10) — 기본 키 — NOT NULL
  • Product_id (product_id) — INT(100) — 외래 키 → Product_info.Product_id — NOT NULL
  • Store_id (store_id) — INT(10) — 외래 키 → Product_info.Store_id — NOT NULL
  • Category (category) — CHAR(100)

Product_info (product_info)

  • Product_id (product_id) — INT(100) — 외래 키 → Store_info.Product_id — NOT NULL
  • Store_id (store_id) — INT(10) — 외래 키 → Store_info.Store_id — NOT NULL
  • Expire_date (expire_date) — CHAR(20)
  • Cost (cost) — INT(10)
  • Category (category) — CHAR(100)
  • Name (name) — CHAR(100)
  • Allowed_age (allowed_age) — INT(10)

Store_info (store_info)

  • Product_id (product_id) — INT(100) — 기본 키 — NOT NULL
  • Store_id (store_id) — INT(10) — 외래 키 → All_store_info.Store_id — NOT NULL
  • Store_name — CHAR(100)
  • Store_ address (store_ address) — CHAR(20)