team_seenear

Tables (7)

call_simulation_log

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

chat_message_log

  • id (사용자 고유 id) — INTEGER — Primary key — NOT NULL
  • session_id (세션고유id) — INTEGER — Foreign key → chat_session.id — NOT NULL
  • message (대화내용) — TEXT — NOT NULL
  • created_at (메시지생성시간) — DATETIME

chat_session

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

friend_match

  • id (사용자 고유 id) — INTEGER — Primary key — NOT NULL
  • session_id (세션고유id) — INTEGER — Foreign key → session_keyword.session_id — NOT NULL
  • keyword_id (키워드고유id) — INTEGER — Foreign key → session_keyword.keyword_id — NOT NULL
  • requester_id (요청자고유id) — INTEGER — Foreign key → user.id — NOT NULL
  • receiver_id (수신자고유id) — INTEGER — Foreign key → user.id — NOT NULL
  • status (친구상태) — VARCHAR(20)
  • matched_reason (공통키워드) — VARCHAR(255)
  • created_at (요청일시) — DATETIME
  • updated_at (상태변경일시) — DATETIME

keyword

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

session_keyword

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

user

  • id (사용자 고유 id) — INTEGER — Primary key — 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)
  • is_privacy_agreed (개인정보동의여부) — BOOLEAN
  • is_voice_agreed (음성인식동의여부) — BOOLEAN
  • is_location_agreed (위치정보동의여부) — BOOLEAN
  • created_at (가입일시) — DATETIME
  • category (취미,관심사)