s

Tables (3)

Category (Untitled2)

  • Category_id (category_id) — INT() — Primary key — NOT NULL
  • Category_name (category_name) — VARCHAR(20)

Management (Untitled)

  • Product_id (product_id) — INT() — Primary key — NOT NULL
  • Store_id (store_id) — INT() — Foreign key → Store.Store_id — NOT NULL
  • Category_id (category_id) — INT() — Foreign key → Category.Category_id — NOT NULL
  • Expire_Date (expire_date) — INT()
  • Price (price) — INT()
  • Stock (stock) — INT()

Store (Untiled1)

  • Store_id (store_id) — INT() — Primary key — NOT NULL
  • Store_name (store_name) — VARCHAR(20)
  • Store_address (store_address) — VARCHAR(20)