HyangDam
Tables (13)
comments
- comment_id — BIGINT — Primary key
- post_id — BIGINT
- user_id — BIGINT
- content — TEXT
- created_at — TIMESTAMP
likes
- id — BIGINT — Primary key
- user_id — BIGINT
- perfume_id — BIGINT
- 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
- 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
- title — VARCHAR(255)
- content — TEXT
- created_at — TIMESTAMP
recommendations
- id — BIGINT — Primary key
- user_id — BIGINT
- perfume_id — BIGINT
- similarity_score — FLOAT
- created_at — TIMESTAMP
search_logs
- id — BIGINT — Primary key
- user_id — BIGINT
- keyword — VARCHAR(255)
- perfume_id — BIGINT
- created_at — TIMESTAMP
user_onboarding
- onboarding_id — BIGINT
- user_id — BIGINT
- preferred_target — ENUM('male', 'female', 'unisex')
- created_at — TIMESTAMP
user_perfumes
- id — BIGINT — Primary key
- user_id — BIGINT
- perfume_id — BIGINT
- status — ENUM('owned', 'wishlist')
user_selected_perfumes
- id — BIGINT — Primary key
- user_id — BIGINT
- perfume_id — BIGINT
- feeling — VARCHAR(255)
user_vectors
- user_id — BIGINT
- fresh — FLOAT
- woody — FLOAT
- oriental — FLOAT
- floral — FLOAT
- spicy — FLOAT
- sweet — FLOAT
- updated_at — TIMESTAMP
users
- user_id — BIGINT — Primary key
- email — VARCHAR(255)
- password — VARCHAR(255)
- gender — ENUM('male', 'female', 'other')
- age — INT
- created_at — TIMESTAMP