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