Hintic
Tables (11)
accords (어코드 종류)
- id — UUID — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
bookmarks (찜)
- user_id — UUID — Foreign key → users.id — NOT NULL
- perfume_id — UUID — Foreign key → perfumes.id — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
brands (브랜드)
- id — UUID — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- country — VARCHAR(50)
- founded_year — SMALLINT
- description — TEXT
- logo_url — TEXT
- created_at — TIMESTAMPTZ — NOT NULL
hint_sessions (향수 추천)
- id — UUID — Primary key — NOT NULL
- user_id — UUID — Foreign key → users.id — NOT NULL
- raw_input — TEXT — NOT NULL
- ai_keywords — TEXT
- matched_perfume_ids — UUID
- created_at — TIMESTAMPTZ — NOT NULL
notes (노트 종류)
- id — UUID — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
perfume_accords (향수_어코드)
- perfume_id — UUID — Foreign key → perfumes.id — NOT NULL
- accord_id — UUID — Foreign key → accords.id — NOT NULL
perfume_notes (향수_노트)
- position — VARCHAR(10) — Primary key — NOT NULL
- perfume_id — UUID — Foreign key → perfumes.id — NOT NULL
- note_id — UUID — Foreign key → notes.id — NOT NULL
perfumes (향수)
- id — UUID — Primary key — NOT NULL
- name — VARCHAR(255) — NOT NULL
- brand_id — UUID — Foreign key → brands.id — NOT NULL
- description — TEXT
- thumbnail_url — TEXT
- created_at — TIMESTAMPTZ — NOT NULL
sihyang_keywords (시향_키워드)
- id — UUID — Primary key — NOT NULL
- sihyang_note_id — UUID — Foreign key → sihyang_notes.id — NOT NULL
- keyword — VARCHAR(20) — NOT NULL
sihyang_notes (시향 일기)
- id — UUID — Primary key — NOT NULL
- user_id — UUID — Foreign key → users.id — NOT NULL
- perfume_id — UUID — Foreign key → perfumes.id — NOT NULL
- preference — SMALLINT — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
users (회원)
- id — UUID — Primary key — NOT NULL — ㅇ
- email — VARCHAR(255) — NOT NULL
- password_hash — VARCHAR(255)
- nickname — VARCHAR(50) — NOT NULL
- birth_date — DATE
- gender — VARCHAR(10)
- profile_image_url — TEXT
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
- deleted_at — TIMESTAMPTZ