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)