SoongSoong

Tables (13)

comments

  • comment_id — BIGINT
  • post_id — BIGINT — Foreign key → posts.post_id — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • content — TEXT
  • created_at — TIMESTAMP

likes

  • id — BIGINT
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • perfume_id — BIGINT — Foreign key → perfumes.perfume_id — NOT NULL
  • UNIQUE(user_id, — perfume_id)

magazines

  • magazine_id — BIGINT
  • title — VARCHAR(255)
  • content — TEXT
  • image_url — TEXT
  • created_at — TIMESTAMP

perfume_vectors

  • perfume_id — BIGINT — Foreign key → perfumes.perfume_id
  • fresh — FLOAT
  • woody — FLOAT
  • oriental — FLOAT
  • floral — FLOAT
  • spicy — FLOAT
  • sweet — FLOAT
  • updated_at — TIMESTAMP

perfumes

  • perfume_id — BIGINT
  • brand — VARCHAR(255)
  • name — VARCHAR(255)
  • type — VARCHAR(100)
  • category — VARCHAR(255)
  • target_audience — ENUM('male', 'female', 'unisex')
  • longevity — VARCHAR(50)
  • created_at — TIMESTAMP

posts

  • post_id — BIGINT
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • title — VARCHAR(255)
  • content — TEXT
  • created_at — TIMESTAMP

recommendations

  • id — BIGINT
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • perfume_id — BIGINT — Foreign key → perfumes.perfume_id — NOT NULL
  • similarity_score — FLOAT
  • created_at — TIMESTAMP

search_logs

  • id — BIGINT
  • user_id — BIGINT — Foreign key → users.user_id
  • perfume_id — BIGINT — Foreign key → perfumes.perfume_id
  • keyword — VARCHAR(255)
  • created_at — TIMESTAMP

user_onboarding

  • onboarding_id — BIGINT
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • preferred_target — ENUM('male', 'female', 'unisex')
  • created_at — TIMESTAMP

user_perfumes

  • id — BIGINT
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • perfume_id — BIGINT — Foreign key → perfumes.perfume_id — NOT NULL
  • status — ENUM('owned', 'wishlist')

user_selected_perfumes

  • id — BIGINT
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • perfume_id — BIGINT — Foreign key → perfumes.perfume_id — NOT NULL
  • feeling — VARCHAR(255)

user_vectors

  • user_id — BIGINT — Foreign key → users.user_id
  • fresh — FLOAT
  • woody — FLOAT
  • oriental — FLOAT
  • floral — FLOAT
  • spicy — FLOAT
  • sweet — FLOAT
  • updated_at — TIMESTAMP

users

  • user_id — BIGINT
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • gender — ENUM('male', 'female', 'other')
  • age — INT
  • created_at — TIMESTAMP