0504

Tables (4)

Category (category)

  • Category id (category_id) — INT(11) — Primary key — NOT NULL
  • Category Name (category_name) — VARCHAR(255)

Master (master)

  • Key — Primary key — NOT NULL
  • Product id (product_id) — INT(11) — Foreign key → Product.Product id — NOT NULL
  • Category id (category_id) — INT(11) — Foreign key → Product.Category id — NOT NULL
  • Store id (store_id) — INT(11) — Foreign key → Store.Store id — NOT NULL

Product (product)

  • Product id (product_id) — INT(11) — Primary key — NOT NULL
  • Category id (category_id) — INT(11) — Foreign key → Category.Category id — NOT NULL
  • Product Name (product_name) — VARCHAR(255)
  • Product Price (product_price) — INT(11)
  • Product Count (product_count) — INT(11)

Store (store)

  • Store id (store_id) — INT(11) — Primary key — NOT NULL
  • Store Name (store_name) — VARCHAR(255)
  • Store Location (Store_location) — VARCHAR(255)