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