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