search_api

Tables (3)

search_logs (검색어)

  • id (PK) — int — Primary key — NOT NULL
  • user_id (FK) — int — Foreign key → user.id — NOT NULL
  • ip (비회원 IP) — string
  • createdAt (검색시간) — Date
  • keyword (검색어) — string

user (유저)

  • id (PK) — int — Primary key — NOT NULL
  • email (유저 이메일) — string

user_info (유저 정보)

  • userId (PK) — int — Foreign key → user.id — NOT NULL
  • age (나이) — string
  • gender (성별) — string
  • region (국가) — string