0504ws

Tables (4)

Product (Untitled)

  • product_id — Integer — Primary key — NOT NULL
  • product_category_id — Integer — Foreign key → Product_category.product_category_id — NOT NULL
  • product_name — VARCHAR(50)
  • product_color — VARCHAR(50)
  • product_size — VARCHAR(50)

Product_category (Untitled4)

  • product_category_id — INTEGER — Primary key — NOT NULL
  • product_category_name — VARCHAR(50)

Product_to_Store (Untitled3)

  • product_id — Integer — Foreign key → Product.product_id — NOT NULL
  • store_id — Integer — Foreign key → Store.store_id — NOT NULL
  • product_count — Integer

Store (Untitled2)

  • store_id — Integer — Primary key — NOT NULL
  • store_name — VARCHAR(50)
  • store_place — VARCHAR(50)
  • store_owner — VARCHAR(50)