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)