shop

Tables (3)

brand (mss_brand)

  • brand_id — NUMBER — Primary key — NOT NULL
  • brand_name — VARCHAR2(60) — NOT NULL

category (mss_category)

  • category_id — NUMBER — Primary key — NOT NULL
  • category_name — VARCHAR2(60) — NOT NULL

product (mss_product)

  • product_id — NUMBER — Primary key — NOT NULL
  • brand_id — NUMBER — Foreign key → brand.brand_id — NOT NULL
  • category_id — NUMBER — Foreign key → category.category_id — NOT NULL
  • product_name — VARCHAR2(100) — NOT NULL
  • description — VARCHAR2(1000)