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 (취미,관심사)