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