편의점 상품 관리

테이블 (7)

Category (category)

  • Category_id (category_id) — INT — 기본 키 — NOT NULL
  • Category_name (category_name) — VARCHAR(255)

Category_Product (category_product)

  • Category_id (category_id) — INT — 외래 키 → Category.Category_id — NOT NULL
  • Supplier_id (supplier_id) — INT — 외래 키 → Product.Supplier_id — NOT NULL

Convenient_Store (convenient_store)

  • Region_id (region_id) — INT — 외래 키 → Region.Region_id — NOT NULL
  • Address (addresss) — VARCHAR(255)
  • Phone (phone) — VARCHAR(255)

Convenient_Store_Product (convenient_store_product)

  • Region_id (region_id) — INT — 외래 키 → Convenient_Store.Region_id — NOT NULL
  • Supplier_id (supplier_id) — INT — 외래 키 → Product.Supplier_id — NOT NULL

Product (product)

  • Supplier_id (supplier_id) — INT — 외래 키 → Supplier.Supplier_id — NOT NULL
  • Price (price) — INT
  • Quantity (quantity) — INT
  • Expiration_date (expiration_date) — TEXT(255)

Region (region)

  • Region_id (region_id) — INT — 기본 키 — NOT NULL
  • Region_name (region_name) — VARCHAR(255)

Supplier (supplier)

  • Supplier_id (supplier_id) — INT — 기본 키 — NOT NULL
  • Supplier_name (supplier_name) — VARCHAR(255)
  • Supplier_phone (supplier_phone) — VARCHAR(255)
  • E-mail (e-mail) — VARCHAR(255)