randomChat

Tables (7)

CHAT_SESSION (채팅방)

  • 채팅방ID (session_id) — bigint — Primary key — NOT NULL — user1_id, created_at 복합인덱스 user2_id, created_at 복합인덱스 status 인덱스
  • 유저1ID (user1_id) — bigint — Foreign key → USER.유저ID — NOT NULL
  • 유저2ID (user2_id) — bigint — Foreign key → USER.유저ID — NOT NULL
  • 생성시간 (created_at) — timestamp
  • 종료시간 (ended_at) — timestamp
  • 상태 (status) — enum — ACTIVE, ENDED, TIMEOUT, DISCONNECTED, REPORTED, BANNED

LOGIN_HISTORY (로그인기록)

  • 로그ID (log_id) — bigint — Primary key — NOT NULL — log_id, log_at 복합 인덱스
  • 유저ID (user_id) — bigint — Foreign key → USER.유저ID — NOT NULL
  • 아이피 (ip_address) — varchar(45)
  • 성공여부 (is_success)
  • 실패이유 (fail_reason) — varchar(100)

MATCHING_HISTORY (매칭내역)

  • 내역ID (history_id) — bigint — Primary key — NOT NULL
  • 매칭시도유저ID (requester_id) — bigint — Foreign key → USER.유저ID — NOT NULL
  • 매칭대상유저ID (target_id) — bigint — Foreign key → USER.유저ID
  • 채팅방ID (session_id) — bigint — Foreign key → CHAT_SESSION.채팅방ID — user1_id, created_at 복합인덱스 user2_id, created_at 복합인덱스 status 인덱스
  • 매칭상태 (status) — enum — PENDING, SUCCESS, FAILED
  • 매칭시도시간 (created_at) — timestamp
  • 실패사유 (failure_reason) — enum — CANCELLED, TIMEOUT, SERVER_ERROR

MESSAGE (대화)

  • 대화ID (message_id) — bigint — Primary key — NOT NULL — session_id, created_at desc 복합인덱스 서버, 로컬 양쪽 모두에 저장
  • 유저ID (user_id) — bigint — Foreign key → USER.유저ID — NOT NULL
  • 채팅방ID (session_id) — bigint — Foreign key → CHAT_SESSION.채팅방ID — NOT NULL
  • 생성시간 (created_at) — timestamp
  • 읽음상태 (is_read) — tinyint
  • 타입 (type) — enum — TEXT, IMAGE, VIDEO, AUDIO
  • content — text

Profile (프로필)

  • 유저ID (user_id) — bigint — Foreign key → USER.유저ID — NOT NULL
  • 닉네임 (nickname) — varchar(30)
  • 성별 (gender) — enum — MALE, FEMALE

REPORT (신고)

  • 신고ID (report_id) — bigint — Primary key — NOT NULL
  • 채팅방ID (session_id) — bigint — Foreign key → CHAT_SESSION.채팅방ID — NOT NULL — user1_id, created_at 복합인덱스 user2_id, created_at 복합인덱스 status 인덱스
  • 신고한유저ID (reporter_id) — bigint — Foreign key → USER.유저ID — NOT NULL
  • 신고당한유저ID (reported_id) — bigint — Foreign key → USER.유저ID — NOT NULL
  • 처리상태 (is_processed) — tinyint
  • 신고시간 (created_at) — timestamp
  • 신고코드 (code) — enum — SPAM, OFFENSIVE_CONTENT, INAPPROPRIATE_PROFILE, FAKE_GENDER, CHILD_SEXUAL_ABUSE, OTHER
  • 신고사유 (reason) — varchar(100)

USER (유저)

  • 유저ID (user_id) — bigint — Primary key — NOT NULL
  • 고유넘버 (uuid) — varchar(36)
  • 전화번호 (phone_num) — varchar(20)
  • 마지막사용시간 (last_active_at) — timestamp
  • 계정생성시간 (created_at) — timestamp — 서버에서 사용시 Instant 타입. Instant <-> LocalDateTime 변환 시 zoneId도 포함해서 변환시켜야함
  • 계정삭제시간 (deleted_at) — timestamp
  • 상태 (status) — enum