Roombi

Tables (4)

Combination Log (combination_log)

  • Combination Number (combination_no) — Primary key — NOT NULL
  • ID Number (id2) — Foreign key → User.ID Number — NOT NULL
  • Single Score Sum (single_score_sum)
  • Field (combination_score)
  • Hearted (liked)
  • Product 1 ID Number (product_id1) — INT — Foreign key → Furniture Catalogue DB.New Id — NOT NULL
  • Product 2 ID Number (product_id2) — INT — Foreign key → Furniture Catalogue DB.New Id — NOT NULL
  • Product 3 ID Number (product_id3) — INT — Foreign key → Furniture Catalogue DB.New Id — NOT NULL
  • Product 4 ID Number (product_id4) — INT — Foreign key → Furniture Catalogue DB.New Id — NOT NULL

Furniture Catalogue DB (furniture_list)

  • New Id (NEW_ID) — INT — Primary key — NOT NULL
  • Name
  • Price
  • Category
  • Color
  • Size
  • Rating
  • Reviews
  • URL
  • Image URL (Image_URL)
  • Product Number (Product_Number)
  • Category Number (Category_Num)
  • Converted Color (Color_2)
  • Color Number (Color_Num)

Heartlist (heart_list)

  • Heart ID Number (heart_id) — Primary key — NOT NULL
  • Combination Number (combination_no) — Foreign key → Combination Log.Combination Number — NOT NULL
  • ID Number (id2) — Foreign key → Combination Log.ID Number — NOT NULL

User (users)

  • ID Number (id) — Primary key — NOT NULL
  • User ID Name (user_id)
  • User Password (encrypted_pwd)
  • User UUID Number (user_number)