HyangDam_fix

Tables (13)

likes

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

magazines

  • magazine_id — BIGINT — Primary key — NOT NULL
  • title — VARCHAR(255)
  • content — TEXT
  • image_url — TEXT
  • created_at — TIMESTAMP

perfume_reviews

  • review_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user_perfumes.user_id — NOT NULL
  • perfume_id — BIGINT — Foreign key → user_perfumes.perfume_id — NOT NULL
  • rating — TINYINT — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

perfume_vectors

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

perfumes

  • perfume_id — BIGINT — Primary key — NOT NULL
  • brand — VARCHAR(255)
  • name — VARCHAR(255)
  • type — VARCHAR(100)
  • category — VARCHAR(255)
  • target_audience — ENUM('male', 'female', 'unisex')
  • longevity — VARCHAR(50)
  • description — TEXT
  • notes — TEXT
  • image_url — TEXT
  • created_at — TIMESTAMP

recommendations

  • id — BIGINT — Primary key — NOT NULL
  • 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

refresh_tokens

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • token_hash — VARCHAR(255) — NOT NULL
  • expires_at — TIMESTAMP — NOT NULL
  • revoked_at — TIMESTAMP
  • created_at — TIMESTAMP

search_logs

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

social_accounts

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • provider — ENUM('kakao', 'google', 'naver') — NOT NULL
  • provider_user_id — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP

user_onboarding

  • onboarding_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • current_perfumes — JSON
  • preferred_target — ENUM('male', 'female', 'unisex')
  • selected_categories — JSON — NOT NULL
  • avoid_categories — JSON — NOT NULL
  • focus_categories — JSON — NOT NULL
  • preferred_brands — JSON — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

user_perfumes

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

user_vectors

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

users

  • user_id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255)
  • name — VARCHAR(100)
  • nickname — VARCHAR(100)
  • gender — ENUM('male', 'female', 'other')
  • birth_date — DATE
  • age — INT
  • profile_image_url — TEXT
  • status — ENUM('active', 'deleted') — NOT NULL
  • nickname_updated_at — TIMESTAMP
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP