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)