team_seenear

Tables (7)

call_simulation_log

  • id — INTEGER — Primary key — NOT NULL — 통화이력고유ID
  • match_id — INTEGER — Foreign key → friend_match.id — NOT NULL — 매칭고유ID
  • caller_id — INTEGER — Foreign key → user.id — NOT NULL — 발신자고유ID
  • status — VARCHAR(20) — NOT NULL — 통화결과
  • duration_second — INTEGER — 통화지속시간
  • called_at — DATETIME — 통화시도시간

chat_message_log

  • id — INTEGER — Primary key — NOT NULL — 메시지고유ID
  • session_id — INTEGER — Foreign key → chat_session.id — NOT NULL — 세션고유ID
  • sender_type — VARCHAR(10) — NOT NULL — 발신자구분
  • message — TEXT — NOT NULL — 대화내용
  • created_at — DATETIME — 메시지생성시간

chat_session

  • id — INTEGER — Primary key — NOT NULL — 세션고유ID
  • user_id — INTEGER — Foreign key → user.id — NOT NULL — 사용자고유ID
  • created_at — DATETIME — 대화시작시간
  • ended_at — DATETIME — 대화종료시간
  • generated_image_url — VARCHAR(500) — 생성이미지경로

friend_match

  • id — INTEGER — Primary key — NOT NULL — 매칭고유ID
  • requester_id — INTEGER — Foreign key → user.id — NOT NULL — 요청자고유ID
  • receiver_id — INTEGER — Foreign key → user.id — NOT NULL — 수신자고유ID
  • status — VARCHAR(20) — 매칭상태
  • matched_reason — VARCHAR(255) — 매칭사유요약
  • created_at — DATETIME — 요청일시
  • updated_at — DATETIME — 상태변경일시

keyword

  • id — INTEGER — Primary key — NOT NULL — 키워드고유ID
  • name — VARCHAR(50) — NOT NULL — 키워드이름
  • category — VARCHAR(20) — NOT NULL — 키워드카테고리

session_keyword

  • session_id — INTEGER — Foreign key → chat_session.id — NOT NULL — 세션고유ID
  • keyword_id — INTEGER — Foreign key → keyword.id — NOT NULL — 키워드고유ID

user

  • id — INTEGER — Primary key — NOT NULL — 사용자고유ID
  • login_id — VARCHAR(50) — NOT NULL — 로그인아이디
  • password — VARCHAR(255) — NOT NULL — 비밀번호
  • name — VARCHAR(50) — NOT NULL — 이름
  • nik_name — VARCHAR(50) — NOT NULL — 닉네임
  • birth_date — DATE — 생년월일
  • gender — VARCHAR(10) — 성별
  • phone_number — VARCHAR(20) — NOT NULL — 전화번호
  • region — VARCHAR(100) — 거주지역
  • profile_flower — VARCHAR(50) — 프로필꽃
  • profile_color — VARCHAR(7) — 프로필색상
  • is_privacy_agreed — BOOLEAN — 개인정보동의여부
  • is_voice_agreed — BOOLEAN — 음성인식동의여부
  • is_location_agreed — BOOLEAN — 위치정보동의여부
  • created_at — DATETIME — 가입일시