convenience store

Tables (4)

Category (Untitled4)

  • Category ID (category_id) — INT(10) — Primary key — NOT NULL
  • Store ID (store_id) — INT(10) — Foreign key → Convenience Store.Store ID — NOT NULL
  • Category Name (category name) — VARCHAR(20)

Convenience Store (Untitled)

  • Store ID (store_id) — INT(10) — Primary key — NOT NULL
  • Location (location) — VARCHAR(20)
  • Store Name (store_name) — VARCHAR(20)

Order (Untitled3)

  • Order ID (order_id) — INT(10) — Primary key — NOT NULL
  • Order Date (order_date) — CHAR(8)
  • Order Quantity (order_quantity) — INT

Product (Untitled2)

  • Product Code (product_code_id) — INT(10) — Primary key — NOT NULL
  • Category ID (category_id) — INT(10) — Foreign key → Category.Category ID — NOT NULL
  • Store ID (store_id) — INT(10) — Foreign key → Category.Store ID — NOT NULL
  • Price (price) — INT
  • Stock (stock) — INT
  • Order (order) — INT
  • Warehousing (warehousing) — CHAR(8)
  • Expiration (expiration) — CHAR(8)
  • Minimum Stock (minimum stock) — INT