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