kpsa-hack

Tables (8)

diary (일기)

  • idx — Long — Primary key — NOT NULL
  • member_id — String — Foreign key → member.id — NOT NULL
  • complite_cnt — String
  • before_score — String
  • after_score — String
  • dialy_text — String
  • created_at — String
  • fail_cnt — String

fcm_token_manage (FCM 토큰 관리 테이블)

  • idx — Long — Primary key — NOT NULL
  • member_id — String — Foreign key → member.id — NOT NULL
  • token — TEXT

level_info (레벨 관련 정보)

  • level — Long — Primary key — NOT NULL
  • member_id — String — Foreign key → member_level.member_id — NOT NULL
  • one_line_text — String
  • emotion_text — String
  • courage_text — String

location_spot (불안 장소)

  • idx — Long — Primary key
  • member_id — String — Foreign key → member_level.member_id — NOT NULL
  • number_list_str — Number
  • spot — String

member (사용자)

  • id (Key) — String — Primary key — NOT NULL
  • idx — Long — NOT NULL
  • email — String
  • name — String
  • nickname — String
  • birth — String
  • gender — String
  • visited — String
  • response_cnt — String

member_level (사용자 별 level 관리 테이블)

  • idx — Long — Primary key — NOT NULL
  • member_id — String — Foreign key → member.id — NOT NULL
  • level — Number
  • choice_space — List
  • total_score — INT
  • created_at — String

member_llm_data (사용자 LLM Log)

  • idx — Long — Primary key — NOT NULL
  • member_id — String — Foreign key → member.id — NOT NULL
  • type — bit
  • button_type — bit

symptoms (증상)

  • idx — Long — Primary key
  • number_list_str — Number
  • symptoms — String