편의점상품관리

테이블 (3)

Product (Untitled2)

  • Product_id (product_id) — INT — 기본 키 — NOT NULL
  • Name (name) — VARCHAR(255)
  • Price (price) — INT
  • Expiration Date (expiration_date) — DATETIME
  • Manufacturing Date (Manu_date) — DATETIME

branch (Untitled)

  • Branch_id (branch_id) — INT — 기본 키 — NOT NULL
  • Name (name) — VARCHAR
  • Address (address) — VARCHAR
  • Monthly Sales (monthly_sales) — INT

stock (Untitled3)

  • Branch_id (branch_id) — INT — 외래 키 → branch.Branch_id — NOT NULL
  • Product_id (product_id) — INT — 외래 키 → Product.Product_id — NOT NULL